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 | Â |