| 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 | 9 | EM | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 2 | F06005 | Batch Processing Parameters | 5 | JE | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 3 | F06107 | Employee Wage Attachment Rules | 20 | J$ | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 4 | F0618 | Employee Transaction History | 65 | YT | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 5 | F06931 | Wage Attachment File | 4 | J3 | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 6 | F069311 | Wage Attachment Additional Exemptions | 3 | J3 | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 7 | F07300 | Employee Lockout Code File | 6 | YB | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| TOP05A: OW HR & PR Foundation |
| 8 | F05003 | Verification of Employment Data | 29 | EV | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 9 | F060116 | Employee Master Information | 27 | YA | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 10 | F0601161 | Point-In-Time Employee Master | 29 | PT | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 11 | F060116W | EE Master Request File | 27 | YA | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 12 | F060116Z | Unedited Quick Hire Transaction File | 59 | SZ | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| TOP05T: Time Entry |
| 13 | F06116 | Employee Transaction Detail File | 65 | YT | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 14 | F06116Z1 | Employee Transactions - Batch File | 79 | VL | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 15 | F06116Z2 | ESS Timecard History | 79 | VM | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 16 | F06278 | Retro Timecard Detail File | 65 | YT | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| TOP07: Payroll |
| 17 | F06270 | Retro Processing Parameter | 48 | JP | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 18 | F0701740 | Quantum Control Tax | 4 | YQ | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 19 | F0701741 | Canadian Deduction | 4 | YD | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 20 | F07107 | Employee Wage Attachment Rules | 25 | JW | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 21 | F07172 | ROE Max/Min | 2 | YD | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 22 | F074001 | New Hire Reporting Workfile - OneWorld Only | 44 | NH | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 23 | F07830 | Employee Federal Control Table | 82 | Y0 | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 24 | F07831 | Employee State/Local Control Table | 42 | YB | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 25 | F07832 | Employee Special Handling Control Table | 59 | YH | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 26 | F079320 | Wage Attachment Exemptions by Pay Frequency | 2 | WX | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 27 | F07UI200 | Timecard History Work File | 68 | TH | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 28 | F8907444 | New Hire Detail File Transfer - Texas (44) | 45 | TX | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| TOP08AD: ADP Integration |
| 29 | F05137 | ADP Employee Master Information | 18 | AD | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 30 | F051371 | ADP Employee DBA Instructions | 6 | AD | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 31 | F051372 | ADP Employee Job Master Information | 6 | AD | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 32 | F051373 | ADP Employee Auto Deposit Instructions | 6 | AD | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 33 | F051374 | ADP Employee Tax Withholding/Override Instructions | 6 | AD | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| TOP08B: Benefits Administration |
| 34 | F085573W | Entered Benefit Amount/Rate Edits | 3 | MM | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| TOP08P: Position Control |
| 35 | F08001 | Job information | 7 | JM | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| TOP08W: Wage and Salary |
| 36 | F08830WF | Compensation Root Work Table | 72 | YN | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| TOP18: Resource Scheduling |
| 37 | F186602 | Labor Rules Tag File | 75 | TF | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| TOP48S: Service Billing |
| 38 | F48S0618 | Payroll Reclassification Workfile | 65 | YT | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| TOP75A: Australia - Reporting System Only |
| 39 | F75A0500 | AU Bonus and Back Pay Tax Workfile | 13 | BP | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 40 | F75A0501 | AU Bonus and Back Pay Tax History | 13 | TH | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| TOP75Z: New Zealand - Reporting System Only |
| 41 | F75Z0002 | New Zealand Ledger Detail | 8 | Z2 | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| TOP77: Payroll (Canadian) |
| 42 | F06176 | Unemployment Insurance History File | 14 | YS | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
| 43 | F77173 | ROE Summary History Work File | 4 | JF | PFRQ | Pay Frequency | Character | UDC | 1 | 0 |
