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

Database Reference Sybase 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
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