SAVINGS_MGT_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: EMPL_CO_VW
3	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
4	LIMIT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Limit Type 401=401(a) Limit 401G=401(a) Limit Grandfather Plan 402=402(g) Limit 403=403(b) Limit 415=415(c) Limit 415Z=415(c) Limit for 403(b) plans 457=457 Limit CH01=User Defined Per Check Limit 1 CH02=User Defined Per Check Limit 2 CH03=User Defined Per Check Limit 3 CH04=User Defined Per Check Limit 4 CH05=User Defined Per Check Limit 5 USER=User Defined Limit Default Value: 402 Prompt Table: EXP_LMT_TYP_VW
5	LIMIT_EXT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Limit Extension Type A=Catch Up - Extend Limit B=Age - Extend Limit E=Adjust Eligible Earnings YTD H=Hardship - Reduce Limit Default Value: B Prompt Table: %EDITTABLE
6	EXT_AMOUNT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Extension Amount
7	EXT_ELECTION	Character(1)	VARCHAR2(1) NOT NULL	Extension Election Y/N Table Edit Default Value: Y
8	LMT_AMT_OVRD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Limit Amount Override
9	LTD_SERVICE_YEARS	Number(8,5)	DECIMAL(7,5) NOT NULL	Service Years LTD
10	YTD_SERVICE_YEARS	Number(8,5)	DECIMAL(7,5) NOT NULL	Service Years YTD
11	GRS_YTD	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Gross Earnings YTD
12	DED_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction Balance YTD
13	DED_YTD_NON_ELECT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Ded YTD Non-Elect
14	DED_YTD_ER	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Ded YTD Employer
15	DED_LTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction Balance LTD
16	DED_LTD_NON_ELECT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Ded LTD Non Elect
17	DED_LTD_ER	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Ded LTD Employer
18	DED_ADJ	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction Adjustment Balance field.
19	DED_ADJ_NON_ELECT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction Balance Non-Elect
20	YTD_402G_CAP_USED	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	402(g) Cap Extension Used YTD
21	DED_ADJ_ER	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction Balance Employer
22	DED_ADJ_PA	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction Adj from PA
23	SERVICE_YRS_OVRD	Character(1)	VARCHAR2(1) NOT NULL	Override Service Years Calc Y/N Table Edit Default Value: N
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	TERMINATION_DT	Date(10)	DATE	Termination Date
29	ROTH_THRESHOLD	Character(1)	VARCHAR2(1) NOT NULL	Over FICA Earnings Threshold for Roth Rollover Y/N Table Edit Default Value: N
30	BAS_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Identifies a benefits-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and benefits eligibility. A BAS (PeopleSoft Benefits Administration System) action may correspond to a BAS Event Class, which defines how a benefits-related event is recognized and handled. Some examples of BAS actions (and event classes) are Hire, Family Status Change, and Open Enrollment. Prompt Table: BAS_EVT_MANUAL
31	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update
32	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
33	OPRID_ROTHTH	Character(30)	VARCHAR2(30) NOT NULL	Roth Threshold User ID
34	UPDATE_DATE_ROTHTH	Date(10)	DATE	Roth Threshold Last Update Date
35	OPRID_BASACT	Character(30)	VARCHAR2(30) NOT NULL	BAS Trigger User ID
36	CREATE_DATE_BASACT	Date(10)	DATE	BAS Trigger Create Date