Skip to content

Activity Attempt Fact

Table Overview

This table contains 41 columns.

Quick Navigation

Column Definitions

academic_integrity_actor

Business Definition

The ACADEMIC_INTEGRITY_ACTOR column identifies the individual or system that initiated an academic integrity scan for a student activity attempt. This information is crucial for analyzing who or what triggered the scan, helping to understand the context and frequency of integrity checks. Note that this column is populated based on the most recent 'Ranked' event in the feedback event log, so it reflects the latest actor involved in the integrity process.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:12:55.254000 by VISHAL.PATIL@IMAGINELEARNING.COM

academic_integrity_scan_dt

Business Definition

The ACADEMIC_INTEGRITY_SCAN_DT column records the date and time when an academic integrity scan was completed for a student's activity attempt. This information is crucial for analyzing the timeliness and frequency of integrity checks, helping to ensure that all submissions are reviewed promptly. Note that this timestamp reflects the completion of the scan, not the start, and it is derived from the most recent 'Ranked' event in the feedback log.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T01:12:53.658000 by VISHAL.PATIL@IMAGINELEARNING.COM

activity_assessment_type

Business Definition

The ACTIVITY_ASSESSMENT_TYPE column in the Student Activity Attempts Fact Table indicates whether an assessment is a 'PreTest' or 'PostTest'. This classification is crucial for analyzing student performance before and after instruction, helping educators and administrators evaluate the effectiveness of teaching methods. Note that this column is primarily used in EdgeEx for diagnostic versus mastery assessments and may contain NULL values if the assessment type is not specified.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:12:56.783000 by VISHAL.PATIL@IMAGINELEARNING.COM

activity_attempt_fact_key

Business Definition

The ACTIVITY_ATTEMPT_FACT_KEY uniquely identifies each instance where a student attempts a specific activity within the system. This key is crucial for tracking and analyzing individual student performance and engagement with various activities. It is generated by combining several identifiers to ensure each attempt is distinctly recorded, which is essential for accurate reporting and analysis. Note that this key is a composite of multiple identifiers, so any changes in the underlying data (such as user IDs or activity paths) could affect its uniqueness.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:11:56.705000 by VISHAL.PATIL@IMAGINELEARNING.COM

activity_last_attempted_on

Business Definition

The ACTIVITY_LAST_ATTEMPTED_ON column in the Student Activity Attempts Fact Table records the most recent date and time a student interacted with a specific activity. This information is crucial for analyzing student engagement and progress, as it helps identify when students last attempted an activity. It's important to note that this timestamp is updated incrementally as the student continues working, so it always reflects the latest interaction.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T01:12:38.120000 by VISHAL.PATIL@IMAGINELEARNING.COM

activity_name

Business Definition

The ACTIVITY_NAME column in the Student Activity Attempts Fact Table represents the human-readable name of the learning activity that a student has attempted. This column is crucial for analysis and reporting as it identifies the specific learning object completed, allowing educators and analysts to track student engagement and performance across different activities. It is important to note that the primary source for this name is the activity title from metadata, but it may fall back to the path name if the title is not available, ensuring that every activity has a name for reporting purposes.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:12:19.078000 by VISHAL.PATIL@IMAGINELEARNING.COM

activity_path_id

Business Definition

The ACTIVITY_PATH_ID column uniquely identifies the specific path or sequence of activities that a student follows within a course or learning module. This identifier is crucial for analyzing student progression and performance across different learning paths, allowing educators and analysts to understand how students navigate through the content. It's important to note that this ID is used to link activities to their respective content paths, ensuring accurate tracking and reporting of student activity attempts.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T01:12:25.695000 by VISHAL.PATIL@IMAGINELEARNING.COM

activity_score

Business Definition

The ACTIVITY_SCORE column represents the student's performance on a specific activity, scored on a scale of 0 to 100. This score is used to evaluate student progress and identify areas where additional support may be needed. It is calculated based on the sum of points earned divided by the total possible points, with a preference for the score from the TakeCompleted event if available. Please note that this score is an aggregated value and may not reflect individual event scores.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T01:12:33.014000 by VISHAL.PATIL@IMAGINELEARNING.COM

activity_started_on

Business Definition

The "ACTIVITY_STARTED_ON" column in the Student Activity Attempts Fact Table records the exact time when a student first began an activity. This timestamp is crucial for analyzing student engagement and performance, as it helps track the start of each attempt. Note that this time is determined by the earliest recorded interaction with the activity, so it may not capture any preparatory work done before the first logged event.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T01:12:36.576000 by VISHAL.PATIL@IMAGINELEARNING.COM

activity_type

Business Definition

The ACTIVITY_TYPE column in the Student Activity Attempts Fact Table indicates the format or type of educational activity, such as a video, quiz, interactive session, or assignment. This information is crucial for analyzing the types of activities students engage with, helping to understand preferences and effectiveness of different instructional modalities. Note that this column may include data from multiple sources, and in some cases, the activity type might be derived from the definition type if the primary source is unavailable.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:12:20.761000 by VISHAL.PATIL@IMAGINELEARNING.COM

ai_detected_score

Business Definition

The AI_DETECTED_SCORE column represents the highest probability score (ranging from 0 to 1) that indicates the likelihood of content being generated by AI, as detected during student activity attempts. This score is used to analyze the prevalence of AI-generated content in student submissions and to identify potential instances of academic dishonesty. It's important to note that higher scores suggest a greater likelihood of AI-generated content, but they are not definitive proof and should be reviewed in context.

Data Type

FLOAT

Nullable

Yes

Last Updated

2025-12-10T01:12:50.309000 by VISHAL.PATIL@IMAGINELEARNING.COM

app_domain_key

Business Definition

The APP_DOMAIN_KEY column in the Student Activity Attempts Fact Table identifies the specific application environment where a student's activity took place, such as production, test, or edgeex. This information is crucial for analysis and reporting, as it allows us to filter and compare student activities across different environments. It's important to note that this column is used to exclude certain domains like 'student.ex.edgenuity.com' in regular events but includes it in edgeex events, which may affect data interpretation.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T01:12:02.972000 by VISHAL.PATIL@IMAGINELEARNING.COM

application_key

Business Definition

The APPLICATION_KEY column in the ACTIVITY_ATTEMPT_FACT table identifies the specific application within our system that generated a student activity event. This information is crucial for analyzing which applications are most frequently used by students and for understanding the distribution of activities across different applications. It's important to note that this key references the APPLICATION_DIM table for detailed application context, and in some cases, it may default to -1 if the application is not specified.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T01:12:04.401000 by VISHAL.PATIL@IMAGINELEARNING.COM

assignable_key

Business Definition

The ASSIGNABLE_KEY column in the ACTIVITY_ATTEMPT_FACT table represents a unique identifier for each assignment or task that students attempt. This key is essential for analyzing student performance and engagement by linking each attempt to a specific assignment. It's important to note that this key is only active for current assignments, so historical or inactive assignments are not included.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T01:13:01.324000 by VISHAL.PATIL@IMAGINELEARNING.COM

assignable_uuid

Business Definition

The ASSIGNABLE_UUID column represents a unique identifier for each assignment or task that a student attempts. This identifier is crucial for tracking and analyzing student performance across different assignments, allowing for detailed reporting on individual and group progress. It is important to note that this identifier links to additional assignment metadata, providing a comprehensive view of the assignment details.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:12:59.671000 by VISHAL.PATIL@IMAGINELEARNING.COM

course_id

Business Definition

The COURSE_ID column in the ACTIVITY_ATTEMPT_FACT table represents the unique identifier for a course or curriculum program that a student is enrolled in. This column is essential for course-level reporting and analysis, allowing users to track student activity and performance within specific courses. It's important to note that the COURSE_ID may come from different sources depending on the context (e.g., assignment IDs from learning paths or course IDs from content logs), so consistency in reporting should be verified.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:12:47.318000 by VISHAL.PATIL@IMAGINELEARNING.COM

dw_created_by

Business Definition

The "DW_CREATED_BY" column in the Student Activity Attempts Fact Table indicates the user who initially created the record in the data warehouse. This information is useful for tracking the origin of data entries and can be used for auditing and accountability purposes in reports and analyses. Note that this field is automatically set to the current user at the time of record creation and is preserved during any subsequent updates.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:12:42.707000 by VISHAL.PATIL@IMAGINELEARNING.COM

dw_created_on

Business Definition

The "DW_CREATED_ON" column in the Student Activity Attempts Fact Table represents the date and time when a record was first added to the data warehouse. This timestamp is crucial for tracking when student activity data was initially captured, allowing analysts to understand the chronology of data entry and perform time-based analyses. It's important to note that this timestamp is set automatically when the record is created and remains unchanged during any subsequent updates, ensuring the original entry time is preserved.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T01:12:41.521000 by VISHAL.PATIL@IMAGINELEARNING.COM

dw_updated_by

Business Definition

The "DW_UPDATED_BY" column in the Student Activity Attempts Fact Table indicates the user who last modified the record. This information is useful for tracking changes and understanding who made updates, which can be crucial for auditing and accountability purposes. Note that this field is automatically updated to the current user during any modification, ensuring accurate tracking of changes.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:12:45.605000 by VISHAL.PATIL@IMAGINELEARNING.COM

dw_updated_on

Business Definition

The "DW_UPDATED_ON" column in the ACTIVITY_ATTEMPT_FACT table represents the most recent time a student activity attempt record was updated in the data warehouse. This timestamp is crucial for tracking the freshness of data and is often used in analysis and reporting to ensure that the latest information is being considered. It's important to note that this timestamp is updated every time the record is modified, so it reflects the last change made to the data, not necessarily the time of the student's activity attempt.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T01:12:44.299000 by VISHAL.PATIL@IMAGINELEARNING.COM

is_activity_completed

Business Definition

The "IS_ACTIVITY_COMPLETED" column in the Student Activity Attempts Fact Table indicates whether a student has completed a specific activity. This flag is used to analyze student progress and completion rates, helping to identify which activities have been successfully finished. It's important to note that this column is based on the presence of a 'TakeCompleted' event, so it may not capture all nuances of activity completion if the event is not properly recorded.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-10T01:12:40.026000 by VISHAL.PATIL@IMAGINELEARNING.COM

is_speed_radar_violated

Business Definition

The column "IS_SPEED_RADAR_VIOLATED" indicates whether a student completed an activity suspiciously fast, potentially suggesting that they may have rushed through it. This flag is useful for analyzing student engagement and identifying instances where the activity might not have been thoroughly completed. It's important to note that this flag is based on automated detection and may not always accurately reflect the student's actual engagement level.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-10T01:12:58.154000 by VISHAL.PATIL@IMAGINELEARNING.COM

lesson_attempt_id

Business Definition

The LESSON_ATTEMPT_ID column uniquely identifies each attempt a student makes to complete a lesson. This identifier is crucial for tracking and analyzing student progress across multiple activities within the same lesson session. It is important to note that this field is only populated for events data and will be empty for EdgeEx data.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:13:02.655000 by VISHAL.PATIL@IMAGINELEARNING.COM

lesson_name

Business Definition

The LESSON_NAME column in the ACTIVITY_ATTEMPT_FACT table represents the name of the lesson that contains the activity attempted by a student. This information is useful for analyzing which lessons are most frequently attempted or completed, helping educators understand student engagement and progress. Note that this column may be empty for activities that are not part of a specific lesson.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:12:17.114000 by VISHAL.PATIL@IMAGINELEARNING.COM

lesson_path_id

Business Definition

The LESSON_PATH_ID column represents a unique identifier for the lesson content path associated with a student's activity attempt. This column is used to analyze and report on student engagement and performance within specific lesson paths, helping to identify trends and areas for improvement. It's important to note that this field may be empty (NULL) for standalone activities that are not part of a lesson path, so not all activity attempts will have a corresponding LESSON_PATH_ID.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:12:28.762000 by VISHAL.PATIL@IMAGINELEARNING.COM

org_key

Business Definition

The ORG_KEY column in the ACTIVITY_ATTEMPT_FACT table represents the unique identifier for the organization or school that a student is associated with. This column is crucial for analyzing student activity attempts by their respective organizations, allowing for insights into performance and engagement at the organizational level. It's important to note that the ORG_KEY is determined through a complex logic that prioritizes registration organizations over ALA organizations, which may affect the accuracy of the data in certain edge cases.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T01:12:12.105000 by VISHAL.PATIL@IMAGINELEARNING.COM

parent_path_metadata_key

Business Definition

The PARENT_PATH_METADATA_KEY column in the Student Activity Attempts Fact Table identifies the parent content level (such as a lesson or unit) that contains the specific activity being tracked. This column is crucial for hierarchical analysis, allowing users to roll up activity data to higher levels of the content structure for comprehensive reporting. It's important to note that this key is coalesced with a value of -1 if no parent is found, ensuring that all activities are accounted for in the analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T01:12:27.342000 by VISHAL.PATIL@IMAGINELEARNING.COM

path_metadata_key

Business Definition

The PATH_METADATA_KEY column in the Student Activity Attempts Fact Table represents a unique identifier for the versioned metadata of the content path associated with a student's activity attempt. This key is used to track and analyze the specific version of the content that a student interacted with, enabling detailed reporting on content usage and effectiveness. It's important to note that this key links to a separate table containing the metadata details, so it should be used in conjunction with that table for comprehensive analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T01:12:24.112000 by VISHAL.PATIL@IMAGINELEARNING.COM

plagiarism_score

Business Definition

The PLAGIARISM_SCORE column represents the highest percentage of similarity between a student's submitted work and existing sources, as detected by our plagiarism detection tool. This score is used to assess the originality of student submissions and can be analyzed to identify potential academic integrity issues. It's important to note that this score is based on the most severe instance of similarity found, and further investigation may be required to determine if plagiarism has actually occurred.

Data Type

FLOAT

Nullable

Yes

Last Updated

2025-12-10T01:12:52.314000 by VISHAL.PATIL@IMAGINELEARNING.COM

product_key

Business Definition

The PRODUCT_KEY column in the ACTIVITY_ATTEMPT_FACT table identifies the specific educational product or curriculum associated with each student activity attempt, such as Edgenuity Math or Imagine Learning ELA. This column is crucial for product-level reporting, allowing analysts to understand which products are being used and how effectively they are supporting student learning. It is important to note that this column references the PRODUCT_DIM table for product classification, and any missing values are represented by -1.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T01:12:06.402000 by VISHAL.PATIL@IMAGINELEARNING.COM

rad_time_spent_in_seconds

Business Definition

The column "RAD_TIME_SPENT_IN_SECONDS" represents the total time a student spent actively engaged with a specific activity, measured in seconds. This metric is used to analyze student engagement and participation levels, helping to identify which activities are most effective in keeping students involved. It's important to note that this time is calculated based on when a student navigates to and away from an activity, with a maximum timeout of 30 minutes, ensuring a more accurate measure of actual engagement.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T01:12:31.897000 by VISHAL.PATIL@IMAGINELEARNING.COM

scanned_for_ai

Business Definition

The "SCANNED_FOR_AI" column indicates whether a student's activity attempt was checked for AI-generated content. This information is crucial for analyzing the authenticity of student submissions and ensuring academic integrity. Note that if this column is NULL, it means the activity was not scanned for AI-generated content.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-10T01:12:48.960000 by VISHAL.PATIL@IMAGINELEARNING.COM

sequence_id

Business Definition

The SEQUENCE_ID column in the ACTIVITY_ATTEMPT_FACT table represents a unique identifier for a specific learning sequence or assignment that a student is engaged with. This identifier is crucial for analyzing student performance and progress across different learning activities. It is important to note that the SEQUENCE_ID can be derived from various sources depending on the type of learning program (e.g., ILP, ABLD/Mastery, EdgeEx), which may affect the consistency of the data.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:11:59.990000 by VISHAL.PATIL@IMAGINELEARNING.COM

sequence_sub_type

Business Definition

The SEQUENCE_SUB_TYPE column in the ACTIVITY_ATTEMPT_FACT table categorizes the specific type of activity a student is engaged in, such as 'Instruction', 'Practice', 'Formative', 'Mastery', or 'Assignment'. This classification is crucial for analyzing student performance and engagement across different types of educational activities. It's important to note that the categorization is derived from various sources and may have slight variations depending on the educational program (e.g., ABLD, ILP, Mastery Pathway, EdgeEx).

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:13:04.075000 by VISHAL.PATIL@IMAGINELEARNING.COM

sequence_type_label

Business Definition

The SEQUENCE_TYPE_LABEL column in the Student Activity Attempts Fact Table identifies the type of learning sequence or workflow that a student is engaged in, such as an Individualized Learning Path (ILP), Assignment Builder (ABLD), Mastery Pathway, or EdgeEx courses. This information is crucial for analyzing the effectiveness of different instructional contexts and understanding how students interact with various learning sequences. It's important to note that the values in this column are derived from user context tags and may include a fixed value for EdgeEx courses.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:11:58.121000 by VISHAL.PATIL@IMAGINELEARNING.COM

source_system_id

Business Definition

The SOURCE_SYSTEM_ID column in the ACTIVITY_ATTEMPT_FACT table identifies the platform that recorded the student activity attempt, with '3' representing the new platform and '4' representing the legacy platform. This information is crucial for filtering and analyzing data based on the platform used, allowing for comparisons between the two systems. Note that this column is used to exclude data from the legacy platform (EdgeEx) in certain reports and analyses.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T01:12:08.015000 by VISHAL.PATIL@IMAGINELEARNING.COM

subject

Business Definition

The "SUBJECT" column in the ACTIVITY_ATTEMPT_FACT table represents the academic subject area (such as Math, English Language Arts, Science, or Social Studies) associated with each student activity attempt. This column is crucial for analyzing student performance and engagement across different subjects, enabling subject-level reporting. It is important to note that the subject information is extracted from the content metadata and may occasionally be missing or incomplete if the metadata is not properly populated.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:12:15.401000 by VISHAL.PATIL@IMAGINELEARNING.COM

take_id

Business Definition

The TAKE_ID column represents a unique identifier for each attempt a student makes at an activity. It is used to track individual activity sessions, allowing for detailed analysis of student performance and engagement over multiple attempts. Note that each new attempt generates a new TAKE_ID, so it's important to consider this when aggregating data to avoid double-counting efforts.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:12:01.465000 by VISHAL.PATIL@IMAGINELEARNING.COM

time_spent_in_seconds

Business Definition

The TIME_SPENT_IN_SECONDS column in the ACTIVITY_ATTEMPT_FACT table represents the total amount of time a student spent engaged in a specific activity, measured in seconds. This metric is crucial for analyzing student engagement and performance, as it helps identify how much time students are dedicating to different activities. It's important to note that this time is calculated by summing the duration of all events within a session, so it reflects active engagement rather than total session time.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T01:12:30.293000 by VISHAL.PATIL@IMAGINELEARNING.COM

user_key

Business Definition

The USER_KEY column in the ACTIVITY_ATTEMPT_FACT table represents a unique identifier for the student or learner who attempted an activity. This column is essential for analyzing and reporting on individual student performance and behavior, allowing for user-level aggregations and detailed insights. It is important to note that this key is used to link to additional student information in the user dimension, ensuring comprehensive and accurate analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T01:12:09.652000 by VISHAL.PATIL@IMAGINELEARNING.COM

user_uuid

Business Definition

The USER_UUID column represents a unique identifier for each user in our system, ensuring consistent tracking of individual users across different activities and platforms. This identifier is crucial for analysis and reporting as it allows us to accurately attribute activities and outcomes to specific users. It is important to note that this identifier is more stable than other user identifiers, which may change over time, making it a reliable key for user-related data analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T01:12:13.775000 by VISHAL.PATIL@IMAGINELEARNING.COM