GM_MILE_NOTI_VW

(SQL View)
 Index Back

Milestone Notification history

Last milestone notification

SELECT A.CONTRACT_NUM , A.BUSINESS_UNIT , A.MILESTONE_ID , MAX(A.LAST_SEQ_NBR) FROM %Table(GM_MILE_HISTORY) A GROUP BY A.CONTRACT_NUM , A.BUSINESS_UNIT , A.MILESTONE_ID

  • Parent record: GM_AWD_MILE

    • # 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