W3EB_LE_TMPLFVW

(SQL View)
 Index Back

Template List

Flid Life Event Template View of record - W3EB_LE_LIST

SELECT A.LE_TEMPLATE_ID ,B.DESCR100 ,LE_IS_FLUID FROM PS_W3EB_LE_LIST A , PS_AGC_TMPL_TBL 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_TBL C WHERE B.AGC_TEMPLATE_ID = C.AGC_TEMPLATE_ID AND C.EFFDT <= %CurrentDateIn)

  • Related Language Record: W3EB_LE_TMPLFLV

    • # 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 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    3 LE_IS_FLUID Character(1) VARCHAR2(1) NOT NULL Action Item Fluid flag.
    N=Classic
    Y=Is Fluid