Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

A number of queries in Quest are run in order to ensure that the courses we are transferring over have good information.

Log into Quest and in Query viewer run the following queries:

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 add add formula (=EXACT(F3,G3)) UW_RS_SCTN_CMBN_TOTALS_SB

  • No labels