Current Decision Support Projects

Project (ServiceNow Link)	Description	Current Status	Comments
UCPath	Implement the UCPath CDW (Common Data Warehouse), including UCI customizations. Import Informatica mappings delivered from UCLA. Maintain UCI's implementation of the DDODS (data dissemination operational data store). Design SQL Views to be used by campus Tier-N systems using the Enterprise Service Bus (ESB). Develop reports based on campus and UCIMC requirements.	In Progress
Research Administration Reporting & Data Warehouse	Phase I of project (report remediation): Develop ODS and replace legacy reports with new reports in Cognos Phase II of project (new reports): Develop ODS and/or dimensional data warehouse and reports based on requirements	In Progress
/wiki/spaces/adcom/pages/68014905	A number of groups across the campus create and utilize student data and process it in different ways for different purposes. This project is to create and execute a roadmap for a student data warehouse that will help organize and make student data available in a more efficient and useful manner, and to a larger audience than it is available to today.	In Progress	Daily Admissions data mart design and ETL development 95% complete.
Decision Support Access Request Process
SQL Server Upgrade	Upgrade primary data warehouse SQL from 2008 R2 to 2016 before June 2019.	In Progress	Development server migration complete. Planning for production migration
Database Planning and Proposal for new Architecture

Project (ServiceNow Link)	Description	Start	Current Status	Comments
KFS Historical Chart of Accounts	Enhancement of KFS data warehouse to track changes on the chart of accounts attributes. Develop reports to display historical attributes based on requirements.	9/1/2015	On Hold	Awaiting implementation requirements from functional office.
KFS Pending Entries	New addition to KFS data warehouse to include pending entries. Modify or develop reports based on requirements.	9/1/2015	On Hold
KFS Kuali Budget (KBM)	New addition to KFS data warehouse to include Kuali Budget Module (KBM) documents, attributes and transactions. Develop reports based on requirements.	5/1/2016	On Hold	Awaiting resource availability
/wiki/spaces/SIS/pages/21103609 (SIS)	Work with Ellucian to implement Banner ODS, EDW and reporting for SIS and related student systems. This project also includes integration of historical student data into the ODS, as well as Canvas, DegreeWorks, GradAid and other student systems as needed.		On Hold	Project put on hold