PA_CLC_EA_SP (SQL Table)	Index Back
Calc Results Employee Accounts This is an employee table containing Calc Results for Employee Accounts.

PA_CLC_EA_SP

(SQL Table)

Calc Results Employee Accounts

This is an employee table containing Calc Results for Employee Accounts.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CALC_NAME Character(20) VARCHAR2(20) NOT NULL Calculation Name

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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 START_DT Date(10) DATE Start Date

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

7 END_DT Date(10) DATE end date

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	CALC_NAME	Character(20)	VARCHAR2(20) NOT NULL	Calculation Name
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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	START_DT	Date(10)	DATE	Start Date
6	SERVICE_FR_NAME	Character(10)	VARCHAR2(10) NOT NULL	Service Function Result. Prompt Table: PA_DFN_SVC_VW
7	END_DT	Date(10)	DATE	end date
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.