| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05A: OW HR & PR Foundation |
1 | F05003 | Verification of Employment Data | 26 | EV | EST | Employment Status | Character | UDC | 1 | 0 |
2 | F060116 | Employee Master Information | 11 | YA | EST | Employment Status | Character | UDC | 1 | 0 |
3 | F0601161 | Point-In-Time Employee Master | 13 | PT | EST | Employment Status | Character | UDC | 1 | 0 |
4 | F060116W | EE Master Request File | 11 | YA | EST | Employment Status | Character | UDC | 1 | 0 |
5 | F060116Z | Unedited Quick Hire Transaction File | 44 | SZ | EST | Employment Status | Character | UDC | 1 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
6 | F060118 | Employee Jobs | 22 | YE | EST | Employment Status | Character | UDC | 1 | 0 |
7 | F060119 | Employee Jobs History File | 23 | YE | EST | Employment Status | Character | UDC | 1 | 0 |
TOP08AD: ADP Integration |
8 | F05137 | ADP Employee Master Information | 7 | AD | EST | Employment Status | Character | UDC | 1 | 0 |
9 | F051371 | ADP Employee DBA Instructions | 4 | AD | EST | Employment Status | Character | UDC | 1 | 0 |
10 | F051372 | ADP Employee Job Master Information | 4 | AD | EST | Employment Status | Character | UDC | 1 | 0 |
11 | F051373 | ADP Employee Auto Deposit Instructions | 4 | AD | EST | Employment Status | Character | UDC | 1 | 0 |
12 | F051374 | ADP Employee Tax Withholding/Override Instructions | 4 | AD | EST | Employment Status | Character | UDC | 1 | 0 |
TOP08U: OW HR US |
13 | F08366 | NDT - Key Employee Detail | 16 | HY | EST | Employment Status | Character | UDC | 1 | 0 |
TOP08W: Wage and Salary |
14 | F08201 | Salary Review Workfile | 14 | HR | EST | Employment Status | Character | UDC | 1 | 0 |
15 | F08830WF | Compensation Root Work Table | 13 | YN | EST | Employment Status | Character | UDC | 1 | 0 |
TOP75A: Australia - Reporting System Only |
16 | F75A0006 | Australian Employee Tax Overrides | 9 | ZE | EST | Employment Status | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.