| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05A: 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 |
5 | F060119 | Employee Jobs History File | 21 | YE | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
6 | F060118 | Employee Jobs | 20 | YE | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
TOP08AD: ADP Integration |
7 | F05137 | ADP Employee Master Information | 16 | AD | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
TOP08P: Position Control |
8 | F08001 | Job information | 8 | JM | EEOJ | Job Category (EEO) | String | UDC | 3 | 0 |
TOP08R: 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.
TOPUDC 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 | 010 | 1st/Mid-Level Managers | | Y |
13 | 02 | Middle and Other Managers | | Y |
14 | 03 | Professionals | | Y |
15 | 04 | Semi-Professionals/Technicians | | Y |
16 | 05 | Supervisors-Clerical/Sales/Svc | | Y |
17 | 06 | Supervisors-Mfg/Proc/Trades | | Y |
18 | 07 | Administrative/Senior Clerical | | Y |
19 | 08 | Sales and Service | | Y |
20 | 09 | Skilled Crafts and Trades | | Y |
21 | 10 | Clerical Workers | | Y |
22 | 11 | Sales and Service | | Y |
23 | 12 | Semi-Skilled Manual Workers | | Y |
24 | 13 | Sales and Service | | Y |
25 | 14 | Other Manual Workers | | Y |
26 | 501 | Officials, Admins, Managers | | Y |
27 | 502 | Principals | | Y |
28 | 503 | Asst. Principals, Teaching | | Y |
29 | 504 | Asst. Principals, Non-Teaching | | Y |
30 | 505 | Elementary Classroom Teachers | | Y |
31 | 506 | Secondary Classroom Teachers | | Y |
32 | 507 | Other Classroom Teachers | | Y |
33 | 508 | Guidance | | Y |
34 | 509 | Psychological | | Y |
35 | 510 | Librarians/Audio-Visual Staff | | Y |
36 | 511 | Consultants/Supervisors | | Y |
37 | 512 | Other Professional Staff | | Y |
38 | 513 | Teacher Aides | | Y |
39 | 514 | Technicians | | Y |
40 | 515 | Clerical/Secretarial Staff | | Y |
41 | 516 | Service Workers | | Y |
42 | 517 | Skilled Crafts | | Y |
43 | 518 | Laborers: Unskilled | | Y |
44 | A | Officials and Administrators | | Y |
45 | B | Professionals | | Y |
46 | C | Technicians | | Y |
47 | D | Protective Service Workers | | Y |
48 | E | Paraprofessionals | | Y |
49 | F | Administrative Support | | Y |
50 | G | Skilled Craft Workers | | Y |
51 | H | Service-Maintenance | | Y |