CBR_EVENT_RULES

(SQL Table)
 Index Back

COBRA Event Rules

CBR_Event_Rules is a record that defines the rules that regulate the various COBRA event classifications. These rules include length of coverage, the COBRA period calculation method, the secondary event aspects of the COBRA event class and whether the COBRA surcharges are waived for this event class. These rules are used by the COBOL job of the COBRA Administration product to qualify and process COBRA events.

  • Related Language Record: CBR_EVENT_R_LNG

  • Parent Record Of CBR_EVENT_BENEF UPG_CBR_EVT_BNF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COBRA_EVENT_CLASS Character(3) VARCHAR2(3) NOT NULL COBRA Event Classification
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 MM_COVERAGE Number(2,0) SMALLINT NOT NULL Months of Coverage
    7 ADDL_MM_DISABLED Number(2,0) SMALLINT NOT NULL Additional Months if Disabled
    8 COBRA_PD_BEGINS_CD Character(1) VARCHAR2(1) NOT NULL COBRA Period Begins
    E=On the Event Date
    M=On Month-Begin After Event Dt
    P=On Pay Pd Begin after Event Dt

    Default Value: E

    9 USE_BAS_EVENT_RULE Character(1) VARCHAR2(1) NOT NULL Use BenAdmin Event Rules

    Y/N Table Edit

    Default Value: Y

    10 INCL_ALT_COVRG Character(1) VARCHAR2(1) NOT NULL Include Alternative Coverage

    Y/N Table Edit

    Default Value: Y

    11 EVENT_NOTIFY_DAYS Number(2,0) SMALLINT NOT NULL Days to Notify of Event
    12 RESPONSE_DAYS Number(2,0) SMALLINT NOT NULL Response Days Allowed
    13 PAYMENT_GRACE_DAYS Number(2,0) SMALLINT NOT NULL Payment Grace Days
    14 WAIVE_COBRA_SURCHG Character(1) VARCHAR2(1) NOT NULL Waive COBRA Surcharge

    Y/N Table Edit

    Default Value: N

    15 SECOND_EVENT_ROLE Character(1) VARCHAR2(1) NOT NULL Secondary Event Role
    P=Preceeding Initial Event
    S=Succeeding Second Event
    16 SECOND_EVENT_MONTH Number(2,0) SMALLINT NOT NULL Second Event Additional Months
    17 SECOND_EVENT_MODE Character(1) VARCHAR2(1) NOT NULL Secondary Event Add Mode
    A=Add Additional Months Coverage
    E=Extend Initial Coverage
    N=No Action
    18 BENEFIT_LOST_LEVEL Character(1) VARCHAR2(1) NOT NULL Benefit Lost Level
    D=Dependent
    E=Employee
    19 MANUAL_EVT_ALLOWED Character(1) VARCHAR2(1) NOT NULL Manual Events Allowed

    Y/N Table Edit

    Default Value: N