| 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 | 13 | JI | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 2 | F0609 | Deduction/Benefit/Accrual Ledger File | 2 | Y$ | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 3 | F0618 | Employee Transaction History | 5 | YT | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 4 | F0619 | Benefit/Accrual Detail File | 2 | Y$ | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 5 | F0709 | Deduction/Benefit/Accrual Ledger File | 2 | Y$ | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| TOP05A: OW HR & PR Foundation |
| 6 | F06345 | Historical Payroll Register | 3 | JL | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| TOP05T: Time Entry |
| 7 | F06116 | Employee Transaction Detail File | 5 | YT | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 8 | F06116Z1 | Employee Transactions - Batch File | 22 | VL | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 9 | F06278 | Retro Timecard Detail File | 8 | YT | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| TOP07: Payroll |
| 10 | F06053 | Interim Check Parameters File | 13 | YW | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 11 | F06156 | Pay Check History Summary | 4 | YU | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 12 | F06166 | Pay Check History Tax Ledger | 3 | YV | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 13 | F06166A | Tax Ledger (Additional) | 2 | YV | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 14 | F06350I | WF - Paycheck (Interims) | 5 | Y4 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 15 | F0701740 | Quantum Control Tax | 6 | YQ | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 16 | F0701741 | Canadian Deduction | 6 | YD | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 17 | F0705 | DBA Period Control File | 10 | J@ | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 18 | F07149 | Accrual Fiscal/Anniversary History Work File | 20 | Y8 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 19 | F07186 | Stub Information History Table | 1 | Y8 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 20 | F071861 | Stub Detail Piece Rate History File | 1 | Y8 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 21 | F0719 | DBA Transaction Detail History | 2 | Y$ | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 22 | F0728 | Employee Paid Workers Compensation Transactions | 4 | YW | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 23 | F0729 | Employee DBA Override Instructions | 2 | Y9 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 24 | F07350 | Payment File | 2 | Y0 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 25 | F07351 | Payment Distribution File | 1 | Y1 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 26 | F07352 | Stub Information File | 1 | Y2 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 27 | F073521 | Stub Detail Piece Rate File | 1 | Y2 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 28 | F07353 | Tax Detail File | 2 | Y3 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 29 | F07355 | Pre-Payroll Error File | 26 | Y5 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 30 | F07UI200 | Timecard History Work File | 8 | TH | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| TOP08B: Benefits Administration |
| 31 | F08371 | Reimbursement Spending Account Claims File | 18 | B6 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| TOP08U: OW HR US |
| 32 | F08360 | Nondiscrimination Groups | 24 | HE | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| TOP18: Resource Scheduling |
| 33 | F186602 | Labor Rules Tag File | 19 | TF | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| TOP48S: Service Billing |
| 34 | F48S0618 | Payroll Reclassification Workfile | 5 | YT | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| TOP75A: Australia - Reporting System Only |
| 35 | F75A0005 | Coinage Details Work File | 2 | A5 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 36 | F75A0301 | Superannuation Payment | 5 | SA | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| TOP75Z: New Zealand - Reporting System Only |
| 37 | F75Z0002 | New Zealand Ledger Detail | 2 | Z2 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 38 | F75Z0009 | New Zealand Tax Detail Work File | 2 | TX | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 39 | F75Z0010 | New Zealand Tax Detail Tag Table | 2 | TD | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| TOP77: Payroll (Canadian) |
| 40 | F06176 | Unemployment Insurance History File | 3 | YS | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 41 | F0716 | Pay Check History Tax Ledger - Canadian DB | 3 | YV | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 42 | F07183 | Commission History Detail File | 2 | ZB | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 43 | F77703 | Payroll History Audit Report - Worktable | 11 | AR | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| TOP89: Conversion Programs |
| 44 | F07186T | Piece Rate History File | 1 | Y8 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
| 45 | F07352T | Piece Rate Stub Detail Tag File | 1 | Y2 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
