BAS_PASSIVE_EVT

(SQL Table)
Index Back

BAS Passive Event Definitions

BAS_PASSIVE_EVENT is used to define the conditions associated with each passive event.

  • Related Language Record: BAS_PSV_EVT_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PASSIVE_EVENT_ID Character(3) VARCHAR2(3) NOT NULL Passive Event ID
    2 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 PASSIVE_EVENT_USE Character(1) VARCHAR2(1) NOT NULL Passive Event Type
    B=Employee's Birthdate
    S=Employee's Service Date

    Default Value: B

    6 EVENT_CLASS Character(3) VARCHAR2(3) NOT NULL Event Classification

    Prompt Table: EVT_CLASS_VW

    7 COBRA_EVENT_CLASS Character(3) VARCHAR2(3) NOT NULL COBRA Event Classification

    Prompt Table: CBR_EVENT_RULES

    8 PASSIVE_EVENT_DD Number(3,0) SMALLINT NOT NULL Event Limit - Days
    9 PASSIVE_EVENT_MM Number(4,0) SMALLINT NOT NULL Event Limit - Months