School of Medicine External Database

Implementation Plan

1. SOM DB Schema
   A new schema will be created on the development sakai database called 'SOM'.
2. SVM View Creation
   View ddl for each table in the aaud, courses, and dictionary databases will be created and executed on the SOM schema. This will create a set of views that mirror the columns in the SVM tables. These views can be queried in the same fashion as a table. The data for view columnds will be pulled from the existing materialized views in the external database. Unmappable values and columns requiring revision of the materialized views will be left blank.
3. Degree Navigator Feed
   An account on the Degree Navigator system must be created for the external database. This account will be used to create a database link to degree navigator. Once created, an existing pl/sql feed procedure will be copied from the Course Management system to the external database. This feed procedure will copy data from Degree Navigator nightly into a local table on the external database.
4. Materialized View Revision
   The existing External Database materialized view and view log ddl will be revised to include the new columns that are needed. Any new materialized views will be defined as well as their accompanying view logs.
5. Creation of Banner View Logs
   The materialized view log ddl will be submitted to the Banner code migration team for analysis and deployment to the banner development and test environments.
6. Materialized View Creation
   Once the view logs are created on the banner environments, the materialized view scripts will be run on our development environment. At this point the materialized views in the external database will contain the new data.
7. SVM View Revision
   The view ddl for the SOM views will be revised to include the newly acquired data. The resulting views will have data for all columns that can be filled with data from the external database.
8. Project Completion