The following Value Sets and Lookup Types will be used in the Job and Position Key Flexfields. See the Position Key Flexfield and Job Key Flexfield for additional details.
| Description | Lookup Type Name | Type | Req. | Remarks |
|---|---|---|---|---|
| Occupational Series (map to Value Set GHR_US_JOB_KFF_SEGMENT) | sql script | X | X | field size in Job must be 4 |
| Position Title (map to Value Set GHR_US_POSITION_KFF_SEGMENT) | sql script | X | X | field size must be 60, validation: none |
| Position Descrip Num (map to Value Set GHR_US_POSITION_KFF_SEGMENT) | sql script | X | X | field size in Position must be 15, validation: none |
| Sequence Number (map to Value Set GHR_US_POSITION_KFF_SEGMENT) | sql script | N | field size in Position must be 15, validation: none | |
| Agency/Subelement Code (map to Value Set GHR_US_POSITION_KFF_SEGMENT) | sql script | X | X | DINs JRB and JRC, field size must be 4 |
| NFC Installed | YES_NO | X | ||
| NFC Personnel Office ID | GHR_US_PERSONNEL_OFFICE_ID | X | ||
| NFC Valid Code | X | |||
| NFC Agency Code | GHR_US_NFC_AGENCY_CODE | X |
The following is additional information about GHR_US_ORG_INFORMATION:
Occupational Series Value Set and Lookup Type: GHR_US_OCC_SERIES and its values are predefined (table "occcode").
Position Title Value Set: GHR_US_POSITION_TITLE is predefined but not its values.
Position Descrip Num Value Set: GHR_US_POS_DESC_NUM is predefined but not its values.
Sequence Number Value Set: GHR_US_SEQUENCE_NUM is predefined but not its values.
Agency/Subelement Code Value Set and Lookup Type: GHR_US_AGENCY_CODE and its values are predefined (table "255").
| Description | Lookup Type Name | Type | Req. | Remarks |
|---|---|---|---|---|
| Agency / Subelement Code | GHR_US_AGENCY_CODE | X | ||
| Organization Structure ID | GHR_US_ORG_STRUCTURE_ID | X | validation: none | |
| Org Info Line 1 | X | validation: none | ||
| Org Info Line 2 | X | validation: none | ||
| Org Info Line 3 | X | validation: none | ||
| Org Info Line 4 | X | validation: none | ||
| Org Info Line 5 | X | validation: none | ||
| Org Info Line 6 | X | validation: none | ||
| OCT Organizational Title | X | validation: none |