W3EB_INSJOB_VW (SQL View)	Index Back
EE Savings Plan Beneficiaries SAVINGS_BENEFIC is a record which identifies the beneficiaries associated with the savings plan that a participant has been enrolled. It is populated in the Base benefits system using the savings_plan3 panel within the Benefits Window or by the BASEMLOD/BASOELOD load processes of the Benefits Administration product. There can be multiple dependent records per savings plan per employee.

W3EB_INSJOB_VW

(SQL View)

EE Savings Plan Beneficiaries

SAVINGS_BENEFIC is a record which identifies the beneficiaries associated with the savings plan that a participant has been enrolled. It is populated in the Base benefits system using the savings_plan3 panel within the Benefits Window or by the BASEMLOD/BASOELOD load processes of the Benefits Administration product. There can be multiple dependent records per savings plan per employee.

SELECT a.EMPLID , a.EMPL_RCD , a.PLAN_TYPE , a.BENEFIT_NBR , a.EFFDT , b.DESCR FROM PS_LIFE_ADD_BEN a , PS_PRIMARY_JOBS c , PS_JOB d , PS_JOBCODE_TBL b WHERE a.EFFDT = ( SELECT MAX(a1.EFFDT) FROM PS_LIFE_ADD_BEN a1 WHERE a1.EMPLID = a.EMPLID AND a1.EMPL_RCD = a.EMPL_RCD AND a1.PLAN_TYPE = a.PLAN_TYPE AND a1.BENEFIT_NBR = a.BENEFIT_NBR AND a1.EFFDT <= %CurrentDateIn) AND c.EMPLID = a.EMPLID AND c.EMPL_RCD = a.EMPL_RCD AND c.PRIMARY_JOB_IND = 'Y' AND c.PRIMARY_JOB_APP = 'BN' AND c.EFFDT = ( SELECT MAX(c1.EFFDT) FROM PS_PRIMARY_JOBS c1 WHERE c1.EMPLID = c.EMPLID AND c1.PRIMARY_JOB_APP = c.PRIMARY_JOB_APP AND c1.EMPL_RCD = c.EMPL_RCD AND c1.EFFDT <= %CurrentDateIn) AND d.EMPLID = a.EMPLID AND d.EMPL_RCD = a.EMPL_RCD AND d.EFFDT = ( SELECT MAX(d1.EFFDT) FROM PS_JOB d1 WHERE d1.EMPLID = d.EMPLID AND d1.EMPL_RCD = d.EMPL_RCD AND d1.EFFDT <= %CurrentDateIn) AND d.EFFSEQ = ( SELECT MAX(d2.EFFSEQ) FROM PS_JOB d2 WHERE d2.EMPLID = d.EMPLID AND d2.EFFDT = d.EFFDT AND d2.EMPL_RCD = d.EMPL_RCD) AND b.SETID = d.SETID_JOBCODE AND b.JOBCODE = d.JOBCODE AND b.EFFDT = ( SELECT MAX(b1.EFFDT) FROM PS_JOBCODE_TBL b1 WHERE b1.SETID = b.SETID AND b1.JOBCODE = b.JOBCODE AND b1.EFFDT <= %CurrentDateIn)

Parent record: SAVINGS_PLAN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 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.
Default Value: 40

4 BENEFIT_NBR Number(3,0) SMALLINT NOT NULL Note! Although this field is part of the index schema for most Base Benefits enrollment-related records, it was in fact never functionally implemented. As such, it is CRITICAL that this field always be set to zero 0.

5 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: SAVINGS_PLAN.COVERAGE_BEGIN_DT

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: PER_ORG_ASGN_VW
3	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. Default Value: 40
4	BENEFIT_NBR	Number(3,0)	SMALLINT NOT NULL	Note! Although this field is part of the index schema for most Base Benefits enrollment-related records, it was in fact never functionally implemented. As such, it is CRITICAL that this field always be set to zero 0.
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: SAVINGS_PLAN.COVERAGE_BEGIN_DT
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description