rgr Table: Guarantor

Database Reference

rgr Table: Guarantor

Indexes

Name	Segment 1
rgr_idx0	grn_s

Columns
Name	Description	Datatype ¿?	Allow Null
grn_s	Guarantor number
	Record modification stamp
d_emp1_ref_stat_s	Employer 1 reference status date
d_emp2_ref_stat_s	Employer 2 reference status date
d_pemp_ref_stat_s	Previous employer reference status date
d_lst_mod_s	Last modification date
d_othr_lst_mod_s	Other address last modification date
d_emp1_lst_mod_s	Employer 1 last modification date
d_emp2_lst_mod_s	Employer 2 last modification date
d_pemp_lst_mod_s	Previous employer last modification date
add_inc_src_s	Additional income source code
emp1_ref_stat_s	Employer 1 reference status
emp2_ref_stat_s	Employer 2 reference status
pemp_ref_stat_s	Previous employer reference status
def_por_s	Default portfolio
def_com_s	Default company
def_reg_s	Default region
def_off_s	Default office
nam_long_s	Long name
add_s	Address
add2_s	Address 2
cty_s	City
st_s	State code (RST.ST_S code)
zip_s	Zip code
bus_phn_s	Business phone
home_phn_s	Home phone number
guarantor_title_s	Guarantor title
lst_mod_init_s	Last modification initials
othr_nam_s	Other address name
othr_add_s	Other address
othr_add2_s	Other address 2
othr_cty_s	Other address city
othr_st_s	Other address state
othr_zip_s	Other address zip code
othr_bus_phn_s	Other address business phone
othr_home_phn_s	Other address home phone
othr_note1_s	Other address note 1
othr_note2_s	Other address note 2
othr_id_s	Other address ID
othr_lst_mod_init_s	Other address last modification initials
emp1_nam_s	Employer 1 name
emp1_cont_s	Employer 1 contact
emp1_cont_title_s	Employer 1 contact title
emp1_add_s	Employer 1 address
emp1_add2_s	Employer 1 address 2
emp1_cty_s	Employer 1 city
emp1_st_s	Employer 1 state
emp1_zip_s	Employer 1 zip code
emp1_phn_s	Employer 1 phone
emp1_position_s	Employer 1 position
emp1_lst_mod_init_s	Employer 1 last modification initials
emp2_nam_s	Employer 2 name
emp2_cont_s	Employer 2 contact
emp2_cont_title_s	Employer 2 contact title
emp2_add_s	Employer 2 address
emp2_add2_s	Employer 2 address 2
emp2_cty_s	Employer 2 city
emp2_st_s	Employer 2 state
emp2_zip_s	Employer 2 zip code
emp2_phn_s	Employer 2 phone
emp2_position_s	Employer 2 position
emp2_lst_mod_init_s	Employer 2 last modification initials
pemp_nam_s	Previous employer name
pemp_cont_s	Previous employer contact
pemp_cont_title_s	Previous employer contact title
pemp_add_s	Previous employer address
pemp_add2_s	Previous employer address 2
pemp_cty_s	Previous employer city
pemp_st_s	Previous employer state
pemp_zip_s	Previous employer zip code
pemp_phn_s	Previous employer phone
pemp_position_s	Previous employer position
pemp_lst_mod_init_s	Previous employer last modification initials
othr_res_yrs_l	Other address years residing
othr_res_mon_l	Other address months residing
emp1_yrs_l	Employer 1 years employed
emp1_mon_l	Employer 1 months employed
emp2_yrs_l	Employer 2 years employed
emp2_mon_l	Employer 2 months employed
pemp_yrs_l	Previous employer years employed
pemp_mon_l	Previous employer months employed
emp1_salary_d	Employer 1 monthly salary
emp2_salary_d	Employer 2 monthly salary
add_inc_d	Additional income source amount
lt_version_s	Letter version code
d_crd_exp_upd_s	Credit exposure, date last updated
t_crd_exp_upd_s	Credit exposure, time last updated
crd_exp_tot_app_l	Credit exposure, total # of approved applications
crd_exp_tot_lse_l	Credit exposure, total # of leases
crd_exp_tot_del_l	Credit exposure, total # of delinquent leases
crd_exp_gr_rec_d	Credit exposure, custom gross receivable
crd_exp_gr_outs_d	Credit exposure, custom gross outstanding balance
crd_exp_net_outs_d	Credit exposure, custom net outstanding balance
crd_exp_tot_apprv_d	Credit exposure, total approved acquisition cost
crd_exp_tot_exposure_d	Credit exposure, total exposure
crd_exp_tot_del_d	Credit exposure, total delinquent
crd_exp_del_cat1_d	Credit exposure, delinquent category 1
crd_exp_del_cat2_d	Credit exposure, delinquent category 2
crd_exp_del_cat3_d	Credit exposure, delinquent category 3
crd_exp_del_cat4_d	Credit exposure, delinquent category 4
email_s	Email address
d_lup_s	Date of last update
t_lup_s	Time of last update
act_stat_s	Activity status (STAT code)
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
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
d_addr_conf_s	Address confirmation date
t_addr_conf_s	Address confirmation time
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
d_birth_s	Date of birth
res_stat_s	Residence status (RES.STAT code)