mwi Table: Insurance Work Schedule
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

mwi Table: Insurance Work Schedule

Indexes

Name Segment 1 Segment 2
mwi_idx0 opr_s lse_s
mwi_idx1 lse_s  


Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
opr_s
Operator initials
d_enter_trk_s
Date entered tracking
when_asgn_c
When the clerk was assigned (I/A/M)
  I - Initial assignment
  A - Auto reassignment
how_asgn_c
How the clerk was assigned
team_asgn_s
Team from which the clerk was chosen
  Must be entered if how_asgn_c = (P, C, R, O, K, or L)
policy_num_s
Insurance policy number
d_ins_exp_s
Insurance expiration date
ins_cov_s
Insurance coverage type
dt_fol_s
Follow-up date and time
prio_c
Priority flag (1/2/3/4)
  1 - Lowest priority
  4 - Highest priority
note_title_s
Title of the note
Record modification stamp