Total Consumer History

Spreadsheet Version

# Field Number
Field Name Field Name
Length Max Field Length
Description Description
1
PID
50
Persistent ID
2
INTERNAL
255
Internal Use
3
INTERNAL2
255
Internal Use
4
INTERNAL3
255
Internal Use
5
PRE
3
Mr, Ms, etc
6
FNAME
50
First Name
7
MNAME
50
Middle Name
8
LNAME
50
Surname
9
SUFFIX
10
Jr., Sr., I, II, II, etc
    10
    GENDER
    1
    Gender Code
  • M – Male
  • F – Female
  • U – Unknown
11
CRD_DOB
6
Date of Birth – YYYYMM
12
DeceasedCD
1
Y – Individual is Deceased
13
INTERNAL4
8
Internal Use
14
INTERNAL5
255
Internal Use
15
INTERNAL6
255
Internal Use
16
INTERNAL7
255
Internal Use
17
INTERNAL8
255
Internal Use
18
IDATE
8
First Time we have seen an individual
19
ODATE
8
Last time we seen activity for that individual
20
INTERNAL9
255
Internal Use
21
INTERNAL10
255
Internal Use
22
INTERNAL11
255
Internal Use

Alias 1

# Field Number
Field Name Field Name
Length Max Field Length
Description Description
23
ALIAS
50
Alternate Spelling/Name
24
PRE1
3
Mr, Ms, etc
25
AFNAME1
50
Alias First Name
26
AMNAME1
50
Alias Middle Name
27
ALNAME1
50
Alias Surname
28
SUFFIX1
10
Jr., Sr., I, II, II, etc
29
GENDER1
1
Gender Code 1
  • M – Male
  • F – Female
  • U – Unknown

    • Alias 2

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    30
    ALIAS2
    50
    Alternate Spelling/Name 2
    31
    PRE2
    3
    Mr, Ms, etc
    32
    AFNAME2
    50
    Alias First Name
    33
    AMNAME2
    50
    Alias Middle Name
    34
    ALNAME2
    50
    Alias Surname
    35
    SUFFIX2
    10
    Jr., Sr., I, II, II, etc
    36
    GENDER2
    1
    Gender Code
  • M – Male
  • F – Female
  • U – Unknown

    • Alias 3

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    37
    ALIAS3
    50
    Alternate Spelling/Name 3
    38
    PRE3
    3
    Mr, Ms, etc
    39
    AFNAME3
    50
    Alias First Name
    40
    AMNAME3
    50
    Alias Middle Name
    41
    ALNAME3
    50
    Alias Surname
    42
    SUFFIX3
    10
    Jr., Sr., I, II, II, etc
    43
    GENDER3
    1
    Gender Code 3
  • M – Male
  • F – Female
  • U – Unknown

    • Alias 4

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    44
    ALIAS4
    50
    Alternate Spelling/Name 4
    45
    PRE2
    3
    Mr, Ms, etc
    46
    AFNAME4
    50
    Alias First Name
    47
    AMNAME4
    50
    Alias Middle Name
    48
    ALNAME4
    50
    Alias Surname
    49
    SUFFIX4
    10
    Jr., Sr., I, II, II, etc
    50
    GENDER4
    1
    Gender Code 4
  • M – Male
  • F – Female
  • U – Unknown

    • Alias 5

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    51
    ALIAS5
    50
    Alternate Spelling/Name 5
    52
    PRE5
    3
    Mr, Ms, etc
    53
    AFNAME5
    50
    Alias First Name
    54
    AMNAME5
    50
    Alias Middle Name
    55
    ALNAME5
    50
    Alias Surname
    56
    SUFFIX5
    10
    Jr., Sr., I, II, II, etc
    57
    GENDER5
    1
    Gender Code 5
  • M – Male
  • F – Female
  • U – Unknown

    • Alias 6

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    58
    ALIAS6
    50
    Alternate Spelling/Name 6
    59
    PRE6
    3
    Mr, Ms, etc
    60
    AFNAME6
    50
    Alias First Name
    61
    AMNAME6
    50
    Alias Middle Name
    62
    ALNAME6
    50
    Alias Surname
    63
    SUFFIX6
    10
    Jr., Sr., I, II, II, etc
    64
    GENDER6
    1
    Gender Code 6
  • M – Male
  • F – Female
  • U – Unknown

    • Alias 7

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    65
    ALIAS7
    50
    Alternate Spelling/Name 7
    66
    PRE7
    3
    Mr, Ms, etc
    67
    AFNAME7
    50
    Alias First Name
    68
    AMNAME7
    50
    Alias Middle Name
    69
    ALNAME7
    50
    Alias Surname
    70
    SUFFIX7
    10
    Jr., Sr., I, II, II, etc
    71
    GENDER7
    1
    Gender Code 7
  • M – Male
  • F – Female
  • U – Unknown

    • Alias 8

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    72
    ALIAS8
    50
    Alternate Spelling/Name 8
    73
    PRE8
    3
    Mr, Ms, etc
    74
    AFNAME8
    50
    Alias First Name
    75
    AMNAME8
    50
    Alias Middle Name
    76
    ALNAME8
    50
    Alias Surname
    77
    SUFFIX8
    10
    Jr., Sr., I, II, II, etc
    78
    GENDER8
    1
    Gender Code 8
  • M – Male
  • F – Female
  • U – Unknown

    • Alias 9

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    79
    ALIAS9
    50
    Alternate Spelling/Name 9
    80
    PRE9
    3
    Mr, Ms, etc
    81
    AFNAME9
    50
    Alias First Name
    82
    AMNAME9
    50
    Alias Middle Name
    83
    ALNAME9
    50
    Alias Surname
    84
    SUFFIX9
    10
    Jr., Sr., I, II, II, etc
    85
    GENDER9
    1
    Gender Code 9
  • M – Male
  • F – Female
  • U – Unknown

    • Alias 10

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    86
    ALIAS10
    50
    Alternate Spelling/Name 10
    87
    PRE10
    3
    Mr, Ms, etc
    88
    AFNAME10
    50
    Alias First Name
    89
    AMNAME10
    50
    Alias Middle Name
    90
    ALNAME10
    50
    Alias Surname
    91
    SUFFIX10
    10
    Jr., Sr., I, II, II, etc
    92
    GENDER10
    1
    Gender Code 10
  • M – Male
  • F – Female
  • U – Unknown

    • Address Sequence 1

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    93
    ADREESS_SEC
    1
    Address Sequence
    94
    ADDRESS
    64
    Full Address
    95
    INTERNAL12
    255
    Internal Use
    96
    HOUSE
    10
    House Number
    97
    PREDIR
    2
    Street PreDirectional: N, S, E, W, NE, etc
    98
    STREET
    28
    Street Name or PO Box name, or RR # Box name, or HC # Box name
    99
    STRTYPE
    4
    Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc
    100
    POSTDIR
    2
    Street Post Direction: N, S, E, W, NE, etc
    101
    APTTYPE
    4
    Unit Designator
    102
    APTNBR
    8
    Unit Number
    103
    CITY
    28
    City Name
    104
    STATE
    2
    State Abbreviation
    105
    ZIP
    5
    Zip Code
    106
    Z4
    4
    Zip+4 Code
    107
    DPC
    3
    Delivery Point Code with Check Digit
    108
    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
    • 109
    CRTE
    4
    Carrier Route Code
    110
    FIPSCD
    3
    FIPS County Code
    111
    Z4TYPE
    1
    Zip+4 Type
  • 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
    • 112
    INTERNAL13
    255
    Internal Use
    113
    EFFDATE
    8
    First time an individual seen at this address
    114
    INTERNAL14
    255
    Internal Use
    115
    ADDRID
    50
    Address ID – “Infutor has synced our addresses to Placekey. Please contact Infutor Sales if you are interested in learning more.”
    116
    INTERNAL15
    8
    Internal Use
    117
    INTERNAL16
    8
    Internal Use

    Address Sequence 2

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    118
    ADREESS_SEC2
    1
    Address Sequence 2
    119
    ADDRESS2
    64
    Full Address
    120
    INTERNAL17
    255
    Internal Use
    121
    HOUSE2
    10
    House Number 2
    122
    PREDIR2
    2
    Street PreDirectional 2: N, S, E, W, NE, etc
    123
    STREET2
    28
    Street Name or PO Box name, or RR # Box name, or HC # Box name
    124
    STRTYPE2
    4
    Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc
    125
    POSTDIR2
    2
    Street Post Direction 2: N, S, E, W, NE, etc
    126
    APTTYPE2
    4
    Unit Designator 2
    127
    APTNBR2
    8
    Unit Number 2
    128
    CITY2
    28
    City Name 2
    129
    STATE2
    2
    State Abbreviation 2
    130
    ZIP2
    5
    Zip Code 2
    131
    Z42
    4
    Zip+4 Code 2
    132
    DPC2
    3
    Delivery Point Code with Check Digit 2
    133
    DPV2
    1
    Delivery Point Validation Code 2
  • 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
    • 134
    CRTE2
    4
    Carrier Route Code 2
    135
    FIPSCD2
    3
    FIPS County Code 2
    136
    Z4TYPE2
    1
    Zip+4 Type 2
  • 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
    • 137
    INTERNAL18
    255
    Internal Use
    138
    EFFDATE2
    8
    First time an individual seen at this address 2
    139
    INTERNAL19
    255
    Internal Use
    140
    ADDRID2
    50
    Address ID2 – “Infutor has synced our addresses to Placekey. Please contact Infutor Sales if you are interested in learning more.”
    141
    INTERNAL20
    8
    Internal Use
    142
    INTERNAL21
    8
    Internal Use

    Address Sequence 3

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    143
    ADREESS_SEC3
    1
    Address Sequence 3
    144
    ADDRESS3
    64
    Full Address
    145
    INTERNAL22
    255
    Internal Use
    146
    HOUSE3
    10
    House Number 3
    147
    PREDIR3
    2
    Street PreDirectional 3: N, S, E, W, NE, etc
    148
    STREET3
    28
    Street Name or PO Box name, or RR # Box name, or HC # Box name
    149
    STRTYPE3
    4
    Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc
    150
    POSTDIR3
    2
    Street Post Direction 3: N, S, E, W, NE, etc
    151
    APTTYPE3
    4
    Unit Designator 3
    152
    APTNBR3
    8
    Unit Number 3
    153
    CITY3
    28
    City Name 3
    154
    STATE
    2
    State Abbreviation 3
    155
    ZIP3
    5
    Zip Code 3
    156
    Z43
    4
    Zip+4 Code 3
    157
    DPC3
    3
    Delivery Point Code with Check Digit 3
    158
    DPV3
    1
    Delivery Point Validation Code 3
  • 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
    • 159
    CRTE3
    4
    Carrier Route Code 3
    160
    FIPSCD3
    3
    FIPS County Code 3
    161
    Z4TYPE3
    1
    Zip+4 Type 3
  • 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
    • 162
    INTERNAL23
    255
    Internal Use
    163
    EFFDATE3
    8
    First time an individual seen at this address 3
    164
    INTERNAL24
    255
    Internal Use
    165
    ADDRID3
    50
    Address ID3 – “Infutor has synced our addresses to Placekey. Please contact Infutor Sales if you are interested in learning more.”
    166
    INTERNAL25
    8
    Internal Use
    167
    INTERNAL26
    8
    Internal Use

    Address Sequence 4

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    168
    ADREESS_SEC4
    1
    Address Sequence 4
    169
    ADDRESS4
    64
    Full Address
    170
    INTERNAL27
    255
    Internal Use
    171
    HOUSE4
    10
    House Number 4
    172
    PREDIR4
    2
    Street PreDirectional 4: N, S, E, W, NE, etc
    173
    STREET
    28
    Street Name or PO Box name, or RR # Box name, or HC # Box name
    174
    STRTYPE
    4
    Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc
    175
    POSTDIR
    2
    Street Post Direction 4: N, S, E, W, NE, etc
    176
    APTTYPE4
    4
    Unit Designator 4
    177
    APTNBR4
    8
    Unit Number 4
    178
    CITY4
    28
    City Name 4
    179
    STATE4
    2
    State Abbreviation 4
    180
    ZIP4
    5
    Zip Code 4
    181
    Z44
    4
    Zip+4 Code 4
    182
    DPC4
    3
    Delivery Point Code with Check Digit 4
    183
    DPV4
    1
    Delivery Point Validation Code 4
  • 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
    • 184
    CRTE4
    4
    Carrier Route Code 4
    185
    FIPSCD4
    3
    FIPS County Code 4
    186
    Z4TYPE4
    1
    Zip+4 Type 4
  • 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
    • 187
    INTERNAL28
    255
    Internal Use
    188
    EFFDATE4
    8
    First time an individual seen at this address 4
    189
    INTERNAL29
    255
    Internal Use
    190
    ADDRID4
    50
    Address ID4 – “Infutor has synced our addresses to Placekey. Please contact Infutor Sales if you are interested in learning more.”
    191
    INTERNAL30
    8
    Internal Use
    192
    INTERNAL31
    8
    Internal Use

    Address Sequence 5

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    193
    ADREESS_SEC5
    1
    Address Sequence 5
    194
    ADDRESS5
    64
    Full Address
    195
    INTERNAL32
    255
    Internal Use
    196
    HOUSE5
    10
    House Number 5
    197
    PREDIR5
    2
    Street PreDirectional 5: N, S, E, W, NE, etc
    198
    STREET5
    28
    Street Name or PO Box name, or RR # Box name, or HC # Box name
    199
    STRTYPE5
    4
    Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc
    200
    POSTDIR5
    2
    Street Post Direction 5: N, S, E, W, NE, etc
    201
    APTTYPE5
    4
    Unit Designator 5
    202
    APTNBR5
    8
    Unit Number 5
    203
    CITY5
    28
    City Name 5
    204
    STATE5
    2
    State Abbreviation 5
    205
    ZIP5
    5
    Zip Code 5
    206
    Z45
    4
    Zip+4 Code 5
    207
    DPC5
    3
    Delivery Point Code with Check Digit 5
    208
    DPV5
    1
    Delivery Point Validation Code 5
  • 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
    • 209
    CRTE5
    4
    Carrier Route Code 5
    210
    FIPSCD5
    3
    FIPS County Code 5
    211
    Z4TYPE5
    1
    Zip+4 Type 5
  • 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
    • 212
    INTERNAL33
    255
    Internal Use
    213
    EFFDATE5
    8
    First time an individual seen at this address 5
    214
    INTERNAL34
    255
    Internal Use
    215
    ADDRID5
    50
    Address ID5 – “Infutor has synced our addresses to Placekey. Please contact Infutor Sales if you are interested in learning more.”
    216
    INTERNAL35
    8
    Internal Use
    217
    INTERNAL36
    8
    Internal Use

    Address Sequence 6

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    218
    ADREESS_SEC6
    1
    Address Sequence 6
    219
    ADDRESS6
    64
    Full Address
    220
    INTERNAL37
    255
    Internal Use
    221
    HOUSE6
    10
    House Number 6
    222
    PREDIR6
    2
    Street PreDirectional 6: N, S, E, W, NE, etc
    223
    STREET6
    28
    Street Name or PO Box name, or RR # Box name, or HC # Box name
    224
    STRTYPE6
    4
    Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc
    225
    POSTDIR6
    2
    Street Post Direction 6: N, S, E, W, NE, etc
    226
    APTTYPE6
    4
    Unit Designator 6
    227
    APTNBR6
    8
    Unit Number 6
    228
    CITY6
    28
    City Name 6
    229
    STATE6
    2
    State Abbreviation 6
    230
    ZIP6
    5
    Zip Code 6
    231
    Z46
    4
    Zip+4 Code 6
    232
    DPC6
    3
    Delivery Point Code with Check Digit 6
    233
    DPV6
    1
    Delivery Point Validation Code 6
  • 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
    • 234
    CRTE6
    4
    Carrier Route Code 6
    235
    FIPSCD6
    3
    FIPS County Code 6
    236
    Z4TYPE6
    1
    Zip+4 Type 6
  • 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
    • 237
    INTERNAL38
    255
    Internal Use
    238
    EFFDATE6
    8
    First time an individual seen at this address 6
    239
    INTERNAL39
    255
    Internal Use
    240
    ADDRID6
    50
    Address ID6 – “Infutor has synced our addresses to Placekey. Please contact Infutor Sales if you are interested in learning more.”
    241
    INTERNAL40
    8
    Internal Use
    242
    INTERNAL41
    8
    Internal Use

    Address Sequence 7

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    243
    ADREESS_SEC7
    1
    Address Sequence 7
    244
    ADDRESS7
    64
    Full Address 7
    245
    INTERNAL42
    255
    Internal Use
    246
    HOUSE7
    10
    House Number 7
    247
    PREDIR7
    2
    Street PreDirectional 7: N, S, E, W, NE, etc
    248
    STREET7
    28
    Street Name or PO Box name, or RR # Box name, or HC # Box name
    249
    STRTYPE
    4
    Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc
    250
    POSTDIR
    2
    Street Post Direction 7: N, S, E, W, NE, etc
    251
    APTTYPE7
    4
    Unit Designator 7
    252
    APTNBR7
    8
    Unit Number 7
    253
    CITY7
    28
    City Name 7
    254
    STATE7
    2
    State Abbreviation 7
    255
    ZIP7
    5
    Zip Code 7
    256
    Z47
    4
    Zip+4 Code 7
    257
    DPC7
    3
    Delivery Point Code with Check Digit 7
    258
    DPV7
    1
    Delivery Point Validation Code 7
  • 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
    • 259
    CRTE7
    4
    Carrier Route Code 7
    260
    FIPSCD7
    3
    FIPS County Code 7
    261
    Z4TYPE7
    1
    Zip+4 Type 7
  • 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
    • 262
    INTERNAL43
    255
    Internal Use
    263
    EFFDATE7
    8
    First time an individual seen at this address 7
    264
    INTERNAL44
    255
    Internal Use
    265
    ADDRID7
    50
    Address ID7 – “Infutor has synced our addresses to Placekey. Please contact Infutor Sales if you are interested in learning more.”
    266
    INTERNAL45
    8
    Internal Use
    267
    INTERNAL46
    8
    Internal Use

    Address Sequence 8

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    268
    ADREESS_SEC8
    1
    Address Sequence 8
    269
    ADDRESS8
    64
    Full Address
    270
    INTERNAL47
    255
    Internal Use
    271
    HOUSE8
    10
    House Number 8
    272
    PREDIR8
    2
    Street PreDirectional 8: N, S, E, W, NE, etc
    273
    STREET8
    28
    Street Name or PO Box name, or RR # Box name, or HC # Box name
    274
    STRTYPE
    4
    Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc
    275
    POSTDIR8
    2
    Street Post Direction 8: N, S, E, W, NE, etc
    276
    APTTYPE8
    4
    Unit Designator 8
    277
    APTNBR8
    8
    Unit Number 8
    278
    CITY8
    28
    City Name 8
    279
    STATE8
    2
    State Abbreviation 8
    280
    ZIP8
    5
    Zip Code 8
    281
    Z48
    4
    Zip+4 Code 8
    282
    DPC8
    3
    Delivery Point Code with Check Digit 8
    283
    DPV8
    1
    Delivery Point Validation Code 8
  • 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
    • 284
    CRTE8
    4
    Carrier Route Code 8
    285
    FIPSCD8
    3
    FIPS County Code 8
    286
    Z4TYPE8
    1
    Zip+4 Type 8
  • 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
    • 287
    INTERNAL48
    255
    Internal Use
    288
    EFFDATE8
    8
    First time an individual seen at this address 8
    289
    INTERNAL49
    255
    Internal Use
    290
    ADDRID8
    50
    Address ID8 – “Infutor has synced our addresses to Placekey. Please contact Infutor Sales if you are interested in learning more.”
    291
    INTERNAL50
    8
    Internal Use
    292
    INTERNAL51
    8
    Internal Use

    Address Sequence 9

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    293
    ADREESS_SEC9
    1
    Address Sequence 9
    294
    ADDRESS9
    64
    Full Address
    295
    INTERNAL52
    255
    Internal Use
    296
    HOUSE9
    10
    House Number 9
    297
    PREDIR
    2
    Street PreDirectional 9: N, S, E, W, NE, etc
    298
    STREET
    28
    Street Name or PO Box name, or RR # Box name, or HC # Box name
    299
    STRTYPE
    4
    Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc
    300
    POSTDIR
    2
    Street Post Direction 9: N, S, E, W, NE, etc
    301
    APTTYPE9
    4
    Unit Designator 9
    302
    APTNBR9
    8
    Unit Number 9
    303
    CITY9
    28
    City Name 9
    304
    STATE9
    2
    State Abbreviation 9
    305
    ZIP9
    5
    Zip Code 9
    306
    Z49
    4
    Zip+4 Code 9
    307
    DPC9
    3
    Delivery Point Code with Check Digit 9
    308
    DPV9
    1
    Delivery Point Validation Code 9
  • 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
    • 309
    CRTE9
    4
    Carrier Route Code 9
    310
    FIPSCD9
    3
    FIPS County Code 9
    311
    Z4TYPE9
    1
    Zip+4 Type 9
  • 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
    • 312
    INTERNAL53
    255
    Internal Use
    313
    EFFDATE9
    8
    First time an individual seen at this address 9
    314
    INTERNAL54
    255
    Internal Use
    315
    ADDRID9
    50
    Address ID9 – “Infutor has synced our addresses to Placekey. Please contact Infutor Sales if you are interested in learning more.”
    316
    INTERNAL55
    8
    Internal Use
    317
    INTERNAL56
    8
    Internal Use

    Address Sequence 10

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    318
    ADREESS_SEC10
    1
    Address Sequence 10
    319
    ADDRESS10
    64
    Full Address
    320
    INTERNAL57
    255
    Internal Use
    321
    HOUSE 10
    10
    House Number 10
    322
    PREDIR
    2
    Street PreDirectional 10: N, S, E, W, NE, etc
    323
    STREET
    28
    Street Name or PO Box name, or RR # Box name, or HC # Box name
    324
    STRTYPE
    4
    Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc
    325
    POSTDIR
    2
    Street Post Direction 10: N, S, E, W, NE, etc
    326
    APTTYPE10
    4
    Unit Designator 10
    327
    APTNBR10
    8
    Unit Number 10
    328
    CITY10
    28
    City Name 10
    329
    STATE10
    2
    State Abbreviation 10
    330
    ZIP10
    5
    Zip Code 10
    331
    Z410
    4
    Zip+4 Code 10
    332
    DPC10
    3
    Delivery Point Code with Check Digit 10
    333
    DPV10
    1
    Delivery Point Validation Code 10
  • 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
    • 334
    CRTE10
    4
    Carrier Route Code 10
    335
    FIPSCD10
    3
    FIPS County Code 10
    336
    Z4TYPE10
    1
    Zip+4 Type 10
  • 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
    • 337
    INTERNAL58
    255
    Internal Use
    238
    EFFDATE10
    8
    First time an individual seen at this address 10
    339
    INTERNAL59
    255
    Internal Use
    340
    ADDRID10
    50
    Address ID10 – “Infutor has synced our addresses to Placekey. Please contact Infutor Sales if you are interested in learning more.”
    341
    INTERNAL60
    8
    Internal Use
    342
    INTERNAL61
    8
    Internal Use

    Phone 1

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    343
    PHONE1
    10
    Phone 1
    344
    INTERNAL62
    255
    Internal Use
    345
    INTERNAL63
    255
    Internal Use
    346
    INTERNAL64
    255
    Internal Use
    347
    INTERNAL65
    255
    Internal Use
    348
    IDATE1
    8
    First Seen Date 1 – YYYYMMDD
    349
    ODATE1
    8
    Last Seen Date 1 – YYYYMMDD

    Phone 2

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    350
    PHONE2
    10
    Phone 2
    351
    INTERNAL66
    255
    Internal Use
    352
    INTERNAL67
    255
    Internal Use
    353
    INTERNAL68
    255
    Internal Use
    354
    INTERNAL69
    255
    Internal Use
    355
    IDATE2
    8
    First Seen Date 2 – YYYYMMDD
    356
    ODATE2
    8
    Last Seen Date 2 – YYYYMMDD

    Phone 3

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    357
    PHONE3
    10
    Phone 3
    358
    INTERNAL71
    255
    Internal Use
    359
    INTERNAL72
    255
    Internal Use
    360
    INTERNAL73
    255
    Internal Use
    361
    INTERNAL73
    255
    Internal Use
    362
    IDATE3
    8
    First Seen Date 3 – YYYYMMDD
    363
    ODATE3
    8
    Last Seen Date 3 – YYYYMMDD

    Phone 4

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    364
    PHONE4
    10
    Phone 4
    365
    INTERNAL74
    255
    Internal Use
    366
    INTERNAL75
    255
    Internal Use
    367
    INTERNAL76
    255
    Internal Use
    368
    INTERNAL77
    255
    Internal Use
    369
    IDATE4
    8
    First Seen Date 4 – YYYYMMDD
    370
    ODATE4
    8
    Last Seen Date 4 – YYYYMMDD

    Phone 5

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    371
    PHONE5
    10
    Phone 5
    372
    INTERNAL78
    255
    Internal Use
    373
    INTERNAL79
    255
    Internal Use
    374
    INTERNAL80
    255
    Internal Use
    375
    INTERNAL81
    255
    Internal Use
    376
    IDATE5
    8
    First Seen Date 5 – YYYYMMDD
    377
    ODATE5
    8
    Last Seen Date 5 – YYYYMMDD

    Phone 6

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    378
    PHONE6
    10
    Phone 6
    379
    INTERNAL82
    255
    Internal Use
    380
    INTERNAL83
    255
    Internal Use
    381
    INTERNAL84
    255
    Internal Use
    382
    INTERNAL85
    255
    Internal Use
    383
    IDATE6
    8
    First Seen Date 6 – YYYYMMDD
    384
    ODATE6
    8
    Last Seen Date 6 – YYYYMMDD

    Phone 7

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    385
    PHONE7
    10
    Phone 7
    386
    INTERNAL86
    255
    Internal Use
    387
    INTERNAL87
    255
    Internal Use
    388
    INTERNAL88
    255
    Internal Use
    389
    INTERNAL89
    255
    Internal Use
    390
    IDATE7
    8
    First Seen Date 7 – YYYYMMDD
    391
    ODATE7
    8
    Last Seen Date 7 – YYYYMMDD

    Phone 8

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    392
    PHONE8
    10
    Phone 8
    393
    INTERNAL90
    255
    Internal Use
    394
    INTERNAL91
    255
    Internal Use
    395
    INTERNAL92
    255
    Internal Use
    396
    INTERNAL93
    255
    Internal Use
    397
    IDATE8
    8
    First Seen Date 8 – YYYYMMDD
    398
    ODATE8
    8
    Last Seen Date 8 – YYYYMMDD

    Phone 9

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    399
    PHONE9
    10
    Phone 9
    400
    INTERNAL94
    255
    Internal Use
    401
    INTERNAL95
    255
    Internal Use
    402
    INTERNAL96
    255
    Internal Use
    403
    INTERNAL97
    255
    Internal Use
    404
    IDATE9
    8
    First Seen Date 9 – YYYYMMDD
    405
    ODATE9
    8
    Last Seen Date 9 – YYYYMMDD

    Phone 10

    # Field Number
    Field Name Field Name
    Length Max Field Length
    Description Description
    406
    PHONE10
    10
    Phone 10
    407
    INTERNAL98
    255
    Internal Use
    408
    INTERNAL99
    255
    Internal Use
    409
    INTERNAL100
    255
    Internal Use
    410
    INTERNAL101
    255
    Internal Use
    411
    IDATE10
    8
    First Seen Date 10 – YYYYMMDD
    412
    ODATE10
    8
    Last Seen Date 10 – YYYYMMDD
    413
    INTERNAL102
    255
    Internal Use

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