NDT_HCE_TBL(SQL Table) |
Index Back |
---|---|
NDT Highly Compensated EE DefnNDT_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 |