| 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 | 28 | YM | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
2 | F0618 | Employee Transaction History | 31 | YT | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
3 | F069126 | Union Rates File | 9 | YL | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
4 | F06936 | Retro Pay Types Rate | 15 | JA | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
TOP05A: OW HR & PR Foundation |
5 | F060116 | Employee Master Information | 42 | YA | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
6 | F0601161 | Point-In-Time Employee Master | 44 | PT | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
7 | F060116W | EE Master Request File | 42 | YA | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
TOP05T: Time Entry |
8 | F06116 | Employee Transaction Detail File | 31 | YT | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
9 | F06116Z1 | Employee Transactions - Batch File | 48 | VL | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
10 | F06278 | Retro Timecard Detail File | 34 | YT | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
TOP06: Payroll (old) - Obsolete-do not reuse |
11 | F060146 | Employees Pay Rate File | 10 | JI | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
TOP07: Payroll |
12 | F07UI200 | Timecard History Work File | 34 | TH | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
TOP08AD: ADP Integration |
13 | F051371 | ADP Employee DBA Instructions | 33 | AD | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
TOP17C: Call Management |
14 | F1760 | Time Entry | 21 | ZB | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
TOP18: Resource Scheduling |
15 | F186602 | Labor Rules Tag File | 43 | TF | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |
TOP48S: Service Billing |
16 | F48S0618 | Payroll Reclassification Workfile | 31 | YT | PBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 |