Ilc Lesson Plan Standards
Table Overview
This table contains 7 columns.
Quick Navigation
Column Definitions
COVERAGE_TYPE
Business Definition
The COVERAGE_TYPE column stores coverage type information for lesson plan standards records. Its business purpose is to support lesson plan standards data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lesson plan standards 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 lesson plan 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 lesson plan 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 lesson plan-standard association identifier. Its business purpose is to serve as the primary key ensuring unique identification of each lesson plan standards record and enable referential integrity across related tables. Users and analysts would use this column to filter, join, and aggregate lesson plan standards data for reporting and analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
LESSON_PLAN_ID
Business Definition
The LESSON_PLAN_ID column foreign key to ilc_lesson_plans(id) - lesson plan. Its business purpose is to link this lesson plan standards record to related lesson plan data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lesson plan standards data for reporting and analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
SOURCE
Business Definition
The SOURCE column stores source information for lesson plan standards records. Its business purpose is to support lesson plan standards data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lesson plan standards data for reporting and analysis.
Data Type
TEXT
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 lesson plan standards record to related standard data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lesson plan 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 lesson plan 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 lesson plan standards data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT