| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05A: OW HR & PR Foundation |
1 | F060116 | Employee Master Information | 138 | YA | PPNB | Pay Period Number | String | Generic Edit | 3 | 0 |
2 | F0601161 | Point-In-Time Employee Master | 140 | PT | PPNB | Pay Period Number | String | Generic Edit | 3 | 0 |
3 | F060116W | EE Master Request File | 138 | YA | PPNB | Pay Period Number | String | Generic Edit | 3 | 0 |
TOP07: Payroll |
4 | F06156 | Pay Check History Summary | 5 | YU | PPNB | Pay Period Number | String | Generic Edit | 3 | 0 |
5 | F06166 | Pay Check History Tax Ledger | 13 | YV | PPNB | Pay Period Number | String | Generic Edit | 3 | 0 |
6 | F06166A | Tax Ledger (Additional) | 16 | YV | PPNB | Pay Period Number | String | Generic Edit | 3 | 0 |
7 | F069066 | Pay Cycle Constant | 3 | JD | PPNB | Pay Period Number | String | Generic Edit | 3 | 0 |
8 | F0701740 | Quantum Control Tax | 5 | YQ | PPNB | Pay Period Number | String | Generic Edit | 3 | 0 |
9 | F0701741 | Canadian Deduction | 5 | YD | PPNB | Pay Period Number | String | Generic Edit | 3 | 0 |
10 | F07210 | Pay Cycle Parameters File | 35 | YD | PPNB | Pay Period Number | String | Generic Edit | 3 | 0 |
11 | F07353 | Tax Detail File | 25 | Y3 | PPNB | Pay Period Number | String | Generic Edit | 3 | 0 |
TOP77: Payroll (Canadian) |
12 | F0716 | Pay Check History Tax Ledger - Canadian DB | 13 | YV | PPNB | Pay Period Number | String | Generic Edit | 3 | 0 |