End-User and Application connection
This table identifies the attributes of the global departments that will be provided to the end-users as a client-facing table. The access to this table will be through SQL Authentication where a user, database name and table name will be provided to the end-users.
For access submit a ticket to it-analytics@usf.edu with the following information included:
Server: usfsynapseanalytics.sql.azuresynapse.net
Port: 1433
Database: biadw
Schema: dim
Table: GlobalDepartment
Account Name you prefer
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 | |
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 |