Data Model > Available DSCs > UNICOM Intelligence Data File CDSC > UNICOM Intelligence Data File schema > L1 table
 
L1 table
The L1 table is a variable-width table that contains the case data for the top-level of the hierarchy.
Columns
The first column in the table defines the primary key for the table, as follows:
:P0
Key: Yes
Column type: Integer
A unique identifier for this row, starting from 1.
There is an additional column in the L1 table for each top-level Metadata Model (MDM) variable 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 L1 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