rxc Table: Credit Bureau Extract Client
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rxc Table: Credit Bureau Extract Client

Indexes

Name Segment 1 Segment 2 Segment 3
rxc_idx0 lse_s ym_rep_s client_id_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
CHAR(10) no
ym_rep_s
Reporting month (YYYYMM)
CHAR(6) no
client_id_s
Client
CHAR(9) no
stamp_l
Record modification stamp
NUMBER(10) no
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
VARCHAR2(25) yes
cb_first_name_s
First name
VARCHAR2(20) yes
cb_middle_name_s
Middle name
VARCHAR2(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
DATE 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
VARCHAR2(32) yes
cb_addr2_s
Address line 2
VARCHAR2(32) yes
cb_city_s
City
VARCHAR2(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