Bottom Level IndHierarchy TypeLevel NumOrganization Hierarchy StatusOrganization Hierarchy Status DateOrganization Hierarchy Status ReasonOrganization Top Parent Start DateTop Level Ind
| Business Data Model Data Model |
| Description | An association between two organizations based on a management, ownership or reporting hierarchical structure. |
| Relationship | |
 Organization Hierarchy_Organization_FK |
|
| Organization Hierarchy_Organization_FK1 |
|
| Organization Hierarchy_Organization_FK2 |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Bottom Level Ind
| Description | Indicates if the child in this relationship is the bottom level of the hierarchy. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Hierarchy Type
| Description | Indicates the nature of the hierarchy. For example: Legal Hierarchy Management Hierarchy Reporting Hierarchy Administrative Divisions Hierarchy |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Level Num
| Description | Indicates at what level in a hierarchy of codes the current record resides. 0 (Zero) would be the root of a hierarchy, 2 is the terminating record and a 1 is any record in between. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Organization Hierarchy Status
| Description | Indicates the state of the hierarchical relationship between two organizations |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Organization Hierarchy Status Date
| Description | The date upon which the status of a relationship between two organizations based on a management, ownership or reporting hierarchical structure is defined. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Organization Hierarchy Status Reason
| Description | Indicates why an organization hierarchy relationship is in its current state. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Organization Top Parent Start Date
| Description | The date upon which the child/parent relationship between the top level parent organization and child organization began. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Top Level Ind
| Description | Indicates whether the hierarchy level is at the top of the hierarchy. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Organization Hierarchy_Organization_FK
| Is Identifying Relationship | true |
| Child Table | Organization Hierarchy |
| Child Role Name | child |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Organization |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Organization Hierarchy_Organization_FK1
| Is Identifying Relationship | true |
| Child Table | Organization Hierarchy |
| Child Role Name | parent |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Organization |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Organization Hierarchy_Organization_FK2
| Is Identifying Relationship | false |
| Child Table | Organization Hierarchy |
| Child Role Name | top level parent |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Organization |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |