| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05A: OW HR & PR Foundation |
1 | F060116 | Employee Master Information | 205 | YA | FTE | Full Time Equivalents | Numeric | Generic Edit | 9 | 2 |
2 | F0601161 | Point-In-Time Employee Master | 207 | PT | FTE | Full Time Equivalents | Numeric | Generic Edit | 9 | 2 |
3 | F060116W | EE Master Request File | 205 | YA | FTE | Full Time Equivalents | Numeric | Generic Edit | 9 | 2 |
4 | F060116Z | Unedited Quick Hire Transaction File | 131 | SZ | FTE | Full Time Equivalents | Numeric | Generic Edit | 9 | 2 |
5 | F060119 | Employee Jobs History File | 48 | YE | FTE | Full Time Equivalents | Numeric | Generic Edit | 9 | 2 |
TOP06: Payroll (old) - Obsolete-do not reuse |
6 | F060118 | Employee Jobs | 47 | YE | FTE | Full Time Equivalents | Numeric | Generic Edit | 9 | 2 |
TOP08: Human Resources |
7 | F082003 | Grade/Step Progression Detail File | 15 | YW | FTE | Full Time Equivalents | Numeric | Generic Edit | 9 | 2 |
TOP08P: Position Control |
8 | F08111 | Position Budget Detail | 11 | HQ | FTE | Full Time Equivalents | Numeric | Generic Edit | 9 | 2 |
9 | F08111P | Purge - Position Budget Detail | 11 | HQ | FTE | Full Time Equivalents | Numeric | Generic Edit | 9 | 2 |
TOP08W: Wage and Salary |
10 | F08830WF | Compensation Root Work Table | 18 | YN | FTE | Full Time Equivalents | Numeric | Generic Edit | 9 | 2 |