PA_SP_TRAN_EST

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	SP_UNIT_COST	Number(12,2)	DECIMAL(11,2) NOT NULL	Service Purchase Cost
7	SP_COST	Number(12,2)	DECIMAL(11,2) NOT NULL	Service Purchase Cost
8	SP_COST_PRE	Number(12,2)	DECIMAL(11,2) NOT NULL	Service Purchase PreTax Cost
9	SP_COST_POST	Number(12,2)	DECIMAL(11,2) NOT NULL	Service Purchase PostTax Cost
10	CALC_NAME	Character(20)	VARCHAR2(20) NOT NULL	Calculation Name
11	FCTN_RSLT_COST	Character(10)	VARCHAR2(10) NOT NULL	Function Result
12	BEN_CMDT_DATE	Date(10)	DATE	Benefit Commencement Date
13	EVENT_AGE	Number(5,2)	DECIMAL(4,2) NOT NULL	Event Age(YY.MM)
14	EVENT_DT	Date(10)	DATE	Event Date
15	SALSC_ASMP_INC_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Salary Scale Percent Increase
16	CURR_BEN	Number(12,2)	DECIMAL(11,2) NOT NULL	Current Benefit
17	PURCH_BEN	Number(12,2)	DECIMAL(11,2) NOT NULL	Benefit with Purchase
18	PYMT_FREQ	Character(4)	VARCHAR2(4) NOT NULL	Payment Frequency 0=One Time Payment 1=Annual Payment 12=Monthly Payment 2=Semi-Annual 24=Semi-Monthly Payment 26=BiWeekly Payment 4=Quarterly Default Value: 12
19	CALC_NAME_BN_NO_SP	Character(20)	VARCHAR2(20) NOT NULL
20	FCTN_RSLT_BN_NO_SP	Character(10)	VARCHAR2(10) NOT NULL
21	CALC_NAME_BN_SP	Character(20)	VARCHAR2(20) NOT NULL
22	FCTN_RSLT_BN_SP	Character(10)	VARCHAR2(10) NOT NULL
23	EST_SELECTED	Character(1)	VARCHAR2(1) NOT NULL	Estimate Selected N=No Y=Yes Default Value: N
24	COST_CALC_DTTM	DateTime(26)	TIMESTAMP	Calculated Datetime
25	BEN_CALC_DTTM	DateTime(26)	TIMESTAMP	Calculated Datetime