| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F0609 | Deduction/Benefit/Accrual Ledger File | 25 | Y$ | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
2 | F06106 | Employee Pay Instructions | 62 | YM | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
3 | F0618 | Employee Transaction History | 49 | YT | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
4 | F0619 | Benefit/Accrual Detail File | 25 | Y$ | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
5 | F0627 | Workers Compensation Summary History | 5 | JH | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
6 | F069126 | Union Rates File | 37 | YL | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
7 | F069216 | Workers Compensation Insurance Rates | 18 | YB | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
8 | F0709 | Deduction/Benefit/Accrual Ledger File | 30 | Y$ | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
TOP05A: OW HR & PR Foundation |
9 | F060116 | Employee Master Information | 123 | YA | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
10 | F0601161 | Point-In-Time Employee Master | 125 | PT | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
11 | F060116W | EE Master Request File | 123 | YA | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
12 | F060116Z | Unedited Quick Hire Transaction File | 65 | SZ | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
13 | F060119 | Employee Jobs History File | 17 | YE | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
TOP05T: Time Entry |
14 | F06116 | Employee Transaction Detail File | 49 | YT | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
15 | F06116Z1 | Employee Transactions - Batch File | 61 | VL | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
16 | F06116Z2 | ESS Timecard History | 61 | VM | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
17 | F06278 | Retro Timecard Detail File | 47 | YT | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
18 | F069136 | Tip Disbursement | 19 | JE | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
19 | F06918 | PF - Piece Rate File | 19 | JN | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
20 | F060118 | Employee Jobs | 16 | YE | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
TOP07: Payroll |
21 | F0716701 | Employee Assignment T/E Template Information | 35 | EA | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
22 | F0716709 | Employee Assignment T/E Template Info History | 35 | EA | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
23 | F0719 | DBA Transaction Detail History | 30 | Y$ | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
24 | F07UI200 | Timecard History Work File | 52 | TH | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
TOP08AD: ADP Integration |
25 | F051371 | ADP Employee DBA Instructions | 67 | AD | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
TOP08H: Health and Safety |
26 | F08601 | Injury/Illness Case Master | 8 | HL | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
TOP08P: Position Control |
27 | F08001 | Job information | 10 | JM | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
28 | F08005 | Business Unit/ Job Id. X-Ref | 7 | JV | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
TOP18: Resource Scheduling |
29 | F186602 | Labor Rules Tag File | 60 | TF | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
TOP48S: Service Billing |
30 | F48S0618 | Payroll Reclassification Workfile | 49 | YT | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
TOP54HS: Health & Safety Incident Mgt |
31 | F54HS02 | Incident People | 13 | S2 | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
32 | F54HS02M | Incident People Change History | 16 | I2 | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |
TOP77: Payroll (Canadian) |
33 | F07183 | Commission History Detail File | 18 | ZB | WET | Sub Class - Workers Comp | Character | UDC | 1 | 0 |