| Description |
Column |
Datatype |
| Guarantor number
|
grn_s |
char (9) |
| Sybase timestamp
|
timestamp |
timestamp |
| Employer 1 reference status date
|
d_emp1_ref_stat_s |
datetime |
| Employer 2 reference status date
|
d_emp2_ref_stat_s |
datetime |
| Previous employer reference status date
|
d_pemp_ref_stat_s |
datetime |
| Last modification date
|
d_lst_mod_s |
datetime |
| Other address last modification date
|
d_othr_lst_mod_s |
datetime |
| Employer 1 last modification date
|
d_emp1_lst_mod_s |
datetime |
| Employer 2 last modification date
|
d_emp2_lst_mod_s |
datetime |
| Previous employer last modification date
|
d_pemp_lst_mod_s |
datetime |
| Additional income source code
|
add_inc_src_s |
char (4) |
| Employer 1 reference status
|
emp1_ref_stat_s |
char (4) |
| Employer 2 reference status
|
emp2_ref_stat_s |
char (4) |
| Previous employer reference status
|
pemp_ref_stat_s |
char (4) |
| Default portfolio
|
def_por_s |
char (2) |
| Default company
|
def_com_s |
char (2) |
| Default region
|
def_reg_s |
char (2) |
| Default office
|
def_off_s |
char (3) |
| Long name
|
nam_long_s |
char (125) |
| Address
|
add_s |
char (36) |
| Address 2
|
add2_s |
char (36) |
| City
|
cty_s |
char (25) |
| State
|
st_s |
char (2) |
| Zip code
|
zip_s |
char (9) |
| Business phone
|
bus_phn_s |
char (10) |
| Home phone number
|
home_phn_s |
char (10) |
| Guarantor title
|
guarantor_title_s |
char (25) |
| Last modification initials
|
lst_mod_init_s |
char (3) |
| Other address name
|
othr_nam_s |
char (36) |
| Other address
|
othr_add_s |
char (36) |
| Other address 2
|
othr_add2_s |
char (36) |
| Other address city
|
othr_cty_s |
char (25) |
| Other address state
|
othr_st_s |
char (2) |
| Other address zip code
|
othr_zip_s |
char (9) |
| Other address business phone
|
othr_bus_phn_s |
char (10) |
| Other address home phone
|
othr_home_phn_s |
char (10) |
| Other address note 1
|
othr_note1_s |
char (36) |
| Other address note 2
|
othr_note2_s |
char (36) |
| Other address ID
|
othr_id_s |
char (9) |
| Other address last modification initials
|
othr_lst_mod_init_s |
char (3) |
| Employer 1 name
|
emp1_nam_s |
char (36) |
| Employer 1 contact
|
emp1_cont_s |
char (25) |
| Employer 1 contact title
|
emp1_cont_title_s |
char (25) |
| Employer 1 address
|
emp1_add_s |
char (36) |
| Employer 1 address 2
|
emp1_add2_s |
char (36) |
| Employer 1 city
|
emp1_cty_s |
char (25) |
| Employer 1 state
|
emp1_st_s |
char (2) |
| Employer 1 zip code
|
emp1_zip_s |
char (9) |
| Employer 1 phone
|
emp1_phn_s |
char (10) |
| Employer 1 position
|
emp1_position_s |
char (25) |
| Employer 1 last modification initials
|
emp1_lst_mod_init_s |
char (3) |
| Employer 2 name
|
emp2_nam_s |
char (36) |
| Employer 2 contact
|
emp2_cont_s |
char (25) |
| Employer 2 contact title
|
emp2_cont_title_s |
char (25) |
| Employer 2 address
|
emp2_add_s |
char (36) |
| Employer 2 address 2
|
emp2_add2_s |
char (36) |
| Employer 2 city
|
emp2_cty_s |
char (25) |
| Employer 2 state
|
emp2_st_s |
char (2) |
| Employer 2 zip code
|
emp2_zip_s |
char (9) |
| Employer 2 phone
|
emp2_phn_s |
char (10) |
| Employer 2 position
|
emp2_position_s |
char (25) |
| Employer 2 last modification initials
|
emp2_lst_mod_init_s |
char (3) |
| Previous employer name
|
pemp_nam_s |
char (36) |
| Previous employer contact
|
pemp_cont_s |
char (25) |
| Previous employer contact title
|
pemp_cont_title_s |
char (25) |
| Previous employer address
|
pemp_add_s |
char (36) |
| Previous employer address 2
|
pemp_add2_s |
char (36) |
| Previous employer city
|
pemp_cty_s |
char (25) |
| Previous employer state
|
pemp_st_s |
char (2) |
| Previous employer zip code
|
pemp_zip_s |
char (9) |
| Previous employer phone
|
pemp_phn_s |
char (10) |
| Previous employer position
|
pemp_position_s |
char (25) |
| Previous employer last modification initials
|
pemp_lst_mod_init_s |
char (3) |
| Other address years residing
|
othr_res_yrs_l |
integer |
| Other address months residing
|
othr_res_mon_l |
integer |
| Employer 1 years employed
|
emp1_yrs_l |
integer |
| Employer 1 months employed
|
emp1_mon_l |
integer |
| Employer 2 years employed
|
emp2_yrs_l |
integer |
| Employer 2 months employed
|
emp2_mon_l |
integer |
| Previous employer years employed
|
pemp_yrs_l |
integer |
| Previous employer months employed
|
pemp_mon_l |
integer |
| Employer 1 monthly salary
|
emp1_salary_d |
double precision |
| Employer 2 monthly salary
|
emp2_salary_d |
double precision |
| Additional income source amount
|
add_inc_d |
double precision |
| Letter version code
|
lt_version_s |
char (4) |
| Credit exposure, date last updated
|
d_crd_exp_upd_s |
datetime |
| Credit exposure, time last updated
|
t_crd_exp_upd_s |
char (6) |
| Credit exposure, total # of approved applications
|
crd_exp_tot_app_l |
integer |
| Credit exposure, total # of leases
|
crd_exp_tot_lse_l |
integer |
| Credit exposure, total # of delinquent leases
|
crd_exp_tot_del_l |
integer |
| Credit exposure, custom gross receivable
|
crd_exp_gr_rec_d |
double precision |
| Credit exposure, custom gross outstanding balance
|
crd_exp_gr_outs_d |
double precision |
| Credit exposure, custom net outstanding balance
|
crd_exp_net_outs_d |
double precision |
| Credit exposure, total approved acquisition cost
|
crd_exp_tot_apprv_d |
double precision |
| Credit exposure, total exposure
|
crd_exp_tot_exposure_d |
double precision |
| Credit exposure, total delinquent
|
crd_exp_tot_del_d |
double precision |
| Credit exposure, delinquent category 1
|
crd_exp_del_cat1_d |
double precision |
| Credit exposure, delinquent category 2
|
crd_exp_del_cat2_d |
double precision |
| Credit exposure, delinquent category 3
|
crd_exp_del_cat3_d |
double precision |
| Credit exposure, delinquent category 4
|
crd_exp_del_cat4_d |
double precision |
| TRW transaction type code
|
trx_type_l |
integer |
| TRW transaction type code last updated date
|
d_trx_type_rptd_s |
datetime |
| Email address
|
email_s |
char (50) |