W3EB_LE_LIST

(SQL Table)
 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.

  • Related Language Record: W3EB_LE_L2_LANG

  • Parent Record Of W3EB_LE_I2_LANG W3EB_LE_ITEM

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

    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