tbl1_Semester_Statuses¶
- Description
This table lists all of the semesters known to Solutions so far, and corresponding statuses.
Columns¶
ID int(11) NOT NULL AUTO_INCREMENT
- Options
display="true", null="true", search="false", type=""
the_semester varchar(25) DEFAULT NULL
- Description
Fall, Spring or Summer
- Options
display="true", null="true", search="false", type=""
the_year smallint(6) DEFAULT NULL
- Description
Semester Year
- Options
display="true", null="true", search="false", type=""
the_status smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
created_date datetime DEFAULT NULL
- Description
Status code representing semester’s status in Solutions (see footnote)
- Footnote
Possible status code values: -100=pending (flagged in Solutions database as semester to be brought in from CSS for first time); 0=in progress (meaning Solutions users are working on this semester – does not necessarily mean classes have started yet) 1=committed (after semester is over) 2=not started (semester in table for other reasons that is not yet active in Solutions – see other fields for examples) 4=dates applied (used for payroll functions, likely obsolete)
- Options
display="true", null="true", search="false", type=""
dont_publish_instructors bit(1) DEFAULT NULL
- Description
TRUE if we want to publish schedule on website but we want to prevent any instructors from being displayed
- Options
display="true", null="true", search="false", type=""
last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
- Options
display="true", null="true", search="false", type=""
subject_codes varchar(255) DEFAULT NULL
- Description
This is a list of unit and subject codes that we will process for the semester. Python programs use this list to see what data to work with for given semesters. Typically this will be set to “01:640 16:640 16:642 16:643” for Fall and Spring and “01:640” for summer
- Options
display="true", null="true", search="false", type=""
scan_for_honors_candidate_responses bit(1) DEFAULT b'0'
- Description
This will be TRUE if the semester is in a phase where we want to scan for Honors Candidate invitation RSVPs. This is set in the Solutions Honors Candidates.
- Footnote
Note that it might be possible to have a semester with this status before the typical Solutions programs would care about this semester. This is the case where the semester’s status code value might be 2 (not started) but this value would be TRUE
- Options
display="true", null="true", search="false", type=""