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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: