Share this page

# DIM_ORG_UNITS

This table stores information of all organization units.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
DIM_PERSON | MANAGER_ID | PK_PERSON_ID
DIM_ORG_UNITS | ORG_UNIT_ID | PARENT_ORG_UNIT_ID

## Column Descriptions

Column Name | Null? | Data Type | Description | SCD2?
--- | --- | --- | --- | ---
PK_ORG_UNITS_ID | NOT NULL | INT | System-generated identifier | No
MD_BUSINESS_KEY | NOT NULL | VARCHAR(1000) | Primary key that is mapped to one or more source columns | No
MD_ENTERPRISE_KEY | NOT NULL | INT | Unique identifier for entity | No
ORG_UNIT_NAME | NOT NULLL | VARCHAR(200) | Name given to this organization unit | No
PARENT_ORG_UNIT_ID | NULLABLE | INT | Unique identifier to the parent organization unit record in the same table | Yes
PARENT_ORG_UNIT_BUSINESS_KEY | NULLABLE | VARCHAR(1000) | Foreign key that is mapped to DIM_ORG_UNITS | Yes
PARENT_ORG_UNIT_ENTERPRISE_KEY | NULLABLE | INT | Unique identifier for foreign key | Yes
MANAGER_ID | NULLABLE | INT | Unique identifier for manager | Yes
MANAGER_BUSINESS_KEY | NULLABLE | VARCHAR(1000) | Foreign key that is mapped to dim_person | Yes
MANAGER_ENTERPRISE_KEY | NULLABLE | INT | Unique identifier for foreign key | Yes
MANGER_NAME | NULLABLE | VARCHAR(200) | Manager name | Yes
DEPARTMENT_CODE | NULLABLE | VARCHAR(30) | The department to which this org unit is associated with. For example, Finance and Marketing. | Yes
DEPARTMENT_NAME | NULLABLE | VARCHAR(150) | Department name | Yes
LOCATION_CODE | NULLABLE | VARCHAR(30) | The location to which this org unit is associated to. For example, Site A and Site B. | Yes
LOCATION_NAME | NULLABLE | VARCHAR(150) | Location name. | Yes
CATEGORY_CODE | NULLABLE | VARCHAR(30) | The type of the org unit. For example, Group, department, and team. | Yes
CATEGORY_NAME | NULLABLE | VARCHAR(150) | Category name | Yes
ENABLED_FLAG | NOT NULL | VARCHAR(1) | Indicates whether this organization unit is enabled | Yes
USER_DATA_SET_CONTEXT_ID | NULLABLE | INT | Parameter set context identifier for the user data fields | Yes
USER_DATA1-20 | NULLABLE | VARCHAR(200) | User data segment | No
VISIBLE_USER_DATA1-20 | NULLABLE | VARCHAR(200) | User data segment | No
REGION_ID | NULLABLE | INT | Region to which this organization unit is associated to | Yes
REGION_NAME | NULLABLE | VARCHAR(100) | Region name | Yes
REGION_CURRENCY_ID | NULLABLE | INT | Currency ID associated with this region | Yes
REGION_CURRENCY_NAME | NULLABLE | VARCHAR(100) | Currency name associated with this region | Yes
REGION_CURRENCY_CODE | NULLABLE | VARCHAR(10) | Currency code associated with this region | Yes
REGION_CALENDAR_ID | NULLABLE | INT | Calendar ID associated with this region | Yes
PRIMARY_FLAG | NOT NULL | VARCHAR(1) | Flag to indicate if this is a primary org unit or not | Yes
FINANCIAL_SUMMARY_ID | NULLABLE | INT | Financial summary ID | No
FINANCIAL_SUMMARY_NAME | NULLABLE | VARCHAR(1300) | Financial summary name | No
INHERIT_PARENT_REGION | NOT NULL | VARCHAR(1) | Indicates whether this organization unit will inherit its parent's region | No
MD_BATCH_ID | NULLABLE | INT | ID of data batch | No
MD_PROCESS_ID | NULLABLE | INT | ID of ETL process running on a specific task | No
MD_SOURCE_INSTANCE_ID | NULLABLE | INT | Contnet pack ID of source instance | No
MD_CREATEDDATE | NULLABLE | DATETIME | Date of the record being inserted | No
MD_DELETEDDATE | NULLABLE | DATETIME | Date of the record being deleted | No
MD_LASTMODDATE | NULLABLE | DATETIME | Date of the record being updated | No
MD_TRANSLASTIND | NULLABLE | VARCHAR(1) | Flags whether it is the latest record after updated by SCD2 | No
MD_TRANSENDDATE | NULLABLE | DATETIME | End date of the record being effective | No
MD_ACTIVESTATUSIND | NULLABLE | VARCHAR(1) | Flags whether or not the old record is deleted | No
MD_HASH_CODE_SCD1 | NULLABLE | VARCHAR(40) | (Only for dimension table) Hash code that is generated by SCD1 columns | No
MD_HASH_CODE_SCD2 | NULLABLE | VARCHAR(40) | (Only for dimension table) Hash code that is generated by SCD2 columns | No

## Projections

This table uses no projections.

## Sequences

Sequence Name | Sequence Type
--- | ---
ORG_UNITS_ENTERPRISE_XREF_SEQ | MD_ENTERPRISE_KEY
ORG_UNITS_KEY_LOOKUP_SEQ | PK_ORG_UNITS_ID
ORG_UNITS_HIERARCHY_SEQ | PARENT_ORG_UNIT_ID

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: