Skip to content

Ilc Data Dashboard Item Scores

Table Overview

This table contains 10 columns.

Quick Navigation

Column Definitions

EXTERNAL_ITEM_REFERENCE

Business Definition

The EXTERNAL_ITEM_REFERENCE column stores external item reference information for data dashboard item scores records. Its business purpose is to support data dashboard item scores data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate data dashboard item scores data for reporting and analysis.

Data Type

TEXT

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 data dashboard item scores records. Its business purpose is to link this data dashboard item scores record to related external session data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate data dashboard item scores data for reporting and analysis.

Data Type

TEXT

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 data dashboard item scores records. Its business purpose is to support data dashboard item scores data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate data dashboard item scores 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 item-level score record used to build data dashboard views. Its business purpose is to track individual assessment item results and enable item-level analytics. Users and analysts would use this column to join item scores with assignment context, student information, and standards alignment for granular assessment analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

IS_ATTEMPTED

Business Definition

The IS_ATTEMPTED column indicates whether student attempted this item. 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 data dashboard item scores data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

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

IS_GRADED

Business Definition

The IS_GRADED column indicates whether the item has been graded (set to true when assignment is closed and all items are either scored or unattempted with default 0). Its business purpose is to distinguish final scores from in-progress work. Users and analysts would use this column to filter for completed assignments only, ensure accurate reporting of finalized results, and track grading completion status.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

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

MAX_SCORE

Business Definition

The MAX_SCORE column indicates the maximum possible points for this assessment item. Its business purpose is to enable percentage score calculations and normalize scoring across different item types. Users and analysts would use this column to calculate percentage correct, compare item difficulty, and standardize scores for cross-item analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

PULLED_AT

Business Definition

The PULLED_AT column stores pulled at information for data dashboard item scores records. Its business purpose is to support data dashboard item scores data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate data dashboard item scores data for reporting and analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

SCORE

Business Definition

The SCORE column contains the points earned by the student on this specific assessment item. Its business purpose is to track item-level performance and support scoring calculations. Users and analysts would use this column to calculate item difficulty metrics, aggregate assignment scores, analyze student performance patterns, and identify items requiring instructional attention.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

UPDATED_AT

Business Definition

The UPDATED_AT column timestamp of last pull for data dashboard. 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 data dashboard item scores data for reporting and analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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