Data Model > Available DSCs > UNICOM Intelligence Data File CDSC > UNICOM Intelligence Data File schema > L2, L3, ... Ln tables
 
L2, L3, ... Ln tables
The UNICOM Intelligence Data File contains one table for each lower level in the hierarchy. The lower-level tables are named L2, L3, L4, and so on, are variable-width tables, and contain the case data for that level.
Columns
The first set of columns in the table define the primary key and the level ID for the table, as follows:
:Pn (where n is 1, 2, 3, and so on)
Key: Yes
Column type: Integer
Linked: :P0 column in the table that is n levels above this table
The row or rows in the table n levels above this table to which this row relates.
The number of columns of type :Pn depends on the depth of the lower-level table in the hierarchy. For example, the number of columns of type :Pn is 1 if the lower-level table's parent is the L1 (top-level) table, 2 if the lower-level table's grandparent is the L1 table, 3 if the lower-level table's great-grandparent is the L1 table, and so on. Each column of type :Pn is part of the primary key.
:P0
Key: Yes
Column type: Integer
Linked: No
A unique identifier for this row, starting from 1.
LevelId
Key: No
Column type: Integer
Linked: No
For a lower-level table that represents a Metadata Model (MDM) categorical loop or grid, the value is the MDM mapped category value for the iteration. For a lower-level table that represents an MDM numeric loop, the value is the iteration number.
There is an additional column in the lower-level table for each MDM variable at that level that is a single-response categorical or a non-categorical variable. Each multiple-response categorical variable, or a multiple-response codes list for a non-categorical variable, is represented in the lower-level table by one column or a multiple set of columns. For more information, see Columns in the L1, L2, L3, ... Ln tables.
See also
UNICOM Intelligence Data File schema