End-User and Application connectionThis 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. 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. | 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. | SourceSystem | Identifies the source system that a department belongs to. Source systems include: FAST (previously USF) GEMS 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 tableThe following table contains the column mapping between the new Global Department and the system sources (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 |
|