| 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 | 26 | YM | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
2 | F0618 | Employee Transaction History | 29 | YT | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
3 | F069126 | Union Rates File | 12 | YL | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
4 | F06936 | Retro Pay Types Rate | 16 | JA | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
TOP05A: PeopleSoft HR & PR Foundation |
5 | F060116 | Employee Master Information | 46 | YA | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
6 | F0601161 | Point-In-Time Employee Master | 48 | PT | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
7 | F060116W | EE Master Request File | 46 | YA | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
8 | F06345 | Historical Payroll Register | 44 | JL | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
TOP05T: Time Entry |
9 | F06116 | Employee Transaction Detail File | 29 | YT | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
10 | F06116Z1 | Employee Transactions - Batch File | 46 | VL | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
11 | F06116Z2 | ESS Timecard History | 46 | VM | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
12 | F06278 | Retro Timecard Detail File | 32 | YT | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
13 | F06918 | PF - Piece Rate File | 10 | JN | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
TOP06: Payroll (old) - Obsolete-do not reuse |
14 | F060146 | Employees Pay Rate File | 11 | JI | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
TOP07: Payroll |
15 | F06350I | WF - Paycheck (Interims) | 25 | Y4 | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
16 | F071861 | Stub Detail Piece Rate History File | 9 | Y8 | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
17 | F073521 | Stub Detail Piece Rate File | 9 | Y2 | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
18 | F07UI200 | Timecard History Work File | 32 | TH | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
TOP08AD: ADP Integration |
19 | F051371 | ADP Employee DBA Instructions | 31 | AD | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
TOP18: Timecard Automation |
20 | F186602 | Labor Rules Tag File | 41 | TF | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
TOP48S: Service Billing |
21 | F48S0618 | Payroll Reclassification Workfile | 29 | YT | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
TOP89: Conversion Programs |
22 | F07186T | Piece Rate History File | 9 | Y8 | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |
23 | F07352T | Piece Rate Stub Detail Tag File | 9 | Y2 | PPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 |