W3EB_LE_TEMP_VW

(SQL View)
 Index Back

Action Item - List

View of the PTAI_LIST

SELECT LE_TEMPLATE_DESC , LE_TEMPLATE_ID , LIFE_EVENT_TYPE FROM PS_W3EB_LE_LIST , PS_PTAI_LIST A WHERE LE_ACTIVE_FLG = 'Y' AND LE_TEMPLATE_ID = A.PTAI_LIST_ID AND A.PTAI_ACTIVE_FLG = 'Y' AND A.PTAI_LIST_ID IN ( SELECT B.PTAI_LIST_ID FROM PS_PTAI_ITEM B WHERE B.PTAI_LIST_ID = A.PTAI_LIST_ID)

  • Related Language Record: W3EB_LE_TP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LE_TEMPLATE_DESC Character(30) VARCHAR2(30) NOT NULL Title for the Life Event pagelet
    2 LE_TEMPLATE_ID Character(31) VARCHAR2(31) NOT NULL auto generated Template ID generated by Tools for the List
    3 LIFE_EVENT_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Life Event (e.g. Birth, Adoption, Marriage)
    A=Adoption
    B=Birth
    D=Divorce
    M=Marriage