| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F050116W | Employee Master Integrations Work File | 6 | EM | TRS | Change Reason | String | UDC | 3 | 0 |
TOP05A: OW HR & PR Foundation |
2 | F060116 | Employee Master Information | 36 | YA | TRS | Change Reason | String | UDC | 3 | 0 |
3 | F0601161 | Point-In-Time Employee Master | 38 | PT | TRS | Change Reason | String | UDC | 3 | 0 |
4 | F060116W | EE Master Request File | 36 | YA | TRS | Change Reason | String | UDC | 3 | 0 |
5 | F060116Z | Unedited Quick Hire Transaction File | 88 | SZ | TRS | Change Reason | String | UDC | 3 | 0 |
6 | F060119 | Employee Jobs History File | 55 | YE | TRS | Change Reason | String | UDC | 3 | 0 |
7 | F06045 | Employee Master - Mass Changes | 4 | BB | TRS | Change Reason | String | UDC | 3 | 0 |
8 | F08042 | HR History | 9 | JW | TRS | Change Reason | String | UDC | 3 | 0 |
9 | F08046 | Turnover Column Consolidation | 2 | HZ | TRS | Change Reason | String | UDC | 3 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
10 | F060118 | Employee Jobs | 54 | YE | TRS | Change Reason | String | UDC | 3 | 0 |
11 | F06042 | Future Data EE Master Revisions | 6 | JO | TRS | Change Reason | String | UDC | 3 | 0 |
TOP07: Payroll |
12 | F06053 | Interim Check Parameters File | 10 | YW | TRS | Change Reason | String | UDC | 3 | 0 |
13 | F07355 | Pre-Payroll Error File | 29 | Y5 | TRS | Change Reason | String | UDC | 3 | 0 |
TOP08: Human Resources |
14 | F08720 | Employee Status Change | 7 | SC | TRS | Change Reason | String | UDC | 3 | 0 |
TOP08R: Recruitment Management - (Appl. Track. & Req.) |
15 | F08045 | Employee Turnover Analysis | 3 | HT | TRS | Change Reason | String | UDC | 3 | 0 |
TOP08U: OW HR US |
16 | F08910 | COBRA Qualified Beneficiary File | 19 | J1 | TRS | Change Reason | String | UDC | 3 | 0 |
TOP08W: Wage and Salary |
17 | F08201 | Salary Review Workfile | 32 | HR | TRS | Change Reason | String | UDC | 3 | 0 |
18 | F08818 | Increase Type Rules | 1 | YM | TRS | Change Reason | String | UDC | 3 | 0 |
19 | F08831WF | Compensation Detail Work Table | 4 | YS | TRS | Change Reason | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.