> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# LEGAL_ENTITY_HIERARCHY

The LEGAL\_ENTITY\_HIERARCHY table contains the multi-level legal entity organizational structure.

<Note>
  The content of this table is populated from the content of the [LEGAL\_ENTITY\_PARENT\_CHILD](./legal_entity_parent_child) table.
</Note>

| Column Name                      | Type   | Not Null | Cube Field                                        | Default Value[1](#fn:1) | Description                                                                                      |
| -------------------------------- | ------ | -------- | ------------------------------------------------- | ----------------------- | ------------------------------------------------------------------------------------------------ |
| AS\_OF\_DATE                     | DATE   | Y        |                                                   |                         | Timestamp (at close of business) for the data.                                                   |
| LEGAL\_ENTITY                    | STRING | Y        | [Legal Entities](../cube/dimensions/organization) | N/A                     | Leaf node of the book hierarchy. This matches the last non-\_DATAMEMBER\_ node in levels 1 - 15. |
| LEGAL\_ENTITY\_HIERARCHY\_LEVEL1 | STRING | Y        | Level 1                                           | N/A                     | Node at level 1 of the legal entity hierarchy.                                                   |
| LEGAL\_ENTITY\_HIERARCHY\_LEVEL2 | STRING | Y        | Level 2                                           | N/A                     | Node at level 2 of the legal entity hierarchy.                                                   |
| LEGAL\_ENTITY\_HIERARCHY\_LEVEL3 | STRING | Y        | Level 3                                           | N/A                     | Node at level 3 of the legal entity hierarchy.                                                   |
| LEGAL\_ENTITY\_HIERARCHY\_LEVEL4 | STRING | Y        | Level 4                                           | N/A                     | Node at level 4 of the legal entity hierarchy.                                                   |
| LEGAL\_ENTITY\_HIERARCHY\_LEVEL5 | STRING | Y        | Level 5                                           | N/A                     | Node at level 5 of the legal entity hierarchy.                                                   |

## Unique Key

<table><thead><tr><th>Columns</th></tr></thead><tbody><tr><td>AS\_OF\_DATE</td></tr><tr><td>LEGAL\_ENTITY</td></tr></tbody></table>

## Incoming Joins

<table><thead><tr><th>Source Table</th><th>Source Columns</th><th>Target Columns</th></tr></thead><tbody><tr><td><a href="./trade_attributes">TRADE\_ATTRIBUTES</a></td><td>AS\_OF\_DATE<br />LEGAL\_ENTITY</td><td>AS\_OF\_DATE<br />LEGAL\_ENTITY</td></tr></tbody></table>

***

1. If the default value is marked as empty, it means that the default value is 'null' for nullable fields, and that a value needs to be explicitly set for non-nullable fields.
    [↩︎](#fnref:1)