| 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 | 27 | YM | BHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 |
2 | F0618 | Employee Transaction History | 30 | YT | BHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 |
TOP05A: OW HR & PR Foundation |
3 | F06345 | Historical Payroll Register | 42 | JL | BHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 |
TOP05T: Time Entry |
4 | F06116 | Employee Transaction Detail File | 30 | YT | BHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 |
5 | F06116Z1 | Employee Transactions - Batch File | 47 | VL | BHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 |
6 | F06116Z2 | ESS Timecard History | 47 | VM | BHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 |
7 | F06278 | Retro Timecard Detail File | 33 | YT | BHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 |
TOP07: Payroll |
8 | F079430 | Prevailing Wage Transaction Detail | 17 | PW | BHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 |
9 | F079440 | Prevailing Wage Transaction History | 16 | PW | BHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 |
10 | F07UI200 | Timecard History Work File | 33 | TH | BHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 |
TOP08AD: ADP Integration |
11 | F051371 | ADP Employee DBA Instructions | 32 | AD | BHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 |
TOP18: Resource Scheduling |
12 | F186602 | Labor Rules Tag File | 42 | TF | BHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 |
TOP48S: Service Billing |
13 | F48S0618 | Payroll Reclassification Workfile | 30 | YT | BHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 |