W3EB_LE_ELEM_VW

(SQL View)
 Index Back

Action Item - List

View of the PTAI_LIST

SELECT LE_TEMPLATE_DESC , LE_TEMPLATE_ID , LIFE_EVENT_TYPE , TEXT_ID , TEXT_ID2 FROM PS_W3EB_LE_LIST

  • Related Language Record: W3EB_LE_EL_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
    4 TEXT_ID Character(18) VARCHAR2(18) NOT NULL Text ID

    Prompt Table: W3EB_LE_TEXT_VW

    5 TEXT_ID2 Character(18) VARCHAR2(18) NOT NULL Text ID

    Prompt Table: W3EB_LE_TEXT_VW