SIS DEPARTMENT Table
View exposing student information system department reference data including department codes, names, school affiliations, and administrative attributes used for academic organization and scheduling reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEPARTMENT_CODE |
Code identifying department. |
VARCHAR2 |
4 |
DEPARTMENT_FULL_NAME |
Department full name associated with the record. |
VARCHAR2 |
35 |
DEPARTMENT_LAST_ACTIVITY_DATE |
Date associated with department last activity. |
DATE |
|
DEPARTMENT_NAME |
Department name associated with the record. |
VARCHAR2 |
30 |
DEPARTMENT_NAME_HISTORY |
Department name history associated with the record. |
VARCHAR2 |
250 |
DEPT_BUDGET_CODE |
Code identifying dept budget. |
VARCHAR2 |
6 |
DEPT_NAME_IN_COMMENCEMENT_BK |
Dept name in commencement bk associated with the record. |
VARCHAR2 |
80 |
DLC_KEY |
Surrogate key identifying the dlc. |
VARCHAR2 |
180 |
IS_DEGREE_GRANTING |
Indicator identifying whether degree granting (Y/N). |
VARCHAR2 |
1 |
SCHOOL_CODE |
Code identifying school. |
VARCHAR2 |
2 |
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 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |