| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP08: Human Resources |
| 1 | F0800603 | Job Group Competencies | 1 | JC | JGRP | Job Group | String | UDC | 6 | 0 |
| 2 | F0800612 | User Defined Job Competency Description Reference | 11 | JC | JGRP | Job Group | String | UDC | 6 | 0 |
| 3 | F08006WF | Job Competency Default Overrides Work File | 5 | JC | JGRP | Job Group | String | UDC | 6 | 0 |
| 4 | F087711 | CBPA Appraisal Header | 14 | XJ | JGRP | Job Group | String | UDC | 6 | 0 |
| 5 | F087711B | Performance Appraisal Header Template Keys | 6 | XK | JGRP | Job Group | String | UDC | 6 | 0 |
| 6 | F08776 | CBPA Appraisal Templates | 4 | XO | JGRP | Job Group | String | UDC | 6 | 0 |
| 7 | F08JDWF1 | Job Description Changes Integration Work File | 5 | JC | JGRP | Job Group | String | UDC | 6 | 0 |
| TOP08P: Position Control |
| 8 | F08001 | Job information | 1 | JM | JGRP | Job Group | String | UDC | 6 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 08 / JG (Job Groups) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | |
| 2 | ADMIN | Administrative | | |
| 3 | CMPSYS | Computer & Systems | | |
| 4 | CRAFT | Craft Workers - Skilled | | |
| 5 | EXEC | Executives | | |
| 6 | FINAN | Finance & Administration | | |
| 7 | LABOR | Laborer - Unskilled | | |
| 8 | MGR | Managers | | |
| 9 | MKTSLS | Marketing & Sales | | |
| 10 | OFFICE | Office/Clerical | | |
| 11 | OPER | Operations | | |
| 12 | PROF | Professional | | |
| 13 | SERVIC | Service Personnel | | |
| 14 | TECH | Technical Group | | |
| 15 | TRNG | Training Professionals | | |
