NDT_HCE_TBL

(SQL Table)
Index Back

NDT Highly Compensated EE Defn

NDT_HCE_TBL is the basic record which establishes the IRS criteria for nondiscrimination testing. This record establishes the definition of highly compensated employees and defines the (IRS) limits for 401K and 401M contributions. This record is effective dated, and typically will contain rules for each subsequent plan year.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

2 HCE_COMP_METHOD Character(1) VARCHAR2(1) NOT NULL Compensation Method to be Used
1=Compensation Only
2=Compensation in Top Percent

Default Value: 1

3 COMP_HIGH Number(9,2) DECIMAL(8,2) NOT NULL Compensation High
4 COMP_TOP_PCT Number(9,2) DECIMAL(8,2) NOT NULL Compensation of Top Percent
5 TOP_PCT Number(3,0) SMALLINT NOT NULL Top Percent
6 AGE_RANGE_HIGH Number(3,0) SMALLINT NOT NULL Age Range High
7 MIN_SERVICE_REQD Number(2,0) SMALLINT NOT NULL Minimum Service Required
8 ADP_CALC_YEAR Character(1) VARCHAR2(1) NOT NULL ADP calculation year
C=Current Year
P=Previous Year

Default Value: C

9 ADP_COMP_LIMIT Number(9,2) DECIMAL(8,2) NOT NULL Annual Compensation Lmt (401a)
10 ADP_CONTRIB_LIMIT Number(9,2) DECIMAL(8,2) NOT NULL Annual Contribution Lmt (402g)
11 MIN_TIMES_FACTOR Number(4,2) DECIMAL(3,2) NOT NULL Minimum Times Factor
12 MIN_ADD_FACTOR Number(4,2) DECIMAL(3,2) NOT NULL Minimum Plus Factor
13 MAX_TIMES_FACTOR Number(4,2) DECIMAL(3,2) NOT NULL Maximum Times Factor