| 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: PeopleSoft 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 |
| TOP08AD: ADP Integration |
| 9 | F05137 | ADP Employee Master Information | 8 | AD | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
| TOP08B: Benefits Administration |
| 10 | F08901 | Participant file | 6 | HU | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
| TOP08C: PeopleSoft HR Canadian |
| 11 | F08022 | Canadian Employment Equity Workfile | 4 | YZ | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
| TOP08R: Recruitment Management - (Appl. Track. & Req.) |
| 12 | F08401 | Applicant Master | 11 | HA | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
| 13 | F08401WF | Applicant Work File | 12 | XN | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
| TOP54HS: Health & Safety Incident Mgt |
| 14 | F54HS02 | Incident People | 24 | S2 | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
| 15 | F54HS02M | Incident People Change History | 27 | I2 | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
| TOP74: EMEA Localization |
| 16 | F0091 | A/B Vendor Information for Year-end IVA tape - Italy | 4 | IF | SEX | Gender (Male/Female) | Character | UDC | 1 | 0 |
| TOP74Y: Italy |
| 17 | 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.
