PA_EA_SVC_PRCH (SQL Table)	Index Back
Employee Account Svc. History This is an employee table for Employee Account Service History.

PA_EA_SVC_PRCH

(SQL Table)

Employee Account Svc. History

This is an employee table for Employee Account Service History.

# 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 FUNCTN_RESULT_NM Character(10) VARCHAR2(10) NOT NULL Function Result Name

4 SERVICE_FR_NAME Character(10) VARCHAR2(10) NOT NULL Service Function Result.
Prompt Table: PA_DFN_SVC_VW

5 START_DATE Date(10) DATE Start Date for Gen Standing PO

6 END_DATE Date(10) DATE End Date

7 ACCUM_PERIOD Character(1) VARCHAR2(1) NOT NULL Accumulation Period
A=Employee's Anniversary Year
C=Calendar Year
M=Calendar Month
O=Other Year
P=Plan Year

8 PA_SVC_PRCHABLE Signed Number(11,6) DECIMAL(9,6) NOT NULL Purchasable Service

9 PA_SVC_PURCHASED Signed Number(11,6) DECIMAL(9,6) NOT NULL Purchased Service

10 PA_SVC_PRCH_ADJ Signed Number(11,6) DECIMAL(9,6) NOT NULL This field stores the adjustment amount corresponding to a purchase of service in Pensions.

#	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	FUNCTN_RESULT_NM	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name
4	SERVICE_FR_NAME	Character(10)	VARCHAR2(10) NOT NULL	Service Function Result. Prompt Table: PA_DFN_SVC_VW
5	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
6	END_DATE	Date(10)	DATE	End Date
7	ACCUM_PERIOD	Character(1)	VARCHAR2(1) NOT NULL	Accumulation Period A=Employee's Anniversary Year C=Calendar Year M=Calendar Month O=Other Year P=Plan Year
8	PA_SVC_PRCHABLE	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Purchasable Service
9	PA_SVC_PURCHASED	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Purchased Service
10	PA_SVC_PRCH_ADJ	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	This field stores the adjustment amount corresponding to a purchase of service in Pensions.