HR JOB HIERARCHY Table
Job hierarchy dimension defining multi-level job classification structures used to group jobs for reporting, analytics, and organizational analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_JOB_HIERARCHY_TYPE |
Type of job hierarchy applied (e.g., functional, managerial, reporting, or analytic hierarchy). |
VARCHAR2 |
17 |
HR_JOB_KEY |
Surrogate key identifying the job record associated with this hierarchy definition. |
VARCHAR2 |
10 |
JOB_ID |
Source-system job identifier used to associate hierarchy levels with a specific job. |
VARCHAR2 |
8 |
LEVEL_1_JOB_CLASS |
Top-level job classification representing the broadest grouping within the hierarchy. |
VARCHAR2 |
30 |
LEVEL_2_JOB_CLASS |
Second-level job classification providing a more granular grouping beneath level 1. |
VARCHAR2 |
20 |
LEVEL_3_JOB_CLASS |
Third-level job classification used for further refinement of job groupings. |
VARCHAR2 |
30 |
LEVEL_4_JOB_CLASS |
Fourth-level job classification supporting detailed organizational or analytic breakdowns. |
VARCHAR2 |
30 |
LEVEL_5_JOB_CLASS |
Fifth-level job classification, typically used for specialized or narrowly defined groupings. |
VARCHAR2 |
1 |
LEVEL_6_JOB_CLASS |
Sixth-level job classification, if applicable, for highly granular hierarchy definitions. |
VARCHAR2 |
1 |
LEVEL_7_JOB_CLASS |
Seventh-level job classification reserved for extended hierarchy depth when required. |
VARCHAR2 |
1 |
LEVEL_8_JOB_CLASS |
Eighth-level job classification representing the deepest supported hierarchy level. |
VARCHAR2 |
1 |
MIT_JOB_CODE |
MIT-specific job code used to align jobs within hierarchical classifications. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the job hierarchy record was loaded into the data warehouse. |
DATE |