R_NDT_EMPL_ADP(SQL Table) |
Index Back |
|---|---|
Tmp Tbl-NDT Actual Defer %R_NDT_EMPL_ADP is a temporary record that is used for NDT processing which contains the YTD contribution amount for 401(k) or (m) plus projections, gross YTD earnings amount plus projections, actual deferral percentage for HCE and HCE type against which all employees in test group are validated. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ADP_MODE | Character(1) | VARCHAR2(1) NOT NULL |
ADP Mode
A=Actual F=Forecast |
| 3 | YTD_401_K_M | Character(1) | VARCHAR2(1) NOT NULL | 401(k) or 401(m) YTD |
| 4 | GRS_YTD | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Gross Earnings YTD |
| 5 | DED_YTD | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deduction Balance YTD |
| 6 | ADP_HCE_ACTUAL | Number(6,3) | DECIMAL(5,3) NOT NULL | ADP HCE Actual |
| 7 | HCE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Highly/Lowly Compensated
H=Highly Compensated L=Non Highly Compensated |