mwk Table: Collateral Work Schedule
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

mwk Table: Collateral Work Schedule

Indexes

Name Segment 1 Segment 2
mwk_idx0 opr_s unit_s
mwk_idx1 unit_s  

   
Columns
Name DescriptionDatatype ¿? Allow Null
unit_s
Asset
char(10) no
opr_s
Operator initials
char(3) no
d_enter_trk_s
Date entered tracking
datetime yes
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 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
char(1) no
team_asgn_s
Team from which the clerk was chosen
  Must be entered if how_asgn_c = (P, C, R, O, K, or L)
char(4) 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
track_type_s
Insurance and collateral calculation in EOP
char(4) yes
timestamp
Record modification stamp
timestamp yes