| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05: Time Accounting and HRM Base |
| 1 | F0609 | Deduction/Benefit/Accrual Ledger File | 32 | Y$ | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 2 | F06145 | Calendar Month DBA Summary History File | 54 | YH | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 3 | F0627 | Workers Compensation Summary History | 88 | JH | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 4 | F0709 | Deduction/Benefit/Accrual Ledger File | 37 | Y$ | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| TOP05A: PeopleSoft HR & PR Foundation |
| 5 | F060116 | Employee Master Information | 136 | YA | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 6 | F0601161 | Point-In-Time Employee Master | 138 | PT | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 7 | F060116W | EE Master Request File | 136 | YA | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 8 | F060116Z | Unedited Quick Hire Transaction File | 138 | SZ | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| TOP05T: Time Entry |
| 9 | F06116 | Employee Transaction Detail File | 146 | YT | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 10 | F06116Z1 | Employee Transactions - Batch File | 159 | VL | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 11 | F06116Z2 | ESS Timecard History | 159 | VM | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 12 | F0623 | Piecework History File | 59 | JL | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 13 | F06278 | Retro Timecard Detail File | 145 | YT | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| TOP06: Payroll (old) - Obsolete-do not reuse |
| 14 | F06146 | Employee Transaction History Summary | 59 | YN | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 15 | F06210 | Payroll Cycle Parameters | 80 | YD | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| TOP07: Payroll |
| 16 | F06136 | Tax History | 71 | YZ | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 17 | F06148 | Tax Area Transaction History | 13 | Y@ | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 18 | F06156 | Pay Check History Summary | 41 | YU | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 19 | F06166 | Pay Check History Tax Ledger | 15 | YV | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 20 | F06350I | WF - Paycheck (Interims) | 47 | Y4 | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 21 | F068500 | 941 - Federal Tax History | 9 | YZ | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 22 | F0717 | ROE Summary History | 53 | JF | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 23 | F0719 | DBA Transaction Detail History | 37 | Y$ | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 24 | F07727 | Canadian Pension Information | 28 | J7 | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 25 | F07901 | Pre-Payroll DBA Calculation Control Table | 49 | Y5 | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| TOP18: Timecard Automation |
| 26 | F186602 | Labor Rules Tag File | 152 | TF | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| TOP77: Payroll (Canadian) |
| 27 | F06176 | Unemployment Insurance History File | 21 | YS | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 28 | F0713 | Tax History | 71 | YZ | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 29 | F0713SAV | Backup Copy of F0713 For Tax Ledger Repost | 71 | YZ | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
| 30 | F0716 | Pay Check History Tax Ledger - Canadian DB | 15 | YV | DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 |
