After the schedule has been created and the reps have had time to make any last minutes edits this is the process and procedure to move the course information from Timetabler to Quest.
...
Compare differences between real sections/topic # appearing in Quest and those appearing in Timetabler (The excel that you’ll get from Quest you’ll need to concatenate the subject||Catalog_NBR||topic ID to get them the same as the courses from Timetabler) From Timetabler you’ll just go to the courses level in Timetabler, and simply pull the list of courses directly from there. Need to remove duplicates and sort then do an EXACT function in Excel [example: =EXACT(A2,B2)] (UW_RS_SCH_CRSES_OFFRD_SB)
Compare scheduling groups from timetable (HWDR and HELD) to Quest and ensure they match and we aren’t missing one from each side. Grab a list of the component heldwiths from Timetabler paste it into excel, and run this query: UW_RS_SCTN_CMBN_TOTALS_SB in Quest and use “=EXACT” to find the odd ones out.
Finding who enrolled students into real sections before all the course information has been uploaded so they can remove the students (excludes COOP/WKRPT) (UW_RS_SCH_REAL_ENRL_CHECK_JV)
Run queries to ensure that all the necessary tables are blank:
UW_RS_CLASS_MTG_PAT_NO_ROWS_SB
UW_RS_CLASS_INSTR_NO_ROWS_SB
UW_RS_CLAS_EVNT_NBR_NOBLANK_SB
Infosilem Work:
Once the task document work has been finished and a back up has been taken then you can start the upload.
...
Run Queries to ensure there’s no bad data in Quest:
UW_RS_INSTR_MISS_MTG_PAT_NP
RT #1080936 - if you get results for this query - use this RT as an example
RT #1164199 - in 1219 - 54 rows!
RT #1164199 – another example
Buffer error without an integration SISP-242 (RT #1190284) (
)Jira Legacy server System Jira serverId 2174d23a-1c18-3dfb-9a53-87620f8159d6 key SISP-242 Jira Legacy server System Jira serverId 2174d23a-1c18-3dfb-9a53-87620f8159d6 key SISP-867
UW_RS_SCH_STIME_GT_ETIME_NP
start time is greater than end time (times are messed up!)
UW_RS_SCH_SCTN_CMB_DIFF_DT_NP
for this query you will have to manually look to see if there are mismatched start dates or end dates to know if there are different dates
UW_RS_SINGLE_DAY_GT1_DAY_PAT_N
UW_RS_MISMATCH_PATTERN_DAYS_NP
| Info |
|---|
Let Isaac Morland know that the schedule of classes has been updated |
...
To find instructors attached to courses that are not in their approved subject lists in the instructor/advisor table (their teachables) UW_RS_SCH_NO_SUBJ_INSTR_TBL_NP
To find instructors that were added to only one side of the held with, manually scroll through the list and ensure that each of the held with courses have the same instructors attached: UW_SCH_MISMATCH_DELIV
To ensure that the correct flags are checked on for REG rooms - all facility ID’s (except ONLINE room) is checked on, and only RO rooms are checked on for general assignment. UW_RS_SCH_FAC_NO_CNFL_SB
| Expand | ||
|---|---|---|
| ||
|
...