| 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 | DIM_KEY_ID | NUMBER | 22 | (null) | N | Join key ID (unique within a dimension) |
| 4 | LEVEL_NAME | VARCHAR2 | 30 | (null) | Y | Name of the hierarchy level |
| 5 | KEY_POSITION | NUMBER | 22 | (null) | N | Position of the key column within the level |
| 6 | HIERARCHY_NAME | VARCHAR2 | 30 | (null) | Y | Name of the hierarchy |
| 7 | CHILD_JOIN_OWNER | VARCHAR2 | 30 | (null) | N | Owner of the join column table |
| 8 | CHILD_JOIN_TABLE | VARCHAR2 | 30 | (null) | N | Name of the join column table |
| 9 | CHILD_JOIN_COLUMN | VARCHAR2 | 30 | (null) | N | Name of the join column |
| 10 | CHILD_LEVEL_NAME | VARCHAR2 | 30 | (null) | Y | Name of the child hierarchy level of the join key |