COBRA_RUNCTL (SQL Table)	Index Back
COBRA Run Control COBRA_Runctl is a record used by the COBRA Administration COBOL program. This run control must be set up to trigger processing. This record is created on-line by the COBRA Administration Run Control panel.

COBRA_RUNCTL

(SQL Table)

COBRA Run Control

COBRA_Runctl is a record used by the COBRA Administration COBOL program. This run control must be set up to trigger processing. This record is created on-line by the COBRA Administration Run Control panel.

# 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 PROCESS_DT Date(10) DATE NOT NULL Process Date
Default Value: %date

4 CHKPT_INTERVAL Number(5,2) DECIMAL(4,2) NOT NULL Chk Point Interval in Minutes

5 COBRA_PHASE Character(1) VARCHAR2(1) NOT NULL COBRA Processing Phase
A=Processing Cobra Activity
C=Processing Completed
O=Processing Overage Dependents
P=Processing Cobra Participants
Q=Qualifying Events
R=Ready for Processing
Default Value: R

6 OVERAGE_PROCESS Character(1) VARCHAR2(1) NOT NULL Process Overage Dependents
Y/N Table Edit
Default Value: Y

7 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.

8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

9 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

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

11 COBRA_EVENT_DT Date(10) DATE COBRA Event Date

12 COBRA_EVENT_ID Number(3,0) SMALLINT NOT NULL Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.

13 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

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

#	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	PROCESS_DT	Date(10)	DATE NOT NULL	Process Date Default Value: %date
4	CHKPT_INTERVAL	Number(5,2)	DECIMAL(4,2) NOT NULL	Chk Point Interval in Minutes
5	COBRA_PHASE	Character(1)	VARCHAR2(1) NOT NULL	COBRA Processing Phase A=Processing Cobra Activity C=Processing Completed O=Processing Overage Dependents P=Processing Cobra Participants Q=Qualifying Events R=Ready for Processing Default Value: R
6	OVERAGE_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	Process Overage Dependents Y/N Table Edit Default Value: Y
7	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
10	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.
11	COBRA_EVENT_DT	Date(10)	DATE	COBRA Event Date
12	COBRA_EVENT_ID	Number(3,0)	SMALLINT NOT NULL	Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.
13	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
14	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.