| Data element |
Definition |
| Dept_Code Indexed - no
Format - Varchar2(16)
May be Null? Y | Code for an Academic Department at Penn. Departments manage courses and the instructors who teach in their courses. Subject areas belong to departments. A Department can have many subject areas; each subject area can belong to just one department. |
| Id Indexed - no
Format - Number
May be Null? Y | Internal warehouse field, to uniquely identify rows in this table. |
| Last_Refresh_Date Indexed - no
Format - Date
May be Null? Y | The date the record was last refreshed in the Data Warehouse. |
| Legacy_School_Code Indexed - no
Format - Varchar2(8)
May be Null? Y | Code for the School, in the format used by the legacy system (SRS). |
| School_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the School. At Penn, Schools administer departments and their subject areas. |
| Subject_Code Indexed - no
Format - Varchar2(16)
May be Null? Y | Codes for Subject Areas used on courses offered at Penn. Subject areas belong to departments. A Department can have many subject areas; each subject area can belong to just one department. |
