| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Position | Name | Field Description | Length | Start | End | ||||||||||||||||||||
2 | Field_1 | RecordID | Family Record ID | 9 | 1 | 9 | ||||||||||||||||||||
3 | Field_2 | First Name | Head of Household First Name | 46 | 10 | 55 | ||||||||||||||||||||
4 | Field_3 | Last Name | Head of Household Last Name | 38 | 56 | 93 | ||||||||||||||||||||
5 | Field_4 | Delivery Address | Address - House number and street Name | 30 | 94 | 123 | ||||||||||||||||||||
6 | Field_5 | City | Residence City | 22 | 124 | 145 | ||||||||||||||||||||
7 | Field_6 | State | Residence State | 2 | 146 | 147 | ||||||||||||||||||||
8 | Field_7 | ZIP | Residence Zip Code | 5 | 148 | 152 | ||||||||||||||||||||
9 | Field_8 | Plus 4 | Residence Zip dove plus 4 digit extension | 4 | 153 | 156 | ||||||||||||||||||||
10 | Field_9 | DPV Confirmation | Delivery Point Validation | 1 | 157 | 157 | ||||||||||||||||||||
11 | Field_10 | Latitude | LATITUDE | 9 | 158 | 166 | ||||||||||||||||||||
12 | Field_11 | Longitude | LONGITUDE | 11 | 167 | 177 | ||||||||||||||||||||
13 | Field_12 | Gender | Head of Household Gender | 1 | 178 | 178 | ||||||||||||||||||||
14 | Field_13 | Age | Head of Household Age Range (See Sheet 2 for breakdown) | 7 | 179 | 185 | ||||||||||||||||||||
15 | Field_14 | DOB Month | Date of Birth Month | 2 | 186 | 187 | ||||||||||||||||||||
16 | Field_15 | DOB Day | Date of Birth Day | 2 | 188 | 189 | ||||||||||||||||||||
17 | Field_16 | DOB Year | Date of Birth Year | 4 | 190 | 193 | ||||||||||||||||||||
18 | Field_17 | DOB | Date of Birth | 8 | 194 | 201 | ||||||||||||||||||||
19 | Field_18 | MARITAL STATUS IN THE HHLD | Marital status (Single, Married, Divorced) | 16 | 202 | 217 | ||||||||||||||||||||
20 | Field_19 | ETHNIC | See Ethnic Descriptions Sheet | 26 | 218 | 243 | ||||||||||||||||||||
21 | Field_20 | Ethnic Group | See Ethnic Descriptions Sheet | 34 | 244 | 277 | ||||||||||||||||||||
22 | Field_21 | HISPANIC COUNTRY OF ORIGIN | See Ethnic Descriptions Sheet | 18 | 278 | 295 | ||||||||||||||||||||
23 | Field_22 | ASSIMILATION | See Ethnic Descriptions Sheet | 36 | 296 | 331 | ||||||||||||||||||||
24 | Field_23 | ETHNIC-CONFIDENCE | See Ethnic Descriptions Sheet | 1 | 332 | 332 | ||||||||||||||||||||
25 | Field_24 | LANGUAGE | See Ethnic Descriptions Sheet | 45 | 333 | 377 | ||||||||||||||||||||
26 | Field_25 | Lang_Pref | Language Preference in Household | 24 | 378 | 401 | ||||||||||||||||||||
27 | Field_26 | RELIGION | See Ethnic Descriptions Sheet | 16 | 402 | 417 | ||||||||||||||||||||
28 | Field_27 | CHRISTIAN FAMILIES | Religious christian family | 1 | 418 | 418 | ||||||||||||||||||||
29 | Field_28 | Phone | Landline Phone Number | 10 | 419 | 428 | ||||||||||||||||||||
30 | Field_29 | Cell | Wireless Cellular Phone Number | 16 | 429 | 444 | ||||||||||||||||||||
31 | Field_30 | Cell Carrier | Wireless Cellular Carrier | 73 | 445 | 517 | ||||||||||||||||||||
32 | Field_31 | Dwelling Type | Dwelling Definition (Single family, Multi family, etc…) | 41 | 518 | 558 | ||||||||||||||||||||
33 | Field_32 | Years since home was built | Age of home structure | 15 | 559 | 573 | ||||||||||||||||||||
34 | Field_33 | Estimated Home Value | Home value (Based on Assessed value) | 20 | 574 | 593 | ||||||||||||||||||||
35 | Field_34 | Estimated Income | Household Income (Derived from survey data. Both online and offline sourcing / Value Range) | 7 | 594 | 600 | ||||||||||||||||||||
36 | Field_35 | Net Worth | Net Worth (Derived from survey data and calculated based on known assets for validity / Value Range) | 7 | 601 | 607 | ||||||||||||||||||||
37 | Field_36 | Inf_Credit | Inferred Credit Rank (Values) | 9 | 608 | 616 | ||||||||||||||||||||
38 | Field_37 | NUMBER OF LINES OF CREDIT (TRADE COUNTER) | Inferred lines of available credit (Numeric value 0 -10) | 1 | 617 | 617 | ||||||||||||||||||||
39 | Field_38 | CREDIT - RANGE OF NEW CREDIT | Inferred availaible credit (Dollar Value in ranges) | 1 | 618 | 618 | ||||||||||||||||||||
40 | Field_39 | MEMBERSHIP CLUBS | Indicator Field (Populated with "X" if present) | 1 | 619 | 619 | ||||||||||||||||||||
41 | Field_40 | AMERICAN EXPRESS GOLD/PREMIUM | Indicator Field (Populated with "X" if present) | 1 | 620 | 620 | ||||||||||||||||||||
42 | Field_41 | AMERICAN EXPRESS REGULAR | Indicator Field (Populated with "X" if present) | 1 | 621 | 621 | ||||||||||||||||||||
43 | Field_42 | DISCOVER GOLD/PREMIUM | Indicator Field (Populated with "X" if present) | 1 | 622 | 622 | ||||||||||||||||||||
44 | Field_43 | DISCOVER REGULAR | Indicator Field (Populated with "X" if present) | 1 | 623 | 623 | ||||||||||||||||||||
45 | Field_44 | GASOLINE OR RETAIL CARD GOLD/PREMIUM | Indicator Field (Populated with "X" if present) | 1 | 624 | 624 | ||||||||||||||||||||
46 | Field_45 | GASOLINE OR RETAIL CARD REGULAR | Indicator Field (Populated with "X" if present) | 1 | 625 | 625 | ||||||||||||||||||||
47 | Field_46 | MASTERCARD GOLD/PREMIUM | Indicator Field (Populated with "X" if present) | 1 | 626 | 626 | ||||||||||||||||||||
48 | Field_47 | MASTERCARD REGULAR | Indicator Field (Populated with "X" if present) | 1 | 627 | 627 | ||||||||||||||||||||
49 | Field_48 | VISA GOLD/PREMIUM | Indicator Field (Populated with "X" if present) | 1 | 628 | 628 | ||||||||||||||||||||
50 | Field_49 | VISA REGULAR | Indicator Field (Populated with "X" if present) | 1 | 629 | 629 | ||||||||||||||||||||
51 | Field_50 | BANK CARD HOLDER | Indicator Field (Populated with "X" if present) | 1 | 630 | 630 | ||||||||||||||||||||
52 | Field_51 | GAS/DEPARTMENT/RETAIL CARD HOLDER | Indicator Field (Populated with "X" if present) | 1 | 631 | 631 | ||||||||||||||||||||
53 | Field_52 | TRAVEL AND ENTERTAINMENT CARD HOLDER | Indicator Field (Populated with "X" if present) | 1 | 632 | 632 | ||||||||||||||||||||
54 | Field_53 | CREDIT CARD HOLDER - UNKNOWN TYPE | Indicator Field (Populated with "X" if present) | 1 | 633 | 633 | ||||||||||||||||||||
55 | Field_54 | PREMIUM CARD HOLDER | Indicator Field (Populated with "X" if present) | 1 | 634 | 634 | ||||||||||||||||||||
56 | Field_55 | UPSCALE (DEPARTMENT STORE) CARD HOLDER | Indicator Field (Populated with "X" if present) | 1 | 635 | 635 | ||||||||||||||||||||
57 | Field_56 | CREDIT CARD USER | Indicator Field (Populated with "X" if present) | 1 | 636 | 636 | ||||||||||||||||||||
58 | Field_57 | CREDIT CARD - NEW ISSUE | Indicator Field (Populated with "X" if present) | 1 | 637 | 637 | ||||||||||||||||||||
59 | Field_58 | BANK CARD - PRESENCE IN HOUSEHOLD | Indicator Field (Populated with "X" if present) | 1 | 638 | 638 | ||||||||||||||||||||
60 | Field_59 | Debt Cons | Has applied for a Debt Consolidation in the last 180 days | 1 | 639 | 639 | ||||||||||||||||||||
61 | Field_60 | PayDayApp | Has applied for a Pay Day Loan in the last 180 days | 1 | 640 | 640 | ||||||||||||||||||||
62 | Field_61 | EDUCATION | See Ethnic Descriptions Sheet | 43 | 641 | 683 | ||||||||||||||||||||
63 | Field_62 | College Student | College Student present within the household | 1 | 684 | 684 | ||||||||||||||||||||
64 | Field_63 | EDUCATION ONLINE | See Ethnic Descriptions Sheet | 1 | 685 | 685 | ||||||||||||||||||||
65 | Field_64 | OCCUPATION | See Occupation Sheet | 66 | 686 | 751 | ||||||||||||||||||||
66 | Field_65 | BUSINESS OWNER | Indicator Field (Populated with "X" if present) | 27 | 752 | 778 | ||||||||||||||||||||
67 | Field_66 | HOME OWNER / RENTER | Owner or Renter Indicator | 10 | 779 | 788 | ||||||||||||||||||||
68 | Field_67 | Number of years in residence | Years of family in household | 15 | 789 | 803 | ||||||||||||||||||||
69 | Field_68 | Reason for Loan | Reason for Loan | 30 | 804 | 833 | ||||||||||||||||||||
70 | Field_69 | PASS PROSPECTOR VALUE- Home Value- Mortgage File | Home Value at time of Loan | 8 | 834 | 841 | ||||||||||||||||||||
71 | Field_70 | PURCHASE DATE (CCYYMMDD) | Date of home purchase (CCYYMMDD) | 8 | 842 | 849 | ||||||||||||||||||||
72 | Field_71 | Current age of mortgage | Years since mortgage started | 15 | 850 | 864 | ||||||||||||||||||||
73 | Field_72 | PURCHASE PRICE | Purchase price of home (Dollar amount) | 10 | 865 | 874 | ||||||||||||||||||||
74 | Field_73 | SALES TRANSACTION CODE | Transaction Code | 29 | 875 | 903 | ||||||||||||||||||||
75 | Field_74 | MOST RECENT MORTGAGE AMOUNT | Most recent Mortgage Amount (Dollar Amount Range) | 8 | 904 | 911 | ||||||||||||||||||||
76 | Field_75 | 2ND MOST RECENT MORTGAGE AMOUNT | 2nd Most recent Mortgage Amount (Dollar Amount Range) | 8 | 912 | 919 | ||||||||||||||||||||
77 | Field_76 | PURCHASE 1st MORTGAGE AMOUNT | First mortgage amount (Dollar Amount Range) | 8 | 920 | 927 | ||||||||||||||||||||
78 | Field_77 | PURCHASE 2ND MORTGAGE AMOUNT | Second mortgage amount (Dollar Amount Range) | 8 | 928 | 935 | ||||||||||||||||||||
79 | Field_78 | MOST RECENT MORTGAGE DATE | Date of first mortgage | 8 | 936 | 943 | ||||||||||||||||||||
80 | Field_79 | 2ND MOST RECENT MORTGAGE DATE | Date of second mortgage | 8 | 944 | 951 | ||||||||||||||||||||
81 | Field_80 | PURCHASE MORTGAGE DATE | Date of Mortgage Purchase | 8 | 952 | 959 | ||||||||||||||||||||
82 | Field_81 | Adjustable or fixed rate | Mortgage Interest Type | 10 | 960 | 969 | ||||||||||||||||||||
83 | Field_82 | MOST RECENT MORTGAGE LOAN TYPE CODE | See Genearl Field Definitions | 30 | 970 | 999 | ||||||||||||||||||||
84 | Field_83 | 2ND MOST RECENT MORTGAGE LOAN TYPE CODE | See Genearl Field Definitions | 30 | 1000 | 1029 | ||||||||||||||||||||
85 | Field_84 | PURCHASE 1ST MORTGAGE LOAN TYPE CODE | See Genearl Field Definitions | 30 | 1030 | 1059 | ||||||||||||||||||||
86 | Field_85 | PURCHASE 2ND MORTGAGE LOAN TYPE CODE | See Genearl Field Definitions | 30 | 1060 | 1089 | ||||||||||||||||||||
87 | Field_86 | MOST RECENT LENDER CODE - See Appendix | Lender Name on Mortgage 1 - See Lender Descriptions Tab 5 | 3 | 1090 | 1092 | ||||||||||||||||||||
88 | Field_87 | 2ND MOST RECENT LENDER CODE - See Appendix | Lender Name on Mortgage 2 - See Lender Descriptions Tab 5 | 3 | 1093 | 1095 | ||||||||||||||||||||
89 | Field_88 | PURCHASE LENDER CODE - - See Appendix | Lender Name on Mortgage 2 - See Lender Descriptions Tab 5 | 3 | 1096 | 1098 | ||||||||||||||||||||
90 | Field_89 | MOST RECENT LENDER NAME | Lender Name on Mortgage 2 - See Lender Descriptions Tab 5 | 30 | 1099 | 1128 | ||||||||||||||||||||
91 | Field_90 | 2ND MOST RECENT LENDER NAME | Lender Name on Mortgage 2 - See Lender Descriptions Tab 5 | 59 | 1129 | 1187 | ||||||||||||||||||||
92 | Field_91 | PURCHASE LENDER NAME | Lender Name on Mortgage 2 - See Lender Descriptions Tab 5 | 59 | 1188 | 1246 | ||||||||||||||||||||
93 | Field_92 | Loan to Value Ratio | Loan to Value ratio of home (Value is based on assesed value) | 12 | 1247 | 1258 | ||||||||||||||||||||
94 | Field_93 | MOST RECENT MORTGAGE INTEREST RATE TYPE | MOST RECENT MORTGAGE INTEREST RATE TYPE | 30 | 1259 | 1288 | ||||||||||||||||||||
95 | Field_94 | 2ND MOST RECENT MORTGAGE INTEREST RATE TYPE | 2ND MOST RECENT MORTGAGE INTEREST RATE TYPE | 30 | 1289 | 1318 | ||||||||||||||||||||
96 | Field_95 | PURCHASE 1ST MORTGAGE INTEREST RATE TYPE | PURCHASE 1ST MORTGAGE INTEREST RATE TYPE | 20 | 1319 | 1338 | ||||||||||||||||||||
97 | Field_96 | PURCHASE 2ND MORTGAGE INTEREST RATE TYPE | PURCHASE 2ND MORTGAGE INTEREST RATE TYPE | 1 | 1339 | 1339 | ||||||||||||||||||||
98 | Field_97 | MOST RECENT MORTGAGE INTEREST RATE (note inferred decimal NNDDDD) | MOST RECENT MORTGAGE INTEREST RATE (note inferred decimal NNDDDD) | 6 | 1340 | 1345 | ||||||||||||||||||||
99 | Field_98 | 2ND MOST RECENT MORTGAGE INTEREST RATE (note inferred decimal NNDDDD) | 2ND MOST RECENT MORTGAGE INTEREST RATE (note inferred decimal NNDDDD) | 6 | 1346 | 1351 | ||||||||||||||||||||
100 | Field_99 | PURCHASE 1ST MORTGAGE INTEREST RATE (note inferred decimal NNDDDD) | PURCHASE 1ST MORTGAGE INTEREST RATE (note inferred decimal NNDDDD) | 6 | 1352 | 1357 |