| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05: Time Accounting and HRM Base |
| 1 | F0607 | Wage Attachment Ledger File | 3 | JI | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 2 | F0609 | Deduction/Benefit/Accrual Ledger File | 5 | Y$ | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 3 | F0618 | Employee Transaction History | 71 | YT | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 4 | F0619 | Benefit/Accrual Detail File | 5 | Y$ | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 5 | F0709 | Deduction/Benefit/Accrual Ledger File | 5 | Y$ | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| TOP05A: OW HR & PR Foundation |
| 6 | F06345 | Historical Payroll Register | 22 | JL | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| TOP05T: Time Entry |
| 7 | F06116 | Employee Transaction Detail File | 71 | YT | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 8 | F06116Z1 | Employee Transactions - Batch File | 85 | VL | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 9 | F06278 | Retro Timecard Detail File | 71 | YT | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| TOP06: Payroll (old) - Obsolete-do not reuse |
| 10 | F06042 | Future Data EE Master Revisions | 7 | JO | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 11 | F06210 | Payroll Cycle Parameters | 6 | YD | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| TOP07: Payroll |
| 12 | F06156 | Pay Check History Summary | 6 | YU | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 13 | F06166 | Pay Check History Tax Ledger | 14 | YV | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 14 | F06166A | Tax Ledger (Additional) | 18 | YV | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 15 | F063106 | Deduction/Benefit Work File | 7 | Y7 | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 16 | F06350I | WF - Paycheck (Interims) | 13 | Y4 | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 17 | F068500 | 941 - Federal Tax History | 2 | YZ | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 18 | F069066 | Pay Cycle Constant | 4 | JD | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 19 | F0717 | ROE Summary History | 9 | JF | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 20 | F0719 | DBA Transaction Detail History | 5 | Y$ | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 21 | F07210 | Pay Cycle Parameters File | 32 | YD | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 22 | F07350 | Payment File | 6 | Y0 | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 23 | F07353 | Tax Detail File | 26 | Y3 | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 24 | F07UI200 | Timecard History Work File | 74 | TH | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| TOP08AD: ADP Integration |
| 25 | F05138 | ADP - Pay Cycle Review Control | 3 | PC | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| TOP18: Resource Scheduling |
| 26 | F186602 | Labor Rules Tag File | 80 | TF | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| TOP48S: Service Billing |
| 27 | F48S0618 | Payroll Reclassification Workfile | 71 | YT | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| TOP77: Payroll (Canadian) |
| 28 | F06176 | Unemployment Insurance History File | 4 | YS | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 29 | F0716 | Pay Check History Tax Ledger - Canadian DB | 14 | YV | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
| 30 | F07183 | Commission History Detail File | 5 | ZB | PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 |
