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