| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05: Time Accounting and HRM Base |
| 1 | F06106 | Employee Pay Instructions | 54 | YM | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 2 | F0618 | Employee Transaction History | 84 | YT | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| TOP05A: PeopleSoft HR & PR Foundation |
| 3 | F060116 | Employee Master Information | 75 | YA | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 4 | F0601161 | Point-In-Time Employee Master | 77 | PT | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 5 | F060116W | EE Master Request File | 75 | YA | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 6 | F060116Z | Unedited Quick Hire Transaction File | 101 | SZ | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 7 | F060119 | Employee Jobs History File | 28 | YE | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 8 | F06345 | Historical Payroll Register | 13 | JL | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| TOP05T: Time Entry |
| 9 | F06116 | Employee Transaction Detail File | 84 | YT | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 10 | F06116Z1 | Employee Transactions - Batch File | 98 | VL | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 11 | F06116Z2 | ESS Timecard History | 98 | VM | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 12 | F06278 | Retro Timecard Detail File | 84 | YT | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| TOP06: Payroll (old) - Obsolete-do not reuse |
| 13 | F060118 | Employee Jobs | 27 | YE | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| TOP07: Payroll |
| 14 | F06156 | Pay Check History Summary | 35 | YU | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 15 | F06270 | Retro Processing Parameter | 49 | JP | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 16 | F063106 | Deduction/Benefit Work File | 14 | Y7 | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 17 | F06350I | WF - Paycheck (Interims) | 41 | Y4 | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 18 | F0716701 | Employee Assignment T/E Template Information | 37 | EA | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 19 | F0716709 | Employee Assignment T/E Template Info History | 37 | EA | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 20 | F0717 | ROE Summary History | 44 | JF | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 21 | F07350 | Payment File | 16 | Y0 | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 22 | F07UI200 | Timecard History Work File | 87 | TH | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| TOP08AD: ADP Integration |
| 23 | F051371 | ADP Employee DBA Instructions | 59 | AD | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| TOP08P: Position Control |
| 24 | F08001 | Job information | 37 | JM | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| TOP18: Timecard Automation |
| 25 | F186301 | Timecard Templates | 11 | TT | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| 26 | F186602 | Labor Rules Tag File | 93 | TF | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
| TOP48S: Service Billing |
| 27 | F48S0618 | Payroll Reclassification Workfile | 84 | YT | P001 | Category Codes - Payroll1 | String | UDC | 3 | 0 |
