LeasePak 5.1a Database Reference (Sybase)

mwi Table: Insurance Work Schedule

Description	Column	Datatype
Lease	lse_s	char (10)
Operator initials	opr_s	char (3)
Date entered tracking	d_enter_trk_s	datetime
When the clerk was assigned (I/A/M) I - Initial assignment A - Auto reassignment	when_asgn_c	char (1)
How the clerk was assigned	how_asgn_c	char (1)
Team from which the clerk was chosen Must be entered if how_asgn_c = (P, C, R, O, K, or L)	team_asgn_s	char (4)
Insurance policy number	policy_num_s	char (20)
Insurance expiration date	d_ins_exp_s	datetime
Insurance coverage type	ins_cov_s	char (4)
Follow-up date and time	dt_fol_s	datetime
Priority flag (1/2/3/4) 1 - Lowest priority 4 - Highest priority	prio_c	char (1)
Title of the note	note_title_s	char (41)
Sybase timestamp	timestamp	timestamp

Index name	Piece 1	Piece 2
mwi_idx0	opr_s	lse_s
mwi_idx1	lse_s