CM DDL Structure

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

-

CanonicalCourse

UCD_CM_CANONICALCOURSE_MV

BANNER_CANONICALCOURSE

Materialized View

/mview/ucd_cm_canonicalcourse_mv.sql

-

CanonicalCourse/CourseSet Mapping

UCD_CM_CANONICALCOURSESETS_MV

BANNER_CANON_COURSESETS

Materialized View

/mview/ucd_cm_canonicalcoursesets_mv.sql

-

CourseOffering

UCD_CM_COURSEOFFERING_T(A&B)

COURSEMANAGEMENT_OFFERING

Table

/table/ucd_cm_courseoffering_t.sql

-

UCD_CM_COURSEOFFERING_V

COURSEMANAGEMENT_OFFERING_V

View

/view/ucd_cm_courseoffering_v.sql

-

UCD_CM_COURSEOFFERING_MV

BANNER_COURSEOFFERING

Materialized View

/mview/ucd_cm_courseoffering_mv.sql

-

CourseOffering/CourseSet Mapping

UCD_CM_OFFERINGCOURSESETS_MV

BANNER_OFFERING_COURSESETS

Materialized View

/mview/ucd_cm_offeringcoursesets_mv.sql

-

Section

UCD_CM_SECTION_T(A&B)

COURSEMANAGEMENT_SECTION

Table

/table/ucd_cm_section_t.sql

-

UCD_CM_SECTION_V

COURSEMANAGEMENT_SECTION

View

/view/ucd_cm_section_v.sql

-

UCD_CM_SECTION_MV

COURSEMANAGEMENT_SECTION

Materialized View

/mview/ucd_cm_section_mv.sql

-

UCD_CM_DN_COURSE_DESC_T

DEGREE_NAV_DESC

Table

/table/ucd_cm_dn_course_desc_t.sql

-

EnrollmentSet

UCD_CM_ENROLLMENTSET_MV

BANNER_ENROLLMENTSET

Materialized View

/mview/ucd_cm_enrollmentset_mv.sql

-

Instructor List

UCD_CM_INSTRUCTORS_T(A&B)

COURSEMANAGEMENT_INSTRUCTORS

Table

/table/ucd_cm_instructors_t.sql

-

UCD_CM_INSTRUCTORS_V

COURSEMANAGEMENT_INSTRUCTORS_V

View

/view/ucd_cm_instructors_v.sql

-

UCD_CM_INSTRUCTORS_MV

COURSEMANAGEMENT_INSTRUCTORS_MV

Materialized View

/mview/ucd_cm_instructors_mv.sql

-

Enrollment

UCD_CM_EROLLMENT_T(A&B)

COURSEMANAGEMENT_ENROLLMENT

Table

/table/ucd_cm_enrollment_t.sql

-

UCD_CM_ENROLLMENT_V

COURSEMANAGEMENT_ENROLLMENT

View

/view/ucd_cm_enrollment_v.sql

-

UCD_CM_ENROLLMENT_MV

COURSEMANAGEMENT_ENROLLMENT

Materialized View

/mview/ucd_cm_enrollment_mv.sql

-

UCD_CM_UNEXENROLLMENT_T

UNEX_ENROLLMENT

Table

/table/ucd_cm_unexenrollment_t.sql

-

Meeting

UCD_CM_MEETING_MV

BANNER_MEETING

Materialized View

/mview/ucd_cm_meeting_mv.sql

-

SectionCategory

UCD_CM_SECTIONCATEGORY_MV

BANNER_SECTION_CATEGORY

Materialized View

/mview/ucd_cm_sectioncategory_mv.sql

-

GradingScheme

UCD_CM_GRADINGSCHEME_MV

BANNER_GRADING_SCHEME

Materialized View

/mview/ucd_cm_gradingscheme_mv.sql

-

EnrollmentStatus

UCD_CM_ENROLLMENTSTATUS_MV

BANNER_ENROLLMENTSTATUS

Materialized View

/mview/ucd_cm_enrollmentstatus_mv.sql

-

Person Data

UCD_PERSON_T

MOTHRA_PERSON

Table

/table/ucd_person_t.sql

-

UCD_PERSON_V

UCDSAKAI_PERSON_INFO

/view/ucd_person_v.sql

-