GM_MILE_HISTORY

(SQL Table)
Index Back

Milestone Notification history

  • Related Language Record: GM_MILE_HIS_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 MILESTONE_ID Character(6) VARCHAR2(6) NOT NULL Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
    4 LAST_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Last Sequence number in list
    5 NOTIFED_DTTM DateTime(26) TIMESTAMP The date and time a designated person was notified of a given position limit violation
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    7 NOTE Long Character(256) VARCHAR2(256) Note
    8 OPRID_FROM Character(30) VARCHAR2(30) NOT NULL A user's ID