Ilc Standards
Table Overview
This table contains 14 columns.
Quick Navigation
- AB_CODES
- CODE
- CREATED_AT
- GRADE_LEVEL_CODES
- ID
- NAME
- REFERENCE_URL
- SECTION
- SOURCE
- SOURCE_UUID
- STANDARD_INITIATIVE_ID
- SUBJECT_CODE
- UPDATED_AT
- UUID
Column Definitions
AB_CODES
Business Definition
The AB_CODES column stores ab codes information for standards 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 standards data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
CODE
Business Definition
The CODE column contains the official standard code as it appears in UI and reports (e.g., 'CCSS.MATH.3.OA.A.1'). Its business purpose is to provide human-readable standard identification that matches external documentation. Users and analysts would use this column to filter and group data by specific standards, match ILC data with external assessment systems, and create standards-based progress reports.
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 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 standards data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
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 this standard applies to. 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 standards 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 educational standard (Common Core, state standards, etc.) in the ILC system. Its business purpose is to enable standards alignment tracking across content and assessments. Users and analysts would use this column to join standards with lesson plans, assessment items, and student performance data for standards-based reporting and curriculum alignment analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
NAME
Business Definition
The NAME column stores the complete text description of the educational standard. Its business purpose is to provide the full standard language for reporting and instructional planning. Users and analysts would use this column to display standard descriptions in dashboards, help educators understand standard requirements, and support standards-aligned curriculum documentation.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
REFERENCE_URL
Business Definition
The REFERENCE_URL column stores reference url information for standards records. Its business purpose is to support standards data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate standards data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
SECTION
Business Definition
The SECTION column stores section information for standards records. Its business purpose is to support standards data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate standards data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
SOURCE
Business Definition
The SOURCE column stores source information for standards records. Its business purpose is to support standards data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate standards data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
SOURCE_UUID
Business Definition
The SOURCE_UUID column stores source uuid information for standards records. Its business purpose is to support standards data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate standards data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
STANDARD_INITIATIVE_ID
Business Definition
The STANDARD_INITIATIVE_ID column is a foreign key linking each standard to its parent framework in ILC_STANDARD_INITIATIVES (e.g., Common Core, Texas TEKS). Its business purpose is to group standards by framework for curriculum alignment reporting. Users and analysts would use this column to filter content by standards framework, compare coverage across different state standards, and support multi-framework curriculum mapping.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
SUBJECT_CODE
Business Definition
The SUBJECT_CODE column categorizes standards by subject area (math or ela). Its business purpose is to enable subject-specific filtering and curriculum segmentation. Users and analysts would use this column to separate math from ELA standards in reports, calculate subject-specific coverage metrics, and support discipline-focused analysis.
Data Type
TEXT
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 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 standards data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
UUID
Business Definition
The UUID column stores uuid information for standards records. Its business purpose is to support standards data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate standards data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT