COBRA_ACTIVITY (SQL Table)	Index Back
COBRA Activity Table COBRA_Activity is a record that acts as a repository of COBRA triggers generated by a predefined set of changes that have been made to the employee's HR data. These data changes have potential COBRA qualifying events associated with them. This record is created by Base Benefit online peoplecode, Benefits Administration Event Maintenance and by the overage processing of the COBRA Administration product.

COBRA_ACTIVITY

(SQL Table)

COBRA Activity Table

COBRA_Activity is a record that acts as a repository of COBRA triggers generated by a predefined set of changes that have been made to the employee's HR data. These data changes have potential COBRA qualifying events associated with them. This record is created by Base Benefit online peoplecode, Benefits Administration Event Maintenance and by the overage processing of the COBRA Administration product.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: CBR_ACT_EMPL_VW

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 COBRA_EVENT_DT Date(10) DATE NOT NULL COBRA Event Date
Default Value: %DATE

4 COBRA_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.
Prompt Table: CBR_MAN_EVT_VW

5 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
Default Value: M

6 SCHED_ID Character(6) VARCHAR2(6) NOT NULL Schedule ID

7 EVENT_ID Number(6,0) INTEGER NOT NULL Event Identification

8 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.

9 CBR_COV_OVERRIDE Character(1) VARCHAR2(1) NOT NULL COBRA Coverage Override
Y/N Table Edit
Default Value: N

10 CBR_ALT_COV_TRM_DT Date(10) DATE COBRA Alt Cov Termination Date

11 CBR_COV_AS_OF_DT Date(10) DATE COBRA Covg As Of Dt

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: CBR_ACT_EMPL_VW
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	COBRA_EVENT_DT	Date(10)	DATE NOT NULL	COBRA Event Date Default Value: %DATE
4	COBRA_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only. Prompt Table: CBR_MAN_EVT_VW
5	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 Default Value: M
6	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID
7	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification
8	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.
9	CBR_COV_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	COBRA Coverage Override Y/N Table Edit Default Value: N
10	CBR_ALT_COV_TRM_DT	Date(10)	DATE	COBRA Alt Cov Termination Date
11	CBR_COV_AS_OF_DT	Date(10)	DATE	COBRA Covg As Of Dt