tbl1_Courses_DateTracker¶
- Description
This table keeps track of when each semester was last synchronized and when projected enrollments were last refreshed.
- Footnote
Now that we automatically do the sync and the projected enrollment refresh in same step, these fields should have the same values. Suggestion: consolidate both of these fields into one last updated field
Columns¶
ID int(11) NOT NULL AUTO_INCREMENT
- Options
display="true", null="true", search="false", type=""
session_term varchar(255) DEFAULT NULL
- Description
Fall, Spring or Summer
- Options
display="true", null="true", search="false", type=""
session_year int(11) DEFAULT NULL
- Description
Semester Year
- Options
display="true", null="true", search="false", type=""
last_synchronized datetime DEFAULT NULL
- Description
Timestamp sync with CSS last happened
- Options
display="true", null="true", search="false", type=""
last_pe_refresh datetime DEFAULT NULL
- Description
Timestamp projected enrollments were last refreshed
- 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=""