| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05A: PeopleSoft 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 |
