| 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 | 22 | Y$ | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 2 | F0618 | Employee Transaction History | 47 | YT | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 3 | F0619 | Benefit/Accrual Detail File | 22 | Y$ | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 4 | F0709 | Deduction/Benefit/Accrual Ledger File | 27 | Y$ | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| TOP05T: Time Entry |
| 5 | F06116 | Employee Transaction Detail File | 47 | YT | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 6 | F06116Z1 | Employee Transactions - Batch File | 59 | VL | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 7 | F06116Z2 | ESS Timecard History | 59 | VM | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 8 | F06278 | Retro Timecard Detail File | 45 | YT | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| TOP07: Payroll |
| 9 | F06136 | Tax History | 67 | YZ | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 10 | F063106 | Deduction/Benefit Work File | 13 | Y7 | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 11 | F0719 | DBA Transaction Detail History | 27 | Y$ | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 12 | F07727 | Canadian Pension Information | 24 | J7 | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 13 | F07824 | Company State/Local Control Table | 14 | JD | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 14 | F07825 | Company Special Handling Control Table | 11 | JA | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 15 | F07831 | Employee State/Local Control Table | 22 | YB | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 16 | F07832 | Employee Special Handling Control Table | 12 | YH | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 17 | F07UI200 | Timecard History Work File | 50 | TH | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| TOP18: Resource Scheduling |
| 18 | F186602 | Labor Rules Tag File | 58 | TF | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| TOP48S: Service Billing |
| 19 | F48S0618 | Payroll Reclassification Workfile | 47 | YT | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| TOP77: Payroll (Canadian) |
| 20 | F0713 | Tax History | 67 | YZ | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 21 | F0713SAV | Backup Copy of F0713 For Tax Ledger Repost | 67 | YZ | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 22 | F0716 | Pay Check History Tax Ledger - Canadian DB | 22 | YV | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
| 23 | F07183 | Commission History Detail File | 15 | ZB | WCTY | Work City | Numeric | Generic Edit | 4 | 0 |
