modules

Purpose: Holds module (course) information.
Joins: properties and objectives tables.

Field	Type	Purpose
id	int(11)	Primary Key – auto increment.
moduleid	char(25)	The ID of the module as assigned by the institution.
fullname	text	The full name of the module
active	tinyint(4)	1=active, 0=inactive
vle_api	varchar(255)	VLE API used to obtain learning outcomes
checklist	varchar(255)	Summative exam checklist settings
sms	varchar(255)	The management system the module is imported from NULL if none
selfenroll	tinyint(4)	Can student self enroll on this module 1 is on 0 is off
schoolid	int(11)	The ID of the school to which this module belongs from the schools table
neg_marking	tinyint(1)	Enabel negative marking fro this module 1 is on 0 is off
ebel_grid_template	int(11)	The id of the default ebel_grid_template for this module from the ebel_grid_templates table
mod_deleted	datetime	When a module was deleted (NULL = module is still live).
timed_exams	tinyint(4)	This switched on automatic exam timing for all summative papers in the module.
exam_q_feedback	tinyint(4)	When checked this allows question-based feedback for summative exams.
add_team_members	tinyint(4)	When on any member of staff already in the team can add/delete another member.
map_level	smallint(2)	0 = Session Level, 1 = Module Level
academic_year_start	char(5)	MM/DD when a module changes into the next academic year.

ExamSys (Archive)