AGC_CAT_NOTF_VW

(SQL View)
 Index Back

AGC Category View

Activity Guide Composer Category View

SELECT DISTINCT PKG.AGC_CATEGORY_ID ,PKG.EFFDT ,PKG.DESCR50 FROM PS_AGC_CAT_TBL PKG WHERE PKG.EFFDT = ( SELECT MAX(PKG1.EFFDT) FROM PS_AGC_CAT_TBL PKG1 WHERE PKG1.AGC_CATEGORY_ID = PKG.AGC_CATEGORY_ID AND PKG1.EFFDT <= %CurrentDateIn) AND PKG.AGC_NOTIF_ENABLED = 'Y'

  • Related Language Record: AGC_CAT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGC_CATEGORY_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Category
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50