GM_GUIDE_DESC_V

(SQL View)
 Index Back

Awards Terms and Conditions VW

GM Awards terms and Conditions description view for Award profile PTSF.

SELECT A.CONTRACT_NUM , A.BUSINESS_UNIT , A.PROJECT_ID , BUSINESS_UNIT_PC , A.GUIDE_ID , B.DESCR254 FROM PS_GM_AWD_TERMS A , PS_GM_AWD_GDLN_VW B WHERE ( A.GUIDE_ID = B.GUIDE_ID AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_GM_AWD_GDLN_VW B_ED WHERE B.SETID = B_ED.SETID AND B.GUIDE_ID = B_ED.GUIDE_ID AND B_ED.EFFDT <= %CurrentDateIn))

  • Related Language Record: GM_GUIDE_DES_LV

    • # 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 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    4 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    5 GUIDE_ID Character(5) VARCHAR2(5) NOT NULL Guideline ID

    Prompt Table: GM_GUIDELN_DTL

    6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254