| Description | Column | Datatype |
|---|---|---|
| Lessee number | les_s | char (9) |
| Operator initials | opr_s | char (3) |
| Date entered tracking | d_enter_trk_s | datetime |
| Collection status | col_stat_s | char (4) |
| Automatic-reassignment (X/' ') | auto_reasgn_c | char (1) |
| Reference amount | ref_amt_d | double precision |
| 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 collection team C - Company collection team R - Region collection team O - Office collection team K - Customer collection team L - Lessee collection team S - Supervisor M - Manual |
how_asgn_c | char (1) |
| Team from which collector was assigned
P - Portfolio collection team C - Company collection team R - Region collection team O - Office collection team K - Customer collection team L - Lessee collection team S - Supervisor M - Manual |
team_asgn_s | char (4) |
| Number of delinquent leases | num_delq_l | integer |
| Highest number of days delinquent | days_delq_l | integer |
| 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 |
| Lessee weight | les_weight_l | integer |
| Queue number | queue_s | char (4) |
| Record locked (Y/N) | locked_c | char (1) |
| Exclude from Work Schedule
@ - Do not exclude A - Exclude due to collection status B - Exclude due to bankruptcy status C - Exclude due to collection & bankruptcy status |
ws_excl_c | char (1) |
| Account behavior score | acct_bhv_scr_s | char (8) |
| Index name | Piece 1 | Piece 2 |
|---|---|---|
| mwc_idx0 | opr_s | les_s |
| mwc_idx1 | les_s | |
| mwc_idx2 | queue_s | les_s |