| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F0607 | Wage Attachment Ledger File | 13 | JI | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
2 | F0609 | Deduction/Benefit/Accrual Ledger File | 2 | Y$ | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
3 | F0618 | Employee Transaction History | 5 | YT | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
4 | F0619 | Benefit/Accrual Detail File | 2 | Y$ | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
5 | F0709 | Deduction/Benefit/Accrual Ledger File | 2 | Y$ | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
TOP05A: OW HR & PR Foundation |
6 | F06345 | Historical Payroll Register | 3 | JL | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
TOP05T: Time Entry |
7 | F06116 | Employee Transaction Detail File | 5 | YT | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
8 | F06116Z1 | Employee Transactions - Batch File | 22 | VL | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
9 | F06278 | Retro Timecard Detail File | 8 | YT | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
TOP07: Payroll |
10 | F06053 | Interim Check Parameters File | 13 | YW | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
11 | F06156 | Pay Check History Summary | 4 | YU | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
12 | F06166 | Pay Check History Tax Ledger | 3 | YV | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
13 | F06166A | Tax Ledger (Additional) | 2 | YV | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
14 | F06350I | WF - Paycheck (Interims) | 5 | Y4 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
15 | F0701740 | Quantum Control Tax | 6 | YQ | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
16 | F0701741 | Canadian Deduction | 6 | YD | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
17 | F0705 | DBA Period Control File | 10 | J@ | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
18 | F07149 | Accrual Fiscal/Anniversary History Work File | 20 | Y8 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
19 | F07186 | Stub Information History Table | 1 | Y8 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
20 | F071861 | Stub Detail Piece Rate History File | 1 | Y8 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
21 | F0719 | DBA Transaction Detail History | 2 | Y$ | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
22 | F0728 | Employee Paid Workers Compensation Transactions | 4 | YW | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
23 | F0729 | Employee DBA Override Instructions | 2 | Y9 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
24 | F07350 | Payment File | 2 | Y0 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
25 | F07351 | Payment Distribution File | 1 | Y1 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
26 | F07352 | Stub Information File | 1 | Y2 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
27 | F073521 | Stub Detail Piece Rate File | 1 | Y2 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
28 | F07353 | Tax Detail File | 2 | Y3 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
29 | F07355 | Pre-Payroll Error File | 26 | Y5 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
30 | F07UI200 | Timecard History Work File | 8 | TH | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
TOP08B: Benefits Administration |
31 | F08371 | Reimbursement Spending Account Claims File | 18 | B6 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
TOP08U: OW HR US |
32 | F08360 | Nondiscrimination Groups | 24 | HE | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
TOP18: Resource Scheduling |
33 | F186602 | Labor Rules Tag File | 19 | TF | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
TOP48S: Service Billing |
34 | F48S0618 | Payroll Reclassification Workfile | 5 | YT | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
TOP75A: Australia - Reporting System Only |
35 | F75A0005 | Coinage Details Work File | 2 | A5 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
36 | F75A0301 | Superannuation Payment | 5 | SA | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
TOP75Z: New Zealand - Reporting System Only |
37 | F75Z0002 | New Zealand Ledger Detail | 2 | Z2 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
38 | F75Z0009 | New Zealand Tax Detail Work File | 2 | TX | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
39 | F75Z0010 | New Zealand Tax Detail Tag Table | 2 | TD | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
TOP77: Payroll (Canadian) |
40 | F06176 | Unemployment Insurance History File | 3 | YS | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
41 | F0716 | Pay Check History Tax Ledger - Canadian DB | 3 | YV | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
42 | F07183 | Commission History Detail File | 2 | ZB | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
43 | F77703 | Payroll History Audit Report - Worktable | 11 | AR | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
TOP89: Conversion Programs |
44 | F07186T | Piece Rate History File | 1 | Y8 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |
45 | F07352T | Piece Rate Stub Detail Tag File | 1 | Y2 | CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 |