| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F054101 | Employee Personal Profile Information History Table | 35 | EH | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
2 | F054101W | Employee Personal Profile Information Work Table | 31 | EP | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
TOP05A: OW HR & PR Foundation |
3 | F060116 | Employee Master Information | 5 | YA | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
4 | F0601161 | Point-In-Time Employee Master | 7 | PT | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
5 | F060116W | EE Master Request File | 5 | YA | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
6 | F060116Z | Unedited Quick Hire Transaction File | 31 | SZ | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
TOP07: Payroll |
7 | F074001 | New Hire Reporting Workfile - OneWorld Only | 48 | NH | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
8 | F07880 | SUI Magnetic Media Workfile | 38 | YW | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
TOP08A: eRecruit |
9 | F08492 | EEO Survey | 4 | EO | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
TOP08AD: ADP Integration |
10 | F05137 | ADP Employee Master Information | 8 | AD | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
TOP08B: Benefits Administration |
11 | F08901 | Participant file | 6 | HU | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
TOP08C: OW HR Canadian |
12 | F08022 | Canadian Employment Equity Workfile | 4 | YZ | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
TOP08R: Recruitment Management - (Appl. Track. & Req.) |
13 | F08401 | Applicant Master | 11 | HA | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
14 | F08401WF | Applicant Work File | 12 | XN | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
TOP54HS: Health & Safety Incident Mgt |
15 | F54HS02 | Incident People | 23 | S2 | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
16 | F54HS02M | Incident People Change History | 26 | I2 | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
TOP74: EMEA Localization |
17 | F0091 | A/B Vendor Information for Year-end IVA tape - Italy | 4 | IF | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
TOP74Y: Italy - Reporting System Only |
18 | F74Y0101 | Address Book Italian Tag File - ITA - 01 | 4 | RI | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.