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