08: Human Resources |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 920 | F08JDWF2 | JH | 26 | 3 | Job Description History Integration Work File | Files | 08: Human Resources | |
Number | Description |
---|
1 | JobDescriptionHistory (Primary/Unique) |
| Element | Alias | Description | Sequence |
---|
1 | OTPS | Organization Type Structure | Ascending | 2 | ORMCU | Organizational Business Unit | Ascending | 3 | JBCD | Job Type (Craft) Code | Ascending | 4 | JBST | Job Step | Ascending | 5 | JCC | Job Competency Code | Ascending | 6 | RULEN | Rule Number | Ascending |
|
2 | Org Type Org Bus Unit + |
| Element | Alias | Description | Sequence |
---|
1 | OTPS | Organization Type Structure | Ascending | 2 | ORMCU | Organizational Business Unit | Ascending | 3 | JBCD | Job Type (Craft) Code | Ascending | 4 | JBST | Job Step | Ascending | 5 | EFT | Date - Effective | Descending |
|
3 | Org Type Org Bus Unit B+ |
| Element | Alias | Description | Sequence |
---|
1 | OTPS | Organization Type Structure | Ascending | 2 | ORMCU | Organizational Business Unit | Ascending | 3 | JBCD | Job Type (Craft) Code | Ascending | 4 | JBST | Job Step | Ascending | 5 | JCC | Job Competency Code | Ascending | 6 | COPTN | Option Number | Ascending | 7 | CMPE | Competency Type | Ascending | 8 | CMPC | Competency Code | Ascending |
|