| 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 | 23 | Y$ | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
2 | F06106 | Employee Pay Instructions | 47 | YM | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
3 | F06107 | Employee Wage Attachment Rules | 26 | J$ | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
4 | F0619 | Benefit/Accrual Detail File | 23 | Y$ | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
5 | F0626 | Wage Attachment Control File | 4 | JG | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
6 | F069016 | Payroll Tax Area Profile | 6 | YP | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
7 | F069106 | Union Benefits Master | 26 | Y1 | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
8 | F069116 | Payroll Transaction Constants | 1 | YC | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
9 | F06925 | Employee/Vendor Cross Reference | 7 | YG | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
10 | F06926 | Tax Area/ Vendor Cross Reference | 4 | Y# | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
11 | F06927 | Payee Voucher Rules | 1 | J5 | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
12 | F0709 | Deduction/Benefit/Accrual Ledger File | 28 | Y$ | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
TOP05A: OW HR & PR Foundation |
13 | F060116 | Employee Master Information | 137 | YA | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
14 | F0601161 | Point-In-Time Employee Master | 139 | PT | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
15 | F060116W | EE Master Request File | 137 | YA | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
TOP05T: Time Entry |
16 | F06116 | Employee Transaction Detail File | 100 | YT | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
17 | F06116Z1 | Employee Transactions - Batch File | 114 | VL | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
18 | F06116Z2 | ESS Timecard History | 114 | VM | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
19 | F06278 | Retro Timecard Detail File | 100 | YT | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
TOP07: Payroll |
20 | F063106 | Deduction/Benefit Work File | 18 | Y7 | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
21 | F06490 | Payroll/Accounts Payable Ledger Detail | 3 | JR | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
22 | F06491 | Payroll/Accounts Payable Ledger Detail | 3 | J6 | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
23 | F06492 | Payroll - Accounts Payable Control | 3 | JC | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
24 | F07107 | Employee Wage Attachment Rules | 31 | JW | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
25 | F0716701 | Employee Assignment T/E Template Information | 33 | EA | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
26 | F0716709 | Employee Assignment T/E Template Info History | 33 | EA | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
27 | F0719 | DBA Transaction Detail History | 28 | Y$ | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
28 | F0729 | Employee DBA Override Instructions | 47 | Y9 | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
29 | F07355 | Pre-Payroll Error File | 19 | Y5 | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
30 | F07490 | Payroll - Accounts Payable Detail (One World) | 3 | JR | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
31 | F07491 | Payroll - Accounts Payable Summary File | 3 | J6 | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
32 | F07492 | Payroll - Accounts Payable Control File | 3 | JC | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
33 | F07845 | Fund Master | 3 | FZ | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
TOP08AD: ADP Integration |
34 | F051371 | ADP Employee DBA Instructions | 52 | AD | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
35 | F051375 | ADP Payroll DBA Transaction Constants | 3 | AD | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
TOP08B: Benefits Administration |
36 | F08320 | Benefits Plan Master | 4 | BA | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
37 | F08371 | Reimbursement Spending Account Claims File | 10 | B6 | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
TOP18: Resource Scheduling |
38 | F186602 | Labor Rules Tag File | 106 | TF | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |
TOP75A: Australia - Reporting System Only |
39 | F75A0301 | Superannuation Payment | 6 | SA | ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 |