| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 05A: OW HR & PR Foundation | ||||||||||
| 1 | F060116 | Employee Master Information | 34 | YA | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
| 2 | F0601161 | Point-In-Time Employee Master | 36 | PT | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
| 3 | F060116W | EE Master Request File | 34 | YA | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
| 4 | F060116Z | Unedited Quick Hire Transaction File | 68 | SZ | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
| 06: Payroll (old) - Obsolete-do not reuse | ||||||||||
| 5 | F060118 | Employee Jobs | 20 | YE | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
| 6 | F060119 | Employee Jobs History File | 21 | YE | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
| 08AD: ADP Integration | ||||||||||
| 7 | F05137 | ADP Employee Master Information | 16 | AD | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
| 08P: Position Control | ||||||||||
| 8 | F08001 | Job information | 8 | JM | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
| 08R: Recruitment Management - (Appl. Track. & Req.) | ||||||||||
| 9 | F08401 | Applicant Master | 9 | HA | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
| 10 | F08401WF | Applicant Work File | 10 | XN | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 06 / J (EEO Job Codes (Edit)) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | . | N | ||
| 2 | 001 | Officials and Managers | Y | |
| 3 | 002 | Professionals | Y | |
| 4 | 003 | Technicians | Y | |
| 5 | 004 | Sales | Y | |
| 6 | 005 | Office and Clerical | Y | |
| 7 | 006 | Craft Workers (Skilled) | Y | |
| 8 | 007 | Operatives (Semiskilled) | Y | |
| 9 | 008 | Laborers (Unskilled) | Y | |
| 10 | 009 | Service Workers | Y | |
| 11 | 01 | Senior Managers | Y | |
| 12 | 02 | Middle and Other Managers | Y | |
| 13 | 03 | Professionals | Y | |
| 14 | 04 | Semi-Professionals/Technicians | Y | |
| 15 | 05 | Supervisors-Clerical/Sales/Svc | Y | |
| 16 | 06 | Supervisors-Mfg/Proc/Trades | Y | |
| 17 | 07 | Administrative/Senior Clerical | Y | |
| 18 | 08 | Sales and Service | Y | |
| 19 | 09 | Skilled Crafts and Trades | Y | |
| 20 | 10 | Clerical Workers | Y | |
| 21 | 11 | Sales and Service | Y | |
| 22 | 12 | Semi-Skilled Manual Workers | Y | |
| 23 | 13 | Sales and Service | Y | |
| 24 | 14 | Other Manual Workers | Y | |
| 25 | 501 | Officials, Admins, Managers | Y | |
| 26 | 502 | Principals | Y | |
| 27 | 503 | Asst. Principals, Teaching | Y | |
| 28 | 504 | Asst. Principals, Non-Teaching | Y | |
| 29 | 505 | Elementary Classroom Teachers | Y | |
| 30 | 506 | Secondary Classroom Teachers | Y | |
| 31 | 507 | Other Classroom Teachers | Y | |
| 32 | 508 | Guidance | Y | |
| 33 | 509 | Psychological | Y | |
| 34 | 510 | Librarians/Audio-Visual Staff | Y | |
| 35 | 511 | Consultants/Supervisors | Y | |
| 36 | 512 | Other Professional Staff | Y | |
| 37 | 513 | Teacher Aides | Y | |
| 38 | 514 | Technicians | Y | |
| 39 | 515 | Clerical/Secretarial Staff | Y | |
| 40 | 516 | Service Workers | Y | |
| 41 | 517 | Skilled Crafts | Y | |
| 42 | 518 | Laborers: Unskilled | Y | |
| 43 | A | Officials and Administrators | Y | |
| 44 | B | Professionals | Y | |
| 45 | C | Technicians | Y | |
| 46 | D | Protective Service Workers | Y | |
| 47 | E | Paraprofessionals | Y | |
| 48 | F | Administrative Support | Y | |
| 49 | G | Skilled Craft Workers | Y | |
| 50 | H | Service-Maintenance | Y |