engage_AssignmentDim View

Owned by Stephen Fuqua
Last updated: Sep 16, 2021 by David Clements
2 min read

Purpose

Describes Assignments created in a  Learning Management System (LMS)

SQL Object Name

analytics.engage_AssignmentDim

Usage Notes

None

Data Definition and Sources

Depends on the lmsx.Assignment  table that is introduced by the LMSX extension from the LMS Toolkit. In theory this table can be populated directly through API calls, if the LMSX extension is called. However, in most cases the data will be loaded using the custom components in the LMS Toolkit. When using the Toolkit, recall the workflow:

  1. Extractors pull data from a source system into CSV files.
  2. The Data Store Loader uploads those CSV files into tables in the lms schema
  3. The Harmonizer synchronizes those records with Sections and Students defined in the core Ed-Fi tables, resulting in records loaded into lmsx.Assignment  and lmsx.AssignmentSubmission.

In the table below, the immediate source is given, along with the source from the LMS Toolkit table / CSV files. For more information on the upstream sources from the LMS, please see the mapping notes documentation: Schoology Mapping Notes, Google Classroom Mapping notes, and Canvas Mapping Notes.

Column

Data Type

Source

Description

AssignmentKeyvarchar

lmsx.Assignment.AssignmentIdentifier

  • When using the LMS Toolkit, this value comes from SourceSystemIdentifier in lmsx.Assignment.
This is the natural key from the source system
SchoolKeyint

lmsx.Assignment.SchoolId

  • When using the LMS toolkit, this value is inferred from the relationship of the SisSectionIdentifier in the lms.LMSSection  table to SectionIdentifier  in the edfi.Section table.
Unique key for a school
SourceSystemvarchar

edfi.Descriptor.ShortDescription via

lmsx.SourceSystemDescriptor

  • When using the LMS toolkit, this value comes from the SourceSystem  column in lms.Assignment .
Name of the LMS source system
Titlevarchar

lmsx.Assignment.Title

  • When using the LMS toolkit, comes from Title  in lms.Assignment.
Title of the assignment
Descriptionvarchar

lmsx.Assignment.AssignmentDescription

  • When using the LMS toolkit, comes from AssignmentDescription  in lms.Assignment.
Long description of the assignment (not available in all systems)
StartDateKeyvarchar

lmsx.Assignment.StartDateTime

  • When using the LMS toolkit, comes from StartDateTime  in lms.Assignment.
Start date of the assignment, formatted as a string for use with the DateDim View
EndDateKeyvarcharlmsx.Assignment.EndDateTime
  • When using the LMS toolkit, comes from EndDateTime  in lms.Assignment.
End date of the assignment, formatted as a string for use with the DateDim View
DueDateKeyvarcharlmsx.Assignment.DueDateTime
  • When using the LMS toolkit, comes from DueDateTime  in lms.Assignment.
Due date of the assignment, formatted as a string for use with the DateDim View
MaxPointsintlmsx.Assignment.MaxPoints
  • When using the LMS toolkit, comes from MaxPoints in lms.Assignment.
Maximum number of points available in the assignment
SectionKeyvarchar

Concatenation of the components of the Section natural key, using the column from lmsx.Assignment:

  • SchoolId
  • LocalCourseCode
  • SchoolYear
  • SectionIdentifier
  • SessionName


→ when using the LMS toolkit, these values are inferred from the relationship of the SIS Section Identifier defined in the LMS's section to the SectionIdentifier defined in an Ed-Fi Section.

The unique key for a section, allowing for joins to the SectionDim View
GradingPeriodKeyvarchar

Concatenation of components of the edfi.GradingPeriod entity:

  • GradingPeriodDescriptorId
  • SchoolId
  • BeginDate


→ Inferred from the edfi.SessionGradingPeriod by looking for a related grading period whose begin and end dates encompass the due date of the assignment.

The unique key for a grading period, allowing for joins to the GradingPeriodDim View

Contents