Total Auto Profiles

Spreadsheet Version

# Field Number
Field Name Field Name
Length Max Field Length
Description Description
1
ID
50
Internal Infutor Inventory Number
2
PID
50
Persistent ID
3
VIN
10
10 Digit Masked VIN Number
4
MAKE
30
Vehicle Make
5
MODEL
30
Vehicle Model
6
YEAR
4
Vehicle Year – YYYY
7
VEH_CLASS
15
Vehicle Class
CROSSOVER
FULL SIZE CAR
FULL SIZE SUV
FULL SIZE TRUCK
FULL SIZE VAN
MID SIZE CAR
MID SIZE TRUCK
MID SIZE SUV
MINIVAN
SMALL CAR
SMALL SUV
SMALL TRUCK
8
FUELTYPECD
1
Vehicle Fuel Code
B – Bio Diesel
D – Diesel
F – Flex Fuel
G – Gasoline
H – Hydrogen Fuel Cell
I – Plug-in Hybrid / Electric with Gas Generator
L – Electric
N – Natural Gas
P – Propane
Y – Gas/Electric Hybrid
9
MFGCD
1
Auto Manufacturer Code
A – Antique
C – Chrysler Products
F- Ford Products
G – GM Products
H – High end Imports
L – Low End Imports
O – Other
10
STYLECD
10
Vehicle Style Code
CONV
CPE2DR
CUV
HATCHBACK
LUXURY
PICKUP
SEDAN
SPORT
UTIL
VAN
WAGON
11
MILEAGECD
1
Mileage Code
A-Z in increments of 10,000
0-10000-A
and 250,000+-Z
12
NBRVEHICLES
1
Number of Vehicles per Household: 1-8; 9 – 9 or more
13
IDATE
8
First Seen Date – YYYYMMDD
14
ODATE
8
Last Seen Date – YYYYMMDD
15
FNAME
50
First Name
16
MNAME
50
Middle Name
17
LNAME
50
Surname
18
SUFFIX
10
Jr., Sr., I, II, II, etc
19
GENDER
1
Gender Code:

  • M – Male
  • F – Female
    • 20
    HOUSE
    10
    House Number
    21
    PREDIR
    2
    Street PreDirectional: N, S, E, W, NE, etc
    22
    STREET
    28
    Street Name or PO Box name, or RR # Box name, or HC # Box name
    23
    STRTYPE
    4
    Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc
    24
    POSTDIR
    2
    Street Post Direction: N, S, E, W, NE, etc
    25
    APTTYPE
    4
    Unit Designator
    27
    CITY
    28
    City Name
    28
    STATE
    2
    State Abbreviation
    29
    ZIP
    5
    Zip Code
    30
    Z4
    4
    Zip+4 Code
    31
    DPC
    3
    Delivery Point Code with Check Digit
    32
    CRTE
    4
    Carrier Route Code
    33
    CNTYCD
    3
    County Code
    34
    Z4TYPE
    1
    USPS Zip+4 RecordType
    F – Firm or company address
    G – General delivery address
    H – High-rise or business complex
    P – PO Box address
    R – Rural route address
    S – Street or residential address
    35
    DPV
    1
    Delivery Point Validation Code
    Y – Address DPV confirmed for both primary and (if present) secondary numbers
    D – Address DPV confirmed for the primary number only, and secondary number information was missing
    S – Address DPV confirmed for the primary number only, and secondary number information was present but unconfirmed
    N – Both Primary and (if present) Secondary number information failed to DPV Confirm
    36
    VACANT
    1
    Vacant
    Y – Physical Address Identified by USPS as Vacant
    N – Someone living at that address
    37
    PHONE
    10
    Phone
    38
    DNC
    1
    Y – Do Not Call Flag
    39
    INTERNAL
    255
    Internal Use
    40
    INTERNAL2
    255
    Internal Use
    41
    INTERNAL3
    255
    Internal Use
    42
    CNTY
    30
    County Name
    43
    MSA
    4
    Metropolitan Statistical Area Code
    44
    CBSA
    5
    Core Based Statistical Area
    45
    EHI
    1
    Estimated HouseHold Income Code
    A – Less than $20,000
    B – $20,000 – $29,999
    C – $30,000 – $39,999
    D – $40,000 – $49,999
    E – $50,000 – $74,999
    F – $75,000 – $99,999
    G – $100,000 – $124,999
    H – $125,000 or more
    46
    CHILD
    1
    Y – Presence of Children
    47
    HOMEOWNER
    1
    Y – Home Owner
    48
    PCTW
    1
    Penetration Range – White – See Below
    49
    PCTB
    1
    Penetration Range – Black – See Below
    50
    PCTA
    1
    Penetration Range – Asian – See Below
    51
    PCTH
    1
    Penetration Range – Hispanic – See Below
    52
    PCTSPE
    1
    Penetration Range – English Speaking – See Below
    53
    PCTSPS
    1
    Penetration Range – Spanish Speaking – See Below
    54
    PCTSPA
    1
    Penetration Range – Asian Speaking – See Below
    55
    MHV
    1
    Median House Value
    A – Less than $50,000
    B – $50,000 – $99,999
    C – $100,000 – $149,999
    D – $150,000 – $249,999
    E – $250,000 – $349,999
    F – $350,000 – $499,999
    G – $500,000 – $749,999
    H – $750,000 – $999,999
    I – $1,000,000 or More
    56
    MOR
    1
    Penetration Range – Mail Order Respondent – See Below
    57
    PCTOCCW
    1
    Penetration Range – White Collar – See Below
    58
    PCTOCCB
    1
    Penetration Range – Blue Collar – See Below
    59
    PCTOCCO
    1
    Penetration Range – Other Occupation – See Below
    60
    LOR
    2
    Length of Residence: 00-15 Based on length of residence of the household at the same address Individual household LOR values range from 0, indicating less than 1 year, to 15, indicating 15 or more years. The individual LOR values are summed, divided by the Total Verified, then rounded
    61
    SFDU
    1
    Penetration Range – SFDU Structure – See Below
    62
    MFDU
    1
    Penetration Range – MFDU Structure – See Below
    63
    HHID
    50
    HouseHold ID
    64
    ADDRID
    50
    Address ID – “Infutor has synced our addresses to Placekey. Please contact Infutor Sales if you are interested in learning more.”
    65
    ADDRESS
    64
    Full Address
    66
    INTERNAL5
    255
    Internal Use
    67
    INTERNAL6
    255
    Internal Use
    68
    INTERNAL7
    255
    Internal Use
    69
    INTERNAL8
    255
    Internal Use
    70
    INTERNAL9
    255
    Internal Use
    71
    INTERNAL10
    255
    Internal Use
    72
    INTERNAL11
    255
    Internal Use
    73
    INTERNAL12
    255
    Internal Use
    Penetration Percentage Ranges Penetration Percentage Ranges
    Value Value
    Greater than 95
    A
    95 thru 91
    B
    90 thru 86
    C
    85 thru 81
    D
    80 thru 76
    E
    75 thru 71
    F
    70 thru 66
    G
    65 thru 61
    H
    60 thru 56
    I
    55 thru 51
    J
    50 thru 46
    K
    45 thru 41
    L
    40 thru 36
    M
    35 thru 31
    N
    30 thru 26
    O
    25 thru 21
    P
    20 thru 16
    Q
    15 thru 11
    R
    10 thru 6
    S
    Less than 6
    T

    The information in this document may not be altered, changed, or recreated without written consent of Infutor Data Solutions Inc. – Infutor Confidential and Proprietary