...
- SOM DB Schema
A new schema will be created on the development sakai database called 'SOM'. - 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. - 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. - 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. - 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. - 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. - 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. - Project Completion
SVM View Mappings
The following tables will describe each view that will be created in the School of Medicine schema. Each column in the original SVM table will be listed along with the value to be mapped or the mapping status. A key is presented at the end of the section listing the various color codings.
AAUD.EMPLOYEES / AAUD_EMPLOYEES | |
|---|---|
emp_pkey | mothra_person.mothraid, |
emp_term_code | null, --only latest data is recorded in external database |
emp_clientid | nvl(mothra_person.studentid,mothra_person.employeeid), |
emp_home_dept | mothra_person.dept_code, |
emp_alt_dept_code | null, --PPS |
emp_school_division | null, --PPS |
emp_cbuc | null, --PPS |
emp_status | null, --PPS |
emp_primary_title | null, --PPS |
emp_teaching_title_code | null, --PPS |
emp_teaching_home_dept | null, --SVM specific field from dictionary table |
emp_teaching_percent_fulltime | null, --Derived from SVM specific data |
emp_effort_title_code | null, --Derived from SVM specific data |
emp_effort_home_dept | null --Derived from SVM specific data |
...