CBR_PAR_SRCH1 (SQL View)	Index Back
COBRA Partic Search Record 1 COBRA Partic Search Record implements Departmental Security. It is used as a search record on the Election Data Entry Panels.

CBR_PAR_SRCH1

(SQL View)

COBRA Partic Search Record 1

COBRA Partic Search Record implements Departmental Security. It is used as a search record on the Election Data Entry Panels.

SELECT SEC.OPRID , SEC.EMPLID ,H.BENEFIT_RCD_NBR ,J.COBRA_EVENT_ID ,J.DEPENDENT_BENEF ,SEC.NAME ,SEC.LAST_NAME_SRCH FROM PS_EMPLMT_SRCH_GBL SEC ,PS_COBRA_EVENT H ,PS_CBR_PARTIC J WHERE SEC.EMPLID=H.EMPLID AND SEC.EMPL_RCD=H.EMPL_RCD AND H.EMPLID = J.EMPLID AND H.BENEFIT_RCD_NBR = J.BENEFIT_RCD_NBR AND H.COBRA_EVENT_ID = J.COBRA_EVENT_ID AND J.CBR_PROCESS_STATUS = 'O' AND J.CBR_INIT_EVENT_STS IN ('EE' , 'ER' , 'ET' , 'NT' , 'OP' , 'EC')

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

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

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

6 NAME Character(50) VARCHAR2(50) NOT NULL Name

7 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	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.
4	COBRA_EVENT_ID	Number(3,0)	SMALLINT NOT NULL	Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.
5	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
6	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
7	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name