Skip to content

Assignable Activity Dim

Table Overview

This table contains 31 columns.

Quick Navigation

Column Definitions

activity_category

Business Definition

The ACTIVITY_CATEGORY column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents the type of activity within the instructional design, such as Instruction, Practice, Quiz, or Assessment. Its business purpose is to classify activities for content type filtering and pedagogical analysis. Users and analysts would use this column to understand the distribution of different activity types and to analyze the effectiveness of various instructional methods.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:23:49.606000 by MARKDOWN_IMPORT

activity_description

Business Definition

The ACTIVITY_DESCRIPTION column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents a detailed narrative description of activity content, learning objectives, and instructional context sourced from the curriculum authoring system. It serves the business purpose of providing educators with comprehensive information about the activities, aiding in content discovery and cataloging. Users and analysts would use this column to understand the specifics of each activity, including its educational goals and instructional guidance, to effectively plan and implement educational programs.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:23:50.554000 by MARKDOWN_IMPORT

activity_grade

Business Definition

The ACTIVITY_GRADE column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents the target grade level for activity content, aligned with curriculum standards (e.g., 'Grade 3', 'Grade 9-12'). Users and analysts would use this column to filter activities by grade level for grade-appropriate content and compliance reporting.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:23:51.331000 by MARKDOWN_IMPORT

activity_is_counted

Business Definition

ACTIVITY_IS_COUNTED indicates whether an activity contributes to the overall course grade, helping educators and analysts track student progress and calculate final grades. It is derived from metadata and is particularly useful for distinguishing between graded and non-graded activities, with EdgeEx-based assignments marked as NULL.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-10T02:23:52.114000 by MARKDOWN_IMPORT

activity_name

Business Definition

The ACTIVITY_NAME column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents the user-facing title of an activity from the curriculum structure, extracted from the ASSIGNABLE_EVENT_LOG table. Its business purpose is to provide a clear and recognizable name for activities, which is used in the user interface and for reporting purposes. Users and analysts would use this column to identify specific activities and analyze their occurrences and performance within the curriculum.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:23:52.800000 by MARKDOWN_IMPORT

activity_path_id

Business Definition

The ACTIVITY_PATH_ID column represents a unique identifier for the path of an activity within the WELD_NORTH_PROD system. Its business purpose is to link activities to detailed path and content metadata, including version, type, and hierarchy, which is stored in the PATH_DIM table. Users and analysts would use this column to track specific activities, understand their context within the curriculum, and perform metadata joins for comprehensive analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:23:53.719000 by MARKDOWN_IMPORT

activity_path_metadata_key

Business Definition

The column "ACTIVITY_PATH_METADATA_KEY" represents a unique identifier linking activities to their corresponding metadata in the PATH_METADATA_DIM table. Its business purpose is to provide detailed metadata, versioning, and configuration information for each activity, enabling users and analysts to access comprehensive activity-level data for analysis and reporting.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:23:54.489000 by MARKDOWN_IMPORT

activity_type

Business Definition

The ACTIVITY_TYPE column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents the type of content delivery method for an activity, such as InteractiveContent, Video, Assessment, EmbeddedResource, or ExternalLink. Its business purpose is to categorize activities based on how they are delivered and interacted with, helping users and analysts understand the nature of each activity and determine the appropriate rendering engine and interaction patterns.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:23:55.157000 by MARKDOWN_IMPORT

assignable_activity_key

Business Definition

The ASSIGNABLE_ACTIVITY_KEY column uniquely identifies each activity within an assignment, combining the assignment UUID, lesson path ID, and activity path ID. This key is essential for tracking and reporting on individual activities, ensuring accurate deduplication and enabling detailed analysis of assignments and activities. Users and analysts can use this column to trace the lineage of activities and generate comprehensive reports on assignment progress and performance.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:23:55.896000 by MARKDOWN_IMPORT

assignable_key

Business Definition

The ASSIGNABLE_KEY column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents a unique identifier that links activities to their parent assignments. Its business purpose is to facilitate hierarchical reporting by establishing a relationship between assignments and their associated activities, allowing users and analysts to track and analyze activities within the context of their parent assignments.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:23:56.845000 by MARKDOWN_IMPORT

assignable_path_metadata_key

Business Definition

The column "ASSIGNABLE_PATH_METADATA_KEY" represents a unique identifier linking to metadata about paths at the assignment level, specifically for EdgeEx data. Its business purpose is to provide additional context or details about the paths assigned to activities, helping users and analysts understand the specific characteristics or attributes of these paths. Users would utilize this column to join with the PATH_METADATA_DIM table to retrieve comprehensive metadata, enhancing their analysis of assignment activities within the EdgeEx system.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:23:57.456000 by MARKDOWN_IMPORT

assignable_uuid

Business Definition

The ASSIGNABLE_UUID column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents a unique identifier for assignments, serving as a business key derived from the assignable_event_log.object_id via the assignments_activated_deactivated CTE. Users and analysts would use this column to track and link specific assignments, facilitating the identification of parent assignments and ensuring data integrity across related records.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:23:58.569000 by MARKDOWN_IMPORT

dw_created_by

Business Definition

The "DW_CREATED_BY" column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents the Snowflake user account that created the record. Its business purpose is to track the user or service account responsible for the record creation, providing accountability and aiding in data lineage. Users and analysts would use this column to identify who created specific records, which is useful for auditing and troubleshooting purposes.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:23:59.141000 by MARKDOWN_IMPORT

dw_created_on

Business Definition

The column "DW_CREATED_ON" in the table WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM represents the timestamp when a record was first created in the data warehouse. Its business purpose is to track the exact time of record creation, providing an audit trail for when data was initially inserted. Users and analysts would use this column to understand the chronology of data entry and to ensure data integrity by verifying the creation timestamps.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

is_deleted

Business Definition

The "IS_DELETED" column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table indicates whether an activity has been logically deleted from the EdgeEx curriculum, serving as a soft delete flag for content lifecycle management. Users and analysts can utilize this column to filter out or identify activities that are no longer active in the curriculum, ensuring they are working with current and relevant data.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

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

item_path_uuid_path_metadata_key

Business Definition

The column "ITEM_PATH_UUID_PATH_METADATA_KEY" represents a JSON object that maps question item UUIDs to their corresponding path metadata keys, combining data from multiple sources such as MPNG, formative, and EdgeEx question sources. Its business purpose is to enable question-level content tracking, versioning, and analytics, which is critical for item-level reporting. Users and analysts would use this column to track and analyze the path metadata associated with specific question items, facilitating detailed insights and reporting on question-level data.

Data Type

VARIANT

Nullable

Yes

Last Updated

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

item_type_label

Business Definition

The ITEM_TYPE_LABEL column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents a type label for content items, specifically indicating whether an activity contains trackable question content. Its business purpose is to help users and analysts filter and identify question-based activities within the dataset. Users would utilize this column to quickly determine which activities involve questions, facilitating more targeted analysis and reporting.

Data Type

TEXT

Nullable

Yes

Last Updated

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

lesson_domain_id

Business Definition

The LESSON_DOMAIN_ID column represents a unique identifier for the curriculum domain taxonomy, extracted from the ASSIGNABLE_EVENT_LOG table. Its business purpose is to link lessons to specific domains and standards alignment systems, allowing users and analysts to categorize and analyze educational content based on its domain.

Data Type

TEXT

Nullable

Yes

Last Updated

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

lesson_domain_name

Business Definition

The column "LESSON_DOMAIN_NAME" represents the curriculum domain or subject area, such as Mathematics, Science, or English Language Arts, associated with an assignable activity. Its business purpose is to categorize activities by their subject matter, enabling users and analysts to filter and report on activities based on specific subjects.

Data Type

TEXT

Nullable

Yes

Last Updated

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

lesson_domain_standard

Business Definition

The column "LESSON_DOMAIN_STANDARD" represents the educational standard code or framework that a lesson addresses, such as Common Core State Standards or state-specific standards. Its business purpose is to ensure compliance and facilitate standards-aligned reporting. Users and analysts would use this column to track and analyze the alignment of lessons with educational standards, aiding in curriculum planning and assessment.

Data Type

TEXT

Nullable

Yes

Last Updated

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

lesson_grade_level

Business Definition

The "LESSON_GRADE_LEVEL" column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents the target grade level for the entire lesson, which may differ from the grade level of individual activities within the lesson. This column is used to understand the overall difficulty level of a lesson, helping users and analysts to assess the appropriateness of the lesson for different student groups and to analyze the distribution of lesson difficulties across various educational programs.

Data Type

TEXT

Nullable

Yes

Last Updated

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

lesson_name

Business Definition

The LESSON_NAME column in the ASSIGNABLE_ACTIVITY_DIM table represents the display name of the parent lesson that contains a specific activity, extracted from the learning path structure. It is used to identify and navigate through the curriculum content in the user interface, helping users and analysts understand the context of each activity within its respective lesson.

Data Type

TEXT

Nullable

Yes

Last Updated

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

lesson_path_id

Business Definition

The LESSON_PATH_ID column represents a unique identifier for the parent lesson within the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table. Its business purpose is to link to the PATH_DIM table for lesson structure and metadata, enabling users and analysts to track and analyze specific lessons within the system.

Data Type

TEXT

Nullable

Yes

Last Updated

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

lesson_path_metadata_key

Business Definition

The column "LESSON_PATH_METADATA_KEY" represents a unique identifier linking to detailed metadata about lessons, including titles, authors, and standards. Its business purpose is to facilitate access to comprehensive lesson information, enabling users and analysts to join this data with other datasets for detailed analysis and reporting on educational content.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

lesson_type

Business Definition

The "LESSON_TYPE" column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents the type of lesson content, distinguishing between standard instructional lessons and evaluative assessments. Its business purpose is to categorize activities as either instructional or assessment-based, allowing users and analysts to differentiate between learning and evaluation activities for better analysis and reporting.

Data Type

TEXT

Nullable

Yes

Last Updated

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

split_name

Business Definition

The SPLIT_NAME column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents the name of a split or section within a lesson, specifically for EdgeEx content. It is used to identify subdivisions within lessons, helping users and analysts understand the structure and organization of educational content. This column is particularly useful for analyzing and reporting on the granular components of lessons, enabling more detailed insights into the educational material.

Data Type

TEXT

Nullable

Yes

Last Updated

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

split_path_id

Business Definition

The SPLIT_PATH_ID column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents a unique identifier for the lesson split or section path within the EdgeEx content. Its business purpose is to link to the path_dim table, enabling users and analysts to track and analyze specific lesson splits or sections within the EdgeEx system, while it remains NULL for Armstrong/MPNG content.

Data Type

TEXT

Nullable

Yes

Last Updated

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

split_path_metadata_key

Business Definition

The column "SPLIT_PATH_METADATA_KEY" in the table WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM represents a foreign key that links to the PATH_METADATA_DIM table for split-level metadata, specifically for EdgeEx data. Its business purpose is to provide a reference to detailed path metadata for activities that are split into multiple levels, aiding users and analysts in understanding the hierarchical structure of these activities. This column is particularly useful for users and analysts who need to trace the path metadata associated with split activities, enabling them to perform detailed analysis and reporting on these activities.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

unit_name

Business Definition

The UNIT_NAME column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM table represents the name of a curricular unit within the EdgeEx content hierarchy, specifically at the unit level between course and lesson. Its business purpose is to organize and categorize EdgeEx content, allowing users and analysts to filter and analyze activities based on their respective units.

Data Type

TEXT

Nullable

Yes

Last Updated

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

unit_path_id

Business Definition

The UNIT_PATH_ID column represents a unique identifier for the parent unit's path in the hierarchy, specifically for EdgeEx content. Its business purpose is to link to unit-level metadata in the PATH_DIM table, providing context for the hierarchical structure of units. Users and analysts would use this column to trace and analyze the hierarchical relationships and metadata associated with specific units within the EdgeEx system.

Data Type

TEXT

Nullable

Yes

Last Updated

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

unit_path_metadata_key

Business Definition

The column "UNIT_PATH_METADATA_KEY" in the table WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM represents a foreign key that links to the PATH_METADATA_DIM table, providing unit-level metadata specifically for EdgeEx data. Its business purpose is to facilitate the association of unit-level activities with their corresponding metadata, enabling users and analysts to understand the context and details of these activities. Users would utilize this column to join with the PATH_METADATA_DIM table to retrieve comprehensive metadata information for EdgeEx units, while it remains NULL for Armstrong/MPNG content.

Data Type

NUMBER

Nullable

Yes

Last Updated

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