Global Department Crosswalk

Owned by ramchander
Last updated: Jan 30, 2020 by Randy Smith
3 min read

Report Description

The Global Department Crosswalk report shows how individual departments with data in one or more USF source systems, such as FAST, GEMS, OASIS, Health Banner, Epic, GE/IDX, CODA, are currently grouped together into easier to use and understand "global" departments for reporting, data access control, and other processes.

As a reminder, global departments are simply groupings that enable aggregation and reporting of department-level data for a business unit from sources that use different DeptIDs.  They also allow us to have a naming convention where the prefix reflects the college/unit the department falls under, as well as a separate college/unit attribute field value that is not always available or consistent in the constituent source systems, like the tree-nodes in FAST, VP-Area in GEMS, or College in OASIS.

Mapping page

This page allows you to:

  1. select one or more Global Departments and see which Source Departments from which Source Systems roll up to it,
  2. select one or more Source Departments and see which Source Systems they are from and which Global Departments they roll up into,
  3. select one or more Source Systems and see which Source Departments they contain and which Global Departments they roll up into, or
  4. any combination of the previous three.

The search boxes on this page can help you find Global or Source Departments by name or number (or even the department's primary CIP-code), such as "accounting" or "1402", then use those results to select the one or more Departments which you are most interested in seeing how they are mapped.

Filters

Type of College or Unit

Choose from either "Academic" or "Non-Academic" to limit the global departments to just those colleges/units manually grouped into one of these categories.  For example, Collage of Arts and Sciences global departments are grouped as "Academic", whereas "University Administrative Services" global departments are grouped as "Non-Academic".  This filter is offered to reduce the number of colleges/units to select from next.

College or Unit Name

Name of the College or non-academic Unit used to group one or more Global Departments, for example "College of Arts and Sciences", "USFSM College of Business", "VP Executive Offices".  This is part of the Global Department structure, though it usually reconciles with a department's college-code in GEMS and budget-tree-node in FAST. This is often used as a filter to reduce the number of Global Departments to select from next.

Reset Filters

In case you have used multiple filters and want all of them quickly reset to their defaults.

Visualizations

This three visualizations on this page are used in conjunction with each other so that you can:

  1. select one or more Global Departments and see which Source Departments from which Source Systems roll up to it;
  2. select one or more Source Departments and see which Source Systems they are from and which Global Departments they roll up into;
  3. select one or more Source Systems and see which Source Departments they contain and which Global Departments they roll up into; or
  4. any combination of the previous three.

Global Department Name, and [Primary CIP-code]

Name of the Global Department, as defined in the Global Department system and used to group department-IDs from multiple source systems.  Note that there is no global department "ID", this name is all you need.  An example Global Department is  "USFSM ACCOUNTING", which groups GEMS 4-1402-000, FAST 521402, and OASIS ACC departments together, since they all represent USFSM's Accounting department.

The 6-digit CIP code designated as the "primary" CIP-code for a Global Department, as determined annually by the colleges with the Office of Decision Support, then updated in the Global Department system.  For example, "450201" was determined to be the primary CIP-code for Global Department "CAS ANTHROPOLOGY".  It also happens to be the primary CIP-code for Global Department "USFSM ANTHROPOLOGY".

Note that not all departments have a primary CIP-code, especially non-academic ones, like "AMBULATORY SURGERY CENTER", and note that even though a department has a primary CIP-code, they can still offer programs that fall under other CIP-codes.

For an explanation of what CIP-codes are, see https://nces.ed.gov/ipeds/cipcode, and to see how they tie to curriculum at USF, see https://www.systemacademics.usf.edu/curriculum/definitions.php.

Source Department ID, Name

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.

 

Summary page

This page allows you to:

  1. Quickly find a global department mapping that contains a string you seek, such as "400501" (which will match a primary CIP-code), "Chemistry" (which will match source department names and global department names), "6413" (which will partially match source department IDs), or even "Arts and Sciences" (which will match a college name).
  2. See the number and type of source system departments that comprise each college/unit or, if you drill down, each global department.

Filters

Type of College or Unit

Choose from either "Academic" or "Non-Academic" to limit the global departments to just those colleges/units manually grouped into one of these categories.  For example, Collage of Arts and Sciences global departments are grouped as "Academic", whereas "University Administrative Services" global departments are grouped as "Non-Academic".  This filter is offered to reduce the number of colleges/units to select from next.

College or Unit Name

Name of the College or non-academic Unit used to group one or more Global Departments, for example "College of Arts and Sciences", "USFSM College of Business", "VP Executive Offices".  This is part of the Global Department structure, though it usually reconciles with a department's college-code in GEMS and budget-tree-node in FAST. This is often used as a filter to reduce the number of Global Departments to select from next.

Global Department Name

Name of the Global Department, as defined in the Global Department system and used to group department-IDs from multiple source systems.  Note that there is no global department "ID", this name is all you need.  An example Global Department is  "USFSM ACCOUNTING", which groups GEMS 4-1402-000, FAST 521402, and OASIS ACC departments together, since they all represent USFSM's Accounting department.

Page search

This filter allows you to search through full global department mappings to pick one that contains a string you seek and display the details in the visualizations below.  You can search for strings such as "400501" (which will match a primary CIP-code), "Chemistry" (which will match source department names and global department names), "6413" (which will partially match source department IDs), or even "Arts and Sciences" (which will match a college name).

Visualizations

This three visualizations on this page are used in conjunction with each other so that you can:

  1. use the filters along the top of the page to see just the Colleges/Units, Global Departments, and/or Source Systems you are currently seeking;

  2. select a bar from the Number of Department IDs chart and see the global department mapping details for that College/Unit (or Global Department, if you drilled down) as well as which portion of the pie those departments comprise;
  3. select a global department mapping details line and see where that falls in the bar chart as well as in the pie chart;
  4. select a source system's slice of the pie chart and see where that falls in the bar chart as which global department mappings involve that source system.

Number of Department IDs by Source and by College/Unit

This stacked bar chart allows you to compare between Colleges (or Units) the number of source departments from each source system, and when you drill down, compare the number between Global Departments.

If you select a portion of a bar in this chart, the two related visualizations on this page will respond.

Global Department Mapping Details

This table of details allows you to see the full mapping between:

  • each Global Department, including it's primary CIP-code (if appropriate) and the College/Unit Name it falls under, and
  • each source department, including the Source System, Source Dept ID, Source Department Name and the departments current status being active or inactive.

If you select a line in this list, the two related visualizations on this page will respond.

Number of Departments by Source System

This pie chart allows you to compare between Source Systems (e.g. FAST, GEMS) the number of departments that are part of the global department mappings.

If you select a slice of this pie, the two related visualizations on this page will respond.

 

 Details

College or Unit Name

Name of the College or non-academic Unit used to group one or more Global Departments, for example "College of Arts and Sciences", "USFSM College of Business", "VP Executive Offices".  This is part of the Global Department structure, though it usually reconciles with a department's college-code in GEMS and budget-tree-node in FAST. This is often used as a filter to reduce the number of Global Departments to select from next.

Global Department Name

Name of the Global Department, as defined in the Global Department system and used to group department-IDs from multiple source systems.  Note that there is no global department "ID", this name is all you need.  An example Global Department is  "USFSM ACCOUNTING", which groups GEMS 4-1402-000, FAST 521402, and OASIS ACC departments together, since they all represent USFSM's Accounting department.

Source Department ID, Name

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.

Type of College or Unit

Choose from either "Academic" or "Non-Academic" to limit the global departments to just those colleges/units manually grouped into one of these categories.  For example, Collage of Arts and Sciences global departments are grouped as "Academic", whereas "University Administrative Services" global departments are grouped as "Non-Academic".  This filter is offered to reduce the number of colleges/units to select from next.

Primary CIP-code

The 6-digit CIP code designated as the "primary" CIP-code for a Global Department, as determined annually by the colleges with the Office of Decision Support, then updated in the Global Department system.  For example, "450201" was determined to be the primary CIP-code for Global Department "CAS ANTHROPOLOGY".  It also happens to be the primary CIP-code for Global Department "USFSM ANTHROPOLOGY".

Note that not all departments have a primary CIP-code, especially non-academic ones, like "AMBULATORY SURGERY CENTER", and note that even though a department has a primary CIP-code, they can still offer programs that fall under other CIP-codes.

For an explanation of what CIP-codes are, see https://nces.ed.gov/ipeds/cipcode, and to see how they tie to curriculum at USF, see https://www.systemacademics.usf.edu/curriculum/definitions.php.

GDC Status

Depending on Data Source the status of the department is flagged as 'Active' or 'Inactive'

FAST - For each department the status reflects the current status according to FAST ..

GEMS -  For each department the status reflects the value of the EFF_STATUS field in the PS_DEPT_TBL based on the most recent record.

OASIS - For each college department combination if there has been no student or no course within the past year then the status is set to 'Inactive'.  Departments that previously existed in the source system that have been deleted are also 'Inactive'

OracleHCM - For each department the status reflects the value of the OrgUnitClassificationPEOStatus field in the EmployeeDataLake_sdb.[dbo].[DepartmentPVOViewAll] view.




Details page

This page just allows you to see the details of all the global department mappings.


Data Refreshed On

Data in this report is not live, but it is refreshed nightly. The date on the bottom right of the report displays the most recent day the data was pulled from the source, which is the data warehouse global department crosswalk, which has manually maintained mapping data and nightly refreshed source-system department IDs and names.

Disclaimer

This report displays department information from the data warehouse as of the refresh date.  The data warehouse has a nightly scheduled refresh from the source systems. All values are subject to change over time.

Please send any questions or comments to it-bia@usf.edu

Unauthorized use of this report is prohibited. If you log on to this computer system, you acknowledge your awareness of and concurrence with the University of South Florida policies. The University will prosecute violators to the full extent of the law.