rxc Table: Credit Bureau Extract Client
LeasePak Documentation Suite NETSOL website
Home Search Help
LeasePak Database Objects
Return to Top

Database Reference

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
ym_rep_s 
Reporting month (YYYYMM)
client_id_s 
Client
 
Record modification stamp
client_typ_c 
Client type
report_met_c 
Report on Metro2 extract (Y/N)
report_bus_c 
Report on Business extract (Y/N)
excl_bankrupt_c 
Exclude due to bankruptcy protection (Y/N)
cb_last_name_s 
Last name
cb_first_name_s 
First name
cb_middle_name_s 
Middle name
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
ssn_s 
Social Security number
d_birth_s 
Date of birth
phone_s 
Telephone number
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
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
cb_country_s 
Country code (as defined by Metro2)
cb_addr1_s 
Address line 1
cb_addr2_s 
Address line 2
cb_city_s 
City
st_s 
State code (RST.ST_S code)
zip_s 
Zip code
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
residence_c 
Residence code (O/R/' ')
  O - Owns
  R - Rents
  ' ' - Unknown