Name | Segment 1 | Segment 2 | Segment 3 |
---|---|---|---|
rxc_idx0 | lse_s | ym_rep_s | client_id_s |
Columns | |||
---|---|---|---|
Name | Description | Datatype ¿? | Allow Null |
lse_s | Lease |
char(10) | no |
ym_rep_s | Reporting month (YYYYMM) |
char(6) | no |
client_id_s | Client |
char(9) | no |
timestamp | Record modification stamp |
timestamp | yes |
client_typ_c | Client type |
char(1) | yes |
report_met_c | Report on Metro2 extract (Y/N) |
char(1) | yes |
report_bus_c | Report on Business extract (Y/N) |
char(1) | yes |
excl_bankrupt_c | Exclude due to bankruptcy protection (Y/N) |
char(1) | yes |
cb_last_name_s | Last name |
char(25) | yes |
cb_first_name_s | First name |
char(20) | yes |
cb_middle_name_s | Middle name |
char(20) | yes |
generation_c | Generation code (J/S/2/3/4/5/6/7/8/9/' ') J - Junior S - Senior 2 - II 3 - III 4 - IV 5 - V 6 - VI 7 - VII 8 - VIII 9 - IX ' ' - None |
char(1) | yes |
ssn_s | Social Security number |
char(9) | yes |
d_birth_s | Date of birth |
datetime | yes |
phone_s | Telephone number |
char(10) | yes |
ecoa_c | ECOA code - Equal Credit Opportunity Act (1/2/5/T/X/W/Z) Values set by LeasePak: 1 - Individual 2 - Joint contractual liability 5 - Co-maker or guarantor T - Terminated X - Deceased W - Business/commercial Z - Delete consumer Values not used by LeasePak: 3 - Authorized user 7 - Maker |
char(1) | yes |
consumer_info_s | Consumer information indicator (CONSU.INFO code) A - Chapter 7 bankruptcy petitioned B - Chapter 11 bankruptcy petitioned C - Chapter 12 bankruptcy petitioned D - Chapter 13 bankruptcy petitioned E - Chapter 7 bankruptcy discharged F - Chapter 11 bankruptcy discharged G - Chapter 12 bankruptcy discharged H - Chapter 13 bankruptcy discharged I - Chapter 7 bankruptcy dismissed J - Chapter 11 bankruptcy dismissed K - Chapter 12 bankruptcy dismissed L - Chapter 13 bankruptcy dismissed M - Chapter 7 bankruptcy withdrawn N - Chapter 11 bankruptcy withdrawn O - Chapter 12 bankruptcy withdrawn P - Chapter 13 bankruptcy withdrawn 1A - Personal receivership 2A - Lease assumption Q - Removes previously reported bankruptcy CII (A to P) or personal receivership CII (1A) S - Removes previously reported lease assumption CII (2A) ' ' - Blank retains previously reported CII, or no new CII applies for this reporting period |
char(2) | yes |
cb_country_s | Country code (as defined by Metro2) |
char(2) | yes |
cb_addr1_s | Address line 1 |
char(32) | yes |
cb_addr2_s | Address line 2 |
char(32) | yes |
cb_city_s | City |
char(20) | yes |
st_s | State code (RST.ST_S code) |
char(2) | yes |
zip_s | Zip code |
char(9) | yes |
addr_ind_c | Address indicator (B/C/D/M/N/P/S/U/Y/' ') B - Business address C - Confirmed/verified address D - Data reporter default address M - Military address N - Not confirmed address P - Bill payer service S - Secondary address U - Undeliverable address/returned mail Y - Consumer address ' ' - Unknown indicator |
char(1) | yes |
residence_c | Residence code (O/R/' ') O - Owns R - Rents ' ' - Unknown |
char(1) | yes |