Skip to content

Ilc Lz Code Views

Table Overview

This table contains 21 columns.

Quick Navigation

Column Definitions

ACTIVITY_ID

Business Definition

The ACTIVITY_ID column foreign key to ilc_lz_codes(id) - deprecated: not used anymore, use lz_code_klass_id instead. Its business purpose is to link this lz code views record to related activity data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lz code views data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

CLOSE_AT

Business Definition

The CLOSE_AT column contains the timestamp when the teacher closes the assignment to the student (can be scheduled as a due date). Its business purpose is to enforce assignment deadlines and track assignment windows. Users and analysts would use this column to identify late submissions, calculate assignment duration windows, and analyze the impact of deadline policies on completion rates.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

CREATED_AT

Business Definition

The CREATED_AT column captures the timestamp when a student first loaded the assignment (set once and never updated). Its business purpose is to track initial assignment access for engagement timing analysis. Users and analysts would use this column to calculate time-to-start metrics, identify when students began assignments, and analyze assignment access patterns over time.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

EXTERNAL_SESSION_ID

Business Definition

The EXTERNAL_SESSION_ID column stores external session id information for lz code views records. Its business purpose is to link this lz code views record to related external session data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lz code views 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 student's interaction with an assignment. Its business purpose is to track individual student engagement instances and link them to completion and scoring data. Users and analysts would use this column to join student activity with assignment details and scoring results for comprehensive engagement analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

KLASS_ID

Business Definition

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

Data Type

NUMBER

Nullable

Yes

Last Updated

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

LAST_ANSWERED_AT

Business Definition

The LAST_ANSWERED_AT column records the timestamp when a student last interacted with any item in the assignment. Its business purpose is to track ongoing student engagement and identify when students stopped working. Users and analysts would use this column to calculate time-on-task metrics, identify active vs. abandoned assignments, and analyze student work patterns.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

LMS_INTEGRATION_ID

Business Definition

The LMS_INTEGRATION_ID column stores lms integration id information for lz code views records. Its business purpose is to link this lz code views record to related lms integration data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lz code views data for reporting and analysis.

Data Type

NUMBER

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 code views records. Its business purpose is to link this lz code views record to related lti context data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lz code views data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

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

LTI_LAUNCH_REQUEST

Business Definition

The LTI_LAUNCH_REQUEST column stores lti launch request information for lz code views records. Its business purpose is to support lz code views data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lz code views 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 code views records. Its business purpose is to link this lz code views record to related lti resource link data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lz code views data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

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

LTI_V13_INTEGRATION_ID

Business Definition

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

Data Type

NUMBER

Nullable

Yes

Last Updated

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

LZ_CODE_KLASS_ID

Business Definition

The LZ_CODE_KLASS_ID column is a foreign key linking student activity to the specific assignment-class combination in ILC_LZ_CODE_KLASSES. Its business purpose is to connect students with their class-specific assignment instances (note: this replaces the deprecated ACTIVITY_ID field). Users and analysts would use this column to properly join assignment views with assignment metadata and class context for accurate engagement and completion reporting.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

OPEN_AT

Business Definition

The OPEN_AT column stores the timestamp when the teacher makes the assignment available to the student (can be scheduled in advance). Its business purpose is to control assignment availability and track assignment release timing. Users and analysts would use this column to analyze assignment scheduling patterns, calculate time between assignment release and student completion, and identify proactive vs. reactive assignment distribution.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

RETURN_AT

Business Definition

The RETURN_AT column timestamp when assignment was returned (teachers not required to return assignments). Its business purpose is to support lz code views data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lz code views data for reporting and analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

STUDENT_GRADE_LEVEL_SNAPSHOT

Business Definition

The STUDENT_GRADE_LEVEL_SNAPSHOT column snapshotted grade level of student at time of assignment interaction. Its business purpose is to support lz code views data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lz code views data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

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

STUDENT_ID

Business Definition

The STUDENT_ID column is a foreign key identifying the student who accessed the assignment. Its business purpose is to attribute assignment activity to specific students and enable student-level completion tracking. Users and analysts would use this column to calculate student engagement metrics, identify active vs. inactive students, and analyze individual student learning patterns.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

STUDENT_SCHOOL_SNAPSHOT_ID

Business Definition

The STUDENT_SCHOOL_SNAPSHOT_ID column foreign key to ilc_schools(id) - snapshotted school of student at time of assignment interaction. Its business purpose is to link this lz code views record to related student school snapshot data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate lz code views data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

SUBMITTED

Business Definition

The SUBMITTED column stores submitted information for lz code views 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 lz code views data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

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

UPDATED_AT

Business Definition

The UPDATED_AT column timestamp when record 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 code views data for reporting and analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

VIEWED_AT

Business Definition

The VIEWED_AT column timestamp when assignment was viewed. Its business purpose is to support lz code views data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate lz code views data for reporting and analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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