LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

mwm Table: Maturing Lease Work Schedule

Description Column Datatype
Lease lse_s char (10)
Operator initials opr_s char (3)
Date entered tracking d_enter_trk_s datetime
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 team
  C - Company team
  R - Region team
  O - Office team
  K - Customer team
  L - Lessee team
  S - Supervisor
  M - Manual
how_asgn_c char (1)
Team from which the clerk was chosen
  Must be entered if how_asgn_c = (P, C, R, O, K, or L)
team_asgn_s char (4)
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

mwm Indexes:

Index name Piece 1 Piece 2
mwm_idx0 opr_s lse_s
mwm_idx1 lse_s


HomeTableIndexes