| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F050116W | Employee Master Integrations Work File | 18 | EM | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
2 | F06106 | Employee Pay Instructions | 6 | YM | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
3 | F069106 | Union Benefits Master | 8 | Y1 | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
TOP05A: OW HR & PR Foundation |
4 | F060116 | Employee Master Information | 63 | YA | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
5 | F0601161 | Point-In-Time Employee Master | 65 | PT | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
6 | F060116W | EE Master Request File | 63 | YA | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
7 | F060116Z | Unedited Quick Hire Transaction File | 46 | SZ | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
8 | F060119 | Employee Jobs History File | 8 | YE | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
9 | F060118 | Employee Jobs | 7 | YE | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
TOP07: Payroll |
10 | F065016 | Automatic Bank Deposit Master | 13 | YG | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
11 | F0729 | Employee DBA Override Instructions | 32 | Y9 | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
TOP08AD: ADP Integration |
12 | F05137 | ADP Employee Master Information | 38 | AD | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
13 | F051371 | ADP Employee DBA Instructions | 11 | AD | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
14 | F051373 | ADP Employee Auto Deposit Instructions | 8 | AD | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
TOP08B: Benefits Administration |
15 | F08372 | FSA - Pay Instruction File | 6 | BM | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |
TOP75A: Australia - Reporting System Only |
16 | F75A0009 | Employee DBA Instructions | 3 | A9 | PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 |