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" |
|---|
|
|