| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F0605 | D/B/A Period Control File | 5 | J@ | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
2 | F0609 | Deduction/Benefit/Accrual Ledger File | 3 | Y$ | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
3 | F0618 | Employee Transaction History | 59 | YT | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
4 | F0619 | Benefit/Accrual Detail File | 3 | Y$ | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
5 | F0709 | Deduction/Benefit/Accrual Ledger File | 3 | Y$ | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
TOP05T: Time Entry |
6 | F06116 | Employee Transaction Detail File | 59 | YT | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
7 | F06116Z1 | Employee Transactions - Batch File | 70 | VL | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
8 | F06116Z2 | ESS Timecard History | 70 | VM | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
9 | F06278 | Retro Timecard Detail File | 56 | YT | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
TOP07: Payroll |
10 | F06156 | Pay Check History Summary | 7 | YU | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
11 | F06166 | Pay Check History Tax Ledger | 12 | YV | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
12 | F06166A | Tax Ledger (Additional) | 15 | YV | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
13 | F06166B | Tax Ledger (PA ACT 32) | 14 | YV | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
14 | F0705 | DBA Period Control File | 5 | J@ | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
15 | F0719 | DBA Transaction Detail History | 3 | Y$ | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
16 | F07UI200 | Timecard History Work File | 62 | TH | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
TOP18: Resource Scheduling |
17 | F186602 | Labor Rules Tag File | 70 | TF | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
TOP48S: Service Billing |
18 | F48S0618 | Payroll Reclassification Workfile | 59 | YT | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
TOP76B: Brazil - Reporting System Only |
19 | F761BA | AS Fiscal file book - 09 | 100 | FB | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
TOP77: Payroll (Canadian) |
20 | F0716 | Pay Check History Tax Ledger - Canadian DB | 12 | YV | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
21 | F07183 | Commission History Detail File | 3 | ZB | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |
22 | F77703 | Payroll History Audit Report - Worktable | 8 | AR | HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 |