W3EB_LE_TMPLFLV

(SQL View)
 Index Back

Template List

Flid Life Event Template View of record - W3EB_LE_LIST

SELECT A.LE_TEMPLATE_ID , B.LANGUAGE_CD ,B.DESCR100 FROM PS_W3EB_LE_LIST A , PS_AGC_TMPL_LNG B WHERE A.LE_ACTIVE_FLG = 'Y' AND A.LE_IS_FLUID ='Y' AND A.LE_TEMPLATE_ID=B.AGC_TEMPLATE_ID AND B.EFFDT= ( SELECT MAX(C.EFFDT) FROM PS_AGC_TMPL_LNG C WHERE B.AGC_TEMPLATE_ID = C.AGC_TEMPLATE_ID AND B.LANGUAGE_CD =C.LANGUAGE_CD AND C.EFFDT <= %CurrentDateIn )

  • Related Language Record for W3EB_LE_TMPLFVW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description