COBRA_EVENT

(SQL Table)
 Index Back

COBRA Event Table

COBRA_Event is a record that is created when a COBRA_Activity record has been processed by the qualification phase of the COBRA Administration COBOL program. It includes the COBRA event class, the date of the COBRA event and statuses that indicate whether or not the COBRA Activity was a qualified event.

  • Parent Record Of CBR_PARTIC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
    3 COBRA_EVENT_ID Number(3,0) SMALLINT NOT NULL Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.
    4 COBRA_EVENT_DT Date(10) DATE COBRA Event Date
    5 COBRA_EVENT_CLASS Character(3) VARCHAR2(3) NOT NULL COBRA Event Classification
    6 SCHED_ID Character(6) VARCHAR2(6) NOT NULL Schedule ID
    7 EVENT_ID Number(6,0) INTEGER NOT NULL Event Identification
    8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    9 CBR_ACTION_SOURCE Character(1) VARCHAR2(1) NOT NULL COBRA Action Source
    B=Benefits Administration
    D=Dependent Benef Change
    J=Job Data Change
    M=Manual Event
    O=Overage Process
    P=Personal Data Change
    10 CBR_QUALIFY_STATUS Character(2) VARCHAR2(2) NOT NULL COBRA Qualify Status
    NQ=Not COBRA Qualified
    QE=COBRA Qualify Error
    QL=COBRA Qualified
    QP=Qualify Pending
    UN=Unprocessed
    11 CBR_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL COBRA Process Status
    C=Closed for Processing
    O=Open for Processing
    V=Void
    12 BAS_DATA_CHG Character(1) VARCHAR2(1) NOT NULL BAS Data Change

    Y/N Table Edit

    13 CBR_EVENT_CONFLICT Character(1) VARCHAR2(1) NOT NULL COBRA Event Conflict

    Y/N Table Edit

    14 CBR_EVT_REPRCS_IND Character(1) VARCHAR2(1) NOT NULL COBRA Event Reprocess Indicatr
    N=Normal Processing
    P=Prepare Options
    Q=Qualify Event
    V=Void Event
    15 CBR_COV_OVERRIDE Character(1) VARCHAR2(1) NOT NULL COBRA Coverage Override

    Default Value: N

    16 CBR_ALT_COV_TRM_DT Date(10) DATE COBRA Alt Covg Termination Dt
    17 CBR_COV_AS_OF_DT Date(10) DATE COBRA Covg As Of Dt
    18 CBR_UAVL_NOTIFY_DT Date(10) DATE COBRA Unavailable Notify Dt
    19 CBR_UAVL_PRINT_DT Date(10) DATE COBRA Unavailable Print Dt