Missing Assignments

From CSUMB Data Glossary
Jump to navigation Jump to search

Missing Assignments indicates the number of assignments that students are missing submissions for 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:LMS - Canvas
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 = 'Missing' THEN 1 ELSE 0 END) as assgn_missing from WC_LMS_DTL_ASSIGN_D
OBIEE Folder and Column
Folder Heading:"Dim - LMS - Detail Assignment"
Column Heading:"Status"