Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt

Source Department ID, Name

and Department Status

The source-system-specific ID and name/description for a department.  For example, "0-0101-000" is the DEPTID and "President's Office" is the DESCR in the GEMS source system for a department, which happens to be grouped under the global department "VP EXECUTIVE OFFICES" along with "010100" and "OFFICE OF THE PRESIDENT" DEPTID and DESCR in the FAST source system, along with some other FAST and GEMS departments.

Note that for OASIS departments, the source-system department ID used in the global department system is a concatenation of both the STVDEPT_CODE and STVCOLL_CODE fields, because they are always used as a pair for courses and students, and that allows us to reflect how the same OASIS department code represents different global departments based on the college code with which it is used.  For example, "CHM_AS : Chemistry - Arts and Sciences" belongs to global department "CAS CHEMISTRY", whereas "CHM_AP : Chemistry - Arts and Sciences USFSP" belongs to global department "USFSP BIOLOGICAL SCIENCES".  One amusing side-effect of this pairing and USF's history of renaming colleges is that a global department can include a pair that has not been used in many years, such as "CHM_NS : Chemistry - Natural Sciences" even though the college of Natural Sciences was replaced years ago.Also concatenated to the Source Department ID and Name is the department status which indicates if a department is currently active or inactive.

Requested by:

Approved by:

...