| 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 | 17 | EM | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
TOP05A: PeopleSoft HR & PR Foundation |
2 | F060116 | Employee Master Information | 44 | YA | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
3 | F0601161 | Point-In-Time Employee Master | 46 | PT | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
4 | F060116W | EE Master Request File | 44 | YA | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
5 | F060116Z | Unedited Quick Hire Transaction File | 27 | SZ | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
6 | F060119 | Employee Jobs History File | 11 | YE | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
TOP06: Payroll (old) - Obsolete-do not reuse |
7 | F060118 | Employee Jobs | 10 | YE | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
TOP07: Payroll |
8 | F074001 | New Hire Reporting Workfile - OneWorld Only | 43 | NH | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
9 | F8907444 | New Hire Detail File Transfer - Texas (44) | 44 | TX | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
TOP08: Human Resources |
10 | F082002 | Grade/Step Progression Header File | 5 | YV | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
11 | F083305 | Mail Merge Header/Detail | 16 | MM | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
TOP08AD: ADP Integration |
12 | F05137 | ADP Employee Master Information | 21 | AD | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
TOP08B: Benefits Administration |
13 | F0833WF | Benefit Statement Work file | 13 | WF | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
TOP08P: Position Control |
14 | F08111 | Position Budget Detail | 10 | HQ | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
15 | F08111P | Purge - Position Budget Detail | 10 | HQ | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
TOP08U: PeopleSoft HR US |
16 | F08910 | COBRA Qualified Beneficiary File | 31 | J1 | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
TOP08W: Wage and Salary |
17 | F08201 | Salary Review Workfile | 24 | HR | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |
18 | F08830WF | Compensation Root Work Table | 25 | YN | SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 |