rgr Table: Guarantor
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rgr Table: Guarantor

Indexes

Name Segment 1
rgr_idx0 grn_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
grn_s
Guarantor number
CHAR(9) no
stamp_l
Record modification stamp
NUMBER(10) no
d_emp1_ref_stat_s
Employer 1 reference status date
DATE yes
d_emp2_ref_stat_s
Employer 2 reference status date
DATE yes
d_pemp_ref_stat_s
Previous employer reference status date
DATE yes
d_lst_mod_s
Last modification date
DATE yes
d_othr_lst_mod_s
Other address last modification date
DATE yes
d_emp1_lst_mod_s
Employer 1 last modification date
DATE yes
d_emp2_lst_mod_s
Employer 2 last modification date
DATE yes
d_pemp_lst_mod_s
Previous employer last modification date
DATE 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
VARCHAR2(125) yes
add_s
Address
VARCHAR2(36) yes
add2_s
Address 2
VARCHAR2(36) yes
cty_s
City
VARCHAR2(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
VARCHAR2(25) yes
lst_mod_init_s
Last modification initials
CHAR(3) yes
othr_nam_s
Other address name
VARCHAR2(36) yes
othr_add_s
Other address
VARCHAR2(36) yes
othr_add2_s
Other address 2
VARCHAR2(36) yes
othr_cty_s
Other address city
VARCHAR2(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
VARCHAR2(36) yes
othr_note2_s
Other address note 2
VARCHAR2(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
VARCHAR2(36) yes
emp1_cont_s
Employer 1 contact
VARCHAR2(25) yes
emp1_cont_title_s
Employer 1 contact title
VARCHAR2(25) yes
emp1_add_s
Employer 1 address
VARCHAR2(36) yes
emp1_add2_s
Employer 1 address 2
VARCHAR2(36) yes
emp1_cty_s
Employer 1 city
VARCHAR2(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
VARCHAR2(25) yes
emp1_lst_mod_init_s
Employer 1 last modification initials
CHAR(3) yes
emp2_nam_s
Employer 2 name
VARCHAR2(36) yes
emp2_cont_s
Employer 2 contact
VARCHAR2(25) yes
emp2_cont_title_s
Employer 2 contact title
VARCHAR2(25) yes
emp2_add_s
Employer 2 address
VARCHAR2(36) yes
emp2_add2_s
Employer 2 address 2
VARCHAR2(36) yes
emp2_cty_s
Employer 2 city
VARCHAR2(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
VARCHAR2(25) yes
emp2_lst_mod_init_s
Employer 2 last modification initials
CHAR(3) yes
pemp_nam_s
Previous employer name
VARCHAR2(36) yes
pemp_cont_s
Previous employer contact
VARCHAR2(25) yes
pemp_cont_title_s
Previous employer contact title
VARCHAR2(25) yes
pemp_add_s
Previous employer address
VARCHAR2(36) yes
pemp_add2_s
Previous employer address 2
VARCHAR2(36) yes
pemp_cty_s
Previous employer city
VARCHAR2(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
VARCHAR2(25) yes
pemp_lst_mod_init_s
Previous employer last modification initials
CHAR(3) yes
othr_res_yrs_l
Other address years residing
NUMBER(10) yes
othr_res_mon_l
Other address months residing
NUMBER(10) yes
emp1_yrs_l
Employer 1 years employed
NUMBER(10) yes
emp1_mon_l
Employer 1 months employed
NUMBER(10) yes
emp2_yrs_l
Employer 2 years employed
NUMBER(10) yes
emp2_mon_l
Employer 2 months employed
NUMBER(10) yes
pemp_yrs_l
Previous employer years employed
NUMBER(10) yes
pemp_mon_l
Previous employer months employed
NUMBER(10) yes
emp1_salary_d
Employer 1 monthly salary
NUMBER(15,2) yes
emp2_salary_d
Employer 2 monthly salary
NUMBER(15,2) yes
add_inc_d
Additional income source amount
NUMBER(15,2) yes
lt_version_s
Letter version code
CHAR(4) yes
d_crd_exp_upd_s
Credit exposure, date last updated
DATE 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
NUMBER(10) yes
crd_exp_tot_lse_l
Credit exposure, total # of leases
NUMBER(10) yes
crd_exp_tot_del_l
Credit exposure, total # of delinquent leases
NUMBER(10) yes
crd_exp_gr_rec_d
Credit exposure, custom gross receivable
NUMBER(15,2) yes
crd_exp_gr_outs_d
Credit exposure, custom gross outstanding balance
NUMBER(15,2) yes
crd_exp_net_outs_d
Credit exposure, custom net outstanding balance
NUMBER(15,2) yes
crd_exp_tot_apprv_d
Credit exposure, total approved acquisition cost
NUMBER(15,2) yes
crd_exp_tot_exposure_d
Credit exposure, total exposure
NUMBER(15,2) yes
crd_exp_tot_del_d
Credit exposure, total delinquent
NUMBER(15,2) yes
crd_exp_del_cat1_d
Credit exposure, delinquent category 1
NUMBER(15,2) yes
crd_exp_del_cat2_d
Credit exposure, delinquent category 2
NUMBER(15,2) yes
crd_exp_del_cat3_d
Credit exposure, delinquent category 3
NUMBER(15,2) yes
crd_exp_del_cat4_d
Credit exposure, delinquent category 4
NUMBER(15,2) yes
email_s
Email address
VARCHAR2(50) yes
d_lup_s
Date of last update
DATE 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
DATE 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
DATE yes
res_stat_s
Residence status (RES.STAT code)
CHAR(4) yes