| Column ID | Column name | Data type | Length | Precision | NULL | Description |
|
| 1 | OWNER | VARCHAR2 | 30 | (null) | N | Owner of the dimension |
| 2 | DIMENSION_NAME | VARCHAR2 | 30 | (null) | N | Name of the dimension |
| 3 | HIERARCHY_NAME | VARCHAR2 | 30 | (null) | Y | Name of the hierarchy |
| 4 | POSITION | NUMBER | 22 | (null) | N | Hierarchical position within this hierarchy, position 1 being
the most detailed |
| 5 | CHILD_LEVEL_NAME | VARCHAR2 | 30 | (null) | Y | Name of the child-side level of this 1:n relationship |
| 6 | JOIN_KEY_ID | VARCHAR2 | 40 | (null) | Y | Keys that join child to the parent |
| 7 | PARENT_LEVEL_NAME | VARCHAR2 | 30 | (null) | Y | Name of the parent-side level of this 1:n relationship |