rdm Table: Demographic
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rdm Table: Demographic

Child Tables

Name Description
rdmi Demographic Insurance

Indexes

Name Segment 1
rdm_idx0 app_lse_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
app_lse_s
Lease or application
CHAR(10) no
stamp_l
Record modification stamp
NUMBER(10) no
d_exp_s
Letter of credit expiration date
DATE yes
d_verr_s
Date of verification return
DATE yes
inhs_s
In house rating
CHAR(4) yes
entity_s
Entity filing code
CHAR(4) yes
bond_s
Bond rating
CHAR(4) yes
rat_srvc_s
Rating service
CHAR(4) yes
pr_scr_s
Preliminary credit score
CHAR(4) yes
scr_s
Final credit score
CHAR(4) yes
rec_typ_c
Type of record - lease/application (L/A)
CHAR(1) yes
ib_sec_dep_c
Interest bearing security deposit (Y/N)
CHAR(1) yes
ofc_s
Credit approval officer
CHAR(9) yes
fnd_ofc_s
Funding approval officer
CHAR(9) yes
doc_ofc_s
Document approval officer
CHAR(9) yes
commt1_s
Comments [1]
VARCHAR2(80) yes
commt2_s
Comments [2]
VARCHAR2(80) yes
cus_str1_s
Custom string 1
VARCHAR2(25) yes