| Name | Segment 1 | Segment 2 | Segment 3 | 
|---|---|---|---|
| rxl_idx0 | lse_s | ym_rep_s | |
| rxl_idx1 | ym_rep_s | metro2_s | lse_s | 
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null | 
| lse_s | Lease  | 
CHAR(10) | no | 
| ym_rep_s | Reporting month (YYYYMM)  | 
CHAR(6) | no | 
| metro2_s | Metro2 file format code  | 
CHAR(4) | no | 
| stamp_l | Record modification stamp  | 
NUMBER(10) | no | 
| 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_act_stat_c | Exclude due to lease activity status (Y/N)  | 
CHAR(1) | yes | 
| excl_stop_cb_c | Exclude due to stop credit bureau reporting (Y/N)  | 
CHAR(1) | yes | 
| excl_reason_s | Exclusion reason  | 
CHAR(10) | yes | 
| base_client_s | Client number on base segment of extract  | 
CHAR(9) | yes | 
| d_run_s | Run date  | 
DATE | yes | 
| t_run_s | Run time  | 
CHAR(6) | yes | 
| id_num_s | Identification number  | 
VARCHAR2(20) | yes | 
| account_type_s | Account type  | 
CHAR(2) | yes | 
| d_opened_s | Date opened  | 
DATE | yes | 
| orig_loan_amt_d | Original loan amount  | 
NUMBER(15,2) | yes | 
| terms_duration_l | Terms duration (number of months)  | 
NUMBER(10) | yes | 
| terms_freq_c | Terms frequency (M/Q/S/Y)
  Values set by LeasePak:
    M - Monthly
    Q - Quarterly
    S - Semiannually
    Y - Annually
  Values not used by LeasePak:
    B - Biweekly
    D - Deferred
    E - Semimonthly
    L - Bimonthly
    P - Single payment loan
    T - Tri-annually
    W - Weekly | 
CHAR(1) | yes | 
| sched_mon_pmt_amt_d | Scheduled monthly payment amount  | 
NUMBER(15,2) | yes | 
| actual_pmt_amt_d | Actual payment amount  | 
NUMBER(15,2) | yes | 
| cb_account_stat_s | Credit bureau account status (CB.ACCSTAT code) 11 = Current (0-29 days past due date) 13 = Paid or closed with zero balance 61 = Paid in full, was a voluntary surrender 62 = Paid in full, was a collection account 63 = Paid in full, was a repossession 64 = Paid in full, was a charge-off 71 = 30-59 days past due date 78 = 60-89 days past due date 80 = 90-119 days past due date 82 = 120-149 days past due date 83 = 150-179 days past due date 84 = 180 or more days past due date 93 = Assigned to collections 95 = Voluntary surrender, there may be a balance due 96 = Repossession, there may be a balance due 97 = Charge-off (unpaid balance reported as a loss) DA = Delete account for reason other than fraud DF = Delete account due to confirmed fraud  | 
CHAR(2) | yes | 
| pmt_rating_c | Payment rating (0/1/2/3/4/5/6/' ')
  Values when account status is 13 or 95:
    0 = Current (0-29 days past due date)
    1 = 30-59 days past due date
    2 = 60-89 days past due date
    3 = 90-119 days past due date
    4 = 120-149 days past due date
    5 = 150-179 days past due date
    6 = 180 or more days past due date
  Value when account status is not 13 or 95:
    ' ' = None
  Values not used by LeasePak:
    G = Collection
    L = Charge-off | 
CHAR(1) | yes | 
| pmt_hist_profile_s | 24-month payment history profile (0/1/2/3/4/5/6/B/D/G/J/K/L) 0 = Current (0-29 days past due date) 1 = 30-59 days past due date 2 = 60-89 days past due date 3 = 90-119 days past due date 4 = 120-149 days past due date 5 = 150-179 days past due date 6 = 180 or more days past due date B = No payment history available prior to this time D = No payment history available this month G = Collection J = Voluntary surrender K = Repossession L = Charge-off  | 
VARCHAR2(24) | yes | 
| special_comment_s | Special comment code (SP.COMMENT code)  | 
CHAR(2) | yes | 
| compliance_cond_s | Compliance condition code (COMPL.COND code)
  XB - Account information disputed by consumer and
       investigation of dispute is in progress
  XC - Investigation of dispute has been completed, but
       consumer disagrees with outcome of investigation
  XH - Investigation of dispute has been completed
  XR - Removes previously reported CCC
  ' ' - Blank retains previously reported CCC, or no new
        CCC applies for this reporting period | 
CHAR(2) | yes | 
| curr_bal_d | Current balance  | 
NUMBER(15,2) | yes | 
| past_due_d | Amount past due  | 
NUMBER(15,2) | yes | 
| orig_chrg_off_amt_d | Original charge-off amount  | 
NUMBER(15,2) | yes | 
| d_account_info_s | Date of account information  | 
DATE | yes | 
| d_first_delq_s | Date of first delinquency  | 
DATE | yes | 
| d_cb_closed_s | Credit bureau date closed  | 
DATE | yes | 
| d_last_pmt_s | Date of last payment  | 
DATE | yes | 
| d_balloon_pmt_due_s | Balloon payment due date  | 
DATE | yes | 
| balloon_pmt_amt_d | Balloon payment amount  | 
NUMBER(15,2) | yes |