Global Department Access for Systems

Owned by Tara Connolly
Last updated: Dec 15, 2023 by Deepshikha Singh (Deactivated)
3 min read

There are two ways to access the Global Department information:

Users creating Power BI reports, apps and dashboards can access the information via the Power BI Dataflow. If data access is needed for an application, a database read-only account can be provided to developers for use by that application.

 

Power BI user access

The access to this table will be through the Power BI service. The user will need to be granted access to the workspace where the dataflow resides.

For requesting this type of access, submit a ticket to it-analytics@usf.edu with the following information included:

  • Workspace: IT Analytics Global Department Dataflows

  • Dataflow: Global Department

Once access is provided, the user can then select the dataflow as a data source in the PBI Desktop:

 

Select ‘Dataflows’ from the list of common data sources

 

 

Navigate the 'Dataflows' folder to get to the desired table (You may be prompted to sign-in to connect to the Power BI service)

 

 

Application access

The access to this table will be through SQL Authentication where a user, database name and table name will be provided to developers.

For requesting this type of access, submit a ticket to it-analytics@usf.edu with the following information included:

 

Global Department table details:

Column

Description

GlobalCollegeUnitName

Identifies the College/Unit Name that a global department rolls up to.

GlobalCollegeUnitID

Identifies the College/Unit ID that a global department rolls up to. COM was changed to MCOM.

GlobalDeptName

Identifies the global department name which generally includes the College/Unit abbreviation at the beginning.

GlobalDeptNameShort

Identifies shortened name for global department which generally includes the College/Unit abbreviation at the beginning and a shortened version of the global department name.

GlobalDeptNameRpt

Identifies the global department name without a College/Unit abbreviation in proper case. Useful for visualizations when it only displays one College/Unit.

GlobalDeptCode

Identifies the Global Department Code which is a shortened version of the global department name in uppercase.

PrimaryCIPCode

Displays the primary CIP code to identify what is primarily taught in this global department.

GlobalDeptID

Identifies the global department ID.

IsAcademic

Identifies if a global department is considered academic.

IsAcademicCollege

Identifies if a college/unit is academic.

SourceSystem

Identifies the source system that a department belongs to. Source systems include:

CODA (previously USFPG)

FAIR (previously SAMAS)

FAST (previously USF)

GEMS

HealthBanner (previously MDBANNER)

OASIS

OracleHCM (currently in UAT)

SourceSystemDeptID

Identifies the DeptID from the source system that is mapped to this global dept.

SourceSystemDeptName

Identifies the DeptName from the source system that is mapped to this global dept.

 

Mapping DWPROD global department views and SID global department table to the new Azure dim.GlobalDepartment table

The following table contains the column mapping between the new Global Department and the current global department (DWPROD IAM and IDM views and Global Dept SID table):

Dim.GlobalDepartment

GLOBAL_DEPT_MAP_V

GLOBAL_DEPT_MAP_IDM_V

SID_Title_GlobalDepartments

GlobalCollegeUnitName 

COLLEGE_NAME_TITLECASE

COLLEGE_NAME_TITLECASE

College_Name_Titlecase

GlobalCollegeUnitID

COLLEGE_CODE

COLLEGE_CODE

College_Code

GlobalDeptName

GLOBAL_DEPT_NAME

GLOBAL_DEPT_NAME

Global_Dept_Name

GlobalDeptNameShort 

SHORT_NAME

SHORT_NAME

Short_Name

GlobalDeptCode

ABBREVIATED_NAME

ABBREVIATED_NAME

Abbreviated_Name

PrimaryCIPCode

PRIMARY_CIPC

PRIMARY_CIPC

Primary_CIPC

GlobalDeptID

KEY_GLOBAL_DEPT

KEY_GLOBAL_DEPT

Key_Global_Dept

SourceSystem

DEPT_SOURCE

DEPT_SOURCE

Dept_Source

SourceSystemDeptID

DEPT_DIV_CODE

DEPT_DIV_CODE

Dept_Div_Code

SourceSystemDeptName

DEPT_DIV_NAME

DEPT_DIV_NAME

Dept_Div_Name

HealthIndicator

SET_INDICATOR

 

Set_Indicator

PGCompanyCode

COMPANY_CODE

COMPANY_CODE

Company_Code

IsAcademic

GLOBAL_DEPT_ACADEMIC_FLAG

 

Global_Dept_Academic_Flag

IsAcademicCollege

COLLEGE_ACADEMIC_FLAG

 

College_Academic_Flag

 

 

 

LastLoad_DateTimeStamp

Time Schedule

This job runs at 6:30 AM dailly