Refer to the tables in this topic for detailed information on key flexfield descriptions and lookups.
When you define the position key flexfield, you must define the following segments and then map these segments to the Organization Extra Information Type: US FEDERAL ORGANIZATION INFORMATION.
Value sets and Lookup Types must be used in the Position Key Flexfield segments as indicated in the following table.
See: Setting up the Position Flexfield
| Description | Lookup Type Name | Type | Req. |
|---|---|---|---|
| Position Title (map to GHR_US_ORG_INFORMATION) | GHR_US_POSITION_TITLE | X | * |
| Position Descrip Num (map to GHR_US_ORG_INFORMATION) | GHR_US_POS_DESC_NUM | X | * |
| Sequence Number (map to GHR_US_ORG_INFORMATION) | GHR_US_SEQUENCE_NUM | N | Not required for NFC implementations |
| Agency/Subelement Code (map to GHR_US_ORG_INFORMATION) | GHR_US_AGENCY_CODE | X | * |
| NFC Personnel Office ID | GHR_US_PERSONNEL_OFFICE_ID | X | Required only for NFC implementations |
| NFC Valid Grade | GHR_GRADES | X | Required only for NFC implementations |
| NFC Agency Code | GHR_US_NFC_AGENCY_CODE | X | Required only for NFC implementations |
The Oracle Federal Human Resource product requires the following segment be contained in the client's Job Key Flexfield. After defining the Job Key Flexfield, you map this segment to the Organization Extra Information Type: US FEDERAL ORGANIZATION INFORMATION.
See the Organization Extra Information Type: US FEDERAL ORGANIZATION INFORMATION for additional details about the Job Key Flexfield.
Value sets and Lookup Types must be used in the Job Key Flexfield segment as indicated in the following table. Value Sets and Lookup Types must contain the same name as indicated in the Lookup Type column.
See: Setting up the Job Flexfield
| Description | Lookup Type Name | Type | Req. | Remarks |
|---|---|---|---|---|
| Structure Name: (determined by client) | ||||
| Occupational Series (map to GHR_US_ORG_INFORMATION) | GHR_US_OCC_SERIES | X | * |
| Description | Lookup Type Name | Type | Req. | Remarks |
|---|---|---|---|---|
| Pay Plan | GHR_US_PAY_PALN | X | * | |
| Grade or Level | GHR_US_GRADE_OR_LEVEL | X | * |
There are no minimum requirements for the People Group Key Flexfield.
There are no minimum requirements for the Cost Allocation Key Flexfield.
The Personal Analysis Key Flexfields include the Special Information Types listed below.
| Description | Lookup Type Name | Type | Req. | Remarks |
|---|---|---|---|---|
| Education Level | GHR_US_EDUCATIONAL_LEVEL | X | none | none |
| Academic Discipline | GHR_US_ACADEMIC_DISCIPLINE | X | none | instructional program |
| Year Degree/Cert Attained | GHR_US_YEAR_DEGREE_ATTAINED | N | none | validation: none |
| Credit Hours | GHR_US_CREDIT_HOURS | N | none | validation: none |
| Credit Type | GHR_US_CREDIT_TYPE | X | none | none |
| Type of School | GHR_US_TYPE_OF_SCHOOL | X | none | none |
| College-Major-Minor | GHR_US_COLLEGE_MAJ_MIN | X | none | none |
| Academic Institution Name | GHR_US_ACADEMIC_INSTITUTION | X | none | none |
| Coop Graduation Date | FND_STANDARD_DATE | D | none | none |
| Description | Lookup Type Name | Type | Req. | Remarks |
|---|---|---|---|---|
| Drug Test Date | FND_STANDARD_DATE | D | none | none |
| Physical Exam or Test Type | GHR_US_PHYSICAL_EXAM | X | none | none |
| Physical Date | FND_STANDARD_DATE | D | none | none |
| Type of Occupational Cert | GHR_US_TYPE_OCC_CERT | X | none | none |
| Date Occupational Cert Issued | FND_STANDARD_DATE | D | none | none |
| Drug Test Notification Issued | D | none | none |
| Description | Lookup Type Name | Type | Req. | Remarks |
|---|---|---|---|---|
| Cause of Disciplinary Action | GHR_US_CAUSE_DISP_ACTION | X | none | none |
| Date of Adverse Action | FND_STANDARD_DATE | D | none | none |
| Days Suspended | GHR_US_DAYS_SUSPENDED | N | none | validation: none |
| Date Suspension Over 30 Days | FND_STANDARD_DATE | D | none | none |
| Date Suspension Under 30 Days | FND_STANDARD_DATE | D | none | none |
| PIP Action Taken | GHR_US_PIP_ACTION_TAKEN | X | none | none |
| PIP Beginning Date | FND_STANDARD_DATE | D | none | none |
| PIP Ending Date | FND_STANDARD_DATE | D | none | none |
| PIP Extensions | GHR_US_PIP_EXTENSIONS | X | none | validation: none |
| PIP Length | GHR_US_PIP_LENGTH | X | none | validation: none |
| Adverse Action NOAC | GHR_US_ADVERSE_ACTION_NOAC | X | none | display as first segment |
| Description | Lookup Type Name | Type | Req. | Remarks |
|---|---|---|---|---|
| Language Identifier | GHR_US_LANG_IDENTIFIER | X | none | none |
| Language Proficiency Source | GHR_US_LANG_PROF_SOURCE | X | none | none |
| Language Proficiency Level | GHR_US_LANG_PROF_LEVEL | X | none | none |
| Language Proficiency Test Date | FND_STANDARD_DATE | D | none | none |
| Language Evaluation Method | GHR_US_LANG_EVAL_METHOD | X | none | none |
| Language Reading Proficiency | GHR_US_LANG_PROF | X | none | none |
| Language Speaking Proficiency | GHR_US_LANG_PROF | X | none | none |
| Language Listening Proficiency | GHR_US_LANG_PROF | X | none | none |
| Language Writing Proficiency | GHR_US_LANG_PROF | X | none | none |
| Language Work Experience | GHR_LANG_WORK_EXP | X | none | none |
| Description | Lookup Type Name | Type | Req. | Remarks |
|---|---|---|---|---|
| Appraisal Type | GHR_US_APPRAISAL_TYPE | X | none | QBJ and QHJ |
| Rating of Record | GHR_US_RATING_OF_RECORD | X | none | QBC and QHC, validation: none |
| Date Effective | FND_STANDARD_DATE | D | none | QBB and QHB |
| Rating of Record Pattern | GHR_US_RATING_PATTERN | X | none | none |
| Rating of Record Level | GHR_US_RATING_LEVEL | X | none | none |
| Date Appraisal Period Starts | FND_STANDARD_DATE | D | none | none |
| Date Appraisal Period Ends | FND_STANDARD_DATE | D | none | none |
| Unit | GHR_US_UNIT | X | none | QBE and QHE, validation: none |
| Organization Structure ID | GHR_US_ORG_STRUCTURE_ID | X | none | validation: none |
| Office Symbol | GHR_US_OFFICE_SYMBOL | X | none | QBF and QHF, validation: none |
| Pay Plan | GHR_US_PAY_PLAN | X | none | QBH and QHH |
| Grade | GHR_US_GRADE_OR_LEVEL | X | none | QBG and QHG |
| Date Due | FND_STANDARD_DATE | D | none | none |
| Appraisal System Identifier | GHR_US_APPRAISAL_SYS_ID | X | none | validation: none |
| Date Initial Appraisal Due | FND_STANDARD_DATE | D | none | none |
| Optional Information | GHR_US_OPTNL_APPR_INFO | X | none | validatation: none |
| Performance Rating Points | GHR_US_PERF_RATING_POINTS | none | none | none |
| Description | Lookup Type Name | Type | Req. | Remarks |
|---|---|---|---|---|
| Spcl Plcmt Consid Reason | GHR_US_SPEC_PLCMT_CNSID_RSN | X | none | none |
| Date Prty Plcmt Consid Begins | FND_STANDARD_DATE | D | none | none |
| Date Prty Plcmt Consid Ends | FND_STANDARD_DATE | D | none | none |
| Spcl Pay Plan | GHR_US_PAY_PLAN | X | none | duplicate value set to Pay Plan under Grade |
| Spcl Grade | GHR_US_GRADE_OR_LEVEL | X | none | none |
| Spcl Plcmt Pay Plan - 1 | GHR_US_PAY_PLAN | X | none | duplicate value set to Pay Plan under Grade |
| Acceptable Grade - 1 | GHR_US_GRADE_OR_LEVEL | X | none | none |
| Spcl Plcmt Pay Plan - 2 | GHR_US_PAY_PLAN | X | none | duplicate value set to Pay Plan under Grade |
| Acceptable Grade - 2 | GHR_US_GRADE_OR_LEVEL | X | none | none |
| Spcl Plcmt Pay Plan - 3 | GHR_US_PAY_PLAN | X | none | duplicate value set to Pay Plan under Grade |
| Acceptable Grade - 3 | GHR_US_GRADE_OR_LEVEL | X | none | none |
| Spcl Plcmt Pay Plan - 4 | GHR_US_PAY_PLAN | X | none | duplicate value set to Pay Plan under Grade |
| Acceptable Grade - 4 | GHR_US_GRADE_OR_LEVEL | X | none | none |
| Date Reemployment Rights Expire | FND_STANDARD_DATE | D | none | none |