Share this page
RPT_DIM_ORG_UNITS_MV
This is a materialized view that represents the org unit dimension in Star schema.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
ORG_UNIT_ID |
NOT NULL |
NUMBER |
Unique identifier to represent an org unit. It is derived from PPM KRSC_ORG_UNITS table |
|
ORG_UNIT_NAME |
NOT NULL |
VARCHAR2(200) |
Name of the org unit |
|
PARENT_ORG_UNIT_ID |
NOT NULL |
NUMBER |
Immediate parent org unit ID |
|
PRIMARY_FLAG |
NOT NULL |
VARCHAR2(1) |
A flag (Y/N) that indicates if the org unit is a primary org unit or not |
|
PARENT_ORG_UNIT_NAME |
NULLABLE |
VARCHAR2(200) |
Name of the immediate parent org unit |
|
LEVEL1_ORG_UNIT_ID |
NULLABLE |
VARCHAR2(4000) |
ID of the first level org unit from the top in the org unit hierarchy |
|
LEVEL1_ORG_UNIT_NAME |
NULLABLE |
VARCHAR2(4000) |
Name of the first level org unit from the top in the org unit hierarchy |
|
LEVEL2_ORG_UNIT_ID |
NULLABLE |
VARCHAR2(4000) |
ID of the second level org unit from the top in the org unit hierarchy |
|
LEVEL2_ORG_UNIT_NAME |
NULLABLE |
VARCHAR2(4000) |
Name of the second level org unit from the top in the org unit hierarchy |
|
LEVEL3_ORG_UNIT_ID |
NULLABLE |
VARCHAR2(4000) |
ID of the third level org unit from the top in the org unit hierarchy |
|
LEVEL3_ORG_UNIT_NAME |
NULLABLE |
VARCHAR2(4000) |
Name of the third level org unit from the top in the org unit hierarchy |
|
LEVEL4_ORG_UNIT_ID |
NULLABLE |
VARCHAR2(4000) |
ID of the fourth level org unit from the top in the org unit hierarchy |
|
LEVEL4_ORG_UNIT_NAME |
NULLABLE |
VARCHAR2(4000) |
Name of the fourth level org unit from the top in the org unit hierarchy |
|
LEVEL5_ORG_UNIT_ID |
NULLABLE |
VARCHAR2(4000) |
ID of the fifth level org unit from the top in the org unit hierarchy |
|
LEVEL5_ORG_UNIT_NAME |
NULLABLE |
VARCHAR2(4000) |
Name of the fifth level org unit from the top in the org unit hierarchy |
|
LEVEL6_ORG_UNIT_ID |
NULLABLE |
VARCHAR2(4000) |
ID of the sixth level org unit from the top in the org unit hierarchy |
|
LEVEL6_ORG_UNIT_NAME |
NULLABLE |
VARCHAR2(4000) |
Name of the sixth level org unit from the top in the org unit hierarchy |
|
LEVEL7_ORG_UNIT_ID |
NULLABLE |
VARCHAR2(4000) |
ID of the seventh level org unit from the top in the org unit hierarchy |
|
LEVEL7_ORG_UNIT_NAME |
NULLABLE |
VARCHAR2(4000) |
Name of the seventh level org unit from the top in the org unit hierarchy |
|
LEVEL8_ORG_UNIT_ID |
NULLABLE |
VARCHAR2(4000) |
ID of the eighth level org unit from the top in the org unit hierarchy |
|
LEVEL8_ORG_UNIT_NAME |
NULLABLE |
VARCHAR2(4000) |
Name of the eighth level org unit from the top in the org unit hierarchy |
|
LEVEL9_ORG_UNIT_ID |
NULLABLE |
VARCHAR2(4000) |
ID of the ninth level org unit from the top in the org unit hierarchy |
|
LEVEL9_ORG_UNIT_NAME |
NULLABLE |
VARCHAR2(4000) |
Name of the ninth level org unit from the top in the org unit hierarchy |
|
LEVEL10_ORG_UNIT_ID |
NULLABLE |
VARCHAR2(4000) |
ID of the tenth level org unit from the top in the org unit hierarchy |
|
LEVEL10_ORG_UNIT_NAME |
NULLABLE |
VARCHAR2(4000) |
Name of the tenth level org unit from the top in the org unit hierarchy |
|
STAFFING_PROFILE_ID |
NULLABLE |
NUMBER |
ID of the staffing profile that this org unit has. This refers to RPT_DIM_RM_STAFF_PROFILES materialized view. |
|
ORG_UNIT_MANAGER_ID |
NULLABLE |
VARCHAR2(40) |
User ID of the manager of the org unit |
|
ORG_UNIT_MANAGER_FIRSTNAME |
NULLABLE |
VARCHAR2(80) |
First Name of the manager of the org unit |
|
ORG_UNIT_MANAGER_LASTNAME |
NULLABLE |
VARCHAR2(80) |
Last name of the manager of the org unit |
|
FINANCIAL_SUMMARY_ID |
NULLABLE |
NUMBER |
ID of the org unit's financial summary |
|
FINANCIAL_SUMMARY_NAME |
NOT NULL |
VARCHAR2(1300) |
Name of the org unit's financial summary name |
|
LOCATION |
NULLABLE |
VARCHAR2(150) |
Location of the org unit |
|
DEPARTMENT |
NULLABLE |
VARCHAR2(150) |
Department this org unit belongs to |
|
CATEGORY |
NULLABLE |
VARCHAR2(150) |
Category of this org unit |
|
SOURCE |
NULLABLE |
VARCHAR2(100) |
Source of the org unit |
|
SOURCE_TYPE_CODE |
NULLABLE |
VARCHAR2(30) |
Code of the source of the org unit |
|
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
|
REGION_ID |
NULLABLE |
NUMBER |
ID of the region that the org unit belongs to |
|
REGION_NAME |
NULLABLE |
VARCHAR2(100) |
Name of the region that the org unit belongs to |
|
USER_DATA_SET_CONTEXT_ID |
NULLABLE |
NUMBER |
Parameter set context identifier for the user data fields |
|
USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
|
VISIBLE_USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
Indexes
This table uses no indexes.
Sequences
This table uses no sequences.
