| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05: Time Accounting and HRM Base |
| 1 | F05100 | Resource Competency | 4 | CM | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 2 | F05100Z1 | Resource Competencies Unedited Transactions File | 11 | CU | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 3 | F05104 | Competency Master | 2 | CM | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 4 | F05105 | Goal Suggestions | 3 | GS | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 5 | F05106 | Competency Update Events | 4 | CU | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 6 | F05107 | Competency Update Approval Routing | 3 | CU | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 7 | F05107A | Competency Update Approval Routing Tag File | 3 | CU | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 8 | F05111 | Training/Development | 2 | CT | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 9 | F05112 | Skills/Resources | 3 | ST | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 10 | F05113 | Accomplishments | 2 | AT | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 11 | F05114 | Certifications | 3 | CT | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 12 | F05115 | Education | 2 | ET | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 13 | F05116 | Languages | 3 | LT | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 14 | F05117 | Goal Action Plan | 10 | GL | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 15 | F05118 | Aggregate Competencies | 3 | AC | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 16 | F05120 | Competency History | 4 | MM | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 17 | F05121 | Competency/Course | 4 | CR | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 18 | F051422 | Competency Words | 2 | CW | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 19 | F05153WF | Results Work File Competency Detail | 4 | WF | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 20 | F05154WF | Results Work File Competency Words Detail | 4 | WF | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| TOP08: Human Resources |
| 21 | F0800606 | Competency Options - Overrides | 7 | JC | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 22 | F0800609 | Gap Analysis Snapshot | 16 | YI | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 23 | F08JDWF2 | Job Description History Integration Work File | 9 | JH | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| TOP13R: Resource Assignments |
| 24 | F48311 | Resource Assignments | 15 | RA | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 25 | F48311S | Purge - Resource Assignments | 15 | RA | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| TOP17: Customer Service Management |
| 26 | F3112Z2 | Warranty Claim/Supplier Recovery processing | 116 | WL | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| TOP30: Product Data Management |
| 27 | F300311 | Lean Multi-Level Routing Detail File | 43 | EH | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 28 | F3003Z1 | Routing Transactions File | 82 | SZ | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| TOP31: Shop Floor Control |
| 29 | F3112 | Work Order Routing | 102 | WL | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 30 | F3112S | Purge Shop Floor Control Routing Instructions | 102 | WL | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 31 | F3112Z1 | Outbound Work Order Routings | 116 | SZ | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| TOP40: Inventory/OP Base |
| 32 | F3003 | Routing Master File | 68 | IR | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| TOPF30L: DFM Line Design |
| 33 | FF30L930 | DFM Routings | 68 | LR | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| TOPF31: Lean Transactions |
| 34 | FF31112 | Routing Transaction Table | 55 | EH | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
| 35 | FF31112S | Purge - Routing Transaction Table | 55 | ET | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
