| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05: Time Accounting and HRM Base |
| 1 | F0618 | Employee Transaction History | 21 | YT | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| TOP05A: OW HR & PR Foundation |
| 2 | F060116 | Employee Master Information | 25 | YA | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 3 | F0601161 | Point-In-Time Employee Master | 27 | PT | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 4 | F060116W | EE Master Request File | 25 | YA | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 5 | F060116Z | Unedited Quick Hire Transaction File | 41 | SZ | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 6 | F06345 | Historical Payroll Register | 8 | JL | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 7 | F069056 | Establishment Constant File | 7 | YO | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| TOP05T: Time Entry |
| 8 | F06116 | Employee Transaction Detail File | 21 | YT | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 9 | F06116Z1 | Employee Transactions - Batch File | 38 | VL | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 10 | F06116Z2 | ESS Timecard History | 38 | VM | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 11 | F06278 | Retro Timecard Detail File | 24 | YT | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 12 | F069136 | Tip Disbursement | 28 | JE | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| TOP07: Payroll |
| 13 | F06156 | Pay Check History Summary | 29 | YU | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 14 | F06270 | Retro Processing Parameter | 42 | JP | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 15 | F063106 | Deduction/Benefit Work File | 6 | Y7 | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 16 | F06350I | WF - Paycheck (Interims) | 38 | Y4 | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 17 | F0716701 | Employee Assignment T/E Template Information | 36 | EA | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 18 | F0716709 | Employee Assignment T/E Template Info History | 36 | EA | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 19 | F0717 | ROE Summary History | 42 | JF | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 20 | F07350 | Payment File | 28 | Y0 | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 21 | F07830 | Employee Federal Control Table | 63 | Y0 | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 22 | F07831 | Employee State/Local Control Table | 39 | YB | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 23 | F07832 | Employee Special Handling Control Table | 25 | YH | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 24 | F07UI200 | Timecard History Work File | 24 | TH | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| TOP18: Resource Scheduling |
| 25 | F186301 | Timecard Templates | 16 | TT | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| 26 | F186602 | Labor Rules Tag File | 35 | TF | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
| TOP48S: Service Billing |
| 27 | F48S0618 | Payroll Reclassification Workfile | 21 | YT | MAIL | Routing Code - Check | String | UDC | 10 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
