| 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 | 4 | EM | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |
TOP05A: OW HR & PR Foundation |
2 | F0601161 | Point-In-Time Employee Master | 1 | PT | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |
3 | F0601162 | Point-In-Time Employee Master Header | 1 | PH | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |
4 | F060116Z | Unedited Quick Hire Transaction File | 89 | SZ | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |
5 | F060119 | Employee Jobs History File | 60 | YE | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |
6 | F08042 | HR History | 6 | JW | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |
TOP05T: Time Entry |
7 | F051126 | Managers Delegates Setup File | 3 | Y6 | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
8 | F060118 | Employee Jobs | 59 | YE | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |
TOP07: Payroll |
9 | F07860 | Superannuation Date Tracking | 2 | ST | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |
TOP08: Human Resources |
10 | F08720 | Employee Status Change | 6 | SC | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |
11 | F08750 | Managers Delegates | 3 | MD | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |
TOP08AD: ADP Integration |
12 | F051372 | ADP Employee Job Master Information | 7 | AD | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |
TOP08R: Recruitment Management - (Appl. Track. & Req.) |
13 | F08045 | Employee Turnover Analysis | 4 | HT | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |
14 | F08402 | Applicant Master - Append Table | 2 | HA | EFTO | Date - Effective On | Date | Generic Edit | 6 | 0 |