Ilc Learnosity Item Standards
Table Description
The ILC_LEARNOSITY_ITEM_STANDARDS table provides the mapping between Learnosity assessment items and educational standards. This junction table enables standards-aligned reporting by connecting each assessment item to the specific learning objectives and standards it measures.
Key Business Uses: - Standards-aligned assessment reporting and analytics - Identifying which standards are covered by specific assessment items - Supporting curriculum alignment and gap analysis
Primary Relationships: - Links to Learnosity items via LEARNOSITY_ITEM_ID - References educational standards via STANDARD_ID (ilc_standards)
Table Overview
This table contains 5 columns.
Quick Navigation
Column Definitions
CREATED_AT
Business Definition
The CREATED_AT column stores created at information for learnosity item standards 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 learnosity item standards 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 item-standard association identifier. Its business purpose is to serve as the primary key ensuring unique identification of each learnosity item standards record and enable referential integrity across related tables. Users and analysts would use this column to filter, join, and aggregate learnosity item standards data for reporting and analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
LEARNOSITY_ITEM_ID
Business Definition
The LEARNOSITY_ITEM_ID column foreign key to resources(id) - learnosity item. Its business purpose is to link this learnosity item standards record to related learnosity item data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate learnosity item standards data for reporting and analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
STANDARD_ID
Business Definition
The STANDARD_ID column foreign key to ilc_standards(id) - educational standard. Its business purpose is to link this learnosity item standards record to related standard data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate learnosity item standards 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 learnosity item standards 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 learnosity item standards data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT