mwm Table: Maturing Lease Work Schedule
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

mwm Table: Maturing Lease Work Schedule

Indexes

Name Segment 1 Segment 2
mwm_idx0 opr_s lse_s
mwm_idx1 lse_s  

   
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
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 team
  C - Company team
  R - Region team
  O - Office team
  K - Customer team
  L - Lessee 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
timestamp
Record modification stamp
timestamp yes