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_year, users and modules table.

Field	Type	Purpose	Key
identifier	int(11)	auto increment.	PRIMARY KEY
updated	date	Datetime when the update occurred.
idMod	int(11)	Module ID affected
enrolements	int(11)	Number of new enrolements for the module.
enrolement_details	text	Comma separated list of usernames enroled on module.
deletions	int(11)	Number of deletions for the module.
deletion_details	text	Comma separated list of usernames deleted from module.
import_type	varchar(255)	Where was this import from
calendar_year	int(4)	Academic year the metadata applies to.	FOREIGN KEY academic_year.calendar_year