Ilc Klasses
Table Overview
This table contains 13 columns.
Quick Navigation
- ACTIVE
- CLEVER_ID
- CREATED_AT
- CUSTOMER_ID
- DESCRIPTION
- GRADE_LEVEL_CODES
- ID
- IS_ARCHIVED_BY_SYNC
- NAME
- NAMED_BY_CLEVER
- SUBJECT_CODES
- UPDATED_AT
- XTRA
Column Definitions
ACTIVE
Business Definition
The ACTIVE column indicates whether a class is currently active (true) or has been archived (false). Its business purpose is to distinguish current classes from historical data and prevent students from accessing archived class content. Users and analysts would use this column to filter for active classes only, calculate current enrollment counts, and analyze class lifecycle patterns.
Data Type
BOOLEAN
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
CLEVER_ID
Business Definition
The CLEVER_ID column stores clever id information for klasses records. Its business purpose is to link this klasses record to related clever data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate klasses data for reporting and analysis.
Data Type
TEXT
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 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 klasses data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
CUSTOMER_ID
Business Definition
The CUSTOMER_ID column is a foreign key linking each class to its parent customer organization. Its business purpose is to enforce multi-tenant data boundaries and enable customer-level class aggregations. Users and analysts would use this column to segment classes by organization, calculate customer-specific class counts, and ensure proper data isolation in multi-tenant reporting.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
DESCRIPTION
Business Definition
The DESCRIPTION column stores description information for klasses records. Its business purpose is to support klasses data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate klasses data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
GRADE_LEVEL_CODES
Business Definition
The GRADE_LEVEL_CODES column grade level codes for this class. Its business purpose is to provide unique identification and enable lookups and joins with external systems. Users and analysts would use this column to filter, join, and aggregate klasses data for reporting and analysis.
Data Type
ARRAY
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
ID
Business Definition
The ID column serves as the primary key uniquely identifying each class section in the ILC system. Its business purpose is to enable tracking of class rosters, assignments, and student enrollment over time. Users and analysts would use this column to join class information with teachers, students, and assignments for class-level reporting and analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
IS_ARCHIVED_BY_SYNC
Business Definition
The IS_ARCHIVED_BY_SYNC column stores is archived by sync information for 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 klasses data for reporting and analysis.
Data Type
BOOLEAN
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
NAME
Business Definition
The NAME column contains the human-readable name or title of the class section as defined by the teacher or administrator. Its business purpose is to provide meaningful class identification in user interfaces and reports. Users and analysts would use this column to identify specific class sections, filter data by class name patterns, and present class information in dashboards.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
NAMED_BY_CLEVER
Business Definition
The NAMED_BY_CLEVER column stores named by clever information for 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 klasses data for reporting and analysis.
Data Type
BOOLEAN
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
SUBJECT_CODES
Business Definition
The SUBJECT_CODES column stores subject codes information for klasses records. Its business purpose is to provide unique identification and enable lookups and joins with external systems. Users and analysts would use this column to filter, join, and aggregate klasses data for reporting and analysis.
Data Type
ARRAY
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 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 klasses data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
XTRA
Business Definition
The XTRA column stores xtra information for klasses records. Its business purpose is to support klasses data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate klasses data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT