rxl Table: Credit Bureau Extract Lease
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rxl Table: Credit Bureau Extract Lease

Indexes

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 DescriptionDatatype ¿? 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
timestamp
Record modification stamp
timestamp 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_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
datetime yes
t_run_s
Run time
char(6) yes
id_num_s
Identification number
char(20) yes
account_type_s
Account type
char(2) yes
d_opened_s
Date opened
datetime yes
orig_loan_amt_d
Original loan amount
double precision yes
terms_duration_l
Terms duration (number of months)
integer 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
double precision yes
actual_pmt_amt_d
Actual payment amount
double precision 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
char(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
double precision yes
past_due_d
Amount past due
double precision yes
orig_chrg_off_amt_d
Original charge-off amount
double precision yes
d_account_info_s
Date of account information
datetime yes
d_first_delq_s
Date of first delinquency
datetime yes
d_cb_closed_s
Credit bureau date closed
datetime yes
d_last_pmt_s
Date of last payment
datetime yes
d_balloon_pmt_due_s
Balloon payment due date
datetime yes
balloon_pmt_amt_d
Balloon payment amount
double precision yes