sms_imports

ROGO 6.1.0


Purpose: Stores data about enrolment/deletion changes made on nightly module enrolments from SMS system. A record is used per module.

Joins: academic_yearusers and modules table.

Field
Type
Purpose
Key
identifierint(11)auto increment.PRIMARY KEY
updateddateDatetime when the update occurred.
idModint(11)Module ID affected
enrolementsint(11)Number of new enrolements for the module.
enrolement_detailstextComma separated list of usernames enroled on module.
deletionsint(11)Number of deletions for the module.
deletion_detailstextComma separated list of usernames deleted from module.
import_typevarchar(255)Where was this import from
calendar_yearint(4)Academic year the metadata applies to.FOREIGN KEY academic_year.calendar_year