mwc Table: Collection Work Schedule

Database Reference Sybase DBMS

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