| 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 |