Versions Compared

Key

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

Table of Contents
maxLevel2

...

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:

...

Insert excerpt
GDC Visual Number of Depts by Source system
GDC Visual Number of Depts by Source system
nopaneltrue
 

 Details

Insert excerpt
GDC College or Unit Name
GDC College or Unit Name
nopaneltrue

...

Insert excerpt
GDC Source Department ID and Name
GDC Source Department ID and Name
nopaneltrue
Insert excerptGDC Status DescGDC Status Desc
nopaneltrue

Insert excerpt
GDC Type of College or Unit
GDC Type of College or Unit
nopaneltrue

Insert excerpt
GDC Primary CIP-code
GDC Primary CIP-code
nopaneltrue

Insert excerpt
GDC Status Description
GDC Status Description
nopaneltrue




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.

...