NDT_RUNCTL(SQL Table) |
Index Back |
|---|---|
NDT Run Controls and ResultsNDT_RUNCTL is a record that is used to set up the parameters for a specific nondiscrimination test run, and to store the results of that run. The run parameters are entered through the NDT Run Control panel, and will determine the year(s) being tested, the source for benefit salary, and what projections are requested. Since this table is normalized, the company and pay groups (or separate lines-of-business) being tested are defined separately on a child table, PS_NDT_CO_PAYGROUP (or PS_NDt_co_pay_slob). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ERNCD_SPCL | Character(3) | VARCHAR2(3) NOT NULL |
Special Accumulator Code
Prompt Table: SPCL_EARNS_TBL |
| 2 | PLAN_YEAR_BEGIN_DT | Date(10) | DATE NOT NULL | Plan Year Begin Date |
| 3 | MONTH_END_DT | Date(10) | DATE NOT NULL | Month End Date |
| 4 | YEAR_CD | Character(1) | VARCHAR2(1) NOT NULL |
Year Code:
used in Nondiscriminating Testing and...
B=Current and Prior Plan Year C=Current Plan Year P=Prior Plan Year Default Value: B |
| 5 | PROJECTION_PERCENT | Number(6,3) | DECIMAL(5,3) NOT NULL | Year End Projection Percentage |
| 6 | BENEFITS_BASE | Character(1) | VARCHAR2(1) NOT NULL |
Benefits Base
1=Annual Rate 2=Annual Benefits Base Rate Default Value: 1 |
| 7 | MIN_SERVICE_REQD | Number(2,0) | SMALLINT NOT NULL | Minimum Service Required |
| 8 | AGE_RANGE_HIGH | Number(3,0) | SMALLINT NOT NULL | Age Range High |
| 9 | SLOB | Character(1) | VARCHAR2(1) NOT NULL |
Separate Line of Business
Default Value: N |
| 10 | MIN_EMPLOYEE_COUNT | Number(5,0) | INTEGER NOT NULL | Minimum Employee Count |
| 11 | CAFETERIA_PLAN | Character(1) | VARCHAR2(1) NOT NULL |
Cafeteria Plan
Y/N Table Edit Default Value: N |
| 12 | AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Dollar Amount |
| 13 | ADP_HCE_ACTUAL_K | Number(6,3) | DECIMAL(5,3) NOT NULL | ADP HCE Actual 401(k) |
| 14 | ADP_HCE_FORECAST_K | Number(6,3) | DECIMAL(5,3) NOT NULL | ADP HCE Forecast 401(k) |
| 15 | ADP_LCE_ACTUAL_K | Number(6,3) | DECIMAL(5,3) NOT NULL | ADP LCE Actual 401(k) |
| 16 | ADP_LCE_FORECAST_K | Number(6,3) | DECIMAL(5,3) NOT NULL | ADP LCE Forecast 401(k) |
| 17 | D_EXCESS_ACTUAL_K | Number(6,3) | DECIMAL(5,3) NOT NULL | Disc Excess - 401k (Actual) |
| 18 | D_EXCESS_FCST_K | Number(6,3) | DECIMAL(5,3) NOT NULL | Disc Excess - 401k (Forcast) |
| 19 | RESULTS_ACTUAL_K | Character(1) | VARCHAR2(1) NOT NULL |
Test Results Actual 401(k)
1=Passed 125% Test 2=Passed Alternate 2% Test F=Failed N=Not Performed Default Value: N |
| 20 | RESULTS_FORECAST_K | Character(1) | VARCHAR2(1) NOT NULL |
Test Results Forecast 401(k)
1=Passed 125% Test 2=Passed Alternate 2% Test F=Failed N=Not Performed Default Value: N |
| 21 | ADP_HCE_ACTUAL_M | Number(6,3) | DECIMAL(5,3) NOT NULL | ADP HCE Actual 401(m) |
| 22 | ADP_HCE_FORECAST_M | Number(6,3) | DECIMAL(5,3) NOT NULL | ADP HCE Forecast 401(m) |
| 23 | ADP_LCE_ACTUAL_M | Number(6,3) | DECIMAL(5,3) NOT NULL | ADP LCE Actual 401(m) |
| 24 | ADP_LCE_FORECAST_M | Number(6,3) | DECIMAL(5,3) NOT NULL | ADP LCE Forecast 401(m) |
| 25 | RESULTS_ACTUAL_M | Character(1) | VARCHAR2(1) NOT NULL |
Test Results Actual 401(m)
1=Passed 125% Test 2=Passed Alternate 2% Test F=Failed N=Not Performed Default Value: N |
| 26 | RESULTS_FORECAST_M | Character(1) | VARCHAR2(1) NOT NULL |
Test Results Forecast 401(m)
1=Passed 125% Test 2=Passed Alternate 2% Test F=Failed N=Not Performed Default Value: N |
| 27 | D_EXCESS_ACTUAL_M | Number(6,3) | DECIMAL(5,3) NOT NULL | Disc Excess - 401m (Actual) |
| 28 | D_EXCESS_FCST_M | Number(6,3) | DECIMAL(5,3) NOT NULL | Disc Excess - 401m (Forcast) |
| 29 | TOTAL_HCE_COUNT | Number(6,0) | INTEGER NOT NULL | Total HCE Count |
| 30 | TOTAL_NHCE_COUNT | Number(6,0) | INTEGER NOT NULL | Total NHCE Count |
| 31 | RESULTS_ACTUAL_AGG | Character(1) | VARCHAR2(1) NOT NULL |
Aggregate Test Results-Actual
F=Failed N=Not Performed P=Passed Default Value: N |
| 32 | RESULTS_FORCST_AGG | Character(1) | VARCHAR2(1) NOT NULL |
Aggregate Test Results-Forcst
F=Failed N=Not Performed P=Passed Default Value: N |