| 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 | 7 | YM | PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 |
2 | F069106 | Union Benefits Master | 9 | Y1 | PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 |
TOP05A: OW HR & PR Foundation |
3 | F060116 | Employee Master Information | 64 | YA | PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 |
4 | F0601161 | Point-In-Time Employee Master | 66 | PT | PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 |
5 | F0601161 | Point-In-Time Employee Master | 63 | PT | DT | Date - Terminated | Date | Generic Edit | 6 | 0 |
6 | F060116W | EE Master Request File | 64 | YA | PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
7 | F060118 | Employee Jobs | 8 | YE | PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 |
8 | F060119 | Employee Jobs History File | 9 | YE | PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 |
TOP07: Payroll |
9 | F065016 | Automatic Bank Deposit Master | 14 | YG | PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 |
10 | F0729 | Employee DBA Override Instructions | 33 | Y9 | PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 |
TOP08: Human Resources |
11 | F082003 | Grade/Step Progression Detail File | 8 | YW | PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 |
TOP08AD: ADP Integration |
12 | F051371 | ADP Employee DBA Instructions | 12 | AD | PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 |
13 | F051373 | ADP Employee Auto Deposit Instructions | 9 | AD | PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 |
TOP08B: Benefits Administration |
14 | F08372 | FSA - Pay Instruction File | 7 | BM | PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 |