| Description | Column | Datatype |
|---|---|---|
| Lease | lse_s | char (10) |
| Operator initials | opr_s | char (3) |
| Date entered tracking | d_enter_trk_s | datetime |
| 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 |
| Note type
For unprocessed notes, note type must start with: A - Application M - Maturing Lease C - Collection K - Collateral S - Customer Service |
note_type_s | char (4) |
| Index name | Piece 1 | Piece 2 | Piece 3 |
|---|---|---|---|
| mws_idx0 | opr_s | lse_s | note_type_s |
| mws_idx1 | lse_s | note_type_s |