PA_PRIOR_PLAN (SQL Table)	Index Back
Prior Plan Data This is an employee table containing minimum benefit information for the prior plan.

PA_PRIOR_PLAN

(SQL Table)

Prior Plan Data

This is an employee table containing minimum benefit information for the prior plan.

# 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
Prompt Table: PA_PLAN_VW

3 BEN_AMT Number(16,6) DECIMAL(15,6) NOT NULL Benefit Amount

4 SERVICE_AMOUNT Number(16,6) DECIMAL(15,6) NOT NULL Minimum Service Amount used in Service Purchase configuration.

5 PART_STATUS Character(1) VARCHAR2(1) NOT NULL Participation Status
N=Not Participating
Y=Participating
Y/N Table Edit

#	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 Prompt Table: PA_PLAN_VW
3	BEN_AMT	Number(16,6)	DECIMAL(15,6) NOT NULL	Benefit Amount
4	SERVICE_AMOUNT	Number(16,6)	DECIMAL(15,6) NOT NULL	Minimum Service Amount used in Service Purchase configuration.
5	PART_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Participation Status N=Not Participating Y=Participating Y/N Table Edit