Purpose: Stores data about enrolment/deletion changes made on nightly module enrolments from SMS system. A record is used per module.
Joins: users and modules table.
Field | Type | Purpose |
---|---|---|
id | int(11) | Primary Key – auto increment. |
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 |
Warning |
---|
The Information below is for an in development branch of RogoROGO 6.1.0+ |
Purpose: Stores data about enrolment/deletion changes made on nightly module enrolments from SMS system. A record is used per module.Version: 6.1
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 |