On Time Assignments describes the number of assignments submitted on time based on the submission status in Canvas.
| Metadata |
|---|
| Where Term Appears |
|---|
| CSUMB Data Warehouse Dashboards: |
|
|---|
| Other Reports: | N/A |
|---|
|
| Data Custodian |
|---|
| Center for Academic Technologies |
| Data Source |
|---|
| Source System: | CMS - SA |
|---|
| Source Table Name: | WC_LMS_DTL_ASSIGN_D (Built using ASSIGNMENT_DIM,ASSIGNMENT_OVERRIDE_DIM etc) |
|---|
| Source Field Name: | SUB_WORKFLOW_STATE,STATUS |
|---|
| Census Process: | N/A |
|---|
|
| Logical Transformation / Calculation |
|---|
| SUM(CASE WHEN sub_workflow_state <> 'graded' and status = 'OnTime' THEN 1 ELSE 0 END) assgn_ontime
from WC_LMS_DTL_ASSIGN_D |
| OBIEE Folder and Column |
|---|
| Folder Heading: | "Dim - LMS - Class Std Summary" |
|---|
| Column Heading: | "Ontime Assignment" |
|---|
|
|
The Ontime Assignments % is derived by looking at all graded Canvas assignments and the assignment status (e.g. Late, Missing, OnTime).
The "OnTime" status applies when the "Submitted At" date is not blank (null) or is before the "Due At" date for the assignment in Canvas.