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