SIS SUBJECT CODE Table
View exposing subject code reference data including course identifiers, titles, descriptions, and attributes used for course scheduling, catalog maintenance, and academic reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COURSE_NUMBER |
Course number associated with the record. |
VARCHAR2 |
3 |
DEPARTMENT_CODE |
Code identifying department. |
VARCHAR2 |
4 |
DEPARTMENT_NAME |
Department name associated with the record. |
VARCHAR2 |
30 |
SCHOOL_CODE |
Code identifying school. |
VARCHAR2 |
2 |
SCHOOL_NAME |
School name associated with the record. |
VARCHAR2 |
30 |
SUBJECT_CODE |
Code identifying subject. |
VARCHAR2 |
3 |
SUBJECT_CODE_DESC |
Description of subject code. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |