|
|
 | | From: | alina rusu | | Subject: | append text file | | Date: | Fri, 21 Jan 2005 12:10:16 -0500 |
|
|
 | Here's the situation,
Our application needs to send a fixed length ASCII file to Experian, the
credit recording bureau, to pull credit reports. I guess this is a pretty
common thing for a lot of applications these days. The Experian data format
is detailed out below. But basically, I will send them a record and get
back a larger record to append back to my customer's data..
I have no problem making the output record, basically I will make a data
file with the structure they indicate, populate the fields and do a copy to
sdf
I believe I'm going to have a problem on the other side retrieving the data,
of course I would start by building a data file with the structure as
indicated and doing an append from sdf, it would be pretty simple but I
recall trying something like this before and I had a problem because the
record size is too large.
Does anyone know the maximum record size for append from fixed length ASCII?
Does anyone know a workaround for this?
Once again, I have not actually completed this project yet, but I remember
doing this before on another project and getting stuck on the append side
because the record size of 5500 characters was pretty large and dBase had a
problem with that. Any information anyone could offer would be most
appreciated and I suspect lots of applications will be doing something like
this integrating with credit reporting data
Thank you
Alina Ruso
Field Number Field Name Length Begin Format
Input = 500 bytes
(*) = Always required on input
Output = 5500 bytes (Echo-back of client input data and Experian output
data) (**) = Always returned on output
Input Record Layout - 500 positions
1 Record Format Identifier (*) 4 1 Char Value "CA1B" constant
Note: Value was "CAM1" for Phase 1A
2 Record Length (*) (**) 4 5 N Input value = 0500
Output value = 5500
Note: Output value was 3000 for Phase 1A
The following fields are blank filled on input and populated by Experian on
output
3 Experian Unique Identifier (**) 30 9 Char Output value = Unique assigned
by Experian (**)
Unique Record Id 16 Unique Id Assigned to Each Record
Unique Client Id 7 Unique Id Assigned to Each Client (RDXnnnn)
Unique Batch Id 7 Unique Id Assigned to Each Batch
4 File One Result Code (**) 2 39 Char Output value =
"HT"=Hit (Record Found - data condition met)
"NH"=No Hit (Rec Found - data condition not met)
"ER"=Error on input (client not charged no billing)
"NR"=Consumer not on-file (client charged)
blank = input record - not yet processed
5 Experian File One Error Code 3 41 Char Experian Error Codes
"CA9" = System Not Available Error, try again
"045","616" = Fatal Input Name Error
"407","408","630" = Fatal Input Address Error
"049" = Input Zip Error
Other Errors - see detailed error code legend
6 Filler 2 44 Char Filler
7 Filler 5 46 Char Filler
(*) Client-supplied Input Information
8 Client Subcode Assigned by Experian (*) 7 51 Char Subcode assigned by
Experian
9 Filler 8 58 Char Filler
10 Client Account Number or Unique Record Identifier 30 66 Char Client"s
account number or unique record identifier
11 Consumer SSN (optional - highly recommended) 9 96 N SSN
12 Consumer Surname (*) 32 105 Char Surname
13 Consumer First Name (*) 32 137 Char First Name
14 Consumer Middle Name or Initial 32 169 Char Middle Name or Initial
15 Consumer suffix text 6 201 Char Possible values are: II, III, IIII, IV,
Jr, Sr, 1, 1ST, 11, 111, 1111, 2, 2ND, 3, 3RD, 4, 4TH
16 Spouse Initial (Optional) 1 207 Char Spouse Initial
17 Street Address (as complete as possible) (*) 60 208 Char House #, Street
Directional, Street Name, Street Suffix, Apartment Number or P.O. Box
address
18 City (*) if zip code not provided) 32 268 Char City
19 State (*) if zip code not provided) 2 300 Char State
20 Zip Code (Optional if city/state present) 5 302 Char Zip
21 Zip + 4 (Optional) 4 307 Char Zip+4
22 Filler 1 311 Char Filler
23 Filler 2 312 Char Filler
The following fields are blank-filled on input and populated by Experian on
output
24 Date Batch Received at Experian 7 314 Char YYYYDDD format
25 Time Batch Received at Experian 4 321 Char HHMM format
(*) Client Input Options - A minimum of one input option must be selected
Client Input Options - Special features for
specific data segments Client Input Options - Special Feature options
26 Filler 4 325 Char Filler
27 Filler 1 329 Char Filler
28 Filler 1 330 Char Filler
29 Include EDA Phone Search 1 331 Char Note: This flag cannot be set
without also setting Client Input Option Number 28 (MetroNet Phones & COA)
"1" = EDA Tight Match Search Logic ("40")
"2" = EDA Medium Match Search Logic ("20")
"3" = EDA Loose Match Search Logic ("00")
blank = not requested
30 Include USPS NCOA Search 1 332 Char Note: This flag cannot be set
without also setting Client Input Option Number 28 Output Option Number 28
(MetroNet Phones & COA)
"Y" = Include
Blank = Not Requested
31 Include Experian File One Fraud Shield Search 1 333 Char Note: This
flag cannot be set without also setting Client input Flag 01 and/or 02 (SSN
& Best N&A)
"Y" = Include
Blank = Not Requested
Client Input Options - File One Data
32 Segment 01 - Social Security Number 1 334 Char Note: The SSN Issued SSN
Fraud Shield Indicator is returned on this output segment when the Fraud
Indicator Flag option is selected
"1" = Verify SSN (do not append SSNs)
"2" = Always Append SSNs (no verify)
"3" = Verify input SSN & Append if no match
Blank = Not requested
33 Segment 02 - Best Name & Address 1 335 Char Note: The High-Risk-Address
Fraud Shield Indicator is returned on this output segment when the Fraud
Indicator Flag Option is selected.
"1" = Verify N&A & Append Best N&A with Demos
"2" = Verify N&A & Append Best N&A (no Demos)
Blank = Not requested
34 Segment 03 - Deceased Information 1 336 Char "Y" = Verify input SSN
against SSA SSN & append if match is found
Blank = Not requested
35 Segment 04 - File One Phones 1 337 Char "1" = match on 7 digits & append
unique phones
"2" = match on 10 digits & append unique phones
"3" = match on 7, apply criteria date, append uniques
Note: up to 3 input phones can be supplied and will be compared
36 Segment 05 - Employment 1 338 Char "1" = Append Best Employment
"2" = Append Additional Employment (future)
Blank = Not requested
Segment 06 - Model Scores "B " = Bankruptcy , "F " =
FICO Risk V2,
"H " = Recovery Bankcard, "J " = Recovery Retail,
"K " = FICO Bankcard V2, "N "= FICO Installment,
"R "= FICO Finance, "V "= FICO Auto,
"W "= TEC model, "3 "= NRM V2,
"RA" = ROI Detail score, "RB" = ROI Summary Score
"5 " = BK Watch, "U " = Sureview Score
blank = not requested
37 Model Score 1 2 339 Char Select value from above list
38 Model Score 2 2 341 Char Select value from above list
39 Model Score 3 2 343 Char Select value from above list
40 Model Score 4 2 345 Char Select value from above list
41 Model Score 5 2 347 Char Select value from above list
Segment 07 - Credit Attributes 1 Deceased Indicator, 4 Public Record
Indicators, 1 Total Derog Accts & Unsatisfied Public Record Count, 1 Total
Monthly Payment Amount, 1 Total Finance Accts with >0 Balance Count, 4 Derog
Counters, 2 Collection Counters,
4 Credit Amounts, 6 Balance Amounts, 4 Utilization ratios, 3 New Account
Open Counts, 2 Inquiry counts
42 Credit Attributes (33) 1 349 Char "Y" = Append
Blank = Not requested
43 Segment 08 - Future 1 350 Char Future
44 Segment 09 - Bankruptcy Information 1 351 Char "Y" = Append
Blank = Not requested
45 Segment 10 -Future 1 352 Char Future
46 Segment 11- Add"l Names & Prior Addresses 1 353 Char "1" = Append
Additional N&A + Demos
"2" = Append Additional N&A only
Blank = Not requested
47 Segment 12 - Driver"s License 1 354 Char "Y" = Append
Blank = Not requested
48 Segment 13 - Additional Attributes 1 355 Char "Y" = Append
Blank = Not requested
Note: Please consult with your sales representative for a list of these
attributes
49 Segment 14 - future 1 356 Char Filler
50 Segment 15 - future 1 357 Char Filler
51 Segment 16 - future 1 358 Char Filler
52 Segment 17 - future 1 359 Char Filler
53 Segment 18 - future 1 360 Char Filler
54 Segment 19 - future 1 361 Char Filler
55 Segment 20- future 1 362 Char Filler
56 Segment 21- future 1 363 Char Filler
57 Segment 22 - future 1 364 Char Filler
58 Segment 23 - future 1 365 Char Filler
59 Segment 24- future 1 366 Char Filler
60 Segment 25 - future 1 367 Char Filler
61 Segment 26 - future 1 368 Char Filler
Client Input Options - MetroNet data
62 Segment 27 - Call Center Scheduler Score 1 369 Char "Y" = Append
Blank = Not requested
Note: This score returns the best time of day to contact the debtor by
phone as well as a probably score of reaching the debtor at that time.
63 Segment 28 - MetroNet Phones & Change of Address 1 370 Char Note: USPS
NCOA Changes of addresses are included in this output segment when the
"Include NCOA" search flag is set.
Note: EDA Phone Numbers are returned in this output segment when there is
no MetroNet Phone available and the Include EDA search flag is set.
"1" = Verify 7 digit input phone & Append unique(s)
"2" = Verify 10 digit input phone & Append unique(s)
blank = Not Requested
Optional Client-Supplied Input Data (130 positions)
64 Consumer Area Code (Client Input Telephone #1) 3 371 Char
Client-supplied input phone 1 (area code)
65 Consumer 7-digit 7 374 Char Client-supplied input phone 1 (number)
66 Consumer Area Code (Client Input Telephone #2) 3 381 Char
Client-supplied input phone 2 (area code)
67 Consumer 7-digit 7 384 Char Client-supplied input phone 2 (number)
68 Consumer Area Code (Client Input Telephone #3) 3 391 Char
Client-supplied input phone 3 (area code)
69 Consumer 7-digit 7 394 Char Client-supplied input phone 3 (number)
70 On-File Phone Recency Criteria date 8 401 Char CCYYMMDD -
Client-supplied date - Compare on-file date to this date and append phones
if unique & on-file date is more recent)
71 Key Code 1 10 409 Char Client-supplied value
72 Key Code 2 10 419 Char Client-supplied value
73 Balance Amount 9 429 Char Balance Amount
74 Account Date 8 438 Char MMDDCCYY format
75 Customer Number 15 446 Char Client supplied value
76 Branch Code 4 461 Char Client supplied value
77 Client Supplied Data Field #1 17 465 Char Reserved for client data
78 Client Supplied Data Field #2 19 482 Char Reserved for client data
End of Input Record Layout 500
Experian Output Data
Experian Standard Output Data (2,500 bytes)
Output Segment 01 - SSN Information
79 Segment ID (**) 2 501 Char "01" - SSN Validation & Append
80 SSN Validation Result Code 2 503 Char " V" = Input SSN Verified with
Best File One SSN
" M" = Input SSN matched other File One SSN
" N" = Input SSN did not match Experian
" Z" = Input SSN could not be verified (not provided)
" K" = Verify resulted in SSN Append (No SSN input)
" X" = Verify resulted in SSN Append (No match)
Blank = Not requested, no record, or error on input
81 SSN Issued Social Fraud Shield Result Code 1 505 Char "Y" = SSN Issued
Social Fraud Alert
"N" = Fraud not found
Blank = No requested, no record, or error on input
82 SSN Append Result Code 2 506 Char " 0" = 0 SSN Appended
" 1" = 1 SSN Appended
" 2" = 2 SSN Appended
" 3" = 3 SSN Appended
Blank = not requested
83 Best File One SSN 9 508 Char Best File One SSN
84 Additional File One SSN 9 517 Char Additional on-file SSN
85 Additional File One SSN 9 526 Char Additional on-file SSN
Output Segment 02 - Best N&A Information
86 Segment ID (**) 2 535 Char "02" - Best N&A & Demos
87 Best N&A Result Code 2 537 Char " V" = Input N&A Verified with Best File
One N&A
" M" = Input N&A Matches another File One N&A
" N" = Input N&A doesn"t match File One N&A
Blank = Not requested, no record, or error on input
Note: Best N&A is always appended with this option
88 Filler 1 539 Char Filler
89 Demographic Result Code 1 540 Char "Y" = Best N&A Appended with
Demographics
"N" = Best N&A Appended without Demographics
Blank = not requested
90 Address Fraud Indicator 1 541 Char "Y" = High Risk Address Fraud Alert
"N" = Address appears to be valid
Blank = not requested
91 Year of Birth (Demo) 4 542 N Year of Birth
92 Date of Birth (Demo) 8 546 N MMDDCCYY format
93 Gender (future) (Demo) 1 554 Char Filler
94 Living Unit Indicator (future) (Demo) 1 555 Char Filler 0
95 Home Ownership Indicator (Demo) 1 556 Char Note - limited data on file
"O" = Owns home - General
"P" = Owns home - reported via Public Record
"C" = Owns home - reported via Credit File
"U" = Owns home - reported via Update Tapes
"R" = Rents
Blank = Unknown
96 Best Surname 32 557 Char Best Name
97 Best First Name 32 589 Char Best Name
98 Best Middle Name or Initial 32 621 Char Best Name
99 Best Suffix 6 653 Char Best Name
100 Best Street Address 60 659 Char Best Address
101 Best City 32 719 Char Best City
102 Best State 2 751 Char Best State
103 Best Zip Code 9 753 Char Best Zip
104 Dwelling Type (Demo) 1 762 Char "A"=Apartment,
"G"=General Dlivery
"M"=Multi-family dwelling
"P"=Post Office Box
"R"=Rural Route
"S"=Single Family Dwelling
"1"=Military
"2"=Mexican Address
"3"=Canadian Address
blank = unknown
105 MSA Code (Demo) - future 4 763 Char Filler
106 County Code (Demo) 3 767 Char County Code
107 Census GEO Code (Demo) 7 770 Char Positions 1-6 = Census Track, Position
7 = Block Group
108 Date Address First Reported 8 777 Char MMDDCCYY format
109 Date Address Last Updated 8 785 Char MMDDCCYY format
110 Number of different surnames at this address (future) 2 793 N 0-99
111 Number of family members at this address (future) 2 795 N 0-99
112 Filler 30 797 Char Filler
Output Segment 03 - Social Security Administration Deceased
113 Segment ID (**) 2 827 Char "03" - SSA Deceased Information
114 SSN Deceased Result Code 2 829 Char " Y" = SSN verified as deceased in
SSA File
" N" = SSN did not match SSA File
Blank = not requested, no record, or error on input
115 Date of Birth of Deceased 8 831 Char MMDDCCYY format
116 Date of Death 8 839 Char MMDDCCYY format
117 State/Country Code of Death (future) 2 847 Char State or country code of
death
118 Zip Code of Last Known Residence (future) 5 849 Char Zip code of last
known residence
119 Zip Code for receipt of lump sum (future) 5 854 Char Zip code for
receipt of lump sum
Output Segment 04 - File One Phones
120 Segment ID (**) 2 859 Char "04" - File One Phone Verification & Append
121 Client Input Phone(s) to File One Phone(s) match result Code 2 861 Char
" 0" = No File One Phones Available
" 1" = Client input matched 1 File One Phone
" 2" = Client input matched 2 File One Phones
" 3" = Client input matched 3 File One Phones
" N" =No client phones matched File One phones
" Z" = No client Input phone provided
blank = not requested, no record, or error on input
122 File One Phone Append Result Code 2 863 Char " 0" = Zero File One Phones
appended
" 1" = 1 File One Phone Appended
" 2" = 2 File One Phones Appended
" 3" = 3 File One Phones Appended
blank = not requested, no record, or error on input
First Experian File One Phone
123 Phone #1- Area Code 3 865 Char Area Code
124 Phone #1- Number 7 868 Char Number
125 Phone Source 1 875 Char Note: Data returned when Permissible Purpose
"P" = Published Residential
"U"= Update Tapes
"I" = Inquiry
"D" = Directory Assistance
blank = unknown
126 Phone Type 1 876 Char "R" = Residence "B" =Business
"P" = Pager "F" =Fax
"C" = Cellular "T" =Pay Phone
"I" = Institution blank = unknown
"S" = Probable Special Phone Number
"W" = Probable Business Phone Number
"X" = Probable Residence Phone Number
"Y" = Probable Cellular Phone Number
"Z" = Probable Pager
127 To-File Date 8 877 Char MMDDCCYY format
128 Date-Last-Updated 8 885 Char MMDDCCYY format
Second Experian File One Phone
129 Phone #2 - Area Code 3 893 Char Area Code
130 Phone #2- Number 7 896 Char Number
131 Phone Source 1 903 Char Note: Data returned when Permissible Purpose
"P" = Published Residential
"U"= Update Tapes
"I" = Inquiry
"D" = Directory Assistance
blank = unknown
132 Phone Type 1 904 Char "R" = Residence "B" =Business
"P" = Pager "F" =Fax
"C" = Cellular "T" =Pay Phone
"I" = Institution blank = unknown
"S" = Probable Special Phone Number
"W" = Probable Business Phone Number
"X" = Probable Residence Phone Number
"Y" = Probable Cellular Phone Number
"Z" = Probable Pager
133 To-File Date 8 905 Char MMDDCCYY format
134 Date-Last-Updated 8 913 Char MMDDCCYY format
Third Experian File One Phone
135 Phone #3 - Area Code 3 921 Char Area Code
136 Phone #3 - Number 7 924 Char Number
137 Phone Source 1 931 Char Note: Data returned when Permissible Purpose
"P" = Published Residential
"U"= Update Tapes
"I" = Inquiry
"D" = Directory Assistance
blank = unknown
138 Phone Type 1 932 Char "R" = Residence "B" =Business
"P" = Pager "F" =Fax
"C" = Cellular "T" =Pay Phone
"I" = Institution blank = unknown
"S" = Probable Special Phone Number
"W" = Probable Business Phone Number
"X" = Probable Residence Phone Number
"Y" = Probable Cellular Phone Number
"Z" = Probable Pager
139 To-File Date 8 933 Char MMDDCCYY format
140 Date-Last-Updated 8 941 Char MMDDCCYY format
Reserved for future use
141 Filler 10 949 Char Filler
142 Filler 1 959 Char Filler
143 Filler 1 960 Char Filler
144 Filler 8 961 Char Filler
145 Filler 8 969 Char Filler
Output Segment 05 - Employment
146 Segment ID (**) 2 977 5 "05" - Employment Append
147 Employment Result Code 2 979 Char " Y" = Appended
" N" = Not Appended
Blank = Not requested, no record, or error on input
148 Employer Name 30 981 Char Employer Name
149 Employer Address Line 1 32 1011 Char Street Number, Direction, Street
Name
150 Employer Address line 2 32 1043 Char City and State or Additional Addr
Info
151 Employer Address line 3 32 1075 Char City and State if Additional Addr
info is present
152 Employer Zip Code 9 1107 Char Zip Code
153 To-File Date 8 1116 Char MMDDCCYY format
154 Date-Last-Updated 8 1124 Char MMDDCCYY format
155 Filler 12 1132 Char Filler
Output Segment 06 - Model Scores (up to 5 scores)
156 Segment ID (**) 2 1144 Char "06" - Model Scores Append
157 Model Append Result Code 2 1146 Char " 0" = 0 model score Appended
(exclusion score)
" 1" = 1 model score Appended
" 2" = 2 model scores Appended
" 3" = 3 model scores Appended
" 4" = 4 model scores Appended
" 5" = 5 model scores Appended
blank = not requested
158 Model 1 Code 2 1148 Char Model 1 Code
159 Model 1 Score or exclusion score 4 1150 Char Model 1 Score or exclusion
score
160 Model 1 Factor Codes 8 1154 Char Model 1 Factor Codes
161 Model 2 Code 2 1162 Char Model 2 Code
162 Model 2 Score or exclusion score 4 1164 Char Model 2 Score or exclusion
score
163 Model 2 Factor Codes 8 1168 Char Model 2 Factor Codes
164 Model 3 Code 2 1176 Char Model 3 Code
165 Model 3 Score or exclusion score 4 1178 Char Model 3 Score or exclusion
score
166 Model 3 Factor Codes 8 1182 Char Model 3 Factor Codes
167 Model 4 Code 2 1190 Char Model 4 Code
168 Model 4 Score or exclusion score 4 1192 Char Model 4 Score or exclusion
score
169 Model 4 Factor Codes 8 1196 Char Model 4 Factor Codes
170 Model 5 Code 2 1204 Char Model 5 Code
171 Model 5 Score or exclusion score 4 1206 Char Model 5 Score or exclusion
score
172 Model 5 Factor Codes 8 1210 Char Model 5 Factor Codes
Output Segment 07 - 33 Credit Attributes
173 Segment ID (**) 2 1218 Char "07" - Credit Attributes (33 Attributes)
174 33 Credit Attributes Append Result Code 2 1220 Char " Y" = Appended
" N" = Not Appended
Blank = Not requested, no record, or error on input
175 Q24DEC 1 1222 Char Deceased Indicator
176 Q24BKC7 1 1223 Char BK Chapter 7 Disposition Indicator
177 Q24BKC11 1 1224 Char BK Chapter 11 Disposition Indicator
178 Q24BKC13 1 1225 Char BK Chapter 13 Disposition Indicator
179 Q24LSAT1 1 1226 Char SAT Judgments/Liens (12 mos) Indicator
180 Q24DG01 2 1227 N Total Derog Accts (Trade & Public Record)
181 Q24TD01 2 1229 N Total Accts with 30 days past due in past 24 mos
182 Q24TD02 2 1231 N Total Accts with 60 days past due in past 24 mos
183 Q24TD03 2 1233 N Total Accts with 90 days past due in past 24 mos
184 Q24TD04 2 1235 N Total Accts with 120-180 days past due in 24 mos
185 Q24TC01 2 1237 N Total Accts in Collection Status
186 Q24TC02 2 1239 N Total Accts w/Paid Collection Status in past 6 mos
187 Q24TAL15 9 1241 N Total Monthly Payment Amt (All - 12 mos)
188 Q24TMT11 9 1250 N Sum of Credit Amt - Mortgages (12 mos)
189 Q24TMT12 9 1259 N Sum of Balance Amt - 1st Mortgages (12 mos)
190 Q24THE11 9 1268 N Sum of Credit Amt - H-Equity/2nd MTG (12 mos)
191 Q24THE12 9 1277 N Sum of Balance Amt - H-Equity/2nd MTG (12 mos)
192 Q24TIN12 9 1286 N Sum of Balance Amt - Installment loans (12 mos)
193 Q24TRV11 9 1295 N Sum of Credit Amt - Revolving Trades (12 mos)
194 Q24TRV12 9 1304 N Sum of Balance Amt - Revolving Trades (12 mos)
195 Q24TRV13 6 1313 N % of Credit Utilization - Revolving Trades (12 mos)
196 Q24TBC13 6 1319 N % of Credit Utilization - Bankcard (12 mos)
197 Q24TBC14 9 1325 Zoned Decimal Sum of Available Credit Amt - Bankcard
(12 mos)
198 Q24TAU12 9 1334 N Sum of Balance Amt - Auto Loans (12 mos)
199 Q24TAU13 6 1343 N % of Credit Utilization - Auto Loans (12 mos)
200 Q24TAE12 9 1349 N Sum of Balance Amt - Auto Leases (12 mos)
201 Q24TAE13 6 1358 N % of Credit Utilization - Auto Leases (12 mos)
202 Q24TAL21 2 1364 N Total Accounts opened in past 6 mos
203 Q24TRV22 2 1366 N Total Revolving Accts opened in past 3 mos
204 Q24TIB22 2 1368 N Total Installment Loans opened in past 3 mos
205 Q24TFN31 2 1370 N Total Finance Accts with Balance >0 (12 mos)
206 Q24IAL01 2 1372 N Total credit inquiries logged in past 3 mos
207 Q24IAL02 2 1374 N Total credit inquiries logged in past 6 mos
Output Segment 08 - Future
208 Segment ID (**) 2 1376 Char "08" - Future
209 Result Code 2 1378 Future
210 Reserved for future use 200 1380 Char Future
Output Segment 09 - Bankruptcy Information
211 Segment ID (**) 2 1580 Char "09" - Bankruptcy Information
212 Bankruptcy Screen Result Code 2 1582 Char " Y" = Appended
" N" = Not Appended
Blank = Not requested, no record, or error on input
213 Status Code 2 1584 Char Qualifies if Status code is:
"13", "15", "16", 17", "22", "23", "24", "25", "26", "27", "28", "29"
214 Status Date 8 1586 Char MMDDCCYY format
215 Court Code 7 1594 Char Court Code
216 Court Name 24 1601 Char Court Name
217 Docket Number 24 1625 Char Docket Number
218 Creditor Name 32 1649 Char Creditor Name
219 ECOA Code 1 1681 Char "I" = Individual
"2" = Joint
"H" = Individual Terminated
"B" = Joint Terminated
blank = unknown
220 Asset Amount 8 1682 Char Asset Amount
221 Liabilities Amount 8 1690 Char Liabilities Amount
222 Repayment % 3 1698 Char For chapter 13 only
223 Adjustment % 2 1701 Char For chapter 13 only
224 Book Page 24 1703 Char Book page and sequence number
225 Voluntary/Involuntary BK indicator 1 1727 Char V=Voluntary,
I=Involuntary blank = unknown
226 Original Filing Date 8 1728 Char MMDDCCYY format
227 Attorney Name (future) 60 1736 Char Attorney Name (future)
228 Attorney Phone (future) 10 1796 Char Attorney Phone (future)
229 Fller 100 1806 Char Filler
Output Segment 10 (future)
230 Segment ID (**) 2 1906 Char "10" - Future
231 Result Code 2 1908 Char Result Code
232 Spouse First Name 15 1910 Char Available with special customer master
setting
233 Filler 15 1925 Char Filler
234 Filler 9 1940 Char Filler
235 Filler 230 1949 Char Filler
Output Segment 11 - Additional Names & Prior Addresses
236 Segment ID (**) 2 2179 Char "11" - Additional N&A & Demos Append
237 Additional Names Result Code 2 2181 Char " 0" = 0 additional names
" 1" = 1 additional name
" 2" = 2 additional names
" 3" = 3 additional names
blank = not requested, no record, or error on input
238 Additional Addresses Result Code 2 2183 Char " 0" = 0 prior addresses
" 1" = 1 prior addresse
" 2" = 2 prior addresses
" 3" = 3 prior addresses
blank = not requested, no record, or error on input
First Additional Name
239 Additional Surname 1 32 2185 Char Additional Surname 1
240 Additional First Name 32 2217 Char Additional First Name
241 Additional Middle Name 32 2249 Char Additional Middle Name
242 Additional Suffix 6 2281 Char Additional Suffix
243 Type 1 2287 Char "A" = AKA
"N" = Nickname
"S" = Similar
Second Additional Name
244 Additional Surname 2 32 2288 Char Additional Surname 2
245 Additional First Name 32 2320 Char Additional First Name
246 Additional Middle Name 32 2352 Char Additional Middle Name
247 Additional Suffix 6 2384 Char Additional Suffix
248 Type 1 2390 Char "A" = AKA
"N" = Nickname
"S" = Similar
Third Additional Name
249 Additional Surname 3 32 2391 Char Additional Surname 3
250 Additional First Name 32 2423 Char Additional First Name
251 Additional Middle Name 32 2455 Char Additional Middle Name
252 Additional Suffix 6 2487 Char Additional Suffix
253 Type 1 2493 Char "A" = AKA
"N" = Nickname
"S" = Similar
First Additional Address
254 Additional (Prior) Street Address #1 60 2494 Char Street Address
255 City 32 2554 Char City
256 State 2 2586 Char State
257 Zip Code 9 2588 Char Zip
258 Dwelling Type (Demo) 1 2597 Char "A" = Apartment
"G" = General Delivery
"M" = Multi-family dwelling
"P" = Post Office Box
"R" = Rural Route
"S" = Single Family Dwelling
"1" = Military
"2" = Mexican Address
"3" = Canadian Address
blank = unknown
259 MSA Code (Demo) - future 4 2598 Char Filler
260 County Code (Demo) 3 2602 Char County Code
261 Census GEO Code (Demo) 7 2605 Char Positions 1-6 = Census Track,
Position 7 = Block Group
262 Date Address First Reported 8 2612 Char MMDDCCYY format
263 Date Address Last Update 8 2620 N MMDDCCYY format
264 Homeowner Indicator (Demo) 1 2628 Char "O" = Owns home - General
"P" = Owns home - reported via Public Record
"C" = Owns home - reported via Credit File
"U" = Owns home - reported via Update Tapes
"R" = Rents
Blank = Unknown
Second Additional Address
265 Additional (Prior) Street Address #2 60 2629 Char Street Address
266 City 32 2689 Char City
267 State 2 2721 Char State
268 Zip Code 9 2723 Char Zip
269 Dwelling Type (Demo) 1 2732 Char "A" = Apartment
"G" = General Delivery
"M" = Multi-family dwelling
"P" = Post Office Box
"R" = Rural Route
"S" = Single Family Dwelling
"1" = Military
"2" = Mexican Address
"3" = Canadian Address
blank = unknown
270 MSA Code (Demo) - Future 4 2733 Char Filler
271 County Code (Demo) 3 2737 Char County Code
272 Census GEO Code (Demo) 7 2740 Char Positions 1-6 = Census Track,
Position 7 = Block Group
273 Date Address First Reported 8 2747 Char MMDDCCYY format
274 Date Address Last Update 8 2755 N MMDDCCYY format
275 Homeowner Indicator (Demo) 1 2763 Char "O" = Owns home - General
"P" = Owns home - reported via Public Record
"C" = Owns home - reported via Credit File
"U" = Owns home - reported via Update Tapes
"R" = Rents
Blank = Unknown
Third Additional Address
276 Additional (Prior) Street Address #3 60 2764 Char Street Address
277 City 32 2824 Char City
278 State 2 2856 Char State
279 Zip Code 9 2858 Char Zip
280 Dwelling Type (Demo) 1 2867 Char "A" = Apartment
"G" = General Delivery
"M" = Multi-family dwelling
"P" = Post Office Box
"R" = Rural Route
"S" = Single Family Dwelling
"1" = Military
"2" = Mexican Address
"3" = Canadian Address
blank = unknown
281 MSA Code (Demo) - Future 4 2868 Char Filler
282 County Code (Demo) 3 2872 Char County Code
283 Census GEO Code (Demo) 7 2875 Char Positions 1-6 = Census Track,
Position 7 = Block Group
284 Date Address First Reported 8 2882 Char MMDDCCYY format
285 Date Address Last Update 8 2890 N MMDDCCYY format
286 Homeowner Indicator (Demo) 1 2898 Char "O" = Owns home - General
"P" = Owns home - reported via Public Record
"C" = Owns home - reported via Credit File
"U" = Owns home - reported via Update Tapes
"R" = Rents
Blank = Unknown
Output Segment 12 - Driver"s License
287 Segment ID (**) 2 2899 Char "12" - Driver"s License
288 Driver"s License Result Code 2 2901 Char " Y" = Appended
" N" = Not Appended
Blank = not requested
289 Driver"s License Number 20 2903 Char Driver"s License Number
290 State Issued 2 2923 Char State Issued
291 Filler 7 2925 Char Filler
292 Filler 7 2932 Char Filler
293 Filler 4 2939 Char Filler
294 Filler 26 2943 Char Filler
Experian FCRA Attributes Output Segment - When FCRA Attributes are present,
it is recommended you obtain a full credit report or a collection report
295 Segment ID (**) 2 2969 Char "FC" - FCRA Information
296 Result Code 2 2971 Char " Y" = Appended
" N" = Not Appended
Blank = not requested
297 Consumer Statement Indicator 1 2973 Char "V" = Victim Statement
"S" = Security Alert Statement
"C" = CRA Alert Statement
"G" = general consumer statement
"B" = Blocked Consumer
If multiple statements on-file most severe return code will be used (order
above). The summary report will have a counter for this field. Each
consumer statement will be written to a separate file for the client.
298 FCRA Attribute, Voluntary BK Withdrawn by Consumer 2 2974 Char FCRA
Attribute, Voluntary BK Withdrawn by Consumer
299 FCRA Attribute, Chapter 7 BK Reported 1 2976 Char FCRA Attribute,
Chapter 7 BK Reported
300 FCRA Attribute, Chapter 11 BK Reported 1 2977 Char FCRA Attribute,
Chapter 11 BK Reported
301 FCRA Attribute, Chapter 12 BK Reported 1 2978 Char FCRA Attribute,
Chapter 12 BK Reported
302 FCRA Attribute, Chapter 13 BK Reported 1 2979 Char FCRA Attribute,
Chapter 13 BK Reported
303 FCRA Attribute, Accounts Closed by Consumer 2 2980 Char FCRA Attribute,
Accounts Closed by Consumer
304 FCRA Attribute, Accounts Disputed by Consumer 2 2982 Char FCRA
Attribute, Accounts Disputed by Consumer
305 Filler 16 2984 Char Filler
306 Record size indicator 1 3000 Char For "CA1B" record type, the value is
" "
For "CAM1" record type, the value is "X"
End of Record Layout for Phase 1A 3000
Output Segment 13 - Additional Attributes
307 Segment ID (**) 2 3001 Char "13" - Additional Attributes
308 Additional Attributes Append Result Code 2 3003 Char " Y" = Appended
" N" = Not Appended
Blank = Not requested, no record, or error on input
309 Attributes Part A 558 3005 Char Refer to Additional Attributes Layout
for details
310 Attributes Part B 690 3563 Char Refer to Additional Attributes Layout
for details
311 Filler 233 4253 Char Filler
END OF CREDIT DATA
312 End of Credit Data Indicator 15 4486 Char "END CREDIT DATA"
Beginning of MetroNet Data
Output Segment 27-Call Center Scheduler Score
313 Segment ID (**) 2 4501 Char "27" - Call Center Scheduler Score
314 Call Center Scheduler Result Code 2 4503 Char " Y" = Appended
" N" = Not Appended
Blank = Not requested, no record, or error on input
315 CCS Score - Time of Day to contact debtor 1 4505 N "A" = Morning
"B" = Afternoon
"C"= Evening
"D"= Evening/Weekend
"E" = Morning & Afternoon
"H" = Morning & Evening/Weekend
"I" = Afternoon & Evening/Weekend
"J" = Evening & Evening/Weekend
"K" = Morning, Afternoon & Evening/Weekend
"L" = Morning, Evening, & Evening/Weekend
"M" = Afternoon, Evening & Evening/Weekend
"N" = Morning,Afternoon & Evening
"O" = Morning, Afternoon, Evening & Evng/Wkend
"U" = Unknown
316 CCS Score - Probably of reaching debtor at that time 1 4506 Char "1" =
Extremely Likely
"2" = Very Likely
"3" = Likely
"4" = Highly Unlikely
"5" = Extremely Unlikely
"0" = Unknown
317 Filler 4 4507 Char Filler
Output Segment 28 MetroNet Phone and Change of Address Information
318 Segment ID (**) 2 4511 Char "28" - MetroNet Phone and Change of Address
319 Filler 2 4513 Char Filler
320 MetroNet Phone Append Result Code 2 4515 Char " 0" = zero MetroNet or
EDA phones Appended
" M" =1 MetroNet Phone Appended
" 1" = 1 EDA Phone Apended
" 2" = 2 EDA Phones Appended
" 3" = 3 EDA Phones Appended
blank = not requested, no record, or error on input
321 MetroNet Change of Address Result Code 1 4517 Char "N" = COA Appended
(USPS NCOA)
"C" = COA Appended (MetroNet Residential COA)
"S" = COA Appended (MetroNet SSN File COA)
"U" = No new address found
blank = not requested, no record, or error in input
322 MetroNet DAP Primary Result Code 2 4518 Char Informational - refer to
MetroNet documentation
323 MetroNet DAP Result Flag 1 4520 Char "P" = Positive match on N&A - no
phone available
"T" = Positive match on N&A - phone available
"U" = Input Name & Addr did not match MetroNet
324 Filler 1 4521 Char Filler
325 EDA Search Result Code 2 4522 Char Informational - refer to MetroNet
documentation
326 COA/NCOA Result Code 2 4524 Char Informational - refer to MetroNet
documentation
327 NCOA Result Code (Nixie Code) 3 4526 Char Informational - refer to
MetroNet documentation
328 Filler 5 4529 Char Filler
Best Phone Number and Change of Address Information
Phone Number information - Source can be MetroNet or EDA - MetroNet
determines best
329 EDA Listing Type 2 4534 Char This field is populated when the source of
the best phone number is EDA
"NP" = Non-Published
"NL" = Not Listed
"NS" = Non-solicitation
blank
330 Best Phone Number Area Code 3 4536 Char Area Code
331 Best Phone Number 7 4539 Char Number
332 Phone Supplier (source) code 1 4546 Char "M" = MetroNet
"E" = EDA
Note if source is EDA - Phone Number and the Name and Address as reported in
the published directory along with up to 2 additional EDA phone entries are
included at the end of this segment for reference.
333 Phone Type - Future 1 4547 Char "S" = Probable Special Phone Number
"W" = Probable Business Phone Number
"X" = Probable Residence Phone Number
"Y" = Probable Cellular Phone Number
"Z" = Probable Pager
blank = unknown
334 To-File Date (Future) 8 4548 Char MMDDCCYY format
335 Date-Last-Updated 8 4556 Char MMDDCCYY format
336 Filler 9 4564 Char Filler
Name information
337 Filler 1 4573 Char Filler
338 Surname 32 4574 Char Surname
339 First Name 32 4606 Char First Name
340 Middle Name or Initial 32 4638 Char Middle Initial
341 Suffix 6 4670 Char Suffix (generation code)
342 Filler 5 4676 Char Filler
Change of Address - Source can be USPS NCOA, MetroNet COA, SSN COA, or a
verified client input address - Metronet determines best
343 House Number 15 4681 Char House number, e.g. 2065
344 Pre-Directional 10 4696 Char Pre-Directional, e.g. East
345 Street Name 32 4706 Char Street Name, e.g. Hyacinth
346 Post Directional 10 4738 Char Post Directional,e.g. West.
347 Suffix 10 4748 Char Suffix , e.g. Avenue or Ave.
348 Unit Designator 10 4758 Unit Designator, e.g. Appartment or Apt. .
349 Unit Number 15 4768 Char Unit Number, e.g. A205
350 City 32 4783 Char City
351 State 2 4815 Char State
352 Zip Code 5 4817 Char Zip Code
353 Zip + 4 4 4822 Char Zip + 4
354 Dwelling Unit Type (future) 3 4826 Char Filler
355 MSA Code (future) 4 4829 Char Filler
356 County Code (future) 3 4833 Char Filler
357 Census GEO Code (future) 7 4836 Char Filler
358 Filler 10 4843 Char Filler
359 Filler 1 4853 Char Filler
360 NCOA Move Type 1 4854 Char Populated when source is USPS/NCOA
"I" = Individual
"F" = Family
"B" = Business
361 NCOA Move Date 8 4855 Char Populated when source is USPS/NCOA
MMDDCCYY format
362 Date Address Last Updated 8 4863 Char MMDDCCYY format
363 Date Address First Reported (future) 8 4871 Char MMDDCCYY format
364 Filler 25 4879 Char Filler
Electronic Directory Assistance Phone Information returned if Special EDA
option is requested and data is found
Best EDA Phone Number
365 EDA Best Pick Score Value 2 4904 Char Value indicating goodness of
match
Refer to MetroNet Documentation
366 Listing Type 2 4906 Char "NP" = Non-Published
"NL" = Not Listed
"NS" = Non-solicitation
blank
367 Area Code 3 4908 Char Area Code
368 Phone Number 7 4911 Char Phone Number
369 Name 32 4918 Char Surname, First name, Middle - space delimited
370 Street Address 40 4950 Char House #, Street name, Appt no. - space
delimited
371 City 20 4990 Char City
372 State 2 5010 Char State
373 Zip Code 5 5012 Char Zip
374 Zip + 4 4 5017 Char Zip + 4
375 Filler 15 5021 Char Filler
Second Best EDA Phone Number
376 EDA Best Pick Score Value 2 5036 Char Value indicating goodness of
match
Refer to MetroNet Documentation
377 Listing Type 2 5038 Char "NP" = Non-Published
"NL" = Not Listed
"NS" = Non-solicitation
blank
378 Area Code 3 5040 Char Area Code
379 Phone Number 7 5043 Char Phone Number
380 Name 32 5050 Char Surname, First name, Middle - space delimited
381 Street Address 40 5082 Char House #, Street name, Appt no. - space
delimited
382 City 20 5122 Char City
383 State 2 5142 Char State
384 Zip Code 5 5144 Char Zip
385 Zip + 4 4 5149 Char Zip + 4
386 Filler 15 5153 Char Filler
Third Best EDA Phone Number
387 EDA Best Pick Score Value 2 5168 Char Value indicating goodness of
match
Refer to MetroNet Documentation
388 Listing Type 2 5170 Char "NP" = Non-Published
"NL" = Not Listed
"NS" = Non-solicitation
blank
389 Area Code 3 5172 Char Area Code
390 Phone Number 7 5175 Char Phone Number
391 Name 32 5182 Char Surname, First name, Middle - space delimited
392 Street Address 40 5214 Char House #, Street name, Appt no. - space
delimited
393 City 20 5254 Char City
394 State 2 5274 Char State
395 Zip Code 5 5276 Char Zip
396 Zip + 4 4 5281 Char Zip + 4
397 Filler 15 5285 Char Filler
Filler
398 Reserved for future 200 5300 Char Filler
399 End of Record Indicator 1 5500 Char Value is "X" for CA1B record
End of Record Layout for Phase 1B 5500
|
|
| | From: | Bruce W. Mercer | | Subject: | Re: append text file | | Date: | Sat, 22 Jan 2005 14:14:47 -0800 |
|
|
| Alina,
The limit to a sdf file should be the same as how many
fields the BDE allows. If you can't get around that, you
could always parse the sdf and get just the data you need.
HTH
--
Bruce W. Mercer
What would you like your computer to do?
Mercer Enterprises
Custom Software, Reporting, and Network admin.
"alina rusu" wrote in message
news:JvDNIv9$EHA.876@news-server...
> Here's the situation,
>
>
> Our application needs to send a fixed length ASCII file to Experian, the
> credit recording bureau, to pull credit reports. I guess this is a pretty
> common thing for a lot of applications these days. The Experian data
format
> is detailed out below. But basically, I will send them a record and get
> back a larger record to append back to my customer's data..
>
> I have no problem making the output record, basically I will make a data
> file with the structure they indicate, populate the fields and do a copy
to
> sdf
>
> I believe I'm going to have a problem on the other side retrieving the
data,
> of course I would start by building a data file with the structure as
> indicated and doing an append from sdf, it would be pretty simple but I
> recall trying something like this before and I had a problem because the
> record size is too large.
>
> Does anyone know the maximum record size for append from fixed length
ASCII?
> Does anyone know a workaround for this?
> Once again, I have not actually completed this project yet, but I remember
> doing this before on another project and getting stuck on the append side
> because the record size of 5500 characters was pretty large and dBase had
a
> problem with that. Any information anyone could offer would be most
> appreciated and I suspect lots of applications will be doing something
like
> this integrating with credit reporting data
>
> Thank you
> Alina Ruso
>
>
> Field Number Field Name Length Begin Format
> Input = 500 bytes
> (*) = Always required on input
> Output = 5500 bytes (Echo-back of client input data and Experian output
> data) (**) = Always returned on output
> Input Record Layout - 500 positions
> 1 Record Format Identifier (*) 4 1 Char Value "CA1B" constant
> Note: Value was "CAM1" for Phase 1A
> 2 Record Length (*) (**) 4 5 N Input value = 0500
> Output value = 5500
> Note: Output value was 3000 for Phase 1A
> The following fields are blank filled on input and populated by Experian
on
> output
> 3 Experian Unique Identifier (**) 30 9 Char Output value = Unique assigned
> by Experian (**)
> Unique Record Id 16 Unique Id Assigned to Each Record
> Unique Client Id 7 Unique Id Assigned to Each Client
(RDXnnnn)
> Unique Batch Id 7 Unique Id Assigned to Each Batch
> 4 File One Result Code (**) 2 39 Char Output value =
> "HT"=Hit (Record Found - data condition met)
> "NH"=No Hit (Rec Found - data condition not met)
> "ER"=Error on input (client not charged no billing)
> "NR"=Consumer not on-file (client charged)
> blank = input record - not yet processed
> 5 Experian File One Error Code 3 41 Char Experian Error Codes
> "CA9" = System Not Available Error, try again
> "045","616" = Fatal Input Name Error
> "407","408","630" = Fatal Input Address Error
> "049" = Input Zip Error
> Other Errors - see detailed error code legend
> 6 Filler 2 44 Char Filler
> 7 Filler 5 46 Char Filler
> (*) Client-supplied Input Information
> 8 Client Subcode Assigned by Experian (*) 7 51 Char Subcode assigned by
> Experian
> 9 Filler 8 58 Char Filler
> 10 Client Account Number or Unique Record Identifier 30 66 Char Client"s
> account number or unique record identifier
> 11 Consumer SSN (optional - highly recommended) 9 96 N SSN
> 12 Consumer Surname (*) 32 105 Char Surname
> 13 Consumer First Name (*) 32 137 Char First Name
> 14 Consumer Middle Name or Initial 32 169 Char Middle Name or Initial
> 15 Consumer suffix text 6 201 Char Possible values are: II, III, IIII,
IV,
> Jr, Sr, 1, 1ST, 11, 111, 1111, 2, 2ND, 3, 3RD, 4, 4TH
> 16 Spouse Initial (Optional) 1 207 Char Spouse Initial
> 17 Street Address (as complete as possible) (*) 60 208 Char House #,
Street
> Directional, Street Name, Street Suffix, Apartment Number or P.O. Box
> address
> 18 City (*) if zip code not provided) 32 268 Char City
> 19 State (*) if zip code not provided) 2 300 Char State
> 20 Zip Code (Optional if city/state present) 5 302 Char Zip
> 21 Zip + 4 (Optional) 4 307 Char Zip+4
> 22 Filler 1 311 Char Filler
> 23 Filler 2 312 Char Filler
> The following fields are blank-filled on input and populated by Experian
on
> output
> 24 Date Batch Received at Experian 7 314 Char YYYYDDD format
> 25 Time Batch Received at Experian 4 321 Char HHMM format
> (*) Client Input Options - A minimum of one input option must be selected
> Client Input Options - Special features for
> specific data segments Client Input Options - Special Feature options
> 26 Filler 4 325 Char Filler
> 27 Filler 1 329 Char Filler
> 28 Filler 1 330 Char Filler
> 29 Include EDA Phone Search 1 331 Char Note: This flag cannot be set
> without also setting Client Input Option Number 28 (MetroNet Phones & COA)
> "1" = EDA Tight Match Search Logic ("40")
> "2" = EDA Medium Match Search Logic ("20")
> "3" = EDA Loose Match Search Logic ("00")
> blank = not requested
> 30 Include USPS NCOA Search 1 332 Char Note: This flag cannot be set
> without also setting Client Input Option Number 28 Output Option Number 28
> (MetroNet Phones & COA)
> "Y" = Include
> Blank = Not Requested
> 31 Include Experian File One Fraud Shield Search 1 333 Char Note: This
> flag cannot be set without also setting Client input Flag 01 and/or 02
(SSN
> & Best N&A)
> "Y" = Include
> Blank = Not Requested
> Client Input Options - File One Data
> 32 Segment 01 - Social Security Number 1 334 Char Note: The SSN Issued
SSN
> Fraud Shield Indicator is returned on this output segment when the Fraud
> Indicator Flag option is selected
> "1" = Verify SSN (do not append SSNs)
> "2" = Always Append SSNs (no verify)
> "3" = Verify input SSN & Append if no match
> Blank = Not requested
> 33 Segment 02 - Best Name & Address 1 335 Char Note: The
High-Risk-Address
> Fraud Shield Indicator is returned on this output segment when the Fraud
> Indicator Flag Option is selected.
> "1" = Verify N&A & Append Best N&A with Demos
> "2" = Verify N&A & Append Best N&A (no Demos)
> Blank = Not requested
> 34 Segment 03 - Deceased Information 1 336 Char "Y" = Verify input SSN
> against SSA SSN & append if match is found
> Blank = Not requested
> 35 Segment 04 - File One Phones 1 337 Char "1" = match on 7 digits &
append
> unique phones
> "2" = match on 10 digits & append unique phones
> "3" = match on 7, apply criteria date, append uniques
> Note: up to 3 input phones can be supplied and will be compared
> 36 Segment 05 - Employment 1 338 Char "1" = Append Best Employment
> "2" = Append Additional Employment (future)
> Blank = Not requested
> Segment 06 - Model Scores "B " = Bankruptcy , "F " =
> FICO Risk V2,
> "H " = Recovery Bankcard, "J " = Recovery Retail,
> "K " = FICO Bankcard V2, "N "= FICO Installment,
> "R "= FICO Finance, "V "= FICO Auto,
> "W "= TEC model, "3 "= NRM V2,
> "RA" = ROI Detail score, "RB" = ROI Summary Score
> "5 " = BK Watch, "U " = Sureview Score
> blank = not requested
> 37 Model Score 1 2 339 Char Select value from above list
> 38 Model Score 2 2 341 Char Select value from above list
> 39 Model Score 3 2 343 Char Select value from above list
> 40 Model Score 4 2 345 Char Select value from above list
> 41 Model Score 5 2 347 Char Select value from above list
> Segment 07 - Credit Attributes 1 Deceased Indicator, 4 Public Record
> Indicators, 1 Total Derog Accts & Unsatisfied Public Record Count, 1 Total
> Monthly Payment Amount, 1 Total Finance Accts with >0 Balance Count, 4
Derog
> Counters, 2 Collection Counters,
> 4 Credit Amounts, 6 Balance Amounts, 4 Utilization ratios, 3 New Account
> Open Counts, 2 Inquiry counts
> 42 Credit Attributes (33) 1 349 Char "Y" = Append
> Blank = Not requested
> 43 Segment 08 - Future 1 350 Char Future
> 44 Segment 09 - Bankruptcy Information 1 351 Char "Y" = Append
> Blank = Not requested
> 45 Segment 10 -Future 1 352 Char Future
> 46 Segment 11- Add"l Names & Prior Addresses 1 353 Char "1" = Append
> Additional N&A + Demos
> "2" = Append Additional N&A only
> Blank = Not requested
> 47 Segment 12 - Driver"s License 1 354 Char "Y" = Append
> Blank = Not requested
> 48 Segment 13 - Additional Attributes 1 355 Char "Y" = Append
> Blank = Not requested
> Note: Please consult with your sales representative for a list of these
> attributes
> 49 Segment 14 - future 1 356 Char Filler
> 50 Segment 15 - future 1 357 Char Filler
> 51 Segment 16 - future 1 358 Char Filler
> 52 Segment 17 - future 1 359 Char Filler
> 53 Segment 18 - future 1 360 Char Filler
> 54 Segment 19 - future 1 361 Char Filler
> 55 Segment 20- future 1 362 Char Filler
> 56 Segment 21- future 1 363 Char Filler
> 57 Segment 22 - future 1 364 Char Filler
> 58 Segment 23 - future 1 365 Char Filler
> 59 Segment 24- future 1 366 Char Filler
> 60 Segment 25 - future 1 367 Char Filler
> 61 Segment 26 - future 1 368 Char Filler
> Client Input Options - MetroNet data
> 62 Segment 27 - Call Center Scheduler Score 1 369 Char "Y" = Append
> Blank = Not requested
> Note: This score returns the best time of day to contact the debtor by
> phone as well as a probably score of reaching the debtor at that time.
> 63 Segment 28 - MetroNet Phones & Change of Address 1 370 Char Note: USPS
> NCOA Changes of addresses are included in this output segment when the
> "Include NCOA" search flag is set.
> Note: EDA Phone Numbers are returned in this output segment when there is
> no MetroNet Phone available and the Include EDA search flag is set.
> "1" = Verify 7 digit input phone & Append unique(s)
> "2" = Verify 10 digit input phone & Append unique(s)
> blank = Not Requested
>
> Optional Client-Supplied Input Data (130 positions)
> 64 Consumer Area Code (Client Input Telephone #1) 3 371 Char
> Client-supplied input phone 1 (area code)
> 65 Consumer 7-digit 7 374 Char Client-supplied input phone 1
(number)
> 66 Consumer Area Code (Client Input Telephone #2) 3 381 Char
> Client-supplied input phone 2 (area code)
> 67 Consumer 7-digit 7 384 Char Client-supplied input phone 2 (number)
> 68 Consumer Area Code (Client Input Telephone #3) 3 391 Char
> Client-supplied input phone 3 (area code)
> 69 Consumer 7-digit 7 394 Char Client-supplied input phone 3 (number)
> 70 On-File Phone Recency Criteria date 8 401 Char CCYYMMDD -
> Client-supplied date - Compare on-file date to this date and append phones
> if unique & on-file date is more recent)
> 71 Key Code 1 10 409 Char Client-supplied value
> 72 Key Code 2 10 419 Char Client-supplied value
> 73 Balance Amount 9 429 Char Balance Amount
> 74 Account Date 8 438 Char MMDDCCYY format
> 75 Customer Number 15 446 Char Client supplied value
> 76 Branch Code 4 461 Char Client supplied value
> 77 Client Supplied Data Field #1 17 465 Char Reserved for client data
> 78 Client Supplied Data Field #2 19 482 Char Reserved for client data
> End of Input Record Layout 500
> Experian Output Data
> Experian Standard Output Data (2,500 bytes)
> Output Segment 01 - SSN Information
> 79 Segment ID (**) 2 501 Char "01" - SSN Validation & Append
> 80 SSN Validation Result Code 2 503 Char " V" = Input SSN Verified with
> Best File One SSN
> " M" = Input SSN matched other File One SSN
> " N" = Input SSN did not match Experian
> " Z" = Input SSN could not be verified (not provided)
> " K" = Verify resulted in SSN Append (No SSN input)
> " X" = Verify resulted in SSN Append (No match)
> Blank = Not requested, no record, or error on input
> 81 SSN Issued Social Fraud Shield Result Code 1 505 Char "Y" = SSN Issued
> Social Fraud Alert
> "N" = Fraud not found
> Blank = No requested, no record, or error on input
> 82 SSN Append Result Code 2 506 Char " 0" = 0 SSN Appended
> " 1" = 1 SSN Appended
> " 2" = 2 SSN Appended
> " 3" = 3 SSN Appended
> Blank = not requested
> 83 Best File One SSN 9 508 Char Best File One SSN
> 84 Additional File One SSN 9 517 Char Additional on-file SSN
> 85 Additional File One SSN 9 526 Char Additional on-file SSN
> Output Segment 02 - Best N&A Information
> 86 Segment ID (**) 2 535 Char "02" - Best N&A & Demos
> 87 Best N&A Result Code 2 537 Char " V" = Input N&A Verified with Best
File
> One N&A
> " M" = Input N&A Matches another File One N&A
> " N" = Input N&A doesn"t match File One N&A
> Blank = Not requested, no record, or error on input
> Note: Best N&A is always appended with this option
> 88 Filler 1 539 Char Filler
> 89 Demographic Result Code 1 540 Char "Y" = Best N&A Appended with
> Demographics
> "N" = Best N&A Appended without Demographics
> Blank = not requested
> 90 Address Fraud Indicator 1 541 Char "Y" = High Risk Address Fraud Alert
> "N" = Address appears to be valid
> Blank = not requested
> 91 Year of Birth (Demo) 4 542 N Year of Birth
> 92 Date of Birth (Demo) 8 546 N MMDDCCYY format
> 93 Gender (future) (Demo) 1 554 Char Filler
> 94 Living Unit Indicator (future) (Demo) 1 555 Char Filler 0
> 95 Home Ownership Indicator (Demo) 1 556 Char Note - limited data on file
> "O" = Owns home - General
> "P" = Owns home - reported via Public Record
> "C" = Owns home - reported via Credit File
> "U" = Owns home - reported via Update Tapes
> "R" = Rents
> Blank = Unknown
> 96 Best Surname 32 557 Char Best Name
> 97 Best First Name 32 589 Char Best Name
> 98 Best Middle Name or Initial 32 621 Char Best Name
> 99 Best Suffix 6 653 Char Best Name
> 100 Best Street Address 60 659 Char Best Address
> 101 Best City 32 719 Char Best City
> 102 Best State 2 751 Char Best State
> 103 Best Zip Code 9 753 Char Best Zip
> 104 Dwelling Type (Demo) 1 762 Char "A"=Apartment,
> "G"=General Dlivery
> "M"=Multi-family dwelling
> "P"=Post Office Box
> "R"=Rural Route
> "S"=Single Family Dwelling
> "1"=Military
> "2"=Mexican Address
> "3"=Canadian Address
> blank = unknown
> 105 MSA Code (Demo) - future 4 763 Char Filler
> 106 County Code (Demo) 3 767 Char County Code
> 107 Census GEO Code (Demo) 7 770 Char Positions 1-6 = Census Track,
Position
> 7 = Block Group
> 108 Date Address First Reported 8 777 Char MMDDCCYY format
> 109 Date Address Last Updated 8 785 Char MMDDCCYY format
> 110 Number of different surnames at this address (future) 2 793 N 0-99
> 111 Number of family members at this address (future) 2 795 N 0-99
> 112 Filler 30 797 Char Filler
> Output Segment 03 - Social Security Administration Deceased
> 113 Segment ID (**) 2 827 Char "03" - SSA Deceased Information
> 114 SSN Deceased Result Code 2 829 Char " Y" = SSN verified as deceased in
> SSA File
> " N" = SSN did not match SSA File
> Blank = not requested, no record, or error on input
> 115 Date of Birth of Deceased 8 831 Char MMDDCCYY format
> 116 Date of Death 8 839 Char MMDDCCYY format
> 117 State/Country Code of Death (future) 2 847 Char State or country code
of
> death
> 118 Zip Code of Last Known Residence (future) 5 849 Char Zip code of last
> known residence
> 119 Zip Code for receipt of lump sum (future) 5 854 Char Zip code for
> receipt of lump sum
> Output Segment 04 - File One Phones
> 120 Segment ID (**) 2 859 Char "04" - File One Phone Verification & Append
> 121 Client Input Phone(s) to File One Phone(s) match result Code 2 861
Char
> " 0" = No File One Phones Available
> " 1" = Client input matched 1 File One Phone
> " 2" = Client input matched 2 File One Phones
> " 3" = Client input matched 3 File One Phones
> " N" =No client phones matched File One phones
> " Z" = No client Input phone provided
> blank = not requested, no record, or error on input
> 122 File One Phone Append Result Code 2 863 Char " 0" = Zero File One
Phones
> appended
> " 1" = 1 File One Phone Appended
> " 2" = 2 File One Phones Appended
> " 3" = 3 File One Phones Appended
> blank = not requested, no record, or error on input
> First Experian File One Phone
> 123 Phone #1- Area Code 3 865 Char Area Code
> 124 Phone #1- Number 7 868 Char Number
> 125 Phone Source 1 875 Char Note: Data returned when Permissible Purpose
> "P" = Published Residential
> "U"= Update Tapes
> "I" = Inquiry
> "D" = Directory Assistance
> blank = unknown
> 126 Phone Type 1 876 Char "R" = Residence "B" =Business
> "P" = Pager "F" =Fax
> "C" = Cellular "T" =Pay Phone
> "I" = Institution blank = unknown
> "S" = Probable Special Phone Number
> "W" = Probable Business Phone Number
> "X" = Probable Residence Phone Number
> "Y" = Probable Cellular Phone Number
> "Z" = Probable Pager
> 127 To-File Date 8 877 Char MMDDCCYY format
> 128 Date-Last-Updated 8 885 Char MMDDCCYY format
> Second Experian File One Phone
> 129 Phone #2 - Area Code 3 893 Char Area Code
> 130 Phone #2- Number 7 896 Char Number
> 131 Phone Source 1 903 Char Note: Data returned when Permissible Purpose
> "P" = Published Residential
> "U"= Update Tapes
> "I" = Inquiry
> "D" = Directory Assistance
> blank = unknown
> 132 Phone Type 1 904 Char "R" = Residence "B" =Business
> "P" = Pager "F" =Fax
> "C" = Cellular "T" =Pay Phone
> "I" = Institution blank = unknown
> "S" = Probable Special Phone Number
> "W" = Probable Business Phone Number
> "X" = Probable Residence Phone Number
> "Y" = Probable Cellular Phone Number
> "Z" = Probable Pager
> 133 To-File Date 8 905 Char MMDDCCYY format
> 134 Date-Last-Updated 8 913 Char MMDDCCYY format
> Third Experian File One Phone
> 135 Phone #3 - Area Code 3 921 Char Area Code
> 136 Phone #3 - Number 7 924 Char Number
> 137 Phone Source 1 931 Char Note: Data returned when Permissible Purpose
> "P" = Published Residential
> "U"= Update Tapes
> "I" = Inquiry
> "D" = Directory Assistance
> blank = unknown
> 138 Phone Type 1 932 Char "R" = Residence "B" =Business
> "P" = Pager "F" =Fax
> "C" = Cellular "T" =Pay Phone
> "I" = Institution blank = unknown
> "S" = Probable Special Phone Number
> "W" = Probable Business Phone Number
> "X" = Probable Residence Phone Number
> "Y" = Probable Cellular Phone Number
> "Z" = Probable Pager
> 139 To-File Date 8 933 Char MMDDCCYY format
> 140 Date-Last-Updated 8 941 Char MMDDCCYY format
> Reserved for future use
> 141 Filler 10 949 Char Filler
> 142 Filler 1 959 Char Filler
> 143 Filler 1 960 Char Filler
> 144 Filler 8 961 Char Filler
> 145 Filler 8 969 Char Filler
> Output Segment 05 - Employment
> 146 Segment ID (**) 2 977 5 "05" - Employment Append
> 147 Employment Result Code 2 979 Char " Y" = Appended
> " N" = Not Appended
> Blank = Not requested, no record, or error on input
> 148 Employer Name 30 981 Char Employer Name
> 149 Employer Address Line 1 32 1011 Char Street Number, Direction, Street
> Name
> 150 Employer Address line 2 32 1043 Char City and State or Additional Addr
> Info
> 151 Employer Address line 3 32 1075 Char City and State if Additional Addr
> info is present
> 152 Employer Zip Code 9 1107 Char Zip Code
> 153 To-File Date 8 1116 Char MMDDCCYY format
> 154 Date-Last-Updated 8 1124 Char MMDDCCYY format
> 155 Filler 12 1132 Char Filler
> Output Segment 06 - Model Scores (up to 5 scores)
> 156 Segment ID (**) 2 1144 Char "06" - Model Scores Append
> 157 Model Append Result Code 2 1146 Char " 0" = 0 model score Appended
> (exclusion score)
> " 1" = 1 model score Appended
> " 2" = 2 model scores Appended
> " 3" = 3 model scores Appended
> " 4" = 4 model scores Appended
> " 5" = 5 model scores Appended
> blank = not requested
> 158 Model 1 Code 2 1148 Char Model 1 Code
> 159 Model 1 Score or exclusion score 4 1150 Char Model 1 Score or
exclusion
> score
> 160 Model 1 Factor Codes 8 1154 Char Model 1 Factor Codes
> 161 Model 2 Code 2 1162 Char Model 2 Code
> 162 Model 2 Score or exclusion score 4 1164 Char Model 2 Score or
exclusion
> score
> 163 Model 2 Factor Codes 8 1168 Char Model 2 Factor Codes
> 164 Model 3 Code 2 1176 Char Model 3 Code
> 165 Model 3 Score or exclusion score 4 1178 Char Model 3 Score or
exclusion
> score
> 166 Model 3 Factor Codes 8 1182 Char Model 3 Factor Codes
> 167 Model 4 Code 2 1190 Char Model 4 Code
> 168 Model 4 Score or exclusion score 4 1192 Char Model 4 Score or
exclusion
> score
> 169 Model 4 Factor Codes 8 1196 Char Model 4 Factor Codes
> 170 Model 5 Code 2 1204 Char Model 5 Code
> 171 Model 5 Score or exclusion score 4 1206 Char Model 5 Score or
exclusion
> score
> 172 Model 5 Factor Codes 8 1210 Char Model 5 Factor Codes
> Output Segment 07 - 33 Credit Attributes
> 173 Segment ID (**) 2 1218 Char "07" - Credit Attributes (33 Attributes)
> 174 33 Credit Attributes Append Result Code 2 1220 Char " Y" = Appended
> " N" = Not Appended
> Blank = Not requested, no record, or error on input
> 175 Q24DEC 1 1222 Char Deceased Indicator
> 176 Q24BKC7 1 1223 Char BK Chapter 7 Disposition Indicator
> 177 Q24BKC11 1 1224 Char BK Chapter 11 Disposition Indicator
> 178 Q24BKC13 1 1225 Char BK Chapter 13 Disposition Indicator
> 179 Q24LSAT1 1 1226 Char SAT Judgments/Liens (12 mos) Indicator
> 180 Q24DG01 2 1227 N Total Derog Accts (Trade & Public Record)
> 181 Q24TD01 2 1229 N Total Accts with 30 days past due in past 24 mos
> 182 Q24TD02 2 1231 N Total Accts with 60 days past due in past 24 mos
> 183 Q24TD03 2 1233 N Total Accts with 90 days past due in past 24 mos
> 184 Q24TD04 2 1235 N Total Accts with 120-180 days past due in 24 mos
> 185 Q24TC01 2 1237 N Total Accts in Collection Status
> 186 Q24TC02 2 1239 N Total Accts w/Paid Collection Status in past 6 mos
> 187 Q24TAL15 9 1241 N Total Monthly Payment Amt (All - 12 mos)
> 188 Q24TMT11 9 1250 N Sum of Credit Amt - Mortgages (12 mos)
> 189 Q24TMT12 9 1259 N Sum of Balance Amt - 1st Mortgages (12 mos)
> 190 Q24THE11 9 1268 N Sum of Credit Amt - H-Equity/2nd MTG (12 mos)
> 191 Q24THE12 9 1277 N Sum of Balance Amt - H-Equity/2nd MTG (12 mos)
> 192 Q24TIN12 9 1286 N Sum of Balance Amt - Installment loans (12 mos)
> 193 Q24TRV11 9 1295 N Sum of Credit Amt - Revolving Trades (12 mos)
> 194 Q24TRV12 9 1304 N Sum of Balance Amt - Revolving Trades (12 mos)
> 195 Q24TRV13 6 1313 N % of Credit Utilization - Revolving Trades (12 mos)
> 196 Q24TBC13 6 1319 N % of Credit Utilization - Bankcard (12 mos)
> 197 Q24TBC14 9 1325 Zoned Decimal Sum of Available Credit Amt - Bankcard
> (12 mos)
> 198 Q24TAU12 9 1334 N Sum of Balance Amt - Auto Loans (12 mos)
> 199 Q24TAU13 6 1343 N % of Credit Utilization - Auto Loans (12 mos)
> 200 Q24TAE12 9 1349 N Sum of Balance Amt - Auto Leases (12 mos)
> 201 Q24TAE13 6 1358 N % of Credit Utilization - Auto Leases (12 mos)
> 202 Q24TAL21 2 1364 N Total Accounts opened in past 6 mos
> 203 Q24TRV22 2 1366 N Total Revolving Accts opened in past 3 mos
> 204 Q24TIB22 2 1368 N Total Installment Loans opened in past 3 mos
> 205 Q24TFN31 2 1370 N Total Finance Accts with Balance >0 (12 mos)
> 206 Q24IAL01 2 1372 N Total credit inquiries logged in past 3 mos
> 207 Q24IAL02 2 1374 N Total credit inquiries logged in past 6 mos
> Output Segment 08 - Future
> 208 Segment ID (**) 2 1376 Char "08" - Future
> 209 Result Code 2 1378 Future
> 210 Reserved for future use 200 1380 Char Future
> Output Segment 09 - Bankruptcy Information
> 211 Segment ID (**) 2 1580 Char "09" - Bankruptcy Information
> 212 Bankruptcy Screen Result Code 2 1582 Char " Y" = Appended
> " N" = Not Appended
> Blank = Not requested, no record, or error on input
> 213 Status Code 2 1584 Char Qualifies if Status code is:
> "13", "15", "16", 17", "22", "23", "24", "25", "26", "27", "28", "29"
> 214 Status Date 8 1586 Char MMDDCCYY format
> 215 Court Code 7 1594 Char Court Code
> 216 Court Name 24 1601 Char Court Name
> 217 Docket Number 24 1625 Char Docket Number
> 218 Creditor Name 32 1649 Char Creditor Name
> 219 ECOA Code 1 1681 Char "I" = Individual
> "2" = Joint
> "H" = Individual Terminated
> "B" = Joint Terminated
> blank = unknown
> 220 Asset Amount 8 1682 Char Asset Amount
> 221 Liabilities Amount 8 1690 Char Liabilities Amount
> 222 Repayment % 3 1698 Char For chapter 13 only
> 223 Adjustment % 2 1701 Char For chapter 13 only
> 224 Book Page 24 1703 Char Book page and sequence number
> 225 Voluntary/Involuntary BK indicator 1 1727 Char V=Voluntary,
> I=Involuntary blank = unknown
> 226 Original Filing Date 8 1728 Char MMDDCCYY format
> 227 Attorney Name (future) 60 1736 Char Attorney Name (future)
> 228 Attorney Phone (future) 10 1796 Char Attorney Phone (future)
> 229 Fller 100 1806 Char Filler
> Output Segment 10 (future)
> 230 Segment ID (**) 2 1906 Char "10" - Future
> 231 Result Code 2 1908 Char Result Code
> 232 Spouse First Name 15 1910 Char Available with special customer master
> setting
> 233 Filler 15 1925 Char Filler
> 234 Filler 9 1940 Char Filler
> 235 Filler 230 1949 Char Filler
> Output Segment 11 - Additional Names & Prior Addresses
> 236 Segment ID (**) 2 2179 Char "11" - Additional N&A & Demos Append
> 237 Additional Names Result Code 2 2181 Char " 0" = 0 additional names
> " 1" = 1 additional name
> " 2" = 2 additional names
> " 3" = 3 additional names
> blank = not requested, no record, or error on input
> 238 Additional Addresses Result Code 2 2183 Char " 0" = 0 prior addresses
> " 1" = 1 prior addresse
> " 2" = 2 prior addresses
> " 3" = 3 prior addresses
> blank = not requested, no record, or error on input
> First Additional Name
> 239 Additional Surname 1 32 2185 Char Additional Surname 1
> 240 Additional First Name 32 2217 Char Additional First Name
> 241 Additional Middle Name 32 2249 Char Additional Middle Name
> 242 Additional Suffix 6 2281 Char Additional Suffix
> 243 Type 1 2287 Char "A" = AKA
> "N" = Nickname
> "S" = Similar
> Second Additional Name
> 244 Additional Surname 2 32 2288 Char Additional Surname 2
> 245 Additional First Name 32 2320 Char Additional First Name
> 246 Additional Middle Name 32 2352 Char Additional Middle Name
> 247 Additional Suffix 6 2384 Char Additional Suffix
> 248 Type 1 2390 Char "A" = AKA
> "N" = Nickname
> "S" = Similar
> Third Additional Name
> 249 Additional Surname 3 32 2391 Char Additional Surname 3
> 250 Additional First Name 32 2423 Char Additional First Name
> 251 Additional Middle Name 32 2455 Char Additional Middle Name
> 252 Additional Suffix 6 2487 Char Additional Suffix
> 253 Type 1 2493 Char "A" = AKA
> "N" = Nickname
> "S" = Similar
> First Additional Address
> 254 Additional (Prior) Street Address #1 60 2494 Char Street Address
> 255 City 32 2554 Char City
> 256 State 2 2586 Char State
> 257 Zip Code 9 2588 Char Zip
> 258 Dwelling Type (Demo) 1 2597 Char "A" = Apartment
> "G" = General Delivery
> "M" = Multi-family dwelling
> "P" = Post Office Box
> "R" = Rural Route
> "S" = Single Family Dwelling
> "1" = Military
> "2" = Mexican Address
> "3" = Canadian Address
> blank = unknown
> 259 MSA Code (Demo) - future 4 2598 Char Filler
> 260 County Code (Demo) 3 2602 Char County Code
> 261 Census GEO Code (Demo) 7 2605 Char Positions 1-6 = Census Track,
> Position 7 = Block Group
> 262 Date Address First Reported 8 2612 Char MMDDCCYY format
> 263 Date Address Last Update 8 2620 N MMDDCCYY format
> 264 Homeowner Indicator (Demo) 1 2628 Char "O" = Owns home - General
> "P" = Owns home - reported via Public Record
> "C" = Owns home - reported via Credit File
> "U" = Owns home - reported via Update Tapes
> "R" = Rents
> Blank = Unknown
> Second Additional Address
> 265 Additional (Prior) Street Address #2 60 2629 Char Street Address
> 266 City 32 2689 Char City
> 267 State 2 2721 Char State
> 268 Zip Code 9 2723 Char Zip
> 269 Dwelling Type (Demo) 1 2732 Char "A" = Apartment
> "G" = General Delivery
> "M" = Multi-family dwelling
> "P" = Post Office Box
> "R" = Rural Route
> "S" = Single Family Dwelling
> "1" = Military
> "2" = Mexican Address
> "3" = Canadian Address
> blank = unknown
> 270 MSA Code (Demo) - Future 4 2733 Char Filler
> 271 County Code (Demo) 3 2737 Char County Code
> 272 Census GEO Code (Demo) 7 2740 Char Positions 1-6 = Census Track,
> Position 7 = Block Group
> 273 Date Address First Reported 8 2747 Char MMDDCCYY format
> 274 Date Address Last Update 8 2755 N MMDDCCYY format
> 275 Homeowner Indicator (Demo) 1 2763 Char "O" = Owns home - General
> "P" = Owns home - reported via Public Record
> "C" = Owns home - reported via Credit File
> "U" = Owns home - reported via Update Tapes
> "R" = Rents
> Blank = Unknown
> Third Additional Address
> 276 Additional (Prior) Street Address #3 60 2764 Char Street Address
> 277 City 32 2824 Char City
> 278 State 2 2856 Char State
> 279 Zip Code 9 2858 Char Zip
> 280 Dwelling Type (Demo) 1 2867 Char "A" = Apartment
> "G" = General Delivery
> "M" = Multi-family dwelling
> "P" = Post Office Box
> "R" = Rural Route
> "S" = Single Family Dwelling
> "1" = Military
> "2" = Mexican Address
> "3" = Canadian Address
> blank = unknown
> 281 MSA Code (Demo) - Future 4 2868 Char Filler
> 282 County Code (Demo) 3 2872 Char County Code
> 283 Census GEO Code (Demo) 7 2875 Char Positions 1-6 = Census Track,
> Position 7 = Block Group
> 284 Date Address First Reported 8 2882 Char MMDDCCYY format
> 285 Date Address Last Update 8 2890 N MMDDCCYY format
> 286 Homeowner Indicator (Demo) 1 2898 Char "O" = Owns home - General
> "P" = Owns home - reported via Public Record
> "C" = Owns home - reported via Credit File
> "U" = Owns home - reported via Update Tapes
> "R" = Rents
> Blank = Unknown
> Output Segment 12 - Driver"s License
> 287 Segment ID (**) 2 2899 Char "12" - Driver"s License
> 288 Driver"s License Result Code 2 2901 Char " Y" = Appended
> " N" = Not Appended
> Blank = not requested
> 289 Driver"s License Number 20 2903 Char Driver"s License Number
> 290 State Issued 2 2923 Char State Issued
> 291 Filler 7 2925 Char Filler
> 292 Filler 7 2932 Char Filler
> 293 Filler 4 2939 Char Filler
> 294 Filler 26 2943 Char Filler
> Experian FCRA Attributes Output Segment - When FCRA Attributes are
present,
> it is recommended you obtain a full credit report or a collection report
> 295 Segment ID (**) 2 2969 Char "FC" - FCRA Information
> 296 Result Code 2 2971 Char " Y" = Appended
> " N" = Not Appended
> Blank = not requested
> 297 Consumer Statement Indicator 1 2973 Char "V" = Victim Statement
> "S" = Security Alert Statement
> "C" = CRA Alert Statement
> "G" = general consumer statement
> "B" = Blocked Consumer
> If multiple statements on-file most severe return code will be used
(order
> above). The summary report will have a counter for this field. Each
> consumer statement will be written to a separate file for the client.
> 298 FCRA Attribute, Voluntary BK Withdrawn by Consumer 2 2974 Char FCRA
> Attribute, Voluntary BK Withdrawn by Consumer
> 299 FCRA Attribute, Chapter 7 BK Reported 1 2976 Char FCRA Attribute,
> Chapter 7 BK Reported
> 300 FCRA Attribute, Chapter 11 BK Reported 1 2977 Char FCRA Attribute,
> Chapter 11 BK Reported
> 301 FCRA Attribute, Chapter 12 BK Reported 1 2978 Char FCRA Attribute,
> Chapter 12 BK Reported
> 302 FCRA Attribute, Chapter 13 BK Reported 1 2979 Char FCRA Attribute,
> Chapter 13 BK Reported
> 303 FCRA Attribute, Accounts Closed by Consumer 2 2980 Char FCRA
Attribute,
> Accounts Closed by Consumer
> 304 FCRA Attribute, Accounts Disputed by Consumer 2 2982 Char FCRA
> Attribute, Accounts Disputed by Consumer
> 305 Filler 16 2984 Char Filler
> 306 Record size indicator 1 3000 Char For "CA1B" record type, the value
is
> " "
> For "CAM1" record type, the value is "X"
> End of Record Layout for Phase 1A 3000
> Output Segment 13 - Additional Attributes
> 307 Segment ID (**) 2 3001 Char "13" - Additional Attributes
> 308 Additional Attributes Append Result Code 2 3003 Char " Y" = Appended
> " N" = Not Appended
> Blank = Not requested, no record, or error on input
> 309 Attributes Part A 558 3005 Char Refer to Additional Attributes Layout
> for details
> 310 Attributes Part B 690 3563 Char Refer to Additional Attributes Layout
> for details
> 311 Filler 233 4253 Char Filler
> END OF CREDIT DATA
> 312 End of Credit Data Indicator 15 4486 Char "END CREDIT DATA"
> Beginning of MetroNet Data
> Output Segment 27-Call Center Scheduler Score
> 313 Segment ID (**) 2 4501 Char "27" - Call Center Scheduler Score
> 314 Call Center Scheduler Result Code 2 4503 Char " Y" = Appended
> " N" = Not Appended
> Blank = Not requested, no record, or error on input
> 315 CCS Score - Time of Day to contact debtor 1 4505 N "A" = Morning
> "B" = Afternoon
> "C"= Evening
> "D"= Evening/Weekend
> "E" = Morning & Afternoon
> "H" = Morning & Evening/Weekend
> "I" = Afternoon & Evening/Weekend
> "J" = Evening & Evening/Weekend
> "K" = Morning, Afternoon & Evening/Weekend
> "L" = Morning, Evening, & Evening/Weekend
> "M" = Afternoon, Evening & Evening/Weekend
> "N" = Morning,Afternoon & Evening
> "O" = Morning, Afternoon, Evening & Evng/Wkend
> "U" = Unknown
> 316 CCS Score - Probably of reaching debtor at that time 1 4506 Char "1"
=
> Extremely Likely
> "2" = Very Likely
> "3" = Likely
> "4" = Highly Unlikely
> "5" = Extremely Unlikely
> "0" = Unknown
> 317 Filler 4 4507 Char Filler
> Output Segment 28 MetroNet Phone and Change of Address Information
> 318 Segment ID (**) 2 4511 Char "28" - MetroNet Phone and Change of
Address
> 319 Filler 2 4513 Char Filler
> 320 MetroNet Phone Append Result Code 2 4515 Char " 0" = zero MetroNet or
> EDA phones Appended
> " M" =1 MetroNet Phone Appended
> " 1" = 1 EDA Phone Apended
> " 2" = 2 EDA Phones Appended
> " 3" = 3 EDA Phones Appended
> blank = not requested, no record, or error on input
> 321 MetroNet Change of Address Result Code 1 4517 Char "N" = COA Appended
> (USPS NCOA)
> "C" = COA Appended (MetroNet Residential COA)
> "S" = COA Appended (MetroNet SSN File COA)
> "U" = No new address found
> blank = not requested, no record, or error in input
> 322 MetroNet DAP Primary Result Code 2 4518 Char Informational - refer to
> MetroNet documentation
> 323 MetroNet DAP Result Flag 1 4520 Char "P" = Positive match on N&A - no
> phone available
> "T" = Positive match on N&A - phone available
> "U" = Input Name & Addr did not match MetroNet
> 324 Filler 1 4521 Char Filler
> 325 EDA Search Result Code 2 4522 Char Informational - refer to MetroNet
> documentation
> 326 COA/NCOA Result Code 2 4524 Char Informational - refer to MetroNet
> documentation
> 327 NCOA Result Code (Nixie Code) 3 4526 Char Informational - refer to
> MetroNet documentation
> 328 Filler 5 4529 Char Filler
> Best Phone Number and Change of Address Information
> Phone Number information - Source can be MetroNet or EDA - MetroNet
> determines best
> 329 EDA Listing Type 2 4534 Char This field is populated when the source
of
> the best phone number is EDA
> "NP" = Non-Published
> "NL" = Not Listed
> "NS" = Non-solicitation
> blank
> 330 Best Phone Number Area Code 3 4536 Char Area Code
> 331 Best Phone Number 7 4539 Char Number
> 332 Phone Supplier (source) code 1 4546 Char "M" = MetroNet
> "E" = EDA
> Note if source is EDA - Phone Number and the Name and Address as reported
in
> the published directory along with up to 2 additional EDA phone entries
are
> included at the end of this segment for reference.
> 333 Phone Type - Future 1 4547 Char "S" = Probable Special Phone Number
> "W" = Probable Business Phone Number
> "X" = Probable Residence Phone Number
> "Y" = Probable Cellular Phone Number
> "Z" = Probable Pager
> blank = unknown
> 334 To-File Date (Future) 8 4548 Char MMDDCCYY format
> 335 Date-Last-Updated 8 4556 Char MMDDCCYY format
> 336 Filler 9 4564 Char Filler
> Name information
> 337 Filler 1 4573 Char Filler
> 338 Surname 32 4574 Char Surname
> 339 First Name 32 4606 Char First Name
> 340 Middle Name or Initial 32 4638 Char Middle Initial
> 341 Suffix 6 4670 Char Suffix (generation code)
> 342 Filler 5 4676 Char Filler
> Change of Address - Source can be USPS NCOA, MetroNet COA, SSN COA, or a
> verified client input address - Metronet determines best
> 343 House Number 15 4681 Char House number, e.g. 2065
> 344 Pre-Directional 10 4696 Char Pre-Directional, e.g. East
> 345 Street Name 32 4706 Char Street Name, e.g. Hyacinth
> 346 Post Directional 10 4738 Char Post Directional,e.g. West.
> 347 Suffix 10 4748 Char Suffix , e.g. Avenue or Ave.
> 348 Unit Designator 10 4758 Unit Designator, e.g. Appartment or Apt. .
> 349 Unit Number 15 4768 Char Unit Number, e.g. A205
> 350 City 32 4783 Char City
> 351 State 2 4815 Char State
> 352 Zip Code 5 4817 Char Zip Code
> 353 Zip + 4 4 4822 Char Zip + 4
> 354 Dwelling Unit Type (future) 3 4826 Char Filler
> 355 MSA Code (future) 4 4829 Char Filler
> 356 County Code (future) 3 4833 Char Filler
> 357 Census GEO Code (future) 7 4836 Char Filler
> 358 Filler 10 4843 Char Filler
> 359 Filler 1 4853 Char Filler
> 360 NCOA Move Type 1 4854 Char Populated when source is USPS/NCOA
> "I" = Individual
> "F" = Family
> "B" = Business
> 361 NCOA Move Date 8 4855 Char Populated when source is USPS/NCOA
> MMDDCCYY format
> 362 Date Address Last Updated 8 4863 Char MMDDCCYY format
> 363 Date Address First Reported (future) 8 4871 Char MMDDCCYY format
> 364 Filler 25 4879 Char Filler
> Electronic Directory Assistance Phone Information returned if Special EDA
> option is requested and data is found
> Best EDA Phone Number
> 365 EDA Best Pick Score Value 2 4904 Char Value indicating goodness of
> match
> Refer to MetroNet Documentation
> 366 Listing Type 2 4906 Char "NP" = Non-Published
> "NL" = Not Listed
> "NS" = Non-solicitation
> blank
> 367 Area Code 3 4908 Char Area Code
> 368 Phone Number 7 4911 Char Phone Number
> 369 Name 32 4918 Char Surname, First name, Middle - space delimited
> 370 Street Address 40 4950 Char House #, Street name, Appt no. - space
> delimited
> 371 City 20 4990 Char City
> 372 State 2 5010 Char State
> 373 Zip Code 5 5012 Char Zip
> 374 Zip + 4 4 5017 Char Zip + 4
> 375 Filler 15 5021 Char Filler
> Second Best EDA Phone Number
> 376 EDA Best Pick Score Value 2 5036 Char Value indicating goodness of
> match
> Refer to MetroNet Documentation
> 377 Listing Type 2 5038 Char "NP" = Non-Published
> "NL" = Not Listed
> "NS" = Non-solicitation
> blank
> 378 Area Code 3 5040 Char Area Code
> 379 Phone Number 7 5043 Char Phone Number
> 380 Name 32 5050 Char Surname, First name, Middle - space delimited
> 381 Street Address 40 5082 Char House #, Street name, Appt no. - space
> delimited
> 382 City 20 5122 Char City
> 383 State 2 5142 Char State
> 384 Zip Code 5 5144 Char Zip
> 385 Zip + 4 4 5149 Char Zip + 4
> 386 Filler 15 5153 Char Filler
> Third Best EDA Phone Number
> 387 EDA Best Pick Score Value 2 5168 Char Value indicating goodness of
> match
> Refer to MetroNet Documentation
> 388 Listing Type 2 5170 Char "NP" = Non-Published
> "NL" = Not Listed
> "NS" = Non-solicitation
> blank
> 389 Area Code 3 5172 Char Area Code
> 390 Phone Number 7 5175 Char Phone Number
> 391 Name 32 5182 Char Surname, First name, Middle - space delimited
> 392 Street Address 40 5214 Char House #, Street name, Appt no. - space
> delimited
> 393 City 20 5254 Char City
> 394 State 2 5274 Char State
> 395 Zip Code 5 5276 Char Zip
> 396 Zip + 4 4 5281 Char Zip + 4
> 397 Filler 15 5285 Char Filler
> Filler
> 398 Reserved for future 200 5300 Char Filler
> 399 End of Record Indicator 1 5500 Char Value is "X" for CA1B record
> End of Record Layout for Phase 1B 5500
>
>
>
>
>
>
>
>
>
>
>
>
|
|
|
