Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

(1) The a1_sps_waitlist view was created to retrieve the waitlist data

(2) The vw_sps_waitlist_build script builds the vw_sps_waitlist table from the a1_sps_waitlist view.

(3) The vw_sps_waitlist_build script is added to the vw_table_build scriptto refresh the waitlist table at 7:30 am daily.

(4) The vw_sps_waitlist table is used in the 'Course Review Tool' Power BI report

Note: Run the following SQL Script manually to refresh the 'vw_sps_waitlist' table:

...