PA_SP_UPGRADE (SQL Table)	Index Back
Service Purchase upgrade data

PA_SP_UPGRADE

(SQL Table)

Service Purchase upgrade data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
Prompt Table: PA_BEN_PLAN_VW

3 FUNCTN_RESULT_NM Character(10) VARCHAR2(10) NOT NULL Function Result Name
Prompt Table: PA_EACCT_VW

4 SVC_FUNCTN_RESULT Character(10) VARCHAR2(10) NOT NULL Benefit Service Functn Result
Prompt Table: PA_DFN_SVC_VW

5 BEGIN_DT Date(10) DATE NOT NULL Begin Date

6 END_DT Date(10) DATE end date

7 UNITS Character(1) VARCHAR2(1) NOT NULL Units
M=Months
Y=Years

8 AMT_TO_PURCH Number(10,6) DECIMAL(9,6) NOT NULL Amount to Purchase

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
2	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan Prompt Table: PA_BEN_PLAN_VW
3	FUNCTN_RESULT_NM	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name Prompt Table: PA_EACCT_VW
4	SVC_FUNCTN_RESULT	Character(10)	VARCHAR2(10) NOT NULL	Benefit Service Functn Result Prompt Table: PA_DFN_SVC_VW
5	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
6	END_DT	Date(10)	DATE	end date
7	UNITS	Character(1)	VARCHAR2(1) NOT NULL	Units M=Months Y=Years
8	AMT_TO_PURCH	Number(10,6)	DECIMAL(9,6) NOT NULL	Amount to Purchase