LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

mwk Table: Collateral Work Schedule

Description Column Datatype
Asset unit_s char (10)
Operator initials opr_s char (3)
Date entered tracking d_enter_trk_s date
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 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
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 timestamp (3)
Priority flag (1/2/3/4)
  1 - Lowest priority
  4 - Highest priority
prio_c char (1)
Title of the note note_title_s varchar2 (41)
Insurance and collateral calculation in EOP track_type_s char (4)
Oracle row stamp stamp_l number (10)

mwk Indexes:

Index name Piece 1 Piece 2
mwk_idx0 opr_s unit_s
mwk_idx1 unit_s


HomeTableIndexes