SAH-LMS-CB-Assignment-View Quick Start Guides

General Information About SAH LMS:

All SAH Students are included, those who have not logged into the LMS will have null data in the LMS fields
CB means Canvas Batch and indicates data was aggregated by Canvas prior to being loaded into the SAH
Technical descriptions for the fields in Canvas LMS can be found here: https://portal.inshosteddata.com/docs

Key Fields:

Role aka (User role, agent role, LMS role)

For more information about the fields in each view, please refer to this document: https://portal.inshosteddata.com/docs

Contains

Only information about Courses

Folder	Fields	Note

Folder	Fields	Note
LMS Course	Course ID Course Name Course Code Course Level Code
LMS Assignment	Assignment ID Assignment Title
	Assignment Grading Type	Possible values: gpa_scale letter_grade not_graded pass_fail percent points
	Assignment Title	Title of the assignment
	Assignment ID	Unique surrogate ID for the assignment.
	Assignment Course ID	Foreign key to the course associated with this assignment
	Assignment Grading Type	Content Developer
LMS Dates	Course Start At	Timestamp for when the course starts.
	Assignment Due At	Timestamp for when the assignment is due
	Assignment All Day Date	The date version of the Assignment due date if the "Assignment All Day" flag is true.
	Assignment Unlock At	Timestamp for when the assignment is unlocked or visible to the user
	Assignment lock At	Timestamp for when the assignment is locked
	Assignment Created At	Timestamp of the first time the assignment was entered into the system
LMS Flags	Assignment All Day	True if A specific time for when the assignment is due was not given. The effective due time will be 11:59pm.
	Assignment Grade Group Students Individually	True if students who submit work as a group will each receive individual grades (vs one grade that is copied to all group members)
	Assignment Muted	[Deprecated] No longer used in Canvas, will always be NULL.
LMS Flag Measure	Assignment Is Discussion Post Count
	Assignment Peer Review Count	The number of pears to assign for review if using algorithmic assignment
	Course Is Major Term Count
LMS Measure	Assignment Group Position	Position of the assignment group in the assignment index page. It determines where it should be displayed on the page and where it should be displayed in a new course if the course is cloned.
	Assignment Points Possible	Total points possible for the assignment
	Assignment Points	The sorting order of the assignment in the group
Term Set - LMS Course	Course Academic Year Long Course Academic Year Short Course Prior Term ID Course Term Canvas ID Course Term Code Course Term ID Course Term Name Course Term Name Long Course Term Name Short Course Term SIS Source ID
Term Set - LMS Course Enrollment	Course Enrollment Term ID	Foreign key to enrollment term