Every UNICOM Intelligence Data File is a file-based database that contains a SchemaVersion table, a Levels table, and an L1 table. If there are lower levels in the data hierarchy (that is, Metadata Model (MDM) variables within loops and grids), the UNICOM Intelligence Data File contains extra tables called L2, L3, L4, and so on, where each additional table represents one lower-level.

The following diagram shows an example schema that contains three lower-level tables:

To query the tables in the schema directly, you must run the SQLite3 command-line access program, which can be downloaded from

However, do not use this method to update data or alter the schema, as the UNICOM Intelligence Data File CDSC might no longer be able to operate on the file.