| 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 | 24 | Y$ | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
2 | F06106 | Employee Pay Instructions | 19 | YM | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
3 | F0618 | Employee Transaction History | 48 | YT | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
4 | F0619 | Benefit/Accrual Detail File | 24 | Y$ | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
5 | F0627 | Workers Compensation Summary History | 4 | JH | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
6 | F069126 | Union Rates File | 22 | YL | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
7 | F069216 | Workers Compensation Insurance Rates | 7 | YB | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
8 | F0709 | Deduction/Benefit/Accrual Ledger File | 29 | Y$ | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
TOP05A: OW HR & PR Foundation |
9 | F060116 | Employee Master Information | 37 | YA | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
10 | F0601161 | Point-In-Time Employee Master | 39 | PT | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
11 | F060116W | EE Master Request File | 37 | YA | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
12 | F060116Z | Unedited Quick Hire Transaction File | 64 | SZ | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
TOP05T: Time Entry |
13 | F06116 | Employee Transaction Detail File | 48 | YT | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
14 | F06116Z1 | Employee Transactions - Batch File | 60 | VL | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
15 | F06278 | Retro Timecard Detail File | 46 | YT | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
16 | F069136 | Tip Disbursement | 18 | JE | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
17 | F06918 | PF - Piece Rate File | 18 | JN | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
18 | F060118 | Employee Jobs | 15 | YE | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
19 | F060119 | Employee Jobs History File | 16 | YE | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
TOP07: Payroll |
20 | F0716701 | Employee Assignment T/E Template Information | 34 | EA | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
21 | F0716709 | Employee Assignment T/E Template Info History | 34 | EA | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
22 | F0719 | DBA Transaction Detail History | 29 | Y$ | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
23 | F07880 | SUI Magnetic Media Workfile | 42 | YW | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
24 | F07UI200 | Timecard History Work File | 51 | TH | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
TOP08AD: ADP Integration |
25 | F05137 | ADP Employee Master Information | 28 | AD | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
26 | F051371 | ADP Employee DBA Instructions | 24 | AD | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
TOP08H: Health and Safety |
27 | F08601 | Injury/Illness Case Master | 7 | HL | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
TOP08P: Position Control |
28 | F08001 | Job information | 9 | JM | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
29 | F08005 | Business Unit/ Job Id. X-Ref | 6 | JV | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
TOP09: General Accounting |
30 | F0901 | Account Master | 39 | GM | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
TOP18: Resource Scheduling |
31 | F186602 | Labor Rules Tag File | 59 | TF | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
TOP48S: Service Billing |
32 | F48S0618 | Payroll Reclassification Workfile | 48 | YT | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
TOP51: Job Costing |
33 | F5109 | Chart Type Master | 8 | GJ | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |
TOP77: Payroll (Canadian) |
34 | F07183 | Commission History Detail File | 17 | ZB | WCMP | Worker's Comp. Insurance Code | String | UDC | 4 | 0 |