HR POSITION FULL Table
View exposing comprehensive HR position data including position identifiers, titles, organizational relationships, job attributes, and extended position reporting fields used for workforce analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AAP_CATEGORY |
Column AAP_CATEGORY. |
VARCHAR2 |
30 |
AAP_CATEGORY_CODE |
Column AAP_CATEGORY_CODE. |
VARCHAR2 |
4 |
BENEFITS_ELIGIBILITY |
Column BENEFITS_ELIGIBILITY. |
VARCHAR2 |
20 |
BENEFITS_ELIGIBILITY_CODE |
Column BENEFITS_ELIGIBILITY_CODE. |
VARCHAR2 |
3 |
COMPENSATE_FREQUENCY |
Column COMPENSATE_FREQUENCY. |
VARCHAR2 |
20 |
COMPENSATE_FREQUENCY_CODE |
Column COMPENSATE_FREQUENCY_CODE. |
VARCHAR2 |
3 |
COST_PLANNING_TYPE |
Column COST_PLANNING_TYPE. |
VARCHAR2 |
14 |
EEO_CATEGORY |
Column EEO_CATEGORY. |
VARCHAR2 |
30 |
EEO_CATEGORY_CODE |
Column EEO_CATEGORY_CODE. |
VARCHAR2 |
3 |
EMPLOYEE_GROUP |
Column EMPLOYEE_GROUP. |
VARCHAR2 |
20 |
EMPLOYEE_GROUP_CODE |
Column EMPLOYEE_GROUP_CODE. |
VARCHAR2 |
1 |
EMPLOYEE_SUBGROUP |
Column EMPLOYEE_SUBGROUP. |
VARCHAR2 |
20 |
EMPLOYEE_SUBGROUP_CODE |
Column EMPLOYEE_SUBGROUP_CODE. |
VARCHAR2 |
2 |
EMPLOYEE_TYPE |
Column EMPLOYEE_TYPE. |
VARCHAR2 |
30 |
ESTIMATED_BUDGET_TYPE |
Column ESTIMATED_BUDGET_TYPE. |
VARCHAR2 |
25 |
ESTIMATED_BUDGET_TYPE_CODE |
Column ESTIMATED_BUDGET_TYPE_CODE. |
VARCHAR2 |
3 |
GL_ACCOUNT_ID |
Column GL_ACCOUNT_ID. |
VARCHAR2 |
6 |
GL_ACCOUNT_NAME |
Column GL_ACCOUNT_NAME. |
VARCHAR2 |
50 |
HR_ORG_UNIT_KEY |
Column HR_ORG_UNIT_KEY. |
VARCHAR2 |
10 |
HR_POSITION_KEY |
Column HR_POSITION_KEY. |
VARCHAR2 |
10 |
IS_ADDITION_TO_HEADCOUNT |
Column IS_ADDITION_TO_HEADCOUNT. |
VARCHAR2 |
3 |
IS_APPROVED |
Column IS_APPROVED. |
VARCHAR2 |
1 |
IS_EXEMPT |
Column IS_EXEMPT. |
VARCHAR2 |
1 |
IS_SHIFT_ELIGIBLE |
Column IS_SHIFT_ELIGIBLE. |
VARCHAR2 |
1 |
IS_VACANT |
Column IS_VACANT. |
VARCHAR2 |
1 |
JOB_DESCRIPTION_FLAG |
Column JOB_DESCRIPTION_FLAG. |
VARCHAR2 |
1 |
JOB_FAMILY |
Column JOB_FAMILY. |
VARCHAR2 |
40 |
JOB_FAMILY_CODE |
Column JOB_FAMILY_CODE. |
VARCHAR2 |
3 |
JOB_TITLE |
Column JOB_TITLE. |
VARCHAR2 |
50 |
MAXIMUM_SALARY |
Column MAXIMUM_SALARY. |
NUMBER |
11,2 |
MINIMUM_SALARY |
Column MINIMUM_SALARY. |
NUMBER |
11,2 |
MIT_JOB_CODE |
Column MIT_JOB_CODE. |
VARCHAR2 |
12 |
OCCUPATION_GROUP |
Column OCCUPATION_GROUP. |
VARCHAR2 |
100 |
OCCUPATION_GROUP_CODE |
Column OCCUPATION_GROUP_CODE. |
VARCHAR2 |
4 |
PAYROLL_RANK |
Column PAYROLL_RANK. |
VARCHAR2 |
30 |
PAYROLL_RANK_CODE |
Column PAYROLL_RANK_CODE. |
VARCHAR2 |
3 |
PAY_GRADE |
Column PAY_GRADE. |
VARCHAR2 |
20 |
PAY_GRADE_AREA |
Column PAY_GRADE_AREA. |
VARCHAR2 |
20 |
PAY_GRADE_AREA_CODE |
Column PAY_GRADE_AREA_CODE. |
VARCHAR2 |
3 |
PAY_GRADE_CODE |
Column PAY_GRADE_CODE. |
VARCHAR2 |
8 |
PAY_GRADE_TYPE |
Column PAY_GRADE_TYPE. |
VARCHAR2 |
20 |
PAY_GRADE_TYPE_CODE |
Column PAY_GRADE_TYPE_CODE. |
VARCHAR2 |
3 |
PERSONNEL_AREA |
Column PERSONNEL_AREA. |
VARCHAR2 |
30 |
PERSONNEL_AREA_CODE |
Column PERSONNEL_AREA_CODE. |
VARCHAR2 |
4 |
PERSONNEL_SUBAREA |
Column PERSONNEL_SUBAREA. |
VARCHAR2 |
20 |
PERSONNEL_SUBAREA_CODE |
Column PERSONNEL_SUBAREA_CODE. |
VARCHAR2 |
4 |
POSITION_BEGIN_DATE |
Column POSITION_BEGIN_DATE. |
DATE |
|
POSITION_BUDGET |
Column POSITION_BUDGET. |
NUMBER |
11,2 |
POSITION_DESCRIPTION_FLAG |
Column POSITION_DESCRIPTION_FLAG. |
VARCHAR2 |
1 |
POSITION_END_DATE |
Column POSITION_END_DATE. |
DATE |
|
POSITION_ID |
Column POSITION_ID. |
VARCHAR2 |
8 |
POSITION_SORT |
Column POSITION_SORT. |
VARCHAR2 |
12 |
POSITION_TITLE |
Column POSITION_TITLE. |
VARCHAR2 |
45 |
POSITION_TITLE_LONG |
Column POSITION_TITLE_LONG. |
VARCHAR2 |
50 |
RECORD_COUNTER |
Column RECORD_COUNTER. |
NUMBER |
|
REFERENCE_SALARY |
Column REFERENCE_SALARY. |
NUMBER |
11,2 |
TENURE_STATUS |
Column TENURE_STATUS. |
VARCHAR2 |
20 |
TENURE_STATUS_CODE |
Column TENURE_STATUS_CODE. |
VARCHAR2 |
3 |
TIME_GROUP |
Column TIME_GROUP. |
VARCHAR2 |
65 |
TIME_GROUP_CODE |
Column TIME_GROUP_CODE. |
VARCHAR2 |
10 |
WAREHOUSE_CLUSTER |
Column WAREHOUSE_CLUSTER. |
VARCHAR2 |
30 |
WAREHOUSE_CLUSTER_CODE |
Column WAREHOUSE_CLUSTER_CODE. |
VARCHAR2 |
5 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |