Skip to content

Ilc Lz Codes

Table Overview

This table contains 14 columns.

Quick Navigation

Column Definitions

ACTIVE

Business Definition

The ACTIVE column indicates whether an assignment is currently active (true) or has been archived (false) by the teacher. Its business purpose is to distinguish accessible assignments from historical records and prevent student access to retired assignments. Users and analysts would use this column to filter for active assignments, track assignment lifecycle, and calculate active assignment counts per teacher or customer.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

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

CODE

Business Definition

The CODE column contains the unique assignment code generated when teachers create assignments, often used by students to access the assignment. Its business purpose is to provide a shareable assignment identifier and enable quick assignment lookup. Users and analysts would use this column to identify specific assignments in reports, troubleshoot student access issues, and track assignment distribution.

Data Type

TEXT

Nullable

Yes

Last Updated

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

CREATED_AT

Business Definition

The CREATED_AT column timestamp when assignment was created. 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 lz codes 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 foreign key to ilc_customers(id) - customer organization. Its business purpose is to link this lz codes record to related customer data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lz codes data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

EXTERNAL_SOURCE

Business Definition

The EXTERNAL_SOURCE column stores external source information for lz codes records. Its business purpose is to support lz codes data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lz codes data for reporting and analysis.

Data Type

TEXT

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 assignment created by teachers in the ILC system. Its business purpose is to track assignment definitions and link them to student completion data. Users and analysts would use this column to join assignment metadata with student submissions, scoring data, and class rosters for comprehensive assignment analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

LEARNOSITY_ACTIVITY_ID

Business Definition

The LEARNOSITY_ACTIVITY_ID column learnosity activity identifier. Its business purpose is to link this lz codes record to related learnosity activity data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lz codes data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

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

LTI_CONTEXT_ID

Business Definition

The LTI_CONTEXT_ID column stores lti context id information for lz codes records. Its business purpose is to link this lz codes record to related lti context data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lz codes data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

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

Business Definition

The LTI_RESOURCE_LINK_ID column stores lti resource link id information for lz codes records. Its business purpose is to link this lz codes record to related lti resource link data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lz codes data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

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

LZ_CODEABLE_ID

Business Definition

The LZ_CODEABLE_ID column is a foreign key linking the assignment to its source lesson plan in ILC_LESSON_PLANS. Its business purpose is to connect teacher-created assignments with the underlying instructional content. Users and analysts would use this column to analyze which lesson plans are most frequently assigned, track content usage, and understand the relationship between curriculum and assignment distribution.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

LZ_CODEABLE_TYPE

Business Definition

The LZ_CODEABLE_TYPE column stores lz codeable type information for lz codes 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 lz codes data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

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

SNAPSHOT_KEY

Business Definition

The SNAPSHOT_KEY column stores snapshot key information for lz codes records. Its business purpose is to support lz codes data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lz codes 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 timestamp when assignment was last updated. 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 lz codes data for reporting and analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

USER_ID

Business Definition

The USER_ID column is a foreign key identifying the teacher who created the assignment. Its business purpose is to attribute assignment authorship and enable teacher-specific assignment analytics. Users and analysts would use this column to calculate assignments created per teacher, identify prolific content creators, and analyze teacher content creation patterns.

Data Type

NUMBER

Nullable

Yes

Last Updated

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