BEN_PROG_CUR_VW (SQL View)	Index Back
EE Benefit Programs BEN_PROG_PARTIC is a record that defines the benefit program for which an employee is enrolled. It is used while processing Payroll and Benefits Administration.

BEN_PROG_CUR_VW

(SQL View)

EE Benefit Programs

BEN_PROG_PARTIC is a record that defines the benefit program for which an employee is enrolled. It is used while processing Payroll and Benefits Administration.

SELECT B.EMPLID ,B.EMPL_RCD ,B.COBRA_EVENT_ID ,B.EFFDT ,B.BENEFIT_PROGRAM FROM PS_BEN_PROG_PARTIC B WHERE B.EFFDT= ( SELECT MAX(B1.EFFDT) FROM PS_BEN_PROG_PARTIC B1 WHERE B1.EMPLID=B.EMPLID AND B1.EMPL_RCD=B.EMPL_RCD AND B1.COBRA_EVENT_ID=B.COBRA_EVENT_ID AND B1.EFFDT<=%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: NEW
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
Prompt Table: PER_ORG_ASGN_VW

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

5 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
Prompt Table: BEN_DEFN_PGM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: PER_ORG_ASGN_VW
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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules. Prompt Table: BEN_DEFN_PGM