SIS COURSE DESCRIPTION Table
View exposing SIS course description reference data including detailed course attributes used for academic reporting and catalog maintenance.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CIP_PROGRAM_CODE |
Code identifying cip program. |
VARCHAR2 |
6 |
COURSE |
Course associated with the record. |
VARCHAR2 |
9 |
COURSE_DESCRIPTION |
Description of course. |
VARCHAR2 |
30 |
COURSE_DESCRIPTION_LONG |
Course description long associated with the record. |
VARCHAR2 |
240 |
COURSE_LEVEL |
Course level associated with the record. |
VARCHAR2 |
2 |
COURSE_OPTION |
Course option associated with the record. |
VARCHAR2 |
4 |
DEFAULT_ULTIMATE_DEGREE |
Default ultimate degree associated with the record. |
VARCHAR2 |
3 |
DEPARTMENT |
Department associated with the record. |
VARCHAR2 |
4 |
DEPARTMENT_NAME |
Department name associated with the record. |
VARCHAR2 |
30 |
DEPT_NAME_IN_COMMENCEMENT_BK |
Dept name in commencement bk associated with the record. |
VARCHAR2 |
80 |
FROM_TERM |
From term associated with the record. |
VARCHAR2 |
6 |
FROM_TERM_DESCRIPTION |
Description of from term. |
VARCHAR2 |
30 |
GRADAUTE_LEVEL |
Gradaute level associated with the record. |
VARCHAR2 |
8 |
GRADUATE_LEVEL |
Graduate level associated with the record. |
VARCHAR2 |
8 |
IS_DEGREE_GRANTING |
Indicator identifying whether degree granting (Y/N). |
CHAR |
|
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
SCHOOL_NAME |
School name associated with the record. |
VARCHAR2 |
30 |
SCHOOL_NAME_IN_COMMENCEMENT_BK |
School name in commencement bk associated with the record. |
VARCHAR2 |
60 |
SIS_COURSE_DESCRIPTION_KEY |
Surrogate key identifying the sis course description. |
VARCHAR2 |
12 |
THRU_TERM |
Thru term associated with the record. |
VARCHAR2 |
6 |
THRU_TERM_DESCRIPTION |
Description of thru term. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |