| Columns |
| Name |
Description |
Datatype ¿? |
Allow Null |
| grn_s |
Guarantor number |
char(9) |
no |
| timestamp |
Record modification stamp |
timestamp |
yes |
| d_emp1_ref_stat_s |
Employer 1 reference status date |
datetime |
yes |
| d_emp2_ref_stat_s |
Employer 2 reference status date |
datetime |
yes |
| d_pemp_ref_stat_s |
Previous employer reference status date |
datetime |
yes |
| d_lst_mod_s |
Last modification date |
datetime |
yes |
| d_othr_lst_mod_s |
Other address last modification date |
datetime |
yes |
| d_emp1_lst_mod_s |
Employer 1 last modification date |
datetime |
yes |
| d_emp2_lst_mod_s |
Employer 2 last modification date |
datetime |
yes |
| d_pemp_lst_mod_s |
Previous employer last modification date |
datetime |
yes |
| add_inc_src_s |
Additional income source code |
char(4) |
yes |
| emp1_ref_stat_s |
Employer 1 reference status |
char(4) |
yes |
| emp2_ref_stat_s |
Employer 2 reference status |
char(4) |
yes |
| pemp_ref_stat_s |
Previous employer reference status |
char(4) |
yes |
| def_por_s |
Default portfolio |
char(2) |
yes |
| def_com_s |
Default company |
char(2) |
yes |
| def_reg_s |
Default region |
char(2) |
yes |
| def_off_s |
Default office |
char(3) |
yes |
| nam_long_s |
Long name |
char(125) |
yes |
| add_s |
Address |
char(36) |
yes |
| add2_s |
Address 2 |
char(36) |
yes |
| cty_s |
City |
char(25) |
yes |
| st_s |
State code (RST.ST_S code) |
char(2) |
yes |
| zip_s |
Zip code |
char(9) |
yes |
| bus_phn_s |
Business phone |
char(10) |
yes |
| home_phn_s |
Home phone number |
char(10) |
yes |
| guarantor_title_s |
Guarantor title |
char(25) |
yes |
| lst_mod_init_s |
Last modification initials |
char(3) |
yes |
| othr_nam_s |
Other address name |
char(36) |
yes |
| othr_add_s |
Other address |
char(36) |
yes |
| othr_add2_s |
Other address 2 |
char(36) |
yes |
| othr_cty_s |
Other address city |
char(25) |
yes |
| othr_st_s |
Other address state |
char(2) |
yes |
| othr_zip_s |
Other address zip code |
char(9) |
yes |
| othr_bus_phn_s |
Other address business phone |
char(10) |
yes |
| othr_home_phn_s |
Other address home phone |
char(10) |
yes |
| othr_note1_s |
Other address note 1 |
char(36) |
yes |
| othr_note2_s |
Other address note 2 |
char(36) |
yes |
| othr_id_s |
Other address ID |
char(9) |
yes |
| othr_lst_mod_init_s |
Other address last modification initials |
char(3) |
yes |
| emp1_nam_s |
Employer 1 name |
char(36) |
yes |
| emp1_cont_s |
Employer 1 contact |
char(25) |
yes |
| emp1_cont_title_s |
Employer 1 contact title |
char(25) |
yes |
| emp1_add_s |
Employer 1 address |
char(36) |
yes |
| emp1_add2_s |
Employer 1 address 2 |
char(36) |
yes |
| emp1_cty_s |
Employer 1 city |
char(25) |
yes |
| emp1_st_s |
Employer 1 state |
char(2) |
yes |
| emp1_zip_s |
Employer 1 zip code |
char(9) |
yes |
| emp1_phn_s |
Employer 1 phone |
char(10) |
yes |
| emp1_position_s |
Employer 1 position |
char(25) |
yes |
| emp1_lst_mod_init_s |
Employer 1 last modification initials |
char(3) |
yes |
| emp2_nam_s |
Employer 2 name |
char(36) |
yes |
| emp2_cont_s |
Employer 2 contact |
char(25) |
yes |
| emp2_cont_title_s |
Employer 2 contact title |
char(25) |
yes |
| emp2_add_s |
Employer 2 address |
char(36) |
yes |
| emp2_add2_s |
Employer 2 address 2 |
char(36) |
yes |
| emp2_cty_s |
Employer 2 city |
char(25) |
yes |
| emp2_st_s |
Employer 2 state |
char(2) |
yes |
| emp2_zip_s |
Employer 2 zip code |
char(9) |
yes |
| emp2_phn_s |
Employer 2 phone |
char(10) |
yes |
| emp2_position_s |
Employer 2 position |
char(25) |
yes |
| emp2_lst_mod_init_s |
Employer 2 last modification initials |
char(3) |
yes |
| pemp_nam_s |
Previous employer name |
char(36) |
yes |
| pemp_cont_s |
Previous employer contact |
char(25) |
yes |
| pemp_cont_title_s |
Previous employer contact title |
char(25) |
yes |
| pemp_add_s |
Previous employer address |
char(36) |
yes |
| pemp_add2_s |
Previous employer address 2 |
char(36) |
yes |
| pemp_cty_s |
Previous employer city |
char(25) |
yes |
| pemp_st_s |
Previous employer state |
char(2) |
yes |
| pemp_zip_s |
Previous employer zip code |
char(9) |
yes |
| pemp_phn_s |
Previous employer phone |
char(10) |
yes |
| pemp_position_s |
Previous employer position |
char(25) |
yes |
| pemp_lst_mod_init_s |
Previous employer last modification initials |
char(3) |
yes |
| othr_res_yrs_l |
Other address years residing |
integer |
yes |
| othr_res_mon_l |
Other address months residing |
integer |
yes |
| emp1_yrs_l |
Employer 1 years employed |
integer |
yes |
| emp1_mon_l |
Employer 1 months employed |
integer |
yes |
| emp2_yrs_l |
Employer 2 years employed |
integer |
yes |
| emp2_mon_l |
Employer 2 months employed |
integer |
yes |
| pemp_yrs_l |
Previous employer years employed |
integer |
yes |
| pemp_mon_l |
Previous employer months employed |
integer |
yes |
| emp1_salary_d |
Employer 1 monthly salary |
double precision |
yes |
| emp2_salary_d |
Employer 2 monthly salary |
double precision |
yes |
| add_inc_d |
Additional income source amount |
double precision |
yes |
| lt_version_s |
Letter version code |
char(4) |
yes |
| d_crd_exp_upd_s |
Credit exposure, date last updated |
datetime |
yes |
| t_crd_exp_upd_s |
Credit exposure, time last updated |
char(6) |
yes |
| crd_exp_tot_app_l |
Credit exposure, total # of approved applications |
integer |
yes |
| crd_exp_tot_lse_l |
Credit exposure, total # of leases |
integer |
yes |
| crd_exp_tot_del_l |
Credit exposure, total # of delinquent leases |
integer |
yes |
| crd_exp_gr_rec_d |
Credit exposure, custom gross receivable |
double precision |
yes |
| crd_exp_gr_outs_d |
Credit exposure, custom gross outstanding balance |
double precision |
yes |
| crd_exp_net_outs_d |
Credit exposure, custom net outstanding balance |
double precision |
yes |
| crd_exp_tot_apprv_d |
Credit exposure, total approved acquisition cost |
double precision |
yes |
| crd_exp_tot_exposure_d |
Credit exposure, total exposure |
double precision |
yes |
| crd_exp_tot_del_d |
Credit exposure, total delinquent |
double precision |
yes |
| crd_exp_del_cat1_d |
Credit exposure, delinquent category 1 |
double precision |
yes |
| crd_exp_del_cat2_d |
Credit exposure, delinquent category 2 |
double precision |
yes |
| crd_exp_del_cat3_d |
Credit exposure, delinquent category 3 |
double precision |
yes |
| crd_exp_del_cat4_d |
Credit exposure, delinquent category 4 |
double precision |
yes |
| email_s |
Email address |
char(50) |
yes |
| d_lup_s |
Date of last update |
datetime |
yes |
| t_lup_s |
Time of last update |
char(6) |
yes |
| act_stat_s |
Activity status (STAT code) |
char(4) |
yes |
| addr_type_c |
Address type (B/D/M/P/S/Y/Z)
B - Business address
D - Data reporter default address
M - Military address
P - Bill payer service
S - Secondary address
Y - Consumer address
Z - Unknown type |
char(1) |
yes |
| addr_stat_c |
Address status (C/N/U/Z)
C - Confirmed/verified address
N - Not confirmed address
U - Undeliverable address/returned mail
Z - Unknown status |
char(1) |
yes |
| d_addr_conf_s |
Address confirmation date |
datetime |
yes |
| t_addr_conf_s |
Address confirmation time |
char(6) |
yes |
| cb_business_c |
Credit bureau business indicator (Y/N)
Y - Report lessee to CB as a business
N - Report lessee to CB as a non-business |
char(1) |
yes |
| d_birth_s |
Date of birth |
datetime |
yes |
| res_stat_s |
Residence status (RES.STAT code) |
char(4) |
yes |