PA_PLAN_DT_TBL (SQL Table)	Index Back
Plan Dates by emp/plan/effdt This is an employee table containing important plan dates for each employee.

PA_PLAN_DT_TBL

(SQL Table)

Plan Dates by emp/plan/effdt

This is an employee table containing important plan dates for each employee.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

3 EFFDT Date(10) DATE Effective Date

4 CURR_ELIG_DT Date(10) DATE Current Eligibility

5 CURR_PRTC_DT Date(10) DATE Current Participation Date

6 ERLY_RET_RED_DT Date(10) DATE Early Ret Date - Reduced

7 NORM_RET_DT Date(10) DATE Normal Retirement Date

8 VESTING_DT Date(10) DATE Date of First Vesting

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
3	EFFDT	Date(10)	DATE	Effective Date
4	CURR_ELIG_DT	Date(10)	DATE	Current Eligibility
5	CURR_PRTC_DT	Date(10)	DATE	Current Participation Date
6	ERLY_RET_RED_DT	Date(10)	DATE	Early Ret Date - Reduced
7	NORM_RET_DT	Date(10)	DATE	Normal Retirement Date
8	VESTING_DT	Date(10)	DATE	Date of First Vesting