Levels table
The Levels table is a fixed-width table that contains one row for each other table in the schema that represents a level in the hierarchy.
Columns
TableNumber
Key: Yes
Column type: Integer
A unique identifier for this row, starting from 1.
TableName
Key: No
Column type: Text
The name of the level table. For the top-level table in the hierarchy, the value is L1. For lower-level tables, the value is L2, L3, L4, and so on.
ParentName
Key: No
Column type: Text
The value of TableName for the level table’s parent table. For the L1 (top-level) table, the value is blank.
DSCTableName
Key: No
Column type: Text
The table name that client applications of the UNICOM Intelligence Data File DSC must use to refer to the level table. For the L1 (top-level) table, the value is HDATA. For lower-level tables, the value of DSCTableName is set to the value of the Metadata Model (MDM) loop or grid variable's Name property.
See also