BEN_PRG_PRTC_VW (SQL View)	Index Back
Vw on BEN_PROG_PARTIC This view has been created on BEN_PROG_PARTIC to get data for payroll processing. The field COBRA_EVENT_ID would have a value of zero for payroll considerations; also the key structure needs to have EMPL_RCD# as the last key field before EFFDT. The view therefore has been created to meet these requirements.

BEN_PRG_PRTC_VW

(SQL View)

Vw on BEN_PROG_PARTIC

This view has been created on BEN_PROG_PARTIC to get data for payroll processing. The field COBRA_EVENT_ID would have a value of zero for payroll considerations; also the key structure needs to have EMPL_RCD# as the last key field before EFFDT. The view therefore has been created to meet these requirements.

select A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.BENEFIT_PROGRAM from PS_BEN_PROG_PARTIC A where A.COBRA_EVENT_ID=0

# 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

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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