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 |
Add Comment