| 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 | F080434A | Veteran Employment Reporting | 19 | VT | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
24 | F080434B | Veterans Employment Reporting (VETS 100A) | 19 | VE | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
25 | F08JDWF2 | Job Description History Integration Work File | 9 | JH | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
TOP08A: eRecruit |
26 | F08471 | Job Posting Competencies | 3 | PC | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
TOP13R: Resource Assignments |
27 | F48311 | Resource Assignments | 15 | RA | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
28 | F48311S | Purge - Resource Assignments | 15 | RA | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
TOP17: Customer Service Management |
29 | F3112Z2 | Warranty Claim/Supplier Recovery processing | 116 | WL | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
TOP30: Product Data Management |
30 | F300311 | Lean Multi-Level Routing Detail File | 43 | EH | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
31 | F3003Z1 | Routing Transactions File | 82 | SZ | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
TOP31: Shop Floor Control |
32 | F3112 | Work Order Routing | 102 | WL | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
33 | F3112S | Purge Shop Floor Control Routing Instructions | 102 | WL | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
34 | F3112Z1 | Outbound Work Order Routings | 116 | SZ | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
TOP40: Inventory/OP Base |
35 | F3003 | Routing Master File | 68 | IR | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
TOPF30L: DFM Line Design |
36 | FF30L930 | DFM Routings | 68 | LR | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
TOPF31: Lean Transactions |
37 | FF31112 | Routing Transaction Table | 55 | EH | CMPC | Competency Code | String | Generic Edit | 10 | 0 |
38 | FF31112S | Purge - Routing Transaction Table | 55 | ET | CMPC | Competency Code | String | Generic Edit | 10 | 0 |