| 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 (P/C/R/O/K/L/S/M)
P - Portfolio team C - Company team R - Region team O - Office team K - Customer team L - Lessee team S - Supervisor M - Manual |
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) |
| 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 |
|---|---|---|
| mwm_idx0 | opr_s | lse_s |
| mwm_idx1 | lse_s |