...
| Status | ||||||
|---|---|---|---|---|---|---|
|
...
Purpose: Stores data about enrolment/deletion changes made on nightly module enrolments from SMS system. A record is used per module.
...
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 |
...