Skip to content

Assignable Dim

Table Overview

This table contains 39 columns.

Quick Navigation

Column Definitions

academic_session_group_key

Business Definition

Groups related academic sessions together for assignments that span multiple sessions. This key links various academic sessions to a single group, making it easier to manage and track assignments across different sessions. It is not used for course sections or independent content, and thus, may often be empty (NULL).

Data Type

NUMBER

Nullable

No

Last Updated

2025-12-10T02:24:14.185000 by MARKDOWN_IMPORT

activity_count

Business Definition

It represents total number of individual activities within an assignable item. For assignments, this is the count of activities from the flattened object items hierarchy. For EdgeEx courses and bundles, it is the sum of all leaf activities. Useful for estimating workload.

Data Type

NUMBER

Nullable

No

Last Updated

2025-12-10T02:24:14.860000 by MARKDOWN_IMPORT

assignable_key

Business Definition

Uniquely identifies each assignable entity, such as a course section, assignment, course, or bundle, across all sources. This is a system-generated number that ensures each entity has a distinct identifier. It is preserved for existing records and automatically generated for new ones.

Data Type

NUMBER

Nullable

No

Last Updated

2025-12-10T02:24:15.709000 by MARKDOWN_IMPORT

assignable_sub_type

Business Definition

Represents the sub-classification or scope of an assignment, providing a more detailed categorization beyond the main type. It aggregates unique values from the path metadata of included lessons, such as 'Course Section' or 'Formative'. This field is specific to assignments and is left empty for course sections and EdgeEx courses/bundles.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:16.875000 by MARKDOWN_IMPORT

assignable_type

Business Definition

Indicates the type of assignable content. Possible values include 'CourseSection' for class instances, 'Assignment' for custom learning paths, 'Course' for EdgeEx courses, and 'Bundle' for Math+ bundles.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:18.517000 by MARKDOWN_IMPORT

assignable_uuid

Business Definition

Identifies the specific assignable entity, such as a course section, assignment, or EdgeEx course/bundle, using a unique identifier from the source systems. This ID is consistent across all event streams and helps track the same entity throughout different processes. It is a 36-character text string that ensures each assignable entity is distinctly recognized.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:19.422000 by MARKDOWN_IMPORT

completion_time

Business Definition

Represents the estimated or actual time required to complete a task, measured in minutes or hours. This field is currently not populated but is reserved for future use to capture either predicted or observed completion times.

Data Type

NUMBER

Nullable

No

Last Updated

2025-12-10T02:24:20.899000 by MARKDOWN_IMPORT

course_edition

Business Definition

Represents the version or edition of the course curriculum. Tracks curriculum revisions and updates for course sections, with higher numbers indicating more recent versions. For assignments and certain courses, this value may be left empty.

Data Type

NUMBER

Nullable

No

Last Updated

2025-12-10T02:24:21.799000 by MARKDOWN_IMPORT

course_family

Business Definition

Groups related course offerings into high-level family classifications for curriculum organization and reporting. Applicable only to course sections, with possible values such as 'Science', 'Humanities', or 'Mathematics'. May be NULL for assignments and certain specialized courses.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:22.505000 by MARKDOWN_IMPORT

course_length

Business Definition

Duration or length classification of the course. This column can include values like 'Year', 'Semester', or 'Module' to indicate the time span or credit hours of the course. It is currently reserved for future enhancements.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:23.363000 by MARKDOWN_IMPORT

course_series

Business Definition

Identifies the course series or sequence within a family of related courses. For example, it might include values like 'Algebra 1', 'Algebra 2' to track progressions. Only applicable to course sections; not used for assignments or EdgeEx courses/bundles.

Data Type

ARRAY

Nullable

No

Last Updated

2025-12-10T02:24:23.990000 by MARKDOWN_IMPORT

description

Business Definition

Represents a detailed, long-form textual description of the assignable content, learning objectives, or course summaries. Currently not populated but reserved for future use to provide comprehensive information about the content.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:24.903000 by MARKDOWN_IMPORT

dw_created_by

Business Definition

Username of the data warehouse user who created the record. Automatically set to the current user at the time of insertion, such as 'SVC_DATA_LOADevents' or 'SVC_DATA_LOADedgeex'. This value is preserved across updates.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:25.733000 by MARKDOWN_IMPORT

dw_created_on

Business Definition

The timestamp when the record was first created in the data warehouse. Automatically set to the current timestamp at the time of insertion and preserved across updates. Marks the initial entry of the record into the system.

Data Type

TIMESTAMP_NTZ

Nullable

No

Last Updated

2025-12-10T02:24:26.835000 by MARKDOWN_IMPORT

dw_effective_end_date

Business Definition

Represents the end date of the current version of a record. Set to '2999-12-31' for active records and updated to the current timestamp when a new version is created. Defines the period during which the record is considered valid.

Data Type

TIMESTAMP_NTZ

Nullable

No

Last Updated

2025-12-10T02:24:27.450000 by MARKDOWN_IMPORT

dw_effective_start_date

Business Definition

Represents the start date and time when a record becomes active or is inserted. This timestamp marks the beginning of the record's validity period and is crucial for tracking changes over time in a slowly changing dimension. It is set to the current timestamp when the record is created or updated.

Data Type

TIMESTAMP_NTZ

Nullable

No

Last Updated

2025-12-10T02:24:28.384000 by MARKDOWN_IMPORT

dw_is_active

Business Definition

Indicates whether a record is currently active. Values are 'True' for active records and 'False' for historical or superseded records. This helps in easily identifying the current state of records.

Data Type

BOOLEAN

Nullable

No

Last Updated

2025-12-10T02:24:29.027000 by MARKDOWN_IMPORT

dw_updated_by

Business Definition

Identifies the Snowflake user who last updated the data warehouse record. This is typically a service account like 'SVC_DATA_LOADevents' or 'SVC_DATA_LOADedgeex', but can also include manual updates such as 'manual_backfill_subject'.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:29.769000 by MARKDOWN_IMPORT

dw_updated_on

Business Definition

The timestamp when the record was last updated or inserted in the data warehouse. This field is automatically set to the current timestamp whenever the record is modified or newly added, helping to track the most recent change.

Data Type

TIMESTAMP_NTZ

Nullable

No

Last Updated

2025-12-10T02:24:30.378000 by MARKDOWN_IMPORT

grade_levels

Business Definition

Represents the grade levels targeted by an assignment. This is an array of grade levels aggregated from the metadata of included lessons, supporting assignments that span multiple grades. For course sections and EdgeEx content, this field is left empty.

Data Type

ARRAY

Nullable

No

Last Updated

2025-12-10T02:24:31.388000 by MARKDOWN_IMPORT

implementation_type

Business Definition

Describes the method of delivery or implementation for an assignable item. Currently unused, but reserved for future use to classify types such as 'Blended', 'Virtual', or 'Traditional'. May include values like 'IC', 'CR', 'HON', 'AG_CR', or 'GR'.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:32.626000 by MARKDOWN_IMPORT

internal_title

Business Definition

Internal title used for administrative purposes, which may differ from the display title for technical identification or legacy system compatibility. This field is typically null for course sections and assignments but uses an internal naming convention for EdgeEx courses and bundles.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:33.337000 by MARKDOWN_IMPORT

lesson_count

Business Definition

Represents the total number of lessons within an assignable item. For assignments, it counts lessons excluding assessments. For EdgeEx courses and bundles, it sums up distinct lessons, indicating the depth of content available.

Data Type

NUMBER

Nullable

No

Last Updated

2025-12-10T02:24:34.238000 by MARKDOWN_IMPORT

metadata

Business Definition

Contains structured metadata or additional properties about the assignable item. Currently not populated, but reserved for future use to store custom fields, tags, or other attributes. This could include information like 'priority', 'status', or 'category'.

Data Type

VARIANT

Nullable

No

Last Updated

2025-12-10T02:24:34.919000 by MARKDOWN_IMPORT

parent_assignable_uuid

Business Definition

Identifies the unique identifier of the parent item in the content hierarchy, such as the course for course sections or the learning path for assignments. This field is empty for top-level content like EdgeEx courses or bundles. It helps in understanding the hierarchical structure of educational content.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:35.617000 by MARKDOWN_IMPORT

primary_teacher_user_key

Business Definition

Identifies the primary teacher for a course section by referencing a unique user key from the user dimension. If no primary teacher is assigned or the user is not found, it defaults to -1. This field is not applicable for assignments or EdgeEx courses/bundles.

Data Type

NUMBER

Nullable

No

Last Updated

2025-12-10T02:24:36.221000 by MARKDOWN_IMPORT

primary_teacher_user_uuid

Business Definition

Identifies the primary teacher responsible for a course section using a unique identifier. This field is derived from the group membership log and is only populated for active primary teacher roles. It is left empty for assignments and certain types of courses that do not have a designated teacher.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:37.260000 by MARKDOWN_IMPORT

school_org_key

Business Definition

Identifies the school or organization that owns a particular course section or assignment. This is done by matching organization IDs and types, and it's left blank for content that isn't tied to a specific organization.

Data Type

NUMBER

Nullable

No

Last Updated

2025-12-10T02:24:38.261000 by MARKDOWN_IMPORT

school_org_uuid

Business Definition

Identifies the unique school or organization that owns a particular assignable item, using a universal identifier. This ID links to the organization's master data across different systems. It is derived from the course section event log or academic session data, but may be NULL for certain courses or bundles.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:39.439000 by MARKDOWN_IMPORT

school_year

Business Definition

Represents the school year associated with an assignable item, such as a course section or assignment. Values are integers like '2024', '2025', or '2026'. This field is NULL for evergreen content that is not tied to a specific academic year.

Data Type

NUMBER

Nullable

No

Last Updated

2025-12-10T02:24:40.169000 by MARKDOWN_IMPORT

secondary_teacher_user_group_key

Business Definition

Represents the group of secondary teachers associated with a course section. If there are no secondary teachers, it defaults to -1. This field is not applicable for assignments or EdgeEx courses/bundles.

Data Type

NUMBER

Nullable

No

Last Updated

2025-12-10T02:24:41.058000 by MARKDOWN_IMPORT

source

Business Definition

Identifies the source system or product that created or owns the assignable. Values include 'EdgeEx' for course sections and content library, 'MPNG' for assignments, and 'Math+' for Math+ curriculum.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:41.764000 by MARKDOWN_IMPORT

start_date

Business Definition

Represents the date and time when an assignable item, such as a course section or assignment, becomes available or active. For course sections, this is derived from the academic session metadata. For assignments, it is taken from the event payload or resource management data. This field is NULL for evergreen content that is always available.

Data Type

TIMESTAMP_NTZ

Nullable

No

Last Updated

2025-12-10T02:24:42.415000 by MARKDOWN_IMPORT

state_course_code

Business Definition

State-mandated course identification code for compliance and reporting purposes. Reserved for future use to link course sections to state curriculum standards. Currently not populated.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:43.087000 by MARKDOWN_IMPORT

status

Business Definition

Represents the current status of an assignable item. For course sections, it directly shows the object status. For assignments, it indicates whether the item is 'ACTIVE' or 'INACTIVE' based on activation events. Values include 'ACTIVE' and 'ARCHIVED'.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:43.664000 by MARKDOWN_IMPORT

subject

Business Definition

Represents the subject area or discipline for assignments, such as 'Social Studies', 'Math', or 'Language Arts'. For assignments, it's a comma-separated list of unique subjects aggregated from the included lessons. This column is left empty for course sections and EdgeEx courses/bundles.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:44.513000 by MARKDOWN_IMPORT

submit_date

Business Definition

Represents the due date or end date for an assignable item. For course sections, this is derived from the academic session metadata. For assignments, it is taken from the event payload or resource management data. This field is NULL for open-ended content.

Data Type

TIMESTAMP_NTZ

Nullable

No

Last Updated

2025-12-10T02:24:45.329000 by MARKDOWN_IMPORT

title

Business Definition

Represents the title of the assignable item as displayed to users. This could be the title of a course section, assignment, or EdgeEx course/bundle. It serves as the primary human-readable name from the source system.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:24:46.226000 by MARKDOWN_IMPORT

unit_count

Business Definition

Represents the total number of units or modules within EdgeEx courses or bundles. This count reflects the highest-level content organization, with typical values ranging from '5' to '14'. The column is not populated for course sections and assignments.

Data Type

NUMBER

Nullable

No

Last Updated

2025-12-10T02:24:46.956000 by MARKDOWN_IMPORT