mwc Table: Collection Work Schedule
LeasePak Documentation Suite NETSOL website
Home Search Help
LeasePak Database Objects
Return to Top

Database Reference

mwc Table: Collection Work Schedule

Indexes

Name Segment 1 Segment 2
mwc_idx0 opr_s les_s
mwc_idx1 les_s  
mwc_idx2 queue_s les_s


Columns
Name DescriptionDatatype ¿? Allow Null
les_s 
Lessee number
opr_s 
Operator initials
d_enter_trk_s 
Date entered tracking
col_stat_s 
Collection status
auto_reasgn_c 
Automatic-reassignment (X/' ')
ref_amt_d 
Reference amount
when_asgn_c 
When the clerk was assigned (I/A/M)
  I - Initial assignment
  A - Auto reassignment
how_asgn_c 
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
team_asgn_s 
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
num_delq_l 
Number of delinquent leases
days_delq_l 
Highest number of days delinquent
dt_fol_s 
Follow-up date and time
prio_c 
Priority flag (1/2/3/4)
  1 - Lowest priority
  4 - Highest priority
note_title_s 
Title of the note
 
Record modification stamp
les_weight_l 
Lessee weight
queue_s 
Queue number
locked_c 
Record locked (Y/N)
ws_excl_c 
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
acct_bhv_scr_s 
Account behavior score