...
# | Course Management Object | Synonym | New DB Object | Old DB Object | DB Object Type | File Path/Name | SVN Status |
---|---|---|---|---|---|---|---|
1 | AcademicSession | UCD_CM_ACADEMICSESSION | UCD_CM_ACADEMICSESSION_MV | BANNER_ACADEMICSESSION | Materialized View | /mview/ucd_cm_academicsession_mv.sql | Done |
2 | CourseSet | UCD_CM_COURSESET | UCD_CM_COURSESET_MV | BANNER_COURSESET | Materialized View | /mview/ucd_cm_courseset_mv.sql | Done |
3 | CanonicalCourse | UCD_CM_CANONICALCOURSE | UCD_CM_CANONICALCOURSE_MV | BANNER_CANONICALCOURSE | Materialized View | /mview/ucd_cm_canonicalcourse_mv.sql | Done |
4 | CanonicalCourse/CourseSet Mapping | UCD_CM_CANONICALCOURSESETS | UCD_CM_CANONICALCOURSESETS_MV | BANNER_CANON_COURSESETS | Materialized View | /mview/ucd_cm_canonical_coursesetscanonicalcoursesets_mv.sql | Done |
5 | CourseOffering | UCD_CM_COURSEOFFERING | UCD_CM_COURSEOFFERING_T(A&B) | COURSEMANAGEMENT_OFFERING | Table | /table/ucd_cm_courseoffering_t.sql | Done |
6 |
| UCD_CM_COURSEOFFERING | UCD_CM_COURSEOFFERING_V | COURSEMANAGEMENT_OFFERING_V | View | /view/ucd_cm_courseoffering_v.sql | Done |
7 |
| #6 | UCD_CM_COURSEOFFERING_MV | BANNER_COURSEOFFERING | Materialized View | /mview/ucd_cm_courseoffering_mv.sql | Done |
8 | CourseOffering/CourseSet Mapping | UCD_CM_OFFERINGCOURSESETS | UCD_CM_OFFERINGCOURSESETS_MV | BANNER_OFFERING_COURSESETS | Materialized View | /mview/ucd_cm_offering_coursesetsofferingcoursesets_mv.sql | Done |
9 | Section | UCD_CM_SECTION | UCD_CM_SECTION_T(A&B) | COURSEMANAGEMENT_SECTION | Table | /table/ucd_cm_section_t.sql | Done |
10 |
| UCD_CM_SECTION | UCD_CM_SECTION_V | COURSEMANAGEMENT_SECTION | View | /view/ucd_cm_section_v.sql | Done |
11 |
| #10 | UCD_CM_SECTION_MV | BANNER_SECTION | Materialized View | /mview/ucd_cm_section_mv.sql | Done |
12 | EnrollmentSet | UCD_CM_ENROLLMENTSET | UCD_CM_ENROLLMENTSET_MV | BANNER_ENROLLMENTSET | Materialized View | /mview/ucd_cm_enrollmentset_mv.sql | Done |
13 | Instructor List | UCD_CM_INSTRUCTORS | UCD_CM_INSTRUCTORS_T(A&B) | COURSEMANAGEMENT_INSTRUCTORS | Table | /table/ucd_cm_instructors_t.sql | Done |
14 |
| UCD_CM_INSTRUCTORS | UCD_CM_INSTRUCTORS_V | COURSEMANAGEMENT_INSTRUCTORS | View | /view/ucd_cm_instructors_v.sql | Done |
15 |
| #14 | UCD_CM_INSTRUCTORS_MV | BANNER_INSTRUCTORS | Materialized View | /mview/ucd_cm_instructors_mv.sql | Done |
16 | Enrollment | UCD_CM_ENROLLMENT | UCD_CM_ENROLLMENT_T(A&B) | COURSEMANAGEMENT_ENROLLMENT | Table | /table/ucd_cm_enrollment_t.sql | Done |
17 |
| UCD_CM_ENROLLMENT | UCD_CM_ENROLLMENT_V | COURSEMANAGEMENT_ENROLLMENT | View | /view/ucd_cm_enrollment_v.sql | Done |
18 |
| #17 | UCD_CM_EMROLLMENT_MV | BANNER_ENROLLMENT | Materialized View | /mview/ucd_cm_enrollment_mv.sql | Done |
19 | Meeting | UCD_CM_MEETING | UCD_CM_MEETING_MV | BANNER_MEETING | Materialized View | /mview/ucd_cm_meeting_mv.sql | Done |
20 | SectionCategory | UCD_CM_SECTIONCATEGORY | UCD_CM_SECTIONCATEGORY_MV | BANNER_SECTION_CATEGORY | Materialized View | /mview/ucd_cm_section_category_mv.sql | Done |
21 | GradingScheme | UCD_CM_GRADINGSCHEME | UCD_CM_GRADINGSCHEME_MV | BANNER_GRADINGSCHEME | Materialized View | /mview/ucd_cm_grading_scheme_mv.sql | Done |
22 | EnrollmentStatus | UCD_CM_ENROLLMENTSTATUS | UCD_CM_ENROLLMENTSTATUS_MV | BANNER_ENROLLMENTSTATUS | Materialized View | /mview/ucd_cm_enrollmentstatus_mv.sql | Done |
23 |
| #6,#10 | UCD_CM_DNDESCRIPTION_T | DEGREE_NAV_DESC | Table | /table/ucd_cm_dn_descriptiondndescription_t.sql | Done |
24 |
| #17 | UCD_CM_UNEXENROLLMENT_T | UNEX_ENROLLMENT | Table | /table/ucd_cm_unexenrollment_t.sql | Done |
25 | Person | UCD_PERSON | UCD_PERSON_V | UCDSAKAI_PERSON_INFO | View | /view/ucd_person_v.sql | Done |
26 |
|
| UCD_PERSON_T | MOTHRA_PERSON | Table | /table/ucd_person_t.sql | Done |
27 | PL/SQL |
| UCD_MOTHRA_P | MOTHRA_FEED_SP | PL/SQL | /plsql/ucd_mothra_p.sql | Done |
28 | PL/SQL |
| UCD_UNEX_P | PKG_UNEX | PL/SQL | /plsql/ucd_unex_p.sql | Done |
29 | PL/SQL |
| UCD_DEGREE_NAVIGATOR_P | DN4_EXTRACT | PL/SQL | /plsql/ucd_degree_navigator_p.sql | Done |
30 | Membership | UCD_CM_MEMBERSHIP | UCD_CM_MEMBERSHIP_T(A&B) | COURSEMANAGEMENT_MEMBERSHIP_T(A&B) | Table | /tables/ucd_cm_membership_t.sql | - |
31 |
| UCD_CM_MEMBERSHIP | UCD_CM_MEMBERSHIP_V | COURSEMANAGEMENT_MEMBERSHIP_V | View | /views/ucd_cm_membership_v.sql | - |
32 |
| ??? | UCD_ATS_LEVEL_MV | BANNER_LEVEL | Materialized View | /mviews/ucd_ats_level_mv.sql | - |
33 |
| ??? | UCD_ATS_ROSTER_V | EXT_COURSE_ROSTER | View | /views/ucd_ats_roster_v.sql | - |