PA_SP_STP_PRDS

#	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_PELG_HIST
3	SP_GAP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Service Purchase Gap Type G=Gaps in Service U=Unknown W=Withdrawn Contribution
4	PA_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
5	SVC_PURCHASE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Service Purchase Type Prompt Table: PA_SP_TYPE_DEFN
6	ELIGIBILITY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	ERP Eligibility Status E=Eligible I=Ineligible U=Undetermined
7	ELIG_OVERIDDEN	Character(1)	VARCHAR2(1) NOT NULL	Sp Eligibility
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
9	BEGIN_DT	Date(10)	DATE	Begin Date
10	END_DT	Date(10)	DATE	end date
11	WITHDRAW_DATE	Date(10)	DATE	Withdrawal \ Cancel Date
12	FUNCTN_RESULT_NM	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name
13	EACCT_FR_NAME	Character(10)	VARCHAR2(10) NOT NULL	This field represents a Contribution Employee Account Function Result.
14	WITHDRAW_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Withdrawal Amount
15	WITHDRAW_AMT_PRE	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Withdrawal Amount
16	WITHDRAW_AMT_POST	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Withdrawn Amount Post-Tax
17	PURCHASED_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Purchased Amount
18	PURCHASED_AMT_PRE	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Purchased Amount Pre-Tax
19	PURCHASED_AMT_POST	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Purchased Amount Post-Tax
20	VERIF_ID	Number(3,0)	SMALLINT NOT NULL	Verification ID Prompt Table: PA_SP_EMPLRVER
21	CUSTOM_STMT_NAME	Character(10)	VARCHAR2(10) NOT NULL	Custom Statement Name Prompt Table: PA_CUSTOM6_VW