Toggle menu
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Missing Assignments indicates the number of assignments that have missing submission status in Canvas.

Metadata
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
Dataset Folder and Field Name
Dataset Folder:"Dim - LMS - Detail Assignment"
Field Name:"Status"


Cookies help us deliver our services. By using our services, you agree to our use of cookies.