W3EB_AGCTMPL_VW

(SQL View)
 Index Back

GDP Template List

View of the GDP AG Template and PTAI_LIST

SELECT A.AGC_TEMPLATE_ID ,A.EFFDT , A.DESCR100 ,A.DESCRLONG ,AGC_LIST_ID FROM PS_AGC_TMPL_TBL A WHERE A.AGC_ACTIVE_FLAG = 'Y' AND AGC_CATEGORY_ID='LIFEEVENT' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_AGC_TMPL_TBL B WHERE B.EFFDT <= %CurrentDateIn AND A.AGC_TEMPLATE_ID = B.AGC_TEMPLATE_ID)

  • Related Language Record: W3EB_AGCTMPL_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LE_TEMPLATE_ID Character(31) VARCHAR2(31) NOT NULL auto generated Template ID generated by Tools for the List
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    4 DESCRLONG Long Character CLOB Long Description
    5 AGC_LIST_ID Character(31) VARCHAR2(31) NOT NULL Activity Guide Composer List Id