Queries that must be be run before importing the courses, they can be run by anyone with query access. The queries can be run throughout the entering of prior term copies to save you from having to a monster clean up, but they all must be run after the prior term copies have been entered and checked:

...

Primary component not graded component 

• UW_RS_SCH_CMPNT_MISMATCH_LW

...

Fix reserve capacity sequence orders

• UW_RS_RESERVE_CAP_ORDER_NP

...

Topics missing from secondary components

• UW_RS_CEM_TOPICS_W_SEC_COMP_KW

...

Reserve Cap Duplicates

• UW_RS_SCH_MULTI_RSRV_CAP_NP

...

Blank Reserve Caps

• UW_RS_SCH_BLANK_RSRV_CAP_NP

...

Fixing Auto Enrol with no secondary component

• UW_RS_SCH_AUTO_NO_AUTO_ENRL_NP

...

Pre-enrollment sections but no real sections

• UW_RS_PCS_BUT_NO_REAL_SB

...

Fixing mismatched class components

• UW_RS_SCH_MISSING_COMPONENT_JV

...

Run after above query to re-add any that were accidentally removed:

• UW_RS_SCH_COMP_NOT_ASS_CLS_JV

Check combined section total to ensure they match (create column and add formula (=EXACT(F3,G3))

...

.

Adding the Courses to the Data Base 

...

Run scheduling queries related to course cleanup: 

UW_RS_MISMATCHED_INSTR_MODE_SB 

UW_RS_CATLG_ORGS_GROUPS_NP  

– Manually scroll through list and ensure that for the subject the Acad Org and Group are the same through the list – if different contact catalog person in either Grad or UG to have them fix it 

UW_RS_SOC_ORGS_GROUPS_NP  

– If you get results you must do a course roll (Curriculum Management -> Roll Curriculum Data Forward -> Course Roll) that should fix them! 

Run query to look for missing RC weights (UW_RS_MISS_RC_IN_RCWGHT_TBL_NP) if there were some that needed to be added re-run: UW_RS_RESERVE_CAP_ORDER_NP to catch any changes. 

Ensure Scheduling has updated all course changes 

...