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 |