vORA_COURSE_CATALOG view
Courses available at the college, and the term range the courses are active.
Source: BANINST1.AS_COURSE_CATALOG
DW Field | Description or Sample |
COURSE_IDENTIFICATION | Short Subject concatenated with the Course Number (BUS170, AG196, etc) |
SUBJECT | Short Subject |
SUBJECT_DESC |
|
COURSE_NUMBER |
|
COURSE_VERSION_NO | (not in use) |
ACADEMIC_YEAR | (not in use) |
ACADEMIC_YEAR_DESC | (not in use) |
ACADEMIC_PERIOD_START | The term code when the course is first offered |
ACADEMIC_PERIOD_START_DESC |
|
ACADEMIC_PERIOD_END | The term when the course was last offered |
ACADEMIC_PERIOD_END_DESC |
|
SUB_ACADEMIC_PERIOD |
|
SUB_ACADEMIC_PERIOD_DESC |
|
ACTIVE_COURSE_IND |
|
STATUS |
|
STATUS_DESC |
|
NON_TRADITIONAL_IND |
|
REPEATABLE_COURSE_IND |
|
NO_OF_REPEATS_ALLOWED |
|
MAXIMUM_REPEAT_UNITS |
|
REPEAT_STATUS_CODE |
|
REPEAT_STATUS_DESC |
|
COLLEGE |
|
COLLEGE_DESC |
|
DEPARTMENT |
|
DEPARTMENT_DESC |
|
DIVISION |
|
DIVISION_DESC |
|
COURSE_CLASS_LEVEL |
|
COURSE_CLASS_LEVEL_DESC |
|
MAJOR |
|
MAJOR_DESC |
|
PROGRAM_CLASSIFICATION |
|
PROGRAM_CLASSIFICATION_DESC |
|
CONTINUING_EDUCATION_IND |
|
CREDIT_MIN |
|
CREDIT_MAX |
|
CREDIT_IND |
|
BILLING_MIN |
|
BILLING_MAX |
|
BILLING_IND |
|
CONTACT_MIN |
|
CONTACT_MAX |
|
CONTACT_IND |
|
FA_FEDERAL_CREDITS |
|
FA_STATE_CREDITS |
|
FA_COUNTY_CREDITS |
|
REPORT_FEDERAL_CREDITS |
|
REPORT_STATE_CREDITS |
|
REPORT_COUNTY_CREDITS |
|
TITLE_SHORT_DESC |
|
TITLE_LONG_DESC |
|
CIP_CODE |
|
CIP_DESC |
|
COURSE_APPROVAL |
|
COURSE_APPROVAL_DESC |
|
COURSE_INFO1 |
|
COURSE_INFO2 |
|
COURSE_INFO3 |
|
COURSE_INFO4 |
|
COURSE_INFO5 |
|
COURSE_INFO6 |
|
DURATION_UNIT |
|
COURSE_DURATION |
|
CURRENT_DATE |
|