BAS_ENR_EMPL

(SQL Table)
 Index Back

BAS Enr RunCtl-New Participant

BAS_ENR_EMPL is a record used by the Benefits Administration Enroll/COBOL program. This is a child record of the run control record, BAS_ENR_RUNCTL. It lists employees to Schedule during list processing. Update this record on-line with the Benefits Administration Important -- this record also used to run batch from the On Demand Event Maintenance panel (SQLExec INSERT People Code is used.) If RUN_CNTL_BEN record is changed, then SQLExec Insert People Code (BENEF_PB_WRK.ODEM_SCHED_ACTY_PB.SavePreChg) has to be modified.

  • Parent record: BAS_ENR_RUNCTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: BAS_ENR_EMPL_V1

    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    5 BAS_ACTION_SOURCE Character(2) VARCHAR2(2) NOT NULL Source of Action
    BP=Benefits Person
    EX=Multijob Trigger Explosion
    ME=Manual Event
    MJ=MultiJob Indicator Change
    OE=Open Enrollment
    PB=Passive Event Birthdate
    PS=Passive Event Service Date
    SN=Snapshot
    TJ=Job Data Change
    TL=Union Change
    TP=Address Change
    6 EVENT_DT Date(10) DATE Event Date
    7 EVENT_EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence of Event