W3EB_SMRY_CNTRL

(SQL Table)
 Index Back

Benefit Summary Controls

Record contains the control field values to generate the employee Benefit Summary. The summary will displayed onlne and available to print.

  • Parent Record Of W3EB_CNTRL_ELE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 PERSONAL_SECTION Character(1) VARCHAR2(1) NOT NULL Personal Information Section
    1=Hide the section
    2=Display the section

    Default Value: 2

    4 DEPEND_SEC Character(1) VARCHAR2(1) NOT NULL used to display the contol for dependent information section.
    1=Hide the section
    2=Hide when no dependent/benefic
    3=Display the section

    Default Value: 3

    5 DEP_BENE_SEC Character(1) VARCHAR2(1) NOT NULL Dependent and Beneficiary section
    1=Hide when no dep/benef enroll
    2=Display the section

    Default Value: 2

    6 INVESTMENT_SEC Character(1) VARCHAR2(1) NOT NULL Investment section
    1=Hide when no allocations
    2=Display the section

    Default Value: 2

    7 ENROLL Character(1) VARCHAR2(1) NOT NULL Enroll