SIS COURSE DESCRIPTION Table
Descriptions of Course Numbers (ie. Courses of Major Departments, Degree Programs) for both undergraduate and graduate levels with specific academic terms. (SIS=Student Information System.)
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CIP_PROGRAM_CODE |
The 6-digit CIP program code. CIP is the NCES (National Center for Education Statistics) publication that classifies instructional programs by standard terminology for curriculum and instruction in local and state school systems and post-secondary institutions. |
VARCHAR2 |
6 |
COURSE |
The major program (eg. "6 2", "15 M", "18 D") in which the student is enrolled in for the current term. |
VARCHAR2 |
9 |
COURSE_DESCRIPTION |
The description of the course or program (eg. "Elec. Eng & Comp Sci" for "6 2", "Management - SM" for "15 M", "Mathematics Doctoral" for "18 D") in which a student is enrolled. |
VARCHAR2 |
30 |
COURSE_DESCRIPTION_LONG |
Longer or more elaborate descriptive text for the courses of major or degree programs. |
VARCHAR2 |
240 |
COURSE_LEVEL |
The level (Graduate or Undergraduate) of the course of major/degree program in which a student is enrolled. |
VARCHAR2 |
2 |
COURSE_OPTION |
The major within the department/course/degree program, Eg. "3" in the Course "6 3", "C" in the Course "18 C". |
VARCHAR2 |
4 |
DEFAULT_ULTIMATE_DEGREE |
The default ultimate degree program associated with the course of major or degree program. |
VARCHAR2 |
12 |
DEPARTMENT |
The department of the primary Course/major: 6, 10, HIST, etc. |
VARCHAR2 |
4 |
DEPARTMENT_NAME |
The name of the department, school, center, or lab. |
VARCHAR2 |
50 |
DEPT_NAME_IN_COMMENCEMENT_BK |
XXX |
VARCHAR2 |
80 |
FROM_TERM |
The academic term code from which the value becomes effective |
VARCHAR2 |
6 |
FROM_TERM_DESCRIPTION |
XXX |
VARCHAR2 |
30 |
GRADAUTE_LEVEL |
XXX |
VARCHAR2 |
8 |
GRADUATE_LEVEL |
Graduate degree levels: DOC (Doctoral degree) and SM (Master's degree). |
VARCHAR2 |
3 |
IS_DEGREE_GRANTING |
'Y' indicates that this is a degree granting department. |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
SCHOOL_NAME |
The descriptive text for SCHOOL_CODE. |
VARCHAR2 |
30 |
SCHOOL_NAME_IN_COMMENCEMENT_BK |
XXX |
VARCHAR2 |
60 |
SIS_COURSE_DESCRIPTION_KEY |
Use this field to join the SIS_COURSE_DESCRIPTION table to another table (most like a fact table) which contains the same-name field. |
VARCHAR2 |
12 |
THRU_TERM |
The academic term code through which the value remains effective. |
VARCHAR2 |
6 |
THRU_TERM_DESCRIPTION |
XXX |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |