| Description | Column | Datatype |
|---|---|---|
| Asset | unit_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 collateral team C - Company collateral team R - Region collateral team O - Office collateral team K - Customer collateral team L - Lessee collateral 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) |
| Insurance and collateral calculation in EOP | track_type_s | char (4) |
| Sybase timestamp | timestamp | timestamp |
| Index name | Piece 1 | Piece 2 |
|---|---|---|
| mwk_idx0 | opr_s | unit_s |
| mwk_idx1 | unit_s |