CRM Freshlink Premium

Overview

In addition to all of the features included in CRM FreshLink Plus, the Premium version adds even more key consumer data elements to enrich the profile of each record in the CRM file. Additional appended attributes include detailed property and vehicle data, as well as, lifestyle data elements. This comprehensive CRM solution is the total package to provide insights and intelligence on all of your customers.

Input

The CRM FreshLink Premium product accepts identity data elements including name, address, phone, and email as input.

Input Field Description
Full Name Full individual Name
First Name First name, 15 characters maximum
Last Name Last name, 20 characters maximum
Address1 Address line 1, 64 characters maximum
Address2 Address line 2, 64 characters maximum
City City name, 28 characters max. * Either City/State or Zip5 is required
State 2 character state abbreviation. * Either City/State or Zip5 is required
Zip5 5 digit numeric USPS zip code. * Either City/State or Zip5 is required
Phone 10 digit numeric phone number (without spaces, dashes, or parentheses)
Phone2 10 digit numeric 2nd phone number (without spaces, dashes, or parentheses)
Email Email address, 100 characters maximum
IP IP v4 address in dotted decimal nnn.nnn.nnn.nnn format
SHA2 64 characters SHA2 email address encryption
SHA1 40 characters SHA1 email address encryption
MD5 32 characters MD5 email address encryption
At a minimum, one of the following input combinations is required for processing:
  • Phone
  • Phone2
  • Email
  • FName + LName
  • FullName
  • Address1 + Zip
  • Address1 + City + State
  • IP
  • Sha2
  • Sha1
  • Md5

Output

Field No. Output Field Description Return Values
1 Cleansed Phone Data in this column indicates that phone input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Phone number or blank
2 Input Phone Type Phone Owner Id Match CategoryIP – Individual - PhoneHP – Household - PhoneAP – Address - PhoneNP – Name – PhoneLP – Last Name – PhoneFP – First Name - PhoneZP –Zip - PhoneP- Phone VerifiedX – No Match IP, HP, AP, NP, LP, FP, ZP, P, X
3 Cleansed Phone 2 Data in this column indicates that phone input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Phone number or blank
4 Input Second Phone Type Phone Owner Id Match CategoryIP – Individual - PhoneHP – Household - PhoneAP – Address - PhoneNP – Name – PhoneLP – Last Name – PhoneFP – First Name - PhoneZP –Zip - PhoneP- Phone VerifiedX – No Match IP, HP, AP, NP, LP, FP, ZP, P, X
5 Cleansed Email Data in this column indicates that email input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Email address or blank
6 Cleansed First Name Data in this column indicates that name input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. First name or blank
7 Cleansed Last Name Data in this column indicates that name input data has been successfully cleansed by CRMFreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Last name or blank
8 Cleansed Middle Name Data in this column indicates that name input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Middle name or blank
9 Cleansed Full Name Data in this column indicates that full name input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Full name or blank
10 Cleansed Full Address Data in this column indicates that address input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Address or blank
11 Cleansed City Data in this column indicates that city input data has been successfully cleansed by CRMFreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. City or blank
12 Cleansed State Data in this column indicates that State input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. State or blank
13 Cleansed Zip Data in this column indicates that zip input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Zip or blank
14 Unique Customer PID Unique individual that was matched to on the database.1st Character – Y (Person found on the database)/N (Person not found on the database). Remaining characters - Unique Identifier. String Value 32 characters max.
15 Household ID Unique address + Last Name that was matched to on the database.1st Character - Y (Address found on the database)/N (Address not found on the database). Remaining characters - Unique Identifier. String Value 100 characters max.
16 Address ID Unique address that was matched to Infutor’s Identity Graph.1st Character - Y (Address found on the database)/N (Address not found on the database).Remaining characters - Unique Identifier. This can be used in conjunction with other data points to understand if multiple customers are living at the same household. String Value 32 characters max.
17 Refreshed First Name If input data is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no data was input, then we reference the Infutor Identity Graph to populate a result. 50 characters
18 Refreshed Last Name If input data is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no data was input, then we reference the Infutor Identity Graph to populate a result. 50 characters
19 Refreshed Middle Name If input data is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no data was input, then we reference the Infutor Identity Graph to populate a result. 1 Character
20 Refreshed House Number If an input House Number is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no House Number was input, then we reference the Infutor Identity Graph to populate one. 10 Characters
21 Refreshed Pre Directional Street Pre Direction: N, S, E, W, NE, SW, etc. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 2 Characters
22 Refreshed Street Name Street name. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 28 Characters
23 Refreshed Street Type Street suffix: ST, AVE, BLVD, etc. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 4 Characters
24 Refreshed Post Directional Street Post Direction: N, S, E, W, NE, SW, etc. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 2 Characters
25 Refreshed Apartment Type Secondary Unit designator: Apt, Suite, etc. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 4 Characters
26 Refreshed Apartment Number Secondary unit number: Apt #, Suite #, etc. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 8 Characters
27 Refreshed Full Address Full address output in a single field. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 100 Characters
28 Refreshed City USPS City Name. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 28 Characters
29 Refreshed State USPS state abbreviation. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 2 Characters
30 Refreshed Zip5 Numeric USPS zip code. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 5 Characters
31 Refreshed Zip +4 Extension Numeric USPS zip+4 extension. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 4 Characters
32 Refreshed Delivery Point Code Delivery point code with check digit. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 3 Characters
33 Refreshed Carrier Route Code Carrier Route Code. If an input address is provided, this field returns the carrier route for that input, and if it was successfully cleansed, the carrier route for the cleansed output will show here. If no input address was provided, then we reference the Infutor Identity Graph to populate an address and this field contains the corresponding carrier route code. 4 Characters
34 Zip4 Type Code Appended USPS Zip+4 typeF – firm or company addressG – General delivery addressH – High-rise or business complexP – PO Box addressR – Rural route addressS – Street or residential addressBlank - Unknown F, G, H, P, R, S
35 Delivery Point Validation Appended Delivery Point ValidationY – Address DPV confirmed for both primary and (if present) secondary numbersD – Address DPV confirmed for primary number only, secondary number information was missingS – Address DPV confirmed for the primary number only, and secondary number information was present but unconfirmedN – Both Primary and (if present) Secondary number information failed to DPV confirmBlank – Address not presented to table Y, D, S, N
36 Appended Validation Date Appended address last validated date YYYYMMDD or YYYYMM, depending on availability.
37 Address Improvement Code Address Improvement Codes:0 - Source Address is best address.1 - Source Address NCOA'd.*2 - Corrected Source Address NCOA'd*.3 - New proprietary change of address returned.4 - Corrected Source Address returned.5 - Source Address NCOA'd, but MLNA.6 - Corrected Source Address NCOA'd, but MLNA.*7 - Source Address NCOA'd, but NIXIE.*8 - Corrected Source Address NCOA'd, but NIXIE.* *Values 1, 2 ,5 - 8 are returned only with the NCOA Add on. 0-8
38 Appended Phone Net new appended 10-digit numeric phone number (without spaces, dashes, or parentheses) 10 characters
39 Appended Phone Type Phone type for the Phone. L=Landline, V=VoIP, W=Wireless, O=Other. L, V, W, O
40 Appended DID Direct Inward Dial Number Y or blank
41 Appended Record Type Appended Record TypeR – ResidentialB – BusinessP – PayphoneU - Unknown R, B, P, U
42 Appended First Date Date record was first received YYYYMMDD
43 Appended Last Date Date record was last received as connected YYYYMMDD
44 Appended Telco Name Name of original telephone company provider 100 Characters
45 Appended Phone Confidence Score Telephone confidence score1 is highest confidence, 5 is lowest. 4’s are considered possible disconnects, 5’s are likely disconnects. PHV 1-3 are considered high confidence records. 1 - 5
46 Appended DA Code Directory Assistance Flag, 1 character max. Y – Record as it appears in Directory Assistance D – Record was removed / delisted from Directory Assistance Blank – Private record (not in Directory Assistance) Y, D, Blank
47 Appended Match Score Appended Match Score (See Appendix B) nnn
48 Appended Match Category Appended Matched Category (up to 3, one for each appended phone)I – IndividualH – HouseholdA – AddressZ – Name/Zip I, H, A, Z
49 Appended Second Phone Net New Appended 10-digit numeric phone number (without spaces, dashes, or parentheses) 10 characters
50 Appended Second Phone Type Phone Type for the second appended phoneL – Land LineV - VoIPW – WirelessO – Other (Pay phone, Pager, Toll Free) L, V, W, O
51 Appended Second DID Direct Inward Dial Number Y or blank
52 Appended Second Record Type Appended Record TypeR – ResidentialB – BusinessP – PayphoneU – Unknown R, B, P, U
53 Appended Second First Date Date record was first received YYYYMMDD
54 Appended Second Last Date Date record was last received as connected YYYYMMDD
55 Appended Second Telco Name Name of original telephone company provider 100 Characters
56 Appended Second Phone Confidence Score Telephone confidence score1 is highest confidence, 5 is lowest. 4’s are considered possible disconnects, 5’s are likely disconnects. PHV 1-3 are considered high confidence records. 1 - 5
57 Appended Second DA Code Directory Assistance Flag, 1 character max. Y – Record as it appears in Directory Assistance D – Record was removed / delisted from Directory Assistance Blank – Private record (not in Directory Assistance) Y, D, Blank
58 Appended Second Match Score Appended Match Score (See Appendix B) nnn
59 Appended Second Match Category Appended Matched Category (up to 3, one for each appended phone)I – IndividualH – HouseholdA – AddressZ – Name/Zip I, H, A, Z
60 Appended Third Phone Net New Appended 10 digit numeric phone number (without spaces, dashes, or parentheses) 10 characters
61 Appended Third Phone Type Phone Type for the Third appended phoneL – Land LineV - VoIPW – WirelessO – Other (Pay phone, Pager, Toll Free) L, V, W, O
62 Appended Third DID Direct Inward Dial Number Y or blank
63 Appended Third Record Type Appended Record TypeR – ResidentialB – BusinessP – PayphoneU – Unknown R, B, P, U
64 Appended Third First Date Date record was first received YYYYMMDD
65 Appended Third Last Date Date record was last received as connected YYYYMMDD
66 Appended Third Telco Name Name of original telephone company provider 100 Characters
67 Appended Third Phone Confidence Score Telephone confidence score1 is highest confidence, 5 is lowest. 4’s are considered possible disconnects, 5’s are likely disconnects. PHV 1-3 are considered high confidence records. 1 - 5
68 Appended Third DA Code Directory Assistance Flag, 1 character max. Y – Record as it appears in Directory Assistance D – Record was removed / delisted from Directory Assistance Blank – Private record (not in Directory Assistance) Y, D, Blank
69 Appended Third Score Appended Match Score (See Appendix B) nnn
70 Appended Third Category Appended Matched Category (up to 3, one for each appended phone)I – IndividualH – HouseholdA – AddressZ – Name/Zip I, H, A, Z
71 Appended Email Net New Appended Email Address 100 Characters
72 Appended Email Suppression Code Email Suppression Code N - Email is Eligible for Deployment N or blank
73 Appended Email Match Score Appended Match Score (See Appendix B) nnn
74 Appended Email Match Category Appended Matched Category I – Individual (First Name, Last Name, and Address)H – Household (Last Name and Address)A – Address (Address)Z – Name/Zip (Last Name and Zip Code) I, H, A, Z
75 Appended Email URL Appended URL - Indicates the website the consumer "opted-in" to receive marketing emails. 100 Characters
76 Appended Email Last Date Appended Email Last Seen Date YYYYMMDD
77 Appended Second Email Net New Appended Email Address 100 Characters
78 Appended Second Email Suppression Code Email Suppression Code N – Email is Eligible for Deployment N or blank
79 Appended Second Email Match Score Appended Match Score (See Appendix B) nnn
80 Appended Second Email Match Category Appended Matched Category I – Individual (First Name, Last Name, and Address)H – Household (Last Name and Address)A – Address (Address)Z – Name/Zip (Last Name and Zip Code) I, H, A, Z
81 Appended Second Email URL Second Appended Email URL - Indicates the website the consumer "opted-in" to receive marketing emails. 100 Characters
82 Appended Second Email Last Date Second Appended Email Last Seen Date YYYYMMDD
83 Appended Third Email Net New Appended Email Address 100 Characters
84 Appended Third Email Suppression Code Email Suppression Code N – Email is Eligible for Deployment N or blank
85 Appended Third Email Match Score Appended Match Score (See Appendix B) nnn
86 Appended Third Email Match Category Appended Matched Category I – Individual (First Name, Last Name, and Address)H – Household (Last Name and Address)A – Address (Address)Z – Name/Zip (Last Name and Zip Code) I, H, A, Z
87 Appended Third Email URL Third Appended Email URL - Indicates the website the consumer "opted-in" to receive marketing emails. 100 Characters
88 Appended Third Email Last Date Third Appended Email Last Seen Date YYYYMMDD
89 Valid Address The validation scores validate the quality of the of the input address data by scoring the formatting of the data on a scale from 0 – 100; 0 being the worst, and 100 being the best. Score 0-100
90 Valid Phone The validation scores validate the quality of the of the input phone data by scoring the formatting of the data on a scale from 0 - 100;0 being the worst, and 100 being the best. Score 0-100
91 Valid Second Phone Score 0-100 that reflects the confidence that a given phone is active and hasn't been reassigned, based on activity & velocity indicators Score 0-100
92 Valid Email The validation scores validate the quality of the of the input email data by scoring the formatting of the data on a scale from 0 – 100; 0 being the worst, and 100 being the best. Score 0-100
93 Valid Name The validation scores validate the quality of the input name data by comparing against common name tables and vulgar word tables to return a score on a scale from 0-100. Score 0-100
94 Phone Confidence Score The Score 0-100 that reflects the confidence that a given phone is active and hasn't been reassigned, based on activity & velocity indicators Score 0-100
95 Second Phone Confidence Score Score 0-100 that reflects the confidence that a given phone is active and hasn't been reassigned, based on activity & velocity indicators Score 0-100
96 Address Confidence Score Score 0-100 that reflects the confidence, accuracy, and deliverability for the input postal address. Score 0-100
97 Name To Phone Using Infutor's identity graph, the "Name" to "Phone" verifies the quality of the of the input identity by scoring the linkage of the "Name" to "Phone" on a scale from 0 – 100. Score 0-100
98 Name To Second Phone Using Infutor's identity graph, the "Name" to "Second Phone" verifies the quality of the of the input identity by scoring the linkage of the "Name" to "Second Phone" on a scale from 0 – 100. Score 0-100
99 Name To Email Using Infutor's identity graph, the "Name" to" Email" verifies the quality of the of the input identity by scoring the linkage of the "Name" to "Email" on a scale from 0 – 100. Score 0-100
100 Name To Address Using Infutor's identity graph, the "Name" to "Address" verifies the quality of the input identity by scoring the linkage of the "Name" to "Address" on a scale from 0 – 100. Score 0-100
101 Address To Phone Using Infutor's identity graph, the "Address" to "Phone" verifies the quality of the input identity by scoring the linkage of the "Address" to "Phone" on a scale from 0 – 100. Score 0-100
102 Address To Second Phone Using Infutor's identity graph, the "Address" to "Second Phone" verifies the quality of the of the input identity by scoring the linkage of the "Address" to "Second Phone" on a scale from 0 – 100. Score 0-100
103 Address To Email Using Infutor's identity graph, the "Address" to "Email" verifies the quality of the of the input identity by scoring the linkage of the "Address" to "Email" on a scale from 0 – 100. Score 0-100
104 Phone To Email Using Infutor's identity graph, the "Phone" to "Email" verifies the quality of the of the input identity by scoring the linkage of the "Phone" to "Email" on a scale from 0 – 100 . Score 0-100
105 Second Phone To Email Using Infutor's identity graph, the "Second Phone" to "Email" verifies the quality of the of the input identity by scoring the linkage of the "Second Phone" to "Email" on a scale from 0 – 100 Score 0-100
106 Deceased The deceased field is used to determine if an identity is living or deceased. A score of 100 represents the individual is living and a score of 0 represents the individual is deceased. If the field is Blank, it means Unknown 0 or 100 or Blank
107 USLocation The "US Location" field is used to determine if an identities' IP Address is recognized to be within USA. A score of 100 represents the individual's IP Address is recognized to be within USA. 0 or 100
108 Valid Count A count of the number of Validation Components which returned a positive verification. Decimal value, 0-5.
109 Linkage Count A count of the number of Linkage Components which returned a positive verification. Decimal value, 0-9.
110 Risk Flag Count A count of the number of Risk Flag Components which returned a positive verification. Decimal value, 0-2.
111 Validation Summary A summary of the Validation Components results. Pass, Fail, or Inconclusive
112 Linkage Summary A summary of the Linkage Components results. Pass, Fail, or Inconclusive
113 Risk Flag Summary A summary of the Risk Flag Components results. Pass, Fail, or Inconclusive
114 ID Verify Score The validation scores validate the quality of the of the input contact data by scoring the formatting of the data on a scale from 0 – 100; 0 being the worse, and 100 being the best. Score 0-100
115 FIPS Code FIPS 2 digit State Code combined with FIPS 3 digit County Code 5 Characters
116 Census Tract Comprised of 6 digit Census Tract, and 4 digit block number 10 Characters
117 Name of Municipality Municipality Name where parcel is located String value
118 Township Coordinates The "township" portion of geographical coordinates based on local surveys. Townships typically run north or south of pre-determined "meridian" in six mile intervals. (e.g., 7, 11S, 1N, 36S) String value
119 Subdivision If the property is in a specific subdivision so noted on deed recordings String value
120 Zoning Codes County and/or Local established Zoning Codes String value
121 Range Coordinates The "range" portion of geographical coordinates based on local surveys. Ranges typically run east or west of pre-determined "meridian" in six mile intervals. (e.g., 3W, 8, 89,31E) String value
122 Section Coordinates The "section" portion of geographical coordinates based on local surveys. Sections are 1 square mile and there are 36 sections within the intersection of a Range / Township. (e.g., 27, 40, 16, 11) String value
123 Property Latitude Property Latitude based on 'parcel' String value
124 Property Longitude Property Longitude based on 'parcel' String value
125 Land Use code A Land Use code converted from various String value
126 APN Assessor's Parcel Number in a formatted form String value
127 APN Sequence Number Sequence number is used to ensure "unique-ness" of the Assessor's Parcel Number String value
128 Absentee Owner Indicator Absentee owner indicator codeA= Absentee(Mail And Situs Not Equal)M= Situs Address Taken From MailO= Owner OccupiedS= Situs From Sale (Occupied)T= Situs From Sale (Absentee) A,M,O,S,T or blank
129 Site Address Indicator Indicate whether the Site data was obtained directly from a county or local Source or was derived by the owners mailing addressM= Mailing AddressS= Local Source M,S or blank
130 Business Owner Indicator Property owner recognized as or business Y or blank
131 Residential Based Indicates whether the property is residential based on individual zip codesY = yesN = no Y, N or blank
132 Property Type Indicator Property type indicator, 2 digit numeric:10 = Single Family Residence / Townhouse11 = Condominium (residential)20 = Commercial21 = Duplex, Triplex, Quadplex22 = Apartment23 = Hotel, Motel24 = Commercial (condominium)25 = Retail26 = Services (general public)27 = Office Building28 = Warehouse29 = Financial Institution30 = Hospital (medical complex, clinic)31 = Parking32 = Amusement – Recreation50 = Industrial51 = Industrial Light52 = Industrial Heavy53 = Transport54 = Utilities70 = Agricultural80 = Vacant90 = Exempt nn
133 Mobile Home Mobile Home is present on the parcel Y or blank
134 Number of Buildings Total number of buildings on the parcel String value
135 Style Indicator Type of building style. Please refer to the Property Addendum document and see "PROP_STYLE" table for code descriptions nnn
136 Number of Stories Number of stories code. Please refer to the Property Addendum document and see “PROP_STORIESCD" table for code descriptions nnn
137 Number of Stories in Building Number of stories String value
138 Number of Apartments Number of Residential, Apartment or Business Units String value
139 Construction quality Type of construction quality of buildingQAV = AVERAGEQBA = BELOW AVERAGEQVV = ABOVE AVERAGEQPO = POORQEX = EXCELLENTQLU = LUXURY999 = BYPASSQGO = GOODQLO = LOWQFA = FAIRQEC = ECONOMICAL nnn
140 Building Type The primary building type code. Please refer to the Property Addendum section and see "PROP_BLDGCD" table for code descriptions nnn
141 Primary Improvement Type Primary improvement type. Please refer to the Property Addendum section and see "PROP_BLDGIMPCD" table for code descriptions nnn
142 Property Condition 0 = NONE999 = BYPASSAVE = AVERAGEDMG = PHYSICAL DAMAGEEXC = EXCELLENTFAI = FAIRGOO = GOODGTE = GOOD TO EXCELLENTPOO = POORUCN = UNDER CONSTRUCTIONUNS = UNSOUNDVGO = VERY GOOD nnn
143 Construction Type Construction Type. Please refer to the Property Addendum document and see "PROP_CNSTRTYPE" table for code descriptions nnn
144 Exterior Walls Type Exterior Walls Type. Please refer to the Property Addendum document and see "PROP_EXTNW" table for code descriptions nnn
145 Land plus Improvement Value The “total” (i.e., land + improvement) value closet to current market value used for assessment by county or local taxing authorities. Integer (dollars)
146 Improvement Value The “improvement” value closest to current market value used for assessment by county or local taxing authorities. Integer (dollars)
147 Property Valuation Type Property Value typeA = AssessedM = MarketP = AppraisedT = Transitional A,M,P,T or blank
148 Land Value Land Value Integer (dollars)
149 Land Value Indicator Land Value IndicatorA = AssessedM = MarketP = AppraisedT = Transitional A,M,P,T or blank
150 Improvement Value Indicator The “improvement” value indicatorA = AssessedM = MarketP = AppraisedT = Transitional A, M, P, or T
151 Assessed Value The Total Assessed Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority. Integer (dollars)
152 Assessed Land Value Assessed Land Value Integer (dollars)
153 Assessed Improvement Value Assessed Improvement Value Integer (dollars)
154 Total Market Value Total Market Value Integer (dollars)
155 Market Land Values Market Land Values Integer (dollars)
156 Market Improvement Value Market Improvement Values Integer (dollars)
157 Total Appraised Value Total Appraised Value Integer (dollars)
158 Appraised Land Value Appraised Land Value Integer (dollars)
159 Appraised Improvement Values Appraised Improvement Values Integer (dollars)
160 Year Built The construction year of the original building. (e.g., YYYY). YYYY
161 Effective Year Built Effective Year Built YYYY
162 Property View Property View, Please refer to the Property Addendum document and see "PROP_VIEW " table for code descriptions nnn
163 Location Associated Aspects Location Associated Aspects, Please refer to the Property Addendum document and see "PROP_LCTN_INFL" table for code descriptions nnn
164 Front Linear Feet Front Linear Feet Integer
165 Linear Feet between Linear feet between Integer
166 Total Acres Total land mass in acres. (4 decimal points). Example: 13000=1.3 acres. Integer
167 Land Square Feet Total land mass in Square Feet. Integer
168 Building Square Footage Building Square Footage Integer
169 Square foot type indicator Square foot type indicator, 1 character max.R = GROUND FLOOR LEVELH = HEATED AREAM = MAIN OR BASE AREAB = BUILDINGA = ADJUSTEDL = LIVINGG = GROSS R,H,M,B,A,L,G or blank
170 Building Square Feet Building Square feet Integer
171 Living Square Feet The area of a building that is used for general living. This is typically the area of a building that is heated or air conditioned and does not include Garage, Porch or Basement square footage. Integer
172 Square Footage Front Square Footage Front Integer
173 Entire Building Square Footage Building Square Footage Integer
174 Square Footage for Improvement Value Square Footage for Improvement Value Integer
175 Basement Square Footage Basement Square Footage Integer
176 Square footage of parking Square footage of parking Integer
177 Number of Rooms Total number of rooms contained in the primary building. Integer
178 Number of Bedrooms Total number of bedrooms contained in the primary building. Integer
179 Total Number of Bathrooms Number of Bathrooms Integer
180 Number of Bathrooms Total number of bathrooms, 2 implied decimal places. 2.00 baths = 200. Integer
181 Total Full baths Total number of Full Baths (typically comprised of a sink, toilet, and bathtub / shower stall). A home containing 2 1/2 baths would have the number 2 stored in this field. Integer
182 Total Half baths Total number of Half Baths (typically comprised of a sink & toilet). A home containing 2 1/2 baths would have the number 1 stored in this field. Integer
183 Total quarter baths Total quarter baths Integer
184 Number of 3 quarter baths Number of 3 quarter baths Integer
185 Total Bathroom Fixtures Total Bathroom Fixtures Integer
186 Air Conditioning Type The type of air conditioning method used to cool the building(e.g., Central, Wall Unit, Evaporative):0=AC.NONEACA=AC.COMMERCIAL A/CACE=AC.CENTRALACH=AC.CHILLED WATERACP=AC.CENTRAL PARTIALACW=AC.CENTRAL & UNITADU=AC.DUAL UNITAEV=AC.EVAPORATIVEAFA=AC.FAN COOLINGAHT=AC.HEAT PUMPAOF=AC.OFFICE ONLYAPF=AC.REFRIGERATIONAPK=AC.PACKAGEAPR=AC.PACKAGE ROOFAPT=AC.PARTIALAPV=AC.REFRIGERATION/EVAPORATIONASE=AC.SEPARATE SYSTEMASO=AC.SOLARASP=AC.SPLIT SYSTEMAWA=AC.WALL UNITAWI=AC.WINDOW UNITAWN=AC.WALL/WINDOW UNIT nnn(3 characters)
187 Basement Type Basement Type0 = NONE999 = BYPASSBFL = FULLCRA = CRAWL-SPACEFBE = BEDROOMFBR = BEDROOM & RECREATION ROOMFCF = COMPLETELY FINISHEDFFD = FINISHED WITH DRYWALLFFI = FINISHEDFFL = FINISHED WITH PLASTERFFP = FINISHED WITH PANELFOF = OFFICEFPA = PARKINGFPF = PARTIALLY FINISHEDFRE = RESIDENTFRR = RECREATION ROOMFST = STORAGEFUN = UNFINISHEDFUT = UTILITY nnn
188 Presence of Fireplace This field is populated with a "Y" if a fireplace is located within the building. Y or blank
189 Number of Fireplace Openings Number of Fireplace Openings Integer
190 Type of Fireplace Type of Fireplace, Please refer to the Property Addendum document and see "PROP_FRPLTYPE” table for code descriptions nnn
191 Type of Foundation Type of Foundation, Please refer to the Property Addendum document and see "PROP_FND" table for code descriptions nnn
192 Floor Construction Type Floor Construction Type999 = BYPASSA = CONCRETEB = WOODC = PLYWOODD = CONCRETE/ASPHALTE = BRICKF = ACRYLICG = ASBESTOSH = GRAVELI = SLATEJ = DIRTK = CINDER BLOCKL = ASPHALTM = BRICK/STONEN = BRICK/STONE/SLATEP = METAL DECKQ = METAL GRATINGR = CORREGATED DECKS = WOOD SHEATHINGT = STEEL-FLAT-SLAB nnn
193 Type of Roof Framing Type of Roof Framing999 = BYPASSB = BAR JOISTC = CONCRETED = BAR JOIST & WOOD DECKE = METAL PIPEF = WOOD FRAMEG = BOWSTRINGJ = BAR JOIST & CONCRETE DECKL = FLEXIBLE/FLEXICOREM = METALO = REINFORCED CONCRETEP = LONGSPAN TRUSSQ = PRESTRESS CONCRETER = BAR JOIST & RIGID FRAMES = STEELT = TRUSS/JOISTU = WOOD BEAMW = WOODX = WOOD JOISTY = WOOD ON STEELZ = WOOD TRUSS nnn
194 Type of Garage Type of Garage, Please refer to the Property Addendum document and see "PROP_GAR" table for code descriptions nnn
195 Method of Heating Method of Heating, Please refer to the Property Addendum document and see "PROP_HEAT" table for code descriptions nnn
196 Number of Parking Spaces Number of Parking Spaces Integer
197 Parking Type Parking Type, Please refer to the Property Addendum document and see "PROP_PRKGTYPE" table for code descriptions nnn
198 Presence of Pool Populated with a "Y" if a Pool is present on the parcel. Y or blank
199 Pool Type Pool Type, Please refer to the Property Addendum document and see "PROP_POOLCD" table for code descriptions nnn
200 Roof Covering Roof Covering, Please refer to the Property Addendum document and see "PROP_ROOFCOVER" table for code descriptions nnn
201 Roof Type 999=BYPASS9A0=IRREGULAR9B0=LEAN TOA=A-FRAMEB=BARNC=CANOPYD=DORMERE=FRAMEF=FLATG=GABLEH=GABLE/HIPI=HIPJ=GEODESICK=MANSARDL=BARRELM=MONITORN=CONTEMPORARYO=SHEDP=PITCHEDQ=PYRAMIDR=ARCHEDS=SAWTOOTHT=CATHEDRAL/CLERESTORYU=BUBBLEV=GAMBRELW=SWISS CHALET/ALPINEX=COMPLEX/CUSTOMY=BUTTERFLYZ=GAMBREL/MANSARD nnn(3 characters)
202 Type of Electricity Type of Electricity0 = NONE999 = BYPASSEAG = AVERAGE WIRINGEAV = AVAILABLEEBA = BELOW AVERAGE WIRINGECN = CONNECTEDEEX = EXTENSIVE WIRINGEGO = GOOD WIRINGEHE = HEAVY WIRINGELI = LIGHT WIRINGEMA = MAXIMUM WIRINGEME = MEDIUM WIRINGEMI = MINIMAL WIRINGEOV = OVERHEAD WIRESEPR = PRIVATE SOURCEETY = TYPICAL WIRINGEUN = UNDERGROUND WIRES nnn
203 Heating Fuel Type Heating Fuel Type, Please refer to the Property Addendum document and see "PROP_FUEL" table for code descriptions String value
204 Sewer Type Sewer Type0 = NONE999 = BYPASSSPU = PUBLICSCE = CESSPOOLSSE = SEPTICSPR = PRIVATESTR = STORMSCO = COMMERCIAL nnn
205 Water Supply Type Water Supply Type, 3 characters max.0 = NONE999 = BYPASSWPU = PUBLICWSC = SPRING/CREEKWWE = WELLWPR = PRIVATEWCO = COMMERCIALWPW = PUBLIC WELLWCI = CISTERN nnn
206 Homestead Qualified Homestead Qualified Y or blank
207 Combat Veteran Presence of Veteran Y or blank
208 Disabled Disable Veteran Y or blank
209 Tax Amount The tax amount provided by the county or local taxing / assessment authority Integer (dollars)
210 Tax Year Tax Year YYYY
211 Sale Year Sale Year YYYY
212 Deed Type Deed Type, 1 character max.U = FORECLOSUREQ = QUIT CLAIMX = MULTI CNTY/ST OR OPEN-END-MTGT = DEED OF TRUSTG = DEEDD = RELEASE OF DEED OF TRUST/MTGF = FINAL JUDGEMENTJ = MECHANIC LIENSL = LIS PENDENSN = NOTICE OF DEFAULTR = RELEASE/RECISIONS = LOAN ASSIGNMENT U,Q,X,T,G,D,F,J, L,N,R,S or blank
213 Recording Date The date the sales transaction was record at the county YYYYMMDD
214 Seller Name Seller Name String Value
215 Sale Date Sale Date YYYYMMDD
216 Sell Price Price of the sale as depicted on the recorded sales transaction. Integer (dollars)
217 Sale Code Sale CodeV = VERIFIEDR = LEASEP = SALE PRICE (PARTIAL)C = CONFIRMEDN = STAMPS ON BACK/NON-DISCLOSEDF = SALE PRICE (FULL)E = ESTIMATEDL = COMMITTED V,R,P,C,N,F,E,L or blank
218 Parcel Sales Parcel Sales, 1 character max.D = MULTI / DETAIL PARCEL SALEM = MULTIPLE PARCEL SALEX = MULTI / SPLIT PARCEL SALES = MULTI / SPLIT PARCEL SALE D,M,X,S or blank
219 Number of Parcels Number of Parcels Integer
220 Last Assessment Year Last Assessment Year YYYY
221 Sale Type Sale Type1 = RESALE2 = REFINANCE3 = SUBDIVISION/NEW CONSTRUCTION4 = TIMESHARE6 = CONSTRUCTION LOAN7 = SELLER CARRYBACK9 = NOMINALD = RELEASE OF DEEDS = ASSIGNMENT OF DEED OF TRUST 1,2,3,4,6,7,9,D,S or blank
222 Prior Recorded Sale Date Prior Recorded Sale Date YYYYMMDD
223 Prior Completed Sale Date Prior Completed Sale Date YYYYMMDD
224 Price of Sale Price of Sale Integer (dollars)
225 Prior Sale Type Prior Sale TypeF = FullP = Partial F, P or Blank
226 Parcel Type Parcel TypeM = MULTIPLE PARCEL SALED = MULTI / DETAIL PARCEL SALEX = MULTI / SPLIT PARCEL SALES = SPLIT PARCEL SALE M,D,X,S or blank
227 Prior Deed Code Prior Deed Code, Please refer to the Property Addendum document and see PROP_DEEDCD_PRIOR" table for code descriptions String value
228 Prior Sale Year Recorded Prior Sale Year Recorded YYYY
229 Prior Deed Type Used Prior Deed Type UsedD = RELEASE OF DEED OF TRUST/MTGF = FINAL JUDGEMENTG = DEEDJ = MECHANIC LIENSL = LIS PENDENSN = NOTICE OF DEFAULTQ = QUIT CLAIMR = RELEASE/RECISIONS = LOAN ASSIGNMENTT = DEED OF TRUSTU = FORECLOSUREX = MULTI CNTY/ST OR OPEN-END-MTGW = WARRANTY DEEDI = ALL INCLUSIVE DEED OF TRUSTM = MORTGAGEC = CONSTRUCTION DEED OF TRUSTA = ASSIGNMENT DEEDE = EXEMPTION DEED n
230 Prior Sale Transaction Code Prior Sale Transaction Code1 = RESALE2 = REFINANCE3 = SUBDIVISION/NEW CONSTRUCTION4 = TIMESHARE6 = CONSTRUCTION LOAN7 = SELLER CARRYBACK9 = NOMINALD = RELEASE OF DEEDS = ASSIGNMENT OF DEED OF TRUST 1,2,3,4,6,7,9,D,S or blank
231 Prior Sale Mortgage Amount Prior Sale Mortgage Amount Integer
232 Fixed or Variable Mortgage Fixed or Variable MortgageFIX = FixedADJ = AdjustableVAR = VariableBAL = Balloon nnn
233 Owner Type Owner Type, Please refer to the Property Addendum document and see "PROP_OWNERCD" table for code descriptions nnn
234 Seller Carry Back Seller Carry BackY = YESA = ASSUMED Y,A or blank
235 Title Company Title Company String values
236 Loan To Value Loan To Value String values
237 Mortgage Amount Amount of loan. Integer (dollars)
238 Mortgage Date Date mortgage was initiated. YYYYMMDD
239 Mortgage Type Mortgage TypeWRP = WRAP-AROUND MORTGAGEVA = Veterans AffairsFHA = Federal Housing AdministrationCNV = CONVENTIONALSBA = SMALL BUSINESS ADMINISTRATIONPP = PRIVATE PARTY LENDERCDA = COMMUNITY DEVLOPMENT AUTHORITYCNS = CONSTRUCTIONLH = LEASE HOLD MORTGAGEPMM = PURCHASE MONEY MORTGAGE nnn
240 Mortgage Deed Type Mortgage Deed Type, Please refer to the layout document and see “PROP_MTGDEEDCD" table for code descriptions String value
241 Mortgage Term The length of time of the mortgage in years. Integer (years)
242 Mortgage Due Date Date mortgage becomes due. YYYYMMDD
243 Mortgage Amount Assumed Mortgage Amount Assumed Integer (dollars)
244 Lender Name Lender Name String value
245 Refi Type Refi TypeY = YEST = TRUST Y,T or blank
246 Equity in Property Equity in Property Y or blank
247 Mortgage Interest Rate Rate Associated with Mortgage (4 decimal). String value, Example: 47300 - 4.73%
248 Mortgage Rate Type Mortgage Rate TypeFIX = FixedADJ = AdjustableVAR = VariableBAL = Balloon nnn
249 2nd Mortgage Amount 2nd Mortgage Amount Integer (dollars)
250 2nd Mortgage Date 2nd Mortgage Date YYYYMMDD
251 2nd Mortgage Type 2nd Mortgage Type String value
252 2nd Deed Type 2nd Deed Type String value
253 2nd Mortgage Term 2nd Mortgage Term String value
254 2nd Mortgage Due Date 2nd Mortgage Due Date YYYYMMDD
255 2nd Mortgage Amount Assumed 2nd Mortgage Amount Assumed String value
256 2nd Mortgage Lender Name 2nd Mortgage Lender Name String value
257 2nd Mortgage Refi Type 2nd Mortgage Refi Type String value
258 2nd Equity in Property 2nd Equity in Property String value
259 2nd Mortgage Interest Rate Rate Associated with Mortgage (4 decimal). String value, Example: 47300 - 4.73%
260 2nd Mortgage Rate Type 2nd Mortgage Rate Type String value
261 3rd Mortgage Amount 3rd Mortgage Amount Integer (dollars)
262 3rd Mortgage Date 3rd Mortgage Date YYYYMMDD
263 3rd Mortgage Type 3rd Mortgage Type String value
264 3rd Mortgage Deed Type 3rd Mortgage Deed Type String value
265 3rd Mortgage Term 3rd Mortgage Term String value
266 3rd Mortgage Due Date 3rd Mortgage Due Date YYYYMMDD
267 3rd Mortgage Amount Assumed Mortgage Amount Assumed Integer (dollars)
268 3rd Mortgage Lender Name 3rd Mortgage Lender Name String value
269 3rd Mortgage Refi Type 3rd Mortgage Refi Type String value
270 3rd Equity in Property 3rd Equity in Property String value
271 3rd Mortgage Interest Rate Rate Associated with Mortgage (4 decimal). String value, Example: 47300 - 4.73%
272 3rd Mortgage Rate Type 3rd Mortgage Rate Type String value
273 Gender M=male, F=Female, blank or U=unknown. M, F, or U
274 Age Adult age. 0 - 99
275 Length of Residence Length of Residence in years, 2 digits. 00 - 99
276 Homeowner H=Homeowner, R=Renter, A=Likely Homeowner, B=Likely Renter H, R, A or B
277 Estimated Household Income Estimated household income, 1 character:A = Less than $20,000B = $20,000 - $29,999C = $30,000 - $39,999D = $40,000 - $49,999E = $50,000 - $74,999F = $75,000 - $99,999G = $100,000 - $124,999H = $125,000 or more A - I
278 Dwelling Type Dwelling Type. S=Single Family Dwelling Unit (SFDU). M=Multi-family Dwelling Unit (MFDU). S or M
279 Marital Status M=Married, S=Single, A=Likely Married, B=Likely Single. M, S, A, or B
280 Median Year Built The year home was built. 4 digits. nnnn
281 Mobile Home Indicator Residence is a mobile home Y or Blank
282 Pool Owner Pool owner Y or Blank
283 Fireplace in Home Home with fireplace Y or Blank
284 Single Parent Single Parent flag Y or Blank
285 Senior in HouseHold Known resident of HH that is 65 or older Y or Blank
286 Credit Card User Known use of Credit Card Y or Blank
287 Wealth Score Model based on income, homeownership, and other assets owned:A = Estimated Net less than $5,000B = Estimated Net $5,000 - $19,999C = Estimated Net $20,000 - $49,999D = Estimated Net $50,000 – $79,999E = Estimated Net $80,000 - $99,999F = Estimated Net $100,000 - $249,999G = Estimated Net $250,000 - $499,999H = Estimated Net over $500,000 A - H
288 Donor to Charity or Causes Charity donor Y or Blank
289 Home Market Value Estimated Home Market value:A = $1,000 - $24,999B = $25,000 - $49,999C = $50,000 - $74,999D = $75,000 - $99,999E = $100,000 - $124,999F = $125,000 - $149,999G = $150,000 - $174,999H = $175,000 - $199,999I = $200,000 - $224,999J = $225,000 - $249,999K = $250,000 - $274,999L = $275,000 - $299,999M = $300,000 - $349,999N = $350,000 - $399,999O = $400,000 - $449,999P = $450,000 - $499,999Q = $500,000 - $749,999R = $750,000 - $999,999S = $1,000,000+ A - S
290 Education Education levelA= Completed High SchoolB= Completed CollegeC= Completed Graduate SchoolD= Attended Vocational/Technical A,B,C,D or blank
291 Ethnicity Ethnicity codeHispanic = Ethnic code YAfrican American = Ethnic code FAsian = Ethnic code A *Information (values) for the states of CO, CT and VA are not provided for this field. The data has been removed based upon our approach to the Sensitive Personal Information requirements for Colorado Privacy Act, the Connecticut Data Privacy Act, and Virginia’s Consumer Data Protection Act. Y,F,A or blank
292 Presence of Children Presence of Children. Y= Children present. Y or blank
293 Child age Ranges Children age rangeA = Presence of Children under 5B = Presence of Children aged 6 – 10C = presence of Children age 11 – 15D = Presence of Children age 17-17 A,B,C,D or blank
294 Number of Children Number of Children. A=No Children, B=less than 3, C= 3-5 Children. A – C
295 Luxury Vehicle Owner Luxury vehicle owner Y or blank
296 SUV Owner SUV vehicle owner Y or blank
297 Pickup Truck Owner Pickup Truck vehicle owner Y or blank
298 Percent Range Black Percent Range Black (Penetration Range - See Appendix A) A – T
299 Percent Range White Percent Range White (Penetration Range - See Appendix A) A – T
300 Percent Range Hispanic Percent Range Hispanic (Penetration Range - See Appendix A) A – T
301 Percent Range Asian Percent Range Asian (Penetration Range - See Appendix A) A – T
302 Percent Range English Speaking Percent Range English Speaking (Penetration Range - See Appendix A) A – T
303 Percentage Range Spanish Speaking Percent Range Spanish Speaking (Penetration Range - See Appendix A) A – T
304 Percent Range Speaking an Asian Language Percent Range Speaking an Asian Language (Penetration Range - See Appendix A) A – T
305 Percentage Range SFDU Percent Range SFDU (Penetration Range - See Appendix A) A – T
306 Percent Range MFDU Percent Range MFDU (Penetration Range - See Appendix A) A – T
307 Median House Value Median House Value Code:A = Less than $50,000B = $50,000 - $99,999C = $100,000 - $149,999D = $150,000 - $249,999E = $250,000 - $349,999F = $350,000 - $499,999G = $500,000 - $749,999H = $750,000 - $999,999I = $1,000,000+ A – I
308 Mail Order Respondent Mail Order Respondent (Penetration Range - See Appendix A) A – T
309 Percent Range Automobile Owner Penetration Range Automobile owner (Range - See Appendix A) A – T
310 Median Years of School Median years of school, 3 digits max. 1 implied decimal. eg 210 = 21.0 years 000-220
311 Penetration Range White Collar Percent Range White Collar (Penetration Range - See Appendix A) A – T
312 Penetration Range Blue Collar Percent Range Blue Collar (Penetration Range - See Appendix A) A – T
313 Penetration Range Other Occupation Percent Range Other Occupation (Penetration Range - See Appendix A) A – T
314 Demographic Level Demographic append level 1 - Zip,Zip+4; 2 - Zip,Zip+2; 3 – Zip 1,2,3
315 Price Club and value Purchasing Indicator Value shopper Y or blank
316 Women Apparel Purchasing Indicator Women’s Apparel A = Purchased Women's Apparel B = Purchased Plus size Women's Apparel A,B or blank
317 Men Apparel Purchasing Indicator Men’s Apparel A = Purchased Men's Apparel B = Purchased Big and Tall Men's Apparel A,B or blank
318 Parenting and Children Interest Bundle Parenting and Children's interest Y or blank
319 Pets Lover Pets Lover or Owner: A = Has Pets B = Equestrian C = Cat Owner D = Dog Owner A,B,C,D or blank
320 Book Buyers Books Buyer Y or blank
321 Book Readers Reader = Y or Blank, 1 character maximum Y or blank
322 Hi-Tech Enthusiasts Hi Tech Enthusiasts Y or blank
323 Arts Bundle Art enthusiastsA = Interest in ArtsB = Avid Music ListenerC = Interest in AntiquesD = Interest in Performing Arts A,B,C,D or blank
324 Collectibles Bundle Collectible’s enthusiastsA = General Interest in CollectiblesB = Interest in Antique CollectiblesC = Interest in Sports Collectibles A,B,C or blank
325 Hobbies Home and Garden Bundle Home garden interestA = Interest in Sewing and KnittingB = Interest in WoodworkingC = Interest in PhotographyD = Home and Garden A,B,C,D or blank
326 Home Improvement Home ImprovementsA – Home Improvement InterestB – Home Improvement DIY A,B or blank
327 Cooking and Wine Cook or Wine enthusiastsA = Gourmet Food and WineB = CookingC = Natural Foods A,B,C or blank
328 Gaming and Gambling Enthusiast Gaming casino, sweepstakes Y or blank
329 Travel Enthusiasts Travel enthusiastsA = TravelB = DomesticC = InternationalD = Cruise A,B,C,D or blank
330 Physical Fitness Fitness enthusiastsA = Interest in Health ExerciseB = RunningC = WalkingD = Aerobics A,B,C,D or blank
331 Self Improvement Health, medical, dieting weight loss, self-improvementA = Health & MedicalB = Dieting Weight lossC = Self-Improvement A,B,C or blank
332 Automotive DIY Parts and accessories, auto work Y or blank
333 Spectator Sports Interest Interest in SportsA = Interest in Sports, GeneralB = Interest in FootballC - Interest in BaseballD = Interest in GolfE = Interest in TennisF - Interest in Auto and Motorcycle racing A,B,C,D,E,F or blank
334 Outdoors Interest in OutdoorsA = Interest in Outdoor - GeneralB = Interest in Snow SportsC = interest in Water SportsD = Interest in Hunting and Fishing A,B,C,D or blank
335 Avid Investors Investing active Y or blank
336 Avid Interest in Boating Interest in Boating Y or blank
337 Avid Interest in Motorcycling Interest on Motorcycling Y or blank
338 GEO Credit **This is a premium attribute field available only by subscription. Contact Infutor Sales for more information. Purchasing Power Model refers to the GEO Credit Score, 1 character:A = (820-High)B = (800-819)C = (780-799)D = (760-779)E = (740-759)F = (720-739)G = (700-719)H = (680-699)I = (660-679)J = (640-659)K = (620-639)L = (600-619)M = (580-599)N = (560-579)O = (540-559)P = (520-539)Q = (500-519)R = (480-499)S = (460-479)T = (Low-459) A - T
339 Phone Type Phone type for the Phone. L=Landline, V=VoIP, W=Wireless, O=Other. L, V, W, O
340 Second Phone Type Phone type for the 2nd Phone. L=Landline, V=VoIP, W=Wireless, O=Other. L, V, W, O
341 Auto Make Vehicle Make, 30 characters max. String value
342 Auto Model Vehicle Model, 30 characters max. String Value
343 Auto Year Vehicle Year YYYY
344 Auto Class Vehicle Class CodeCROSSOVERFULL SIZE CARFULL SIZE SUVFULL SIZE TRUCKFULL SIZE VANMID SIZE CARMID SIZE TRUCKMID SIZE SUVMINIVANSMALL CARSMALL SUVSMALL TRUCK 15 characters
345 Auto Fuel Type Vehicle Fuel Code:B - BiodieselcolumnD - DieselF - Flex-FuelG – GasolineH - Fuel CellI - Plug-In ElectricL - Electric/GasN - CNG (Compressed Natural Gas)P - PropaneY - Hybrid B, D, F, G, H, I, L, N, P, Y
346 Auto MFG Vehicle Manufacturing CodeA - AntiqueC - Chrysler ProductsF - Ford ProductsG - GM ProductsH - High end ImportsL - Low End ImportsO - Other A, C, F, G, H, L, O
347 Auto Style Vehicle Style Code:CONVCOUPECUVHATCHBACKLUXURYPICKUPSEDANSPORTUTILVAN 10 characters
348 Mileage Mileage from the last odometer reading in increments of 10,000.A=0-10,000. Z= 250,000+. A-Z
349 Last Verified Date Last verification date. YYYYMMDD
350 Second Auto Make Second Vehicle Make, 30 characters max. String value
351 Second Auto Model Second Vehicle Model, 30 characters max. String Value
352 Second Auto Year Second Vehicle Year YYYY
353 Second Auto Class Second Vehicle Class CodeCROSSOVERFULL SIZE CARFULL SIZE SUVFULL SIZE TRUCKFULL SIZE VANMID SIZE CARMID SIZE TRUCKMID SIZE SUVMINIVANSMALL CARSMALL SUVSMALL TRUCK 15 characters
354 Second Auto Fuel Type Second Vehicle Fuel Code:B - BiodieselcolumnD - DieselF - Flex-FuelG – GasolineH - Fuel CellI - Plug-In ElectricL - Electric/GasN - CNG (Compressed Natural Gas)P - PropaneY - Hybrid B, D, F, G, H, I, L, N, P, Y
355 Second Auto MFG Second Vehicle Manufacturing CodeA - AntiqueC - Chrysler ProductsF - Ford ProductsG - GM ProductsH - High end ImportsL - Low End ImportsO - Other A, C, F, G, H, L, O
356 Second Auto Style Second Vehicle Style Code:CONVCOUPECUVHATCHBACKLUXURYPICKUPSEDANSPORTUTILVAN 10 characters
357 Second Auto Mileage Second Vehicle Mileage from the last odometer reading in increments of 10,000.A=0-10,000. Z= 250,000+. A-Z
358 Second Auto Last Verified Date Second Vehicle Last verification date. YYYYMMDD
359 Third Auto Make Third Vehicle Make, 30 characters max. String value
360 Third Auto Model Third Vehicle Model, 30 characters max. String Value
361 Third Auto Year Third Vehicle Year YYYY
362 Third Auto Class Third Vehicle Class CodeCROSSOVERFULL SIZE CARFULL SIZE SUVFULL SIZE TRUCKFULL SIZE VANMID SIZE CARMID SIZE TRUCKMID SIZE SUVMINIVANSMALL CARSMALL SUVSMALL TRUCK 15 characters
363 Third Auto Fuel Type Third Vehicle Fuel Code:B - BiodieselcolumnD - DieselF - Flex-FuelG – GasolineH - Fuel CellI - Plug-In ElectricL - Electric/GasN - CNG (Compressed Natural Gas)P - PropaneY - Hybrid B, D, F, G, H, I, L, N, P, Y
364 Third Auto MFG Third Vehicle Manufacturing CodeA - AntiqueC - Chrysler ProductsF - Ford ProductsG - GM ProductsH - High end ImportsL - Low End ImportsO - Other A, C, F, G, H, L, O
365 Third Auto Style Third Vehicle Style Code:CONVCOUPECUVHATCHBACKLUXURYPICKUPSEDANSPORTUTILVAN 10 characters
366 Third Auto Mileage Third Vehicle Mileage from the last odometer reading in increments of 10,000.A=0-10,000. Z= 250,000+. A-Z
367 Third Auto Last Verified Date Third Vehicle Last verification date. YYYYMMDD
368 Fourth Auto Make Fourth Vehicle Make, 30 characters max. String value
369 Fourth Auto Model Fourth Vehicle Model, 30 characters max. String Value
370 Fourth Auto Year Fourth Vehicle Year YYYY
371 Fourth Auto Class Fourth Vehicle Class CodeCROSSOVERFULL SIZE CARFULL SIZE SUVFULL SIZE TRUCKFULL SIZE VANMID SIZE CARMID SIZE TRUCKMID SIZE SUVMINIVANSMALL CARSMALL SUVSMALL TRUCK 15 characters
372 Fourth Auto Fuel Type Fourth Vehicle Fuel Code:B - BiodieselcolumnD - DieselF - Flex-FuelG – GasolineH - Fuel CellI - Plug-In ElectricL - Electric/GasN - CNG (Compressed Natural Gas)P - PropaneY - Hybrid B, D, F, G, H, I, L, N, P, Y
373 Fourth Auto MFG Fourth Vehicle Manufacturing CodeA - AntiqueC - Chrysler ProductsF - Ford ProductsG - GM ProductsH - High end ImportsL - Low End ImportsO - Other A, C, F, G, H, L, O
374 Fourth Auto Style Fourth Vehicle Style Code:CONVCOUPECUVHATCHBACKLUXURYPICKUPSEDANSPORTUTILVAN 10 characters
375 Fourth Auto Mileage Fourth Vehicle Mileage from the last odometer reading in increments of 10,000.A=0-10,000. Z= 250,000+. A-Z
376 Fourth Auto Last Verified Date Fourth Vehicle Last verification date. YYYYMMDD
377 IP Address IP v4 address. xxx.xxx.xxx.xxx IP v4 address
378 Region Region. State name if within the US. 50 characters
379 IP City Approximate city the IP address is located within. 28 characters
380 IP Zip Approximate latitude of the IP address. 11 characters
381 Latitude Approximate longitude of the IP address. 11 characters
382 Longitude Approximate Zip code associated with the IP address. 5 characters
383 Internet Provider Internet service provider responsible for the IP address 255 characters
384 IP From Starting IP of the range that the IP address belongs xxx.xxx.xxx.xxx IP v4 address
385 IP To Final IP of the range that the IP address belongs xxx.xxx.xxx.xxx IP v4 address

Appendix A: Demographic Tag Descriptions

The following is a table of demographic tags descriptions:
XML Tag Name Description Description
Percent Range Black Percent Range Black Penetration Range - See Below
Percent Range White Percent Range White Penetration Range - See Below
Percent Range Hispanic Percent Range Hispanic Penetration Range - See Below
Percent Range Asian Percent Range Asian Penetration Range - See Below
Percent Range English Speaking Percent Range English Speaking Penetration Range - See Below
Percentage Range Spanish Speaking Percentage Range Spanish Speaking Penetration Range - See Below
Percent Range Asian Speaking Percent Range Asian Speaking Penetration Range - See Below
Percentage Range SFDU Percentage Range SFDU Penetration Range - See Below
Percent Range MFDU Percent Range MFDU Penetration Range - See Below
Mail Order Respondent Mail Order Respondent Percent Penetration Range - See Below
Percent Range Automobile Owner Percent Range Automobile Owner Penetration Range - See Below
Penetration Range White Collar Penetration Range White Collar Penetration Range - See Below
Penetration Range Blue Collar Penetration Range Blue Collar Penetration Range - See Below
Penetration Range Other Occupation Penetration Range Other Occupation Penetration Range - See Below
 
Penetration Percentage Ranges
A Greater than 95 K 50 thru 46
B 95 thru 91 L 45 thru 41
C 90 thru 86 M 40 thru 36
D 85 thru 81 N 35 thru 31
E 80 thru 76 O 30 thru 26
F 75 thru 71 P 35 thru 21
G 70 thru 66 Q 20 thru 16
H 65 thru 61 R 15 thru 11
I 60 thru 56 S 10 thru 06
J 55 thru 51 T Less than 6

Appendix B: Match Score Descriptions

Category Description Score Description
IE = Individual with Email 100 Exact First, Exact Last, Exact Street Address, Unit W/A, Zip
IP = Individual with Phone 101 Fuzzy First, Exact Last, Exact Street Address, Unit W/A, Zip
IEP = Individual with Email and Phone 102 Exact First, Fuzzy Last, Exact Street Address, Unit W/A, Zip
103 Fuzzy First, Fuzzy Last, Exact Street Address, Unit W/A, Zip
104 Exact First, Exact Last, Exact Street Address, Unit Missing, Zip
105 Fuzzy First, Exact Last, Exact Street Address,Unit Missing, Zip
106 Exact First, Fuzzy Last, Exact Street Address, Unit Missing, Zip
107 Fuzzy First, Fuzzy Last, Exact Street Address, Unit Missing, Zip
108 Exact First, Exact Last, Fuzzy Street Address, Zip
109 Fuzzy First, Exact Last, Fuzzy Street Address, Zip
110 Exact First, Fuzzy Last, Fuzzy Street Address, Zip
111 Fuzzy First, Fuzzy Last, Fuzzy Street Address, Zip
HE = HouseHold with Email 200 Exact Last, Exact Street Address, Unit W/A, Zip
HP = HouseHold with Phone 201 Fuzzy Last, Exact Street Address, Unit W/A, Zip
HEP = HouseHold with Email and Phone 202 Exact Last, Exact Street Address, Unit Missing, Zip
203 Fuzzy Last, Exact Street Address, Unit Missing, Zip
204 Exact Last, Fuzzy Street Address, Zip
205 Fuzzy Last, Fuzzy Street Address, Zip
AE = Address with Email 300 Exact Street Address, Unit W/A, Zip
AP = Address with Phone 301 Exact Street Address, Unit Missing, Zip
AEP = Address with Email and Phone 302 Fuzzy Street Address, Zip
NP = Name/Phone 400 Exact First, Exact Last, Phone
401 Fuzzy First, Exact Last, Phone
402 Exact First, Fuzzy Last, Phone
403 Fuzzy First, Fuzzy Last, Phone
LP = Last/Phone 450 Exact Last, Phone
451 Fuzzy Last, Phone
NE = Name/Email 470 Exact First, Exact Last, Email
471 Fuzzy First, Exact Last, Email
472 Exact First, Fuzzy Last, Email
473 Fuzzy First, Fuzzy Last, Email
NEP = Name/Email with phone 470 Exact First, Exact Last, Email, Phone
471 Fuzzy First, Exact Last, Email, Phone
472 Exact First, Fuzzy Last, Email, Phone
473 Fuzzy First, Fuzzy Last, Email, Phone
LE = Last/Email 480 Exact Last, Email
481 Fuzzy Last, Email
LEP = Last/Email with Phone 480 Exact Last, Email Phone, Email
481 Fuzzy Last, Email Phone, Email
FP = First/Phone 460 Exact First, Phone
461 Fuzzy, Phone
FE = First/Emaill 490 Exact First, Email
491 Fuzzy First, Email
FEP = First/Email with Phone 490 Exact First, Email, Phone, Email
491 Fuzzy First, Email, Phone, Email
EP = Email with Phone 900 Phone with Email Verified
P 900 Phone Verified
E 900 Email Verified
X or none 999 No match found

Appendix C: Connex Clusters

These are optional fields which provide Groups of consumers that have been segmented based on demographics, psychographics and media consumption, among other lifestyle traits. Please contact Infutor Sales to request these fields.
Field Description
Household Cluster Name Precisely segment and deliver targeted communications at the household level with similar demographics, behaviors, attitudes, preferences, buying habits and media consumption.
Household Cluster Code Assigned code for HouseholdCluster
Detailed Household Cluster Name Precisely segment and deliver targeted communications at the household level with similar demographics, behaviors, attitudes, preferences, buying habits and media consumption.
Detailed Household Cluster Code Assigned detail cluster code for HouseholdCluster
Neighborhood Cluster Name Drive geo-based audience segmentation strategies that maximize your marketing budget when household-level targeting is not an option.
Neighborhood Cluster Code Assigned cluster code for NeighborhoodCluster
Family Cluster Name Ideal for higher-level strategic segmentation and understanding of larger customer groups including categorizing household-level clusters into a broad category of similar audience segments.
Family Cluster Code Assigned cluster code for FamilyCluster
Messaging Cluster Name Ideal for increasing the relevance of offers by tailoring the message to the unique profile of differing customer and prospect segments.
Messaging Cluster Code Assigned cluster code for MessagingCluster
Digital Cluster Name Target consumers based on their online social media and mobile behaviors, preferences and buying habits.
Digital Cluster Code Assigned cluster code for DigitalCluster
Generation Cluster Name Ideal for reaching consumers at specific life stages, as well as for marketing strategies that align with generational attitudes and experiences.
Generation Cluster Code Assigned cluster code for GenerationCluster
Generation Group Code Assigned cluster code for GenerationCluster
Lifestage Cluster Name Develop messaging strategies based on significant milestones in consumers' lives including career, marriage, Children, retirement, and more.
Lifestage Cluster Code Assigned cluster code for LifestageCluster
Lifestage Group Code Assigned group code for LifestageCluster