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.
Column | Data Type | Source | Description |
|---|---|---|---|
| AssignmentKey | varchar | lmsx.Assignment.AssignmentIdentifier → this is the natural key from the source system | Unique key for the assignment |
| SchoolKey | int | lmsx.Assignment.SchoolId → when using the LMS toolkit, this value is inferred from the relationship of the SIS Section Identifier defined in the LMS's section to the SectionIdentifier defined in an Ed-Fi Section. | Unique key for a school |
| SourceSystem | varchar | edfi.Descriptor.ShortDescription via lmsx.SourceSystemDescriptor | Name of the LMS source system |
| Title | varchar | lmsx.Assignment.Title | Title of the assignment |
| Description | varchar | lmsx.Assignment.AssignmentDescription | Long description of the assignment (not available in all systems) |
| StartDateKey | varchar | lmsx.Assignment.StartDateTime | Start date of the assignment, formatted as a string for use with the DateDim View |
| EndDateKey | varchar | lmsx.Assignment.EndDateTime | End date of the assignment, formatted as a string for use with the DateDim View |
| DueDateKey | varchar | lmsx.Assignment.DueDateTime | Due date of the assignment, formatted as a string for use with the DateDim View |
| MaxPoints | int | lmsx.Assignment.MaxPoints | Maximum number of points available in the assignment |
| SectionKey | varchar | Concatenation of the components of the Section natural key, using the column from lmsx.Assignment:
→ 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 |
| GradingPeriodKey | varchar | Concatenation of components of the edfi.GradingPeriod entity:
→ 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 |
August 5, 2021
This documentation is in a pre-release state. The views documented here are in the main branch of the source code repository but have not been formally released to the community yet.
Contents