PA_SP_TRAN_SVC

#	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	SP_ID	Number(11,0)	DECIMAL(11) NOT NULL	Service Purchase ID
4	ESTIMATE_NBR	Number(2,0)	SMALLINT NOT NULL	Estimate Number
5	SVC_FUNCTN_RESULT	Character(10)	VARCHAR2(10) NOT NULL	Benefit Service Functn Result Prompt Table: PA_DFN_SVC_VW
6	PRIMARY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Primary Flag N=No Y=Yes Y/N Table Edit
7	BEGIN_DT	Date(10)	DATE	Begin Date
8	END_DT	Date(10)	DATE	end date
9	FUNCTN_RESULT_NM	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name
10	EACCT_FR_NAME	Character(10)	VARCHAR2(10) NOT NULL	This field represents a Contribution Employee Account Function Result.
11	ADJ_START_DT	Date(10)	DATE	Adjustment Start Date
12	ADJ_END_DT	Date(10)	DATE	Adjustment End Date
13	LAST_PROC_DT	Date(10)	DATE	Last Proc Date
14	BRKS_PRD	Number(10,6)	DECIMAL(9,6) NOT NULL	Breaks for Period
15	UNITS	Character(1)	VARCHAR2(1) NOT NULL	Units M=Months Y=Years
16	FNL_MAX_SVC_NBR	Number(10,6)	DECIMAL(9,6) NOT NULL	Maximum
17	FNL_MIN_SVC_NBR	Number(10,6)	DECIMAL(9,6) NOT NULL	Minimum
18	TOTAL_SVC	Number(10,6)	DECIMAL(9,6) NOT NULL	Total Service
19	PERIOD_SVC	Number(10,6)	DECIMAL(9,6) NOT NULL	Service Period
20	PERIOD_ADJ	Number(10,6)	DECIMAL(9,6) NOT NULL	Period Adjustments
21	AVAIL_TO_PURCH	Number(10,6)	DECIMAL(9,6) NOT NULL	Available to Purchase
22	SVC_WITHDRAWN	Number(10,6)	DECIMAL(9,6) NOT NULL	Service Withdrawn
23	SVC_BUYBACK	Number(10,6)	DECIMAL(9,6) NOT NULL	Service Buyback
24	AMT_TO_PURCH	Number(10,6)	DECIMAL(9,6) NOT NULL	Amount to Purchase