Skip to content

Ilc Lesson Plans

Table Overview

This table contains 23 columns.

Quick Navigation

Column Definitions

ADAPTATION

Business Definition

The ADAPTATION column stores adaptation information for lesson plans 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 lesson plans data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

ARCHIVED_AT

Business Definition

The ARCHIVED_AT column stores archived at information for lesson plans records. Its business purpose is to support lesson plans data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

AUTHORS

Business Definition

The AUTHORS column stores authors information for lesson plans records. Its business purpose is to support lesson plans data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

COACH

Business Definition

The COACH column stores coach information for lesson plans records. Its business purpose is to support lesson plans data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

COVER_IMAGE

Business Definition

The COVER_IMAGE column stores cover image information for lesson plans records. Its business purpose is to support lesson plans data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lesson plans 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 plans 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 plans 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 stores customer id information for lesson plans records. Its business purpose is to link this lesson plans record to related customer data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

DEPRECATED_BY_MESSAGE

Business Definition

The DEPRECATED_BY_MESSAGE column stores deprecated by message information for lesson plans records. Its business purpose is to support lesson plans data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

DEPRECATED_BY_URL

Business Definition

The DEPRECATED_BY_URL column stores deprecated by url information for lesson plans records. Its business purpose is to support lesson plans data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

DESCRIPTION

Business Definition

The DESCRIPTION column stores description information for lesson plans records. Its business purpose is to support lesson plans data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

FORKED_FROM_ID

Business Definition

The FORKED_FROM_ID column stores forked from id information for lesson plans records. Its business purpose is to link this lesson plans record to related forked from data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

ID

Business Definition

The ID column primary key - unique lesson plan identifier. Its business purpose is to serve as the primary key ensuring unique identification of each lesson plans record and enable referential integrity across related tables. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

LESSON_TYPE

Business Definition

The LESSON_TYPE column lesson type: 0=lesson plan (full lesson), 1=instructional video, 2=assessment, 3=activity. bolded types (0,2,3) typically have digital items. Its business purpose is to support lesson plans data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

ORIGINALLY_FORKED_FROM_ID

Business Definition

The ORIGINALLY_FORKED_FROM_ID column stores originally forked from id information for lesson plans records. Its business purpose is to link this lesson plans record to related originally forked from data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

OWNER_ID

Business Definition

The OWNER_ID column stores owner id information for lesson plans records. Its business purpose is to link this lesson plans record to related owner data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

PREMIUM

Business Definition

The PREMIUM column stores premium information for lesson plans 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 lesson plans data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

REVISION_ID

Business Definition

The REVISION_ID column stores revision id information for lesson plans records. Its business purpose is to link this lesson plans record to related revision data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lesson plans 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 plans records. Its business purpose is to support lesson plans data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

STATE

Business Definition

The STATE column stores state information for lesson plans records. Its business purpose is to support lesson plans data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

TEXT_STYLE

Business Definition

The TEXT_STYLE column stores text style information for lesson plans records. Its business purpose is to support lesson plans data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

TITLE

Business Definition

The TITLE column lesson plan title. Its business purpose is to provide human-readable identification in user interfaces and reports. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and 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 lesson plans 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 plans data for reporting and analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

WORKFLOW_STATUS_ID

Business Definition

The WORKFLOW_STATUS_ID column stores workflow status id information for lesson plans records. Its business purpose is to link this lesson plans record to related workflow status data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lesson plans data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT