LeasePak 5.1a Database Reference (Sybase)

rdmi Table: Demographic Insurance

Description	Column	Datatype
Lease or application	app_lse_s	char (10)
Record number	unique_l	integer
Sybase timestamp	timestamp	timestamp
Insurance expiration date	d_ins_s	datetime
Insurance policy effective date	d_pol_s	datetime
Insurance type	ins_typ_s	char (4)
Insurance status	ins_stat_s	char (4)
Insurance carrier	ins_car_s	char (4)
Insurance coverage type	ins_cov_s	char (4)
Policy number	pol_num_s	char (20)
Insurance agent phone	ins_phn_s	char (10)
Loss payee	payee_s	char (36)
Agent name	ag_nam_s	char (36)
Agent address	ag_add_s	char (36)
Agent address 2	ag_add2_s	char (36)
Agent city	ag_cty_s	char (25)
Agent state	ag_st_s	char (2)
Agent zip code	ag_zip_s	char (9)
Agent contact name	ag_cont_nam_s	char (36)
Agent contact title	ag_cont_title_s	char (25)
Amount to loss payee	loss_amt_d	double precision
Insurance agent phone extension	ins_phn_ext_s	char (4)
Insurance carrier name	ins_car_nam_s	char (36)

Index name	Piece 1	Piece 2
rdmi_idx0	app_lse_s	unique_l