AGC_TMPL_NOT_VW

(SQL View)
 Index Back

AGC Template Table

Activity Guide Composer Template Category view

SELECT AGC_CATEGORY_ID ,AGC_TEMPLATE_ID ,DESCR100 FROM PS_AGC_TMPL_TBL A WHERE EFFDT = ( SELECT MAX(EFFDT) FROM PS_AGC_TMPL_TBL A1 WHERE A1.AGC_TEMPLATE_ID = A.AGC_TEMPLATE_ID AND A1.EFFDT <= %CurrentDateIn) AND AGC_ACTIVE_FLAG = 'Y' AND AGC_NOTIF_ENABLED = 'Y'

  • Related Language Record: AGC_TMPL_CAT_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGC_CATEGORY_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Category

    Prompt Table: AGC_CAT_TBL

    2 AGC_TEMPLATE_ID Character(7) VARCHAR2(7) NOT NULL Activity Guide Composer Template Id
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description