| 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 | 21 | Y$ | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
2 | F0618 | Employee Transaction History | 46 | YT | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
3 | F0619 | Benefit/Accrual Detail File | 21 | Y$ | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
4 | F0709 | Deduction/Benefit/Accrual Ledger File | 26 | Y$ | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
TOP05T: Time Entry |
5 | F06116 | Employee Transaction Detail File | 46 | YT | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
6 | F06116Z1 | Employee Transactions - Batch File | 58 | VL | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
7 | F06116Z2 | ESS Timecard History | 58 | VM | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
8 | F06278 | Retro Timecard Detail File | 44 | YT | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
TOP07: Payroll |
9 | F06136 | Tax History | 66 | YZ | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
10 | F063106 | Deduction/Benefit Work File | 12 | Y7 | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
11 | F0719 | DBA Transaction Detail History | 26 | Y$ | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
12 | F07727 | Canadian Pension Information | 23 | J7 | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
13 | F07824 | Company State/Local Control Table | 13 | JD | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
14 | F07825 | Company Special Handling Control Table | 10 | JA | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
15 | F07831 | Employee State/Local Control Table | 21 | YB | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
16 | F07832 | Employee Special Handling Control Table | 11 | YH | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
17 | F07UI200 | Timecard History Work File | 49 | TH | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
TOP18: Resource Scheduling |
18 | F186602 | Labor Rules Tag File | 57 | TF | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
TOP48S: Service Billing |
19 | F48S0618 | Payroll Reclassification Workfile | 46 | YT | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
TOP77: Payroll (Canadian) |
20 | F0713 | Tax History | 66 | YZ | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
21 | F0713SAV | Backup Copy of F0713 For Tax Ledger Repost | 66 | YZ | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
22 | F0716 | Pay Check History Tax Ledger - Canadian DB | 21 | YV | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |
23 | F07183 | Commission History Detail File | 14 | ZB | WCNT | Work County | Numeric | Generic Edit | 3 | 0 |