| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05A: OW HR & PR Foundation |
1 | F060116 | Employee Master Information | 113 | YA | IH | Hours per Standard Year | Numeric | Generic Edit | 7 | 2 |
2 | F0601161 | Point-In-Time Employee Master | 115 | PT | IH | Hours per Standard Year | Numeric | Generic Edit | 7 | 2 |
3 | F060116W | EE Master Request File | 113 | YA | IH | Hours per Standard Year | Numeric | Generic Edit | 7 | 2 |
4 | F060116Z | Unedited Quick Hire Transaction File | 132 | SZ | IH | Hours per Standard Year | Numeric | Generic Edit | 7 | 2 |
5 | F060119 | Employee Jobs History File | 50 | YE | IH | Hours per Standard Year | Numeric | Generic Edit | 7 | 2 |
TOP06: Payroll (old) - Obsolete-do not reuse |
6 | F060118 | Employee Jobs | 49 | YE | IH | Hours per Standard Year | Numeric | Generic Edit | 7 | 2 |
7 | F069096 | Payroll General Constants | 9 | YK | IH | Hours per Standard Year | Numeric | Generic Edit | 7 | 2 |
TOP08: Human Resources |
8 | F082003 | Grade/Step Progression Detail File | 24 | YW | IH | Hours per Standard Year | Numeric | Generic Edit | 7 | 2 |
TOP08AD: ADP Integration |
9 | F05137 | ADP Employee Master Information | 24 | AD | IH | Hours per Standard Year | Numeric | Generic Edit | 7 | 2 |
TOP08W: Wage and Salary |
10 | F082001 | Pay Grade/Salary Range Table | 22 | HS | IH | Hours per Standard Year | Numeric | Generic Edit | 7 | 2 |
11 | F08201 | Salary Review Workfile | 33 | HR | IH | Hours per Standard Year | Numeric | Generic Edit | 7 | 2 |
12 | F08830WF | Compensation Root Work Table | 19 | YN | IH | Hours per Standard Year | Numeric | Generic Edit | 7 | 2 |