| 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 | 55 | YM | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
2 | F0618 | Employee Transaction History | 85 | YT | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
TOP05A: OW HR & PR Foundation |
3 | F060116 | Employee Master Information | 76 | YA | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
4 | F0601161 | Point-In-Time Employee Master | 78 | PT | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
5 | F060116W | EE Master Request File | 76 | YA | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
6 | F060116Z | Unedited Quick Hire Transaction File | 102 | SZ | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
7 | F06345 | Historical Payroll Register | 14 | JL | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
TOP05T: Time Entry |
8 | F06116 | Employee Transaction Detail File | 85 | YT | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
9 | F06116Z1 | Employee Transactions - Batch File | 99 | VL | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
10 | F06278 | Retro Timecard Detail File | 85 | YT | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
11 | F060118 | Employee Jobs | 28 | YE | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
12 | F060119 | Employee Jobs History File | 29 | YE | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
TOP07: Payroll |
13 | F06156 | Pay Check History Summary | 36 | YU | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
14 | F06270 | Retro Processing Parameter | 50 | JP | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
15 | F063106 | Deduction/Benefit Work File | 15 | Y7 | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
16 | F06350I | WF - Paycheck (Interims) | 42 | Y4 | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
17 | F0716701 | Employee Assignment T/E Template Information | 38 | EA | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
18 | F0716709 | Employee Assignment T/E Template Info History | 38 | EA | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
19 | F0717 | ROE Summary History | 45 | JF | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
20 | F07350 | Payment File | 17 | Y0 | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
21 | F07UI200 | Timecard History Work File | 88 | TH | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
TOP08AD: ADP Integration |
22 | F051371 | ADP Employee DBA Instructions | 60 | AD | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
TOP08P: Position Control |
23 | F08001 | Job information | 38 | JM | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
TOP18: Resource Scheduling |
24 | F186301 | Timecard Templates | 12 | TT | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
25 | F186602 | Labor Rules Tag File | 94 | TF | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |
TOP48S: Service Billing |
26 | F48S0618 | Payroll Reclassification Workfile | 85 | YT | P002 | Category Codes - Payroll2 | String | UDC | 3 | 0 |