Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Purpose

Describes Assignments created in a  Learning Management System (LMS)

SQL Object Name

analytics.engage_AssignmentDim

Usage Notes

None

Data Definition and Sources

(warning) Depends on the lmsx.Assignment  table that is introduced by the LMSX extension from 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

→ this is the natural key from the source system, originally stored as lms.SourceSystemIdentifier 

Unique key for the assignment
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
Titlevarcharlmsx.Assignment.TitleTitle of the assignment
Descriptionvarcharlmsx.Assignment.AssignmentDescriptionLong description of the assignment (not available in all systems)
StartDateKeyvarcharlmsx.Assignment.StartDateTimeStart date of the assignment, formatted as a string for use with the DateDim View
EndDateKeyvarcharlmsx.Assignment.EndDateTimeEnd date of the assignment, formatted as a string for use with the DateDim View
DueDateKeyvarcharlmsx.Assignment.DueDateTimeDue date of the assignment, formatted as a string for use with the DateDim View
MaxPointsintlmsx.Assignment.MaxPointsMaximum 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

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

  • No labels