Ilc Lz Code Klasses
Table Description
The ILC_LZ_CODE_KLASSES table provides the association between Learning Zone (LZ) codes and classes (klasses). This junction table enables LZ codes to be assigned to specific classes, controlling which student groups have access to particular learning activities and assignments.
Key Business Uses: - Controlling class-level access to learning assignments - Managing which classes can use specific LZ codes - Supporting targeted assignment distribution to class groups
Primary Relationships: - Links to LZ codes via LZ_CODE_ID (ilc_lz_codes) - References classes via KLASS_ID (ilc_klasses)
Table Overview
This table contains 6 columns.
Quick Navigation
Column Definitions
ACTIVE
Business Definition
The ACTIVE column stores active information for lz code klasses records. Its business purpose is to provide a flag for conditional logic and filtering in queries and applications. Users and analysts would use this column to filter, join, and aggregate lz code klasses data for reporting and analysis.
Data Type
BOOLEAN
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
CREATED_AT
Business Definition
The CREATED_AT column stores created at information for lz code klasses records. Its business purpose is to track the creation timestamp for audit trails and temporal analysis. Users and analysts would use this column to filter, join, and aggregate lz code klasses data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
ID
Business Definition
The ID column primary key - unique assignment-class association identifier. Its business purpose is to serve as the primary key ensuring unique identification of each lz code klasses record and enable referential integrity across related tables. Users and analysts would use this column to filter, join, and aggregate lz code klasses data for reporting and analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
KLASS_ID
Business Definition
The KLASS_ID column foreign key to ilc_klasses(id) - class. Its business purpose is to link this lz code klasses record to related klass data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lz code klasses data for reporting and analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
LZ_CODE_ID
Business Definition
The LZ_CODE_ID column foreign key to ilc_lz_codes(id) - assignment. Its business purpose is to link this lz code klasses record to related lz code data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lz code klasses data for reporting and analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
UPDATED_AT
Business Definition
The UPDATED_AT column stores updated at information for lz code klasses records. Its business purpose is to track the last modification timestamp for audit trails and temporal analysis. Users and analysts would use this column to filter, join, and aggregate lz code klasses data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT