CBR_PAR_PLN_VW1 (SQL View)	Index Back
CBR Partic Pln Data Entry View CBR_Par_Pln_Vw1 is a view based on the CBR_Partic_Plan record. It is used in the COBRA data entry panel. It selects those plan records associated with initial events that are open for processing and for which a COBRA enrollment has not occurred.

CBR_PAR_PLN_VW1

(SQL View)

CBR Partic Pln Data Entry View

CBR_Par_Pln_Vw1 is a view based on the CBR_Partic_Plan record. It is used in the COBRA data entry panel. It selects those plan records associated with initial events that are open for processing and for which a COBRA enrollment has not occurred.

SELECT EMPLID , BENEFIT_RCD_NBR , COBRA_EVENT_ID , DEPENDENT_BENEF , PLAN_TYPE , BENEFIT_PROGRAM , COBRA_EVENT_DT , COVERAGE_BEGIN_DT , DISABL_CVG_BEG_DT , COVERAGE_END_DT , COBRA_ELECT_END_DT , COBRA_ELECT , COBRA_ELECT_DT , COBRA_WAIVE_DT , COBRA_REVOKE_DT , OPTION_CD , BENEFIT_PLAN , COVRG_CD , HLTH_PROVIDER_ID , PREVIOUSLY_SEEN FROM PS_CBR_PARTIC_PLAN WHERE CBR_PROCESS_STATUS = 'O' AND CBR_ENROLL_STATUS = 'N' AND COBRA_EVENT_TYPE = 'I'

# 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 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

5 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.

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

7 COBRA_EVENT_DT Date(10) DATE COBRA Event Date

8 COVERAGE_BEGIN_DT Date(10) DATE Coverage Begin Date

9 DISABL_CVG_BEG_DT Date(10) DATE Disabled Coverage Begin Date

10 COVERAGE_END_DT Date(10) DATE Coverage End Date

11 COBRA_ELECT_END_DT Date(10) DATE COBRA Election Period End Date

12 COBRA_ELECT Character(1) VARCHAR2(1) NOT NULL COBRA Election
E=Elect
W=Waive

13 COBRA_ELECT_DT Date(10) DATE COBRA Election Date

14 COBRA_WAIVE_DT Date(10) DATE COBRA Waive Date

15 COBRA_REVOKE_DT Date(10) DATE COBRA Revoke Date

16 OPTION_CD Character(3) VARCHAR2(3) NOT NULL Option Code
Prompt Table: CBR_OPTNCD_VW

17 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

18 COVRG_CD Character(2) VARCHAR2(2) NOT NULL Coverage Code
Prompt Table: COVRG_CD_TBL

19 HLTH_PROVIDER_ID Character(30) VARCHAR2(30) NOT NULL Health Provider ID

20 PREVIOUSLY_SEEN Character(1) VARCHAR2(1) NOT NULL Previously Seen
Y/N Table Edit

#	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	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
5	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
6	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
7	COBRA_EVENT_DT	Date(10)	DATE	COBRA Event Date
8	COVERAGE_BEGIN_DT	Date(10)	DATE	Coverage Begin Date
9	DISABL_CVG_BEG_DT	Date(10)	DATE	Disabled Coverage Begin Date
10	COVERAGE_END_DT	Date(10)	DATE	Coverage End Date
11	COBRA_ELECT_END_DT	Date(10)	DATE	COBRA Election Period End Date
12	COBRA_ELECT	Character(1)	VARCHAR2(1) NOT NULL	COBRA Election E=Elect W=Waive
13	COBRA_ELECT_DT	Date(10)	DATE	COBRA Election Date
14	COBRA_WAIVE_DT	Date(10)	DATE	COBRA Waive Date
15	COBRA_REVOKE_DT	Date(10)	DATE	COBRA Revoke Date
16	OPTION_CD	Character(3)	VARCHAR2(3) NOT NULL	Option Code Prompt Table: CBR_OPTNCD_VW
17	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
18	COVRG_CD	Character(2)	VARCHAR2(2) NOT NULL	Coverage Code Prompt Table: COVRG_CD_TBL
19	HLTH_PROVIDER_ID	Character(30)	VARCHAR2(30) NOT NULL	Health Provider ID
20	PREVIOUSLY_SEEN	Character(1)	VARCHAR2(1) NOT NULL	Previously Seen Y/N Table Edit