UPG_BN_LMT_TMP2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	ERNCD_SPCL	Character(3)	VARCHAR2(3) NOT NULL	Special Accumulator Code Prompt Table: SPCL_EARNS_TBL
4	PCT_OF_SALARY	Number(7,3)	DECIMAL(6,3) NOT NULL	Percent of Salary
5	DED_YTD_MAX	Number(11,2)	DECIMAL(10,2) NOT NULL	Maximum Yearly Deduction
6	MAX_BENEF_BASE	Number(11,2)	DECIMAL(10,2) NOT NULL	Maximum Benefit Base
7	ROLLOVER_ALLOWED	Character(1)	VARCHAR2(1) NOT NULL	Rollover Allowed Y/N Table Edit
8	ALTA_SVC_YRS	Number(3,0)	SMALLINT NOT NULL	Year of Separation Limit Years
9	ALTB_ADDL_EXCL	Number(11,2)	DECIMAL(10,2) NOT NULL	Any Year Limit Additional Excl
10	ALTB_MAX_ADDL	Number(11,2)	DECIMAL(10,2) NOT NULL	Any Year Maximum Exclusion
11	PER_YEAR_EXPN	Number(11,2)	DECIMAL(10,2) NOT NULL	402(g) Per Year Max Average
12	ANNL_CAP_EXPN	Number(11,2)	DECIMAL(10,2) NOT NULL	Annl Cap Expsn
13	MAX_CAP_EXPN	Number(11,2)	DECIMAL(10,2) NOT NULL	402(g) Max Cap Expansion
14	ALT_402G_ELECTION	Character(1)	VARCHAR2(1) NOT NULL	Elect 402(g) Cap Expansion N=No X=Automatic Election Y=Yes
15	SERVICE_403B_PRORT	Character(1)	VARCHAR2(1) NOT NULL	403(b) Service F=Based on FTE S=Based on Standard Hours