W3EB_LE_TMPL_VW

(SQL View)
 Index Back

Template List

Classic Life Event Template View of record - W3EB_LE_LIST

SELECT LE_TEMPLATE_ID ,LE_TEMPLATE_DESC , LE_IS_FLUID , LIFE_EVENT_TYPE , TEXT_ID , TEXT_ID2 FROM PS_W3EB_LE_LIST WHERE LE_ACTIVE_FLG = 'Y' AND LE_IS_FLUID ='N'

  • Related Language Record: W3EB_LE_TMPL_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 LE_TEMPLATE_DESC Character(30) VARCHAR2(30) NOT NULL Title for the Life Event pagelet
    3 LE_IS_FLUID Character(1) VARCHAR2(1) NOT NULL Action Item Fluid flag.
    N=Classic
    Y=Is Fluid
    4 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
    5 TEXT_ID Character(18) VARCHAR2(18) NOT NULL Text ID

    Prompt Table: W3EB_LE_TEXT_VW

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

    Prompt Table: W3EB_LE_TEXT_VW