| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05: Time Accounting and HRM Base |
| 1 | F05100 | Resource Competency | 3 | CM | CMPE | Competency Type | String | UDC | 3 | 0 |
| 2 | F05100Z1 | Resource Competencies Unedited Transactions File | 10 | CU | CMPE | Competency Type | String | UDC | 3 | 0 |
| 3 | F05104 | Competency Master | 1 | CM | CMPE | Competency Type | String | UDC | 3 | 0 |
| 4 | F05105 | Goal Suggestions | 2 | GS | CMPE | Competency Type | String | UDC | 3 | 0 |
| 5 | F05106 | Competency Update Events | 3 | CU | CMPE | Competency Type | String | UDC | 3 | 0 |
| 6 | F05107 | Competency Update Approval Routing | 2 | CU | CMPE | Competency Type | String | UDC | 3 | 0 |
| 7 | F05107A | Competency Update Approval Routing Tag File | 2 | CU | CMPE | Competency Type | String | UDC | 3 | 0 |
| 8 | F05117 | Goal Action Plan | 9 | GL | CMPE | Competency Type | String | UDC | 3 | 0 |
| 9 | F05118 | Aggregate Competencies | 2 | AC | CMPE | Competency Type | String | UDC | 3 | 0 |
| 10 | F05120 | Competency History | 3 | MM | CMPE | Competency Type | String | UDC | 3 | 0 |
| 11 | F05121 | Competency/Course | 3 | CR | CMPE | Competency Type | String | UDC | 3 | 0 |
| 12 | F051422 | Competency Words | 1 | CW | CMPE | Competency Type | String | UDC | 3 | 0 |
| 13 | F051424 | Competency Detail UDC Words | 1 | CD | CMPE | Competency Type | String | UDC | 3 | 0 |
| 14 | F051425 | Competency Detail Words | 1 | CD | CMPE | Competency Type | String | UDC | 3 | 0 |
| 15 | F05153WF | Results Work File Competency Detail | 3 | WF | CMPE | Competency Type | String | UDC | 3 | 0 |
| 16 | F05154WF | Results Work File Competency Words Detail | 3 | WF | CMPE | Competency Type | String | UDC | 3 | 0 |
| TOP08: Human Resources |
| 17 | F0800606 | Competency Options - Overrides | 6 | JC | CMPE | Competency Type | String | UDC | 3 | 0 |
| 18 | F0800609 | Gap Analysis Snapshot | 14 | YI | CMPE | Competency Type | String | UDC | 3 | 0 |
| 19 | F08JDWF2 | Job Description History Integration Work File | 8 | JH | CMPE | Competency Type | String | UDC | 3 | 0 |
| TOP13R: Resource Assignments |
| 20 | F48311 | Resource Assignments | 14 | RA | CMPE | Competency Type | String | UDC | 3 | 0 |
| 21 | F48311S | Purge - Resource Assignments | 14 | RA | CMPE | Competency Type | String | UDC | 3 | 0 |
| TOP17: Customer Service Management |
| 22 | F3112Z2 | Warranty Claim/Supplier Recovery processing | 115 | WL | CMPE | Competency Type | String | UDC | 3 | 0 |
| TOP30: Product Data Management |
| 23 | F300311 | Lean Multi Level Routing Detail File | 42 | EH | CMPE | Competency Type | String | UDC | 3 | 0 |
| 24 | F3003Z1 | Routing Transactions File | 81 | SZ | CMPE | Competency Type | String | UDC | 3 | 0 |
| TOP31: Shop Floor Control |
| 25 | F3112 | Work Order Routing | 101 | WL | CMPE | Competency Type | String | UDC | 3 | 0 |
| 26 | F3112S | Purge Shop Floor Control Routing Instructions | 101 | WL | CMPE | Competency Type | String | UDC | 3 | 0 |
| 27 | F3112Z1 | Outbound Work Order Routings | 115 | SZ | CMPE | Competency Type | String | UDC | 3 | 0 |
| TOP40: Inventory/OP Base |
| 28 | F3003 | Routing Master File | 67 | IR | CMPE | Competency Type | String | UDC | 3 | 0 |
| TOPF30L: DFM Line Design |
| 29 | FF30L930 | DFM Routings | 67 | LR | CMPE | Competency Type | String | UDC | 3 | 0 |
| TOPF31: Lean Transactions |
| 30 | FF31112 | Routing Transaction Table | 58 | EH | CMPE | Competency Type | String | UDC | 3 | 0 |
| 31 | FF31112S | Purge - Routing Transaction Table | 58 | ET | CMPE | Competency Type | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
