Skip to content

Enrollment Progress Event Fact

Table Overview

This table contains 25 columns.

Quick Navigation

Column Definitions

actual_grade

Business Definition

The ACTUAL_GRADE column represents the overall grade of a student in a course, including the impact of overdue activities which are counted as zeroes. This grade is used to track and report on student progress and performance throughout the course. It maps directly to the 'actualGrade' field in the EnrollmentProgressEvent, which records updates to course grades or progress. Note that this grade is expressed as a percentage to the tenths place and includes penalties for overdue work.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

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

actual_progress

Business Definition

The ACTUAL_PROGRESS column in the ENROLLMENT_PROGRESS_EVENT_FACT table represents the percentage of a course that a student has completed or pretested out of, providing a snapshot of their progress. This metric is crucial for analyzing student engagement and performance, helping educators and administrators track how far along students are in their coursework. It directly maps to the 'actualProgress' field in the EnrollmentProgressEvent, which records updates to course grades or progress. Note that this column is derived and may not account for all types of student activities, so it should be used in conjunction with other metrics for a comprehensive view of student progress.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

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

actual_progress_by_count

Business Definition

The ACTUAL_PROGRESS_BY_COUNT column represents the percentage of course activities that a student has completed. This metric is crucial for tracking student progress and is used in reports and analyses to assess engagement and performance. It directly maps to the "actualProgressByCount" field in the EnrollmentProgressEvent, which records updates to course grades or progress. Note that this column is derived and may not account for activities completed outside the system.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

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

actual_progress_pacing

Business Definition

The ACTUAL_PROGRESS_PACING column represents the difference between student's expected progress and their actual progress at a given time. This metric is crucial for analyzing student performance, as it indicates whether a student is ahead of, on track with, or behind their expected pace. It directly maps to the 'Progress Pacing' field in the EnrollmentProgressEvent, which tracks updates to course grades/progress. A positive value indicates the student is ahead of pace, while a negative value indicates they are behind.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

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

actual_progress_status

Business Definition

The ACTUAL_PROGRESS_STATUS column in the ENROLLMENT_PROGRESS_EVENT_FACT table indicates the current status of a student's progress in a course, based on whether they have submitted their work by the due dates. This column is used to analyze student performance and engagement, helping to identify students who are on track, behind, or ahead in their coursework. It maps directly to the 'Progress Status' field in the EnrollmentProgressEvent from Caliper, which tracks updates to course grades or progress. Note that this status is derived and may not reflect real-time submissions, so it should be used with that understanding.

Data Type

VARCHAR(16777216)

Nullable

Yes

Last Updated

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

actual_progress_target_progress

Business Definition

The "ACTUAL_PROGRESS_TARGET_PROGRESS" column represents the percentage of the course that a student should have completed or pretested out of by the end of the previous working day. This metric is crucial for tracking student progress and is used in reports and analyses to assess whether students are on track with their coursework. It maps directly to the "Target Progress" field in the EnrollmentProgressEvent from Caliper. Note that this value is derived and may not account for real-time progress updates, so it should be used in conjunction with other progress metrics for a comprehensive view.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

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

app_domain_key

Business Definition

The APP_DOMAIN_KEY column in the ENROLLMENT_PROGRESS_EVENT_FACT table represents the unique identifier for the application that generated the enrollment progress event. This field is crucial for analysis and reporting as it helps track which application is responsible for updates to course grades or progress. It maps directly to the 'Event Source' in the EnrollmentProgressEvent, providing context on the origin of the event. Note that this column is derived and may include variations of the URL format, such as 'https://student.ex.edgenuityapp.com'.

Data Type

NUMBER(38,0)

Nullable

No

Last Updated

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

application_key

Business Definition

The APPLICATION_KEY column in the ENROLLMENT_PROGRESS_EVENT_FACT table represents the type of software application that generated the enrollment progress event. This information is crucial for analyzing which applications are being used to track and update student course grades or progress. It maps directly to the 'Event Source Type' in the Caliper EnrollmentProgressEvent. Note that this column is derived and may not always capture the full context of the application used, so it should be considered in conjunction with other data points for comprehensive analysis.

Data Type

NUMBER(38,0)

Nullable

No

Last Updated

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

assignable_type

Business Definition

The "ASSIGNABLE_TYPE" column in the Student Enrollment Progress Fact Table represents the type of enrollment entity being tracked, such as a course or a specific module within a course. This information is crucial for analyzing and reporting on the progress and grades of students across different types of enrollments. It maps directly to the "object.assignable.type" field in the EnrollmentProgressEvent, which tracks updates to course grades or progress. It's important to note that this column is derived and may not capture all nuances of enrollment types, so it should be used in conjunction with other data points for comprehensive analysis.

Data Type

VARCHAR(16777216)

Nullable

Yes

Last Updated

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

dw_created_by

Business Definition

The "DW_CREATED_BY" column in the Student Enrollment Progress Fact Table indicates the user who created the record in the data warehouse. This information is useful for auditing and tracking purposes, allowing analysts to understand who was responsible for entering or updating specific enrollment progress events. It does not directly map to any specific field in the EnrollmentProgressEvent but serves as a metadata attribute for data governance. Note that this column is automatically populated and should not be used for any business logic or calculations.

Data Type

VARCHAR(16777216)

Nullable

No

Last Updated

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

dw_created_on

Business Definition

The "DW_CREATED_ON" column in the ENROLLMENT_PROGRESS_EVENT_FACT table represents the timestamp when the record was created in the data warehouse. This column is crucial for tracking the freshness of data and is often used in analysis and reporting to understand when specific enrollment progress events were recorded. It directly corresponds to the timestamp of the EnrollmentProgressEvent in the Caliper context. Please note that this timestamp reflects the time of data entry into the warehouse, not the actual occurrence of the enrollment event.

Data Type

TIMESTAMP_NTZ(9)

Nullable

No

Last Updated

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

enrollment_uuid

Business Definition

The ENROLLMENT_UUID column represents the unique identifier for a student's enrollment in a course. It is used to track and analyze the progress and grade updates for each student's enrollment. This column maps to the Enrollment ID in the EnrollmentProgressEvent, which records when a course grade or progress is updated. It is important to note that this identifier is in URN format and is essential for accurate reporting and analysis of student performance over time.

Data Type

VARCHAR(16777216)

Nullable

No

Last Updated

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

event_date_key

Business Definition

The EVENT_DATE_KEY column in the ENROLLMENT_PROGRESS_EVENT_FACT table represents the date and time when a student's enrollment progress was updated, such as when a course grade or progress was modified. This column is crucial for tracking and analyzing the timeline of student progress and can be used to report on trends and patterns in enrollment changes over time. It directly maps to the 'Event Timestamp' in the Caliper EnrollmentProgressEvent, providing a standardized way to track these updates. Please note that the timestamps are recorded in UTC format, which may require adjustment for local time zone reporting.

Data Type

NUMBER(38,0)

Nullable

No

Last Updated

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

event_type_key

Business Definition

The EVENT_TYPE_KEY column in the ENROLLMENT_PROGRESS_EVENT_FACT table represents the type of event that occurred related to a student's enrollment progress. This column is specifically used to track when a course grade or progress is updated, and it always indicates a "Modified" action. It maps directly to the EnrollmentProgressEvent in the Caliper context, which helps in monitoring changes in student performance. This information is crucial for analysis and reporting on student progress and academic performance trends.

Data Type

NUMBER(38,0)

Nullable

No

Last Updated

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

object_uuid

Business Definition

The OBJECT_UUID column in the ENROLLMENT_PROGRESS_EVENT_FACT table represents a unique identifier for each enrollment progress event, which tracks updates to a student's course grade or progress. This column is essential for analysis and reporting as it allows for the tracking of individual progress events over time. It maps directly to the 'Progress Object ID' in the EnrollmentProgressEvent, providing a clear link to the specific event being recorded. Note that this identifier is system-generated and should be treated as a unique key for each progress event, ensuring accurate and detailed tracking of student progress.

Data Type

VARCHAR(16777216)

Nullable

Yes

Last Updated

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

org_id

Business Definition

The ORG_ID column represents the unique identifier for the school or organization to which the student's enrollment and course section belong. This ID is crucial for analyzing and reporting on student progress and performance at the organizational level. It maps directly to the 'School/Organization ID' in the EnrollmentProgressEvent, which tracks updates to course grades or progress. Please note that this column is derived and may not be directly editable.

Data Type

VARCHAR(16777216)

Nullable

Yes

Last Updated

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

org_key

Business Definition

The ORG_KEY column in the ENROLLMENT_PROGRESS_EVENT_FACT table represents the unique identifier for the school to which the student's enrollment and course section belong. This column is crucial for analyzing and reporting on student progress and grades at the school level. It maps directly to the School ID in the EnrollmentProgressEvent, which tracks updates to course grades or progress. Note that if the user key is missing or set to -1, the ORG_KEY will also be set to -1, indicating that the school information is not available for those records.

Data Type

NUMBER(38,0)

Nullable

No

Last Updated

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

organization_type

Business Definition

The ORGANIZATION_TYPE column in the ENROLLMENT_PROGRESS_EVENT_FACT table represents the type of organization associated with a student's enrollment in a course section. This information is useful for analyzing how different types of organizations (e.g., schools, departments, or external partners) impact student progress and performance. It maps directly to the 'organization.type' field within the Caliper EnrollmentProgressEvent, which tracks updates to course grades or progress. Please note that this column is derived and may not be available for all enrollment records, depending on the completeness of the source data.

Data Type

VARCHAR(16777216)

Nullable

Yes

Last Updated

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

overall_grade

Business Definition

The OVERALL_GRADE column represents the weighted average of a student's completed activity scores, expressed as a percentage to the tenths place. This column is used to track and report on a student's overall progress and performance in a course. It maps directly to the 'overallGrade' field in the EnrollmentProgressEvent, which records updates to course grades or progress. Please note that this grade is derived from completed activities and may not include pending or incomplete assignments.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

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

relative_grade

Business Definition

The RELATIVE_GRADE column in the ENROLLMENT_PROGRESS_EVENT_FACT table represents the weighted average grade for all activities in a course, including those not yet started or in progress, expressed as a percentage to the tenths place. This metric is crucial for tracking student progress and performance, allowing educators and administrators to identify students who may need additional support. It maps directly to the 'relativeGrade' field in the EnrollmentProgressEvent, which records updates to course grades or progress. Note that this grade includes activities that are not yet due, providing a comprehensive but potentially inflated view of student performance.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

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

section_uuid

Business Definition

The SECTION_UUID column represents the unique identifier for the course section to which a student's enrollment belongs. This identifier is crucial for tracking and analyzing student progress and grades within specific course sections. In the context of the EnrollmentProgressEvent, it maps to the section ID where the enrollment progress is being updated. It's important to note that this identifier is in URN format, which ensures uniqueness across different systems.

Data Type

VARCHAR(16777216)

Nullable

Yes

Last Updated

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

sub_organization_of_type

Business Definition

The "SUB_ORGANIZATION_OF_TYPE" column in the Student Enrollment Progress Fact Table represents the type of the parent organization associated with the student's enrollment, typically indicating the type of school or institution. This information is crucial for analysis and reporting, as it allows for segmentation of enrollment progress data by different types of educational institutions. It maps directly to the "Parent Organization Type" in the EnrollmentProgressEvent, which tracks updates to course grades or progress. It's important to note that this column is derived and may not always be populated if the parent organization type is not available.

Data Type

VARCHAR(16777216)

Nullable

Yes

Last Updated

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

user_key

Business Definition

The USER_KEY column represents a unique identifier for the student whose enrollment progress is being tracked. This key is essential for analyzing and reporting on individual student progress and performance within courses. It maps directly to the 'assignee.id' field in the EnrollmentProgressEvent, which records updates to course grades or progress. Note that this is a surrogate key and does not contain any personally identifiable information.

Data Type

NUMBER(38,0)

Nullable

No

Last Updated

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

user_type

Business Definition

The USER_TYPE column in the ENROLLMENT_PROGRESS_EVENT_FACT table indicates the type of user associated with the enrollment progress event, which is always expected to be "Student." This column is used in analysis and reporting to confirm that the progress updates are indeed related to students. It maps directly to the 'User Type' field in the EnrollmentProgressEvent, which tracks updates to course grades or progress. It's important to note that this column should consistently show "Student," and any deviation might indicate a data quality issue.

Data Type

VARCHAR(16777216)

Nullable

Yes

Last Updated

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

user_uuid

Business Definition

The USER_UUID column represents the unique identifier for a student whose course grade or progress has been updated. This identifier is used to track individual student progress and performance in various courses, enabling detailed analysis and reporting on student enrollment and academic achievements. It maps directly to the 'Student ID' in the EnrollmentProgressEvent, which records updates to course grades or progress. Please note that this identifier is in URN format and is essential for accurate student-level reporting.

Data Type

VARCHAR(16777216)

Nullable

No

Last Updated

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