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 |