W3EB_LE_LIST_FL

(SQL View)
 Index Back

Life Event list table

This table track the Tools auto generated ListID and the associated life event type that was entered on the setup page.

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

  • Related Language Record: W3EB_LE_LFL_LNG

    • # 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

    Default Value: AA

    Prompt Table: W3EB_AGCTMPL_VW

    2 LE_ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Active Flag
    N=Inactive
    Y=Active

    Default Value: Y

    3 LE_TEMPLATE_DESC Character(30) VARCHAR2(30) NOT NULL Title for the Life Event pagelet
    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

    Prompt Table: W3EB_LE_RULES

    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

    7 LE_IS_FLUID Character(1) VARCHAR2(1) NOT NULL Action Item Fluid flag.
    N=Classic
    Y=Is Fluid

    Default Value: N

    8 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N