SAVINGS_403B_EE

#	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	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
3	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
4	SAVINGS_PLAN_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Identifies the type of savings plan, such as 403(b), 457, 401(k). 403B=403b Plans 457=457 Plans Default Value: 403B
5	LTD_SERVICE_YEARS	Number(8,5)	DECIMAL(7,5) NOT NULL	Service Years LTD
6	YTD_SERVICE_YEARS	Number(8,5)	DECIMAL(7,5) NOT NULL	Service Years YTD
7	GRS_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Gross Earnings YTD
8	GRS_YTD_ADJ	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Gross Earnings YTD Adjusted
9	DED_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction Balance YTD
10	DED_YTD_NON_ELECT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Ded YTD Non-Elect
11	DED_YTD_ER	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Ded YTD Employer
12	DED_LTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction Balance LTD
13	DED_LTD_NON_ELECT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Ded LTD Non Elect
14	DED_LTD_ER	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Ded LTD Employer
15	DED_ADJ	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction Adjustment Balance field.
16	DED_ADJ_NON_ELECT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction Balance Non-Elect
17	DED_ADJ_ER	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction Balance Employer
18	DED_ADJ_PA	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction Adj from PA
19	ELECTION_DT	Date(10)	DATE	Election Date
20	ALT_ELECTION	Character(1)	VARCHAR2(1) NOT NULL	415 Alternative Election A=Last Year of Service B=Any Year Rule C=Overall Limit N=No Alternative Election Default Value: N
21	SERVICE_YRS_OVRD	Character(1)	VARCHAR2(1) NOT NULL	Override Service Years Calc Y/N Table Edit Default Value: N
22	PROJ_402G_CAP_EXT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Elective Deferrals Limit
23	YTD_402G_CAP_USED	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	402(g) Cap Extension Used YTD
24	LTD_402G_CAP_USED	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	402(g) Cap Extension Used LTD
25	YTD_402G_DED	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	402(g) Deduction Year to Date
26	LTD_402G_DED	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	402(g) Deductions LTD
27	YTD_415_DED	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	415 Deductions YTD
28	PROJ_DED	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Exclusion Allowance
29	PROJ_DED_ER_LMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Employer Contribution Limit
30	PROJ_DED_ALTA	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Proj Year of Sep Excl Limit
31	PROJ_DED_ALTB	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Any Year Excl Limit
32	PROJ_DED_ALTC	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Overall Excl Limit
33	LIMIT_REDUCTN_402G	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Limit Reduction Amount
34	HARDSHIP_WTHD_DT	Date(10)	DATE	Hardship Withdrawal Date
35	ALT_402G_ELECTION	Character(1)	VARCHAR2(1) NOT NULL	Elect 402(g) Cap Expansion N=No X=Automatic Election Y=Yes Default Value: N
36	TERMINATION_DT	Date(10)	DATE	Termination Date
37	ELECT_457_CATCH_UP	Character(1)	VARCHAR2(1) NOT NULL	457 plan election for "Catch Up" limit processing. Y/N Table Edit Default Value: N
38	UNDERUTIL_457_LMTS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	The amount that the 457 plan limit has been underutilized for all eligible years of participation.
39	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
40	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update