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

Database Reference

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
unique_l
Record number (possible values are 1 to 5)
Record modification stamp
d_ins_s
Insurance expiration date
d_pol_s
Insurance policy effective date
ins_typ_s
Insurance type
ins_stat_s
Insurance status
ins_car_s
Insurance carrier
ins_cov_s
Insurance coverage type
pol_num_s
Policy number
ins_phn_s
Insurance agent phone
payee_s
Loss payee
ag_nam_s
Agent name
ag_add_s
Agent address
ag_add2_s
Agent address 2
ag_cty_s
Agent city
ag_st_s
Agent state
ag_zip_s
Agent zip code
ag_cont_nam_s
Agent contact name
ag_cont_title_s
Agent contact title
loss_amt_d
Amount to loss payee
ins_phn_ext_s
Insurance agent phone extension
ins_car_nam_s
Insurance carrier name