| 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 | 16 | EM | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 2 | F06106 | Employee Pay Instructions | 25 | YM | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 3 | F0618 | Employee Transaction History | 28 | YT | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 4 | F06251 | Step Progression Rate History File | 7 | JB | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 5 | F069126 | Union Rates File | 8 | YL | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 6 | F06936 | Retro Pay Types Rate | 14 | JA | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| TOP05A: PeopleSoft HR & PR Foundation |
| 7 | F060116 | Employee Master Information | 45 | YA | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 8 | F0601161 | Point-In-Time Employee Master | 47 | PT | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 9 | F060116W | EE Master Request File | 45 | YA | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 10 | F060116Z | Unedited Quick Hire Transaction File | 28 | SZ | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 11 | F060119 | Employee Jobs History File | 12 | YE | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 12 | F06345 | Historical Payroll Register | 41 | JL | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| TOP05T: Time Entry |
| 13 | F06116 | Employee Transaction Detail File | 28 | YT | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 14 | F06116Z1 | Employee Transactions - Batch File | 45 | VL | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 15 | F06116Z2 | ESS Timecard History | 45 | VM | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 16 | F06278 | Retro Timecard Detail File | 31 | YT | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| TOP06: Payroll (old) - Obsolete-do not reuse |
| 17 | F060118 | Employee Jobs | 11 | YE | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 18 | F060146 | Employees Pay Rate File | 6 | JI | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| TOP07: Payroll |
| 19 | F06350I | WF - Paycheck (Interims) | 21 | Y4 | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 20 | F07UI200 | Timecard History Work File | 31 | TH | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| TOP08: Human Resources |
| 21 | F082003 | Grade/Step Progression Detail File | 14 | YW | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| TOP08AD: ADP Integration |
| 22 | F05137 | ADP Employee Master Information | 22 | AD | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 23 | F051371 | ADP Employee DBA Instructions | 30 | AD | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| TOP08W: Wage and Salary |
| 24 | F08201 | Salary Review Workfile | 25 | HR | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| 25 | F08830WF | Compensation Root Work Table | 20 | YN | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| TOP17C: Call Management |
| 26 | F1760 | Time Entry | 59 | ZB | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| TOP48S: Service Billing |
| 27 | F48S0618 | Payroll Reclassification Workfile | 28 | YT | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
| TOP75Z: New Zealand |
| 28 | F75Z0006 | Leave Taken A.G.E. Work File | 6 | Z6 | PHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 |
