HR POSITION FULL HISTORY Table
View exposing historical comprehensive HR position data including position identifiers, titles, organizational relationships, job attributes, and period-based reporting fields used for workforce history analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AAP_CATEGORY |
Column AAP_CATEGORY. |
VARCHAR2 |
360 |
AAP_CATEGORY_CODE |
Column AAP_CATEGORY_CODE. |
VARCHAR2 |
48 |
BENEFITS_ELIGIBILITY |
Column BENEFITS_ELIGIBILITY. |
VARCHAR2 |
240 |
BENEFITS_ELIGIBILITY_CODE |
Column BENEFITS_ELIGIBILITY_CODE. |
VARCHAR2 |
36 |
COMPENSATE_FREQUENCY |
Column COMPENSATE_FREQUENCY. |
VARCHAR2 |
240 |
COMPENSATE_FREQUENCY_CODE |
Column COMPENSATE_FREQUENCY_CODE. |
VARCHAR2 |
36 |
COST_PLANNING_TYPE |
Column COST_PLANNING_TYPE. |
VARCHAR2 |
168 |
EEO_CATEGORY |
Column EEO_CATEGORY. |
VARCHAR2 |
360 |
EEO_CATEGORY_CODE |
Column EEO_CATEGORY_CODE. |
VARCHAR2 |
36 |
EMPLOYEE_GROUP |
Column EMPLOYEE_GROUP. |
VARCHAR2 |
240 |
EMPLOYEE_GROUP_CODE |
Column EMPLOYEE_GROUP_CODE. |
VARCHAR2 |
12 |
EMPLOYEE_SUBGROUP |
Column EMPLOYEE_SUBGROUP. |
VARCHAR2 |
240 |
EMPLOYEE_SUBGROUP_CODE |
Column EMPLOYEE_SUBGROUP_CODE. |
VARCHAR2 |
24 |
EMPLOYEE_TYPE |
Column EMPLOYEE_TYPE. |
VARCHAR2 |
360 |
ESTIMATED_BUDGET_TYPE |
Column ESTIMATED_BUDGET_TYPE. |
VARCHAR2 |
300 |
ESTIMATED_BUDGET_TYPE_CODE |
Column ESTIMATED_BUDGET_TYPE_CODE. |
VARCHAR2 |
36 |
GL_ACCOUNT_ID |
Column GL_ACCOUNT_ID. |
VARCHAR2 |
72 |
GL_ACCOUNT_NAME |
Column GL_ACCOUNT_NAME. |
VARCHAR2 |
600 |
HR_ORG_UNIT_KEY |
Column HR_ORG_UNIT_KEY. |
VARCHAR2 |
120 |
HR_POSITION_FP_KEY |
Column HR_POSITION_FP_KEY. |
VARCHAR2 |
168 |
IS_ADDITION_TO_HEADCOUNT |
Column IS_ADDITION_TO_HEADCOUNT. |
VARCHAR2 |
36 |
IS_APPROVED |
Column IS_APPROVED. |
VARCHAR2 |
12 |
IS_EXEMPT |
Column IS_EXEMPT. |
VARCHAR2 |
12 |
IS_SHIFT_ELIGIBLE |
Column IS_SHIFT_ELIGIBLE. |
VARCHAR2 |
12 |
IS_VACANT |
Column IS_VACANT. |
VARCHAR2 |
12 |
JOB_DESCRIPTION_FLAG |
Column JOB_DESCRIPTION_FLAG. |
VARCHAR2 |
12 |
JOB_FAMILY |
Column JOB_FAMILY. |
VARCHAR2 |
480 |
JOB_FAMILY_CODE |
Column JOB_FAMILY_CODE. |
VARCHAR2 |
36 |
JOB_TITLE |
Column JOB_TITLE. |
VARCHAR2 |
600 |
MAXIMUM_SALARY |
Column MAXIMUM_SALARY. |
NUMBER |
11,2 |
MINIMUM_SALARY |
Column MINIMUM_SALARY. |
NUMBER |
11,2 |
MIT_JOB_CODE |
Column MIT_JOB_CODE. |
VARCHAR2 |
144 |
OCCUPATION_GROUP |
Column OCCUPATION_GROUP. |
VARCHAR2 |
1200 |
OCCUPATION_GROUP_CODE |
Column OCCUPATION_GROUP_CODE. |
VARCHAR2 |
48 |
PAYROLL_RANK |
Column PAYROLL_RANK. |
VARCHAR2 |
360 |
PAYROLL_RANK_CODE |
Column PAYROLL_RANK_CODE. |
VARCHAR2 |
36 |
PAY_GRADE |
Column PAY_GRADE. |
VARCHAR2 |
240 |
PAY_GRADE_AREA |
Column PAY_GRADE_AREA. |
VARCHAR2 |
240 |
PAY_GRADE_AREA_CODE |
Column PAY_GRADE_AREA_CODE. |
VARCHAR2 |
36 |
PAY_GRADE_CODE |
Column PAY_GRADE_CODE. |
VARCHAR2 |
96 |
PAY_GRADE_TYPE |
Column PAY_GRADE_TYPE. |
VARCHAR2 |
240 |
PAY_GRADE_TYPE_CODE |
Column PAY_GRADE_TYPE_CODE. |
VARCHAR2 |
36 |
PERSONNEL_AREA |
Column PERSONNEL_AREA. |
VARCHAR2 |
360 |
PERSONNEL_AREA_CODE |
Column PERSONNEL_AREA_CODE. |
VARCHAR2 |
48 |
PERSONNEL_SUBAREA |
Column PERSONNEL_SUBAREA. |
VARCHAR2 |
240 |
PERSONNEL_SUBAREA_CODE |
Column PERSONNEL_SUBAREA_CODE. |
VARCHAR2 |
48 |
POSITION_BUDGET |
Column POSITION_BUDGET. |
NUMBER |
13,2 |
POSITION_DESCRIPTION_FLAG |
Column POSITION_DESCRIPTION_FLAG. |
VARCHAR2 |
12 |
POSITION_ID |
Column POSITION_ID. |
VARCHAR2 |
96 |
POSITION_SORT |
Column POSITION_SORT. |
VARCHAR2 |
144 |
POSITION_TITLE |
Column POSITION_TITLE. |
VARCHAR2 |
540 |
POSITION_TITLE_LONG |
Column POSITION_TITLE_LONG. |
VARCHAR2 |
600 |
RECORD_COUNTER |
Column RECORD_COUNTER. |
NUMBER |
10 |
REFERENCE_SALARY |
Column REFERENCE_SALARY. |
NUMBER |
11,2 |
TENURE_STATUS |
Column TENURE_STATUS. |
VARCHAR2 |
240 |
TENURE_STATUS_CODE |
Column TENURE_STATUS_CODE. |
VARCHAR2 |
36 |
TIME_GROUP |
Column TIME_GROUP. |
VARCHAR2 |
780 |
TIME_GROUP_CODE |
Column TIME_GROUP_CODE. |
VARCHAR2 |
120 |
TIME_MONTH_KEY |
Column TIME_MONTH_KEY. |
VARCHAR2 |
72 |
WAREHOUSE_CLUSTER |
Column WAREHOUSE_CLUSTER. |
VARCHAR2 |
360 |
WAREHOUSE_CLUSTER_CODE |
Column WAREHOUSE_CLUSTER_CODE. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |