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 |