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

Database Reference Sybase 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)
integer no
timestamp
Record modification stamp
timestamp yes
d_ins_s
Insurance expiration date
datetime yes
d_pol_s
Insurance policy effective date
datetime 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
char(20) yes
ins_phn_s
Insurance agent phone
char(10) yes
payee_s
Loss payee
char(36) yes
ag_nam_s
Agent name
char(36) yes
ag_add_s
Agent address
char(36) yes
ag_add2_s
Agent address 2
char(36) yes
ag_cty_s
Agent city
char(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
char(36) yes
ag_cont_title_s
Agent contact title
char(25) yes
loss_amt_d
Amount to loss payee
double precision yes
ins_phn_ext_s
Insurance agent phone extension
char(4) yes
ins_car_nam_s
Insurance carrier name
char(36) yes