rdmi Table: Demographic Insurance
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rdmi Table: Demographic Insurance

Parent Table

Name Description
rdm Demographic

Indexes

Name Segment 1 Segment 2
rdmi_idx0 app_lse_s unique_l

     
Columns
Name DescriptionDatatype ¿? Allow Null
app_lse_s
Lease or application
CHAR(10) no
unique_l
Record number (possible values are 1 to 5)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
d_ins_s
Insurance expiration date
DATE yes
d_pol_s
Insurance policy effective date
DATE yes
ins_typ_s
Insurance type
CHAR(4) yes
ins_stat_s
Insurance status
CHAR(4) yes
ins_car_s
Insurance carrier
CHAR(4) yes
ins_cov_s
Insurance coverage type
CHAR(4) yes
pol_num_s
Policy number
VARCHAR2(20) yes
ins_phn_s
Insurance agent phone
CHAR(10) yes
payee_s
Loss payee
VARCHAR2(36) yes
ag_nam_s
Agent name
VARCHAR2(36) yes
ag_add_s
Agent address
VARCHAR2(36) yes
ag_add2_s
Agent address 2
VARCHAR2(36) yes
ag_cty_s
Agent city
VARCHAR2(25) yes
ag_st_s
Agent state
CHAR(2) yes
ag_zip_s
Agent zip code
CHAR(9) yes
ag_cont_nam_s
Agent contact name
VARCHAR2(36) yes
ag_cont_title_s
Agent contact title
VARCHAR2(25) yes
loss_amt_d
Amount to loss payee
NUMBER(15,2) yes
ins_phn_ext_s
Insurance agent phone extension
CHAR(4) yes
ins_car_nam_s
Insurance carrier name
VARCHAR2(36) yes