| 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.
TOPUDC 06 / T (Termination/Change Reasons) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | . | | |
2 | 001 | New Hire | | |
3 | 002 | Promotion | | |
4 | 003 | Demotion | | |
5 | 004 | Department Change | | |
6 | 005 | Shift Change | | |
7 | 006 | Merit | | |
8 | 007 | Range Adjustment | | |
9 | 008 | Payroll Adjustment | | |
10 | 009 | Annual Raise | | |
11 | 010 | Database correction | | |
12 | 011 | Rehire | | |
13 | 012 | Leave of Absence | | N |
14 | 020 | Minimum Salary Change | | N |
15 | 021 | Variability | | N |
16 | 098 | Automated Conversion-Old Sys. | | |
17 | 099 | **New Hire - Incomplete Setup | | |
18 | DH | Death | | |
19 | DS | Permanent Disability | | |
20 | FR | Furlough | | |
21 | LO | Layoff | | |
22 | RS | Resignation | | |
23 | RT | Retirement | | |
24 | TC | Termination with Cause | | |
25 | TE | Termination-Eligible to rehire | | |