CourseManagement DDL and Object Structure
Course Management Object |
New DB Object |
Old DB Object |
DB Object Type |
File Path/Name |
SVN Status |
|---|---|---|---|---|---|
AcademicSession |
UCD_CM_ACADEMICSESSION_MV |
BANNER_ACADEMICSESSION |
Materialized View |
/mview/ucd_cm_academicsession_mv.sql |
Done |
CourseSet |
UCD_CM_COURSESET_MV |
BANNER_COURSESET |
Materialized View |
/mview/ucd_cm_courseset_mv.sql |
Done |
CanonicalCourse |
UCD_CM_CANONICALCOURSE_MV |
BANNER_CANONICALCOURSE |
Materialized View |
/mview/ucd_cm_canonicalcourse_mv.sql |
Done |
CanonicalCourse/CourseSet Mapping |
UCD_CM_CANONICAL_COURSESETS_MV |
BANNER_CANON_COURSESETS |
Materialized View |
/mview/ucd_cm_canonical_coursesets_mv.sql |
Done |
CourseOffering |
UCD_CM_COURSEOFFERING_T(A&B) |
COURSEMANAGEMENT_OFFERING |
Table |
/table/ucd_cm_courseoffering_t.sql |
Done |
|
UCD_CM_COURSEOFFERING_V |
COURSEMANAGEMENT_OFFERING_V |
View |
/view/ucd_cm_courseoffering_v.sql |
Done |
|
UCD_CM_COURSEOFFERING_MV |
BANNER_COURSEOFFERING |
Materialized View |
/mview/ucd_cm_courseoffering_mv.sql |
Done |
CourseOffering/CourseSet Mapping |
UCD_CM_OFFERING_COURSESETS_MV |
BANNER_OFFERING_COURSESETS |
Materialized View |
/mview/ucd_cm_offering_coursesets_mv.sql |
Done |
Section |
UCD_CM_SECTION_T(A&B) |
COURSEMANAGEMENT_SECTION |
Table |
/table/ucd_cm_section_t.sql |
Done |
|
UCD_CM_SECTION_V |
COURSEMANAGEMENT_SECTION |
View |
/view/ucd_cm_section_v.sql |
Done |
|
UCD_CM_SECTION_MV |
BANNER_SECTION |
Materialized View |
/mview/ucd_cm_section_mv.sql |
Done |
EnrollmentSet |
UCD_CM_ENROLLMENTSET_MV |
BANNER_ENROLLMENTSET |
Materialized View |
/mview/ucd_cm_enrollmentset_mv.sql |
Done |
Instructor List |
UCD_CM_INSTRUCTORS_T(A&B) |
COURSEMANAGEMENT_INSTRUCTORS |
Table |
/table/ucd_cm_instructors_t.sql |
- |
|
UCD_CM_INSTRUCTORS_V |
COURSEMANAGEMENT_INSTRUCTORS |
View |
/view/ucd_cm_instructors_v.sql |
- |
|
UCD_CM_INSTRUCTORS_MV |
BANNER_INSTRUCTORS |
Materialized View |
/mview/ucd_cm_instructors_mv.sql |
Done |
Enrollment |
UCD_CM_EROLLMENT_T(A&B) |
COURSEMANAGEMENT_ENROLLMENT |
Table |
/table/ucd_cm_enrollment_t.sql |
- |
|
UCD_CM_EROLLMENT_V |
COURSEMANAGEMENT_ENROLLMENT |
View |
/view/ucd_cm_enrollment_v.sql |
- |
|
UCD_CM_EROLLMENT_MV |
BANNER_ENROLLMENT |
Materialized View |
/mview/ucd_cm_enrollment_mv.sql |
Done |
Meeting |
UCD_CM_MEETING_MV |
BANNER_MEETING |
Materialized View |
/mview/ucd_cm_meeting_mv.sql |
Done |
SectionCategory |
UCD_CM_SECTION_CATEGORY_MV |
BANNER_SECTION_CATEGORY |
Materialized View |
/mview/ucd_cm_section_category_mv.sql |
Done |
GradingScheme |
UCD_CM_GRADING_SCHEME_MV |
BANNER_GRADINGSCHEME |
Materialized View |
/mview/ucd_cm_grading_scheme_mv.sql |
Done |
EnrollmentStatus |
UCD_CM_ENROLLMENTSTATUS_MV |
BANNER_ENROLLMENTSTATUS |
Materialized View |
/mview/ucd_cm_enrollmentstatus_mv.sql |
Done |