CIS COURSE CATALOG Table
View exposing course catalog data including academic year, subject identifiers, titles, units, grading attributes, GIR and communication attributes, offering indicators, instructors, and descriptive catalog text used for curriculum reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_YEAR |
Academic year as provided by the source. |
VARCHAR2 |
4 |
COMM_REQ_ATTRIBUTE |
Comm req attribute as provided by the source. |
VARCHAR2 |
4 |
COMM_REQ_ATTRIBUTE_DESC |
Description of comm req attribute desc. |
VARCHAR2 |
40 |
DEPARTMENT_CODE |
Code identifying department. |
VARCHAR2 |
4 |
DEPARTMENT_NAME |
Department name as provided by the source. |
VARCHAR2 |
30 |
DESIGN_UNITS |
Design units as provided by the source. |
NUMBER |
2 |
EFFECTIVE_TERM_CODE |
Code identifying effective term. |
VARCHAR2 |
6 |
EQUIVALENT_SUBJECTS |
Equivalent subjects as provided by the source. |
VARCHAR2 |
120 |
FALL_INSTRUCTORS |
Fall instructors as provided by the source. |
VARCHAR2 |
180 |
GIR_ATTRIBUTE |
Gir attribute as provided by the source. |
VARCHAR2 |
4 |
GIR_ATTRIBUTE_DESC |
Description of gir attribute desc. |
VARCHAR2 |
40 |
GLOBAL_COUNTRIES |
Global countries as provided by the source. |
VARCHAR2 |
90 |
GLOBAL_REGIONS |
Global regions as provided by the source. |
VARCHAR2 |
90 |
GRADE_RULE |
Grade rule as provided by the source. |
VARCHAR2 |
1 |
GRADE_RULE_DESC |
Description of grade rule desc. |
VARCHAR2 |
30 |
GRADE_TYPE |
Grade type as provided by the source. |
VARCHAR2 |
1 |
GRADE_TYPE_DESC |
Description of grade type desc. |
VARCHAR2 |
20 |
HASS_ATTRIBUTE |
Hass attribute as provided by the source. |
VARCHAR2 |
8 |
HASS_ATTRIBUTE_DESC |
Description of hass attribute desc. |
VARCHAR2 |
40 |
HGN_CODE |
Code identifying hgn. |
VARCHAR2 |
1 |
HGN_DESC |
Description of hgn desc. |
VARCHAR2 |
15 |
HGN_EXCEPT |
Hgn except as provided by the source. |
VARCHAR2 |
90 |
IS_OFFERED_FALL_TERM |
Indicator identifying whether offered fall term (Y/N). |
VARCHAR2 |
1 |
IS_OFFERED_IAP |
Indicator identifying whether offered iap (Y/N). |
VARCHAR2 |
1 |
IS_OFFERED_SPRING_TERM |
Indicator identifying whether offered spring term (Y/N). |
VARCHAR2 |
1 |
IS_OFFERED_SUMMER_TERM |
Indicator identifying whether offered summer term (Y/N). |
VARCHAR2 |
1 |
IS_OFFERED_THIS_YEAR |
Indicator identifying whether offered this year (Y/N). |
VARCHAR2 |
1 |
IS_PRINTED_IN_BULLETIN |
Indicator identifying whether printed in bulletin (Y/N). |
VARCHAR2 |
1 |
IS_VARIABLE_UNITS |
Indicator identifying whether variable units (Y/N). |
VARCHAR2 |
1 |
JOINT_SUBJECTS |
Joint subjects as provided by the source. |
VARCHAR2 |
120 |
LAB_UNITS |
Lab units as provided by the source. |
NUMBER |
2 |
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
LECTURE_UNITS |
Lecture units as provided by the source. |
NUMBER |
2 |
MASTER_SUBJECT_ID |
Business identifier for the master subject. |
VARCHAR2 |
8 |
MEETS_WITH_SUBJECTS |
Meets with subjects as provided by the source. |
VARCHAR2 |
120 |
ON_LINE_PAGE_NUMBER |
On line page number as provided by the source. |
VARCHAR2 |
41 |
PREPARATION_UNITS |
Preparation units as provided by the source. |
NUMBER |
2 |
PREREQUISITES |
Prerequisites as provided by the source. |
VARCHAR2 |
200 |
PRINT_SUBJECT_ID |
Business identifier for the print subject. |
VARCHAR2 |
50 |
SCHOOL_WIDE_ELECTIVES |
School wide electives as provided by the source. |
VARCHAR2 |
120 |
SOURCE_SUBJECT_ID |
Business identifier for the source subject. |
VARCHAR2 |
8 |
SPRING_INSTRUCTORS |
Spring instructors as provided by the source. |
VARCHAR2 |
180 |
STATUS_CHANGE |
Status change as provided by the source. |
VARCHAR2 |
200 |
SUBJECT_CODE |
Code identifying subject. |
VARCHAR2 |
3 |
SUBJECT_DESCRIPTION |
Description of subject description. |
VARCHAR2 |
2000 |
SUBJECT_ID |
Business identifier for the subject. |
VARCHAR2 |
8 |
SUBJECT_NUMBER |
Subject number as provided by the source. |
VARCHAR2 |
4 |
SUBJECT_SHORT_TITLE |
Subject short title as provided by the source. |
VARCHAR2 |
30 |
SUBJECT_TITLE |
Subject title as provided by the source. |
VARCHAR2 |
150 |
SUPERVISOR_ATTRIBUTE |
Supervisor attribute as provided by the source. |
VARCHAR2 |
4 |
SUPERVISOR_ATTRIBUTE_DESC |
Description of supervisor attribute desc. |
VARCHAR2 |
40 |
TERM_DURATION |
Term duration as provided by the source. |
VARCHAR2 |
30 |
TOTAL_UNITS |
Total units as provided by the source. |
NUMBER |
2 |
TUITION_ATTRIBUTE |
Tuition attribute as provided by the source. |
VARCHAR2 |
4 |
TUITION_ATTRIBUTE_DESC |
Description of tuition attribute desc. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
Date associated with warehouse load. |
DATE |
|
WRITE_REQ_ATTRIBUTE |
Write req attribute as provided by the source. |
VARCHAR2 |
4 |
WRITE_REQ_ATTRIBUTE_DESC |
Description of write req attribute desc. |
VARCHAR2 |
40 |