BI - Cognos: CRS (Contract & Research System) - update ODS/Cognos



Completed [Completed]

100% complete, updated on Tue 8/8/23 2:34 PM by Andi Niess

Changed Status from In Process to Completed.
Changed Health from Green to None.
Changed Percent Complete from 50% to 100%.
Completed under parent project 422944


Fri 5/6/22 - Tue 8/8/23
Information Technology
Project & Portfolio Management / Project Request
IT-General / BI/DBA
None - No health has been set
Thu 5/5/22 3:31 PM
Tue 8/8/23 2:34 PM
Tue 8/8/23 2:34 PM

New Project Request

Point of Contact
This can either be the project manager or the person who knows the most about the project. Note that the project manager is assigned after the project is created.
How can we help you?
Please provide details regarding your request? Do you have a solution defined or do you need support identifying a solution?
Due to the WorkDay implementation, ORA has added (and continuing to add) fields in CRS for the Inbound Integration. We will need to add these fields to the ODS prior to WorkDay launch. In addition, these will be needed for COGNOS reports for validation in WorkDay.
Provide the background of this request.
What events or discussions preceded this request? Have there been previous efforts related to this request? Are you working with a vendor already? What are the benefits of this initiative?
Worked with the BI team (Jackie, Craig and Andi) on getting these fields in the ODS initially in 2020 and 2021. Changes will require a rebuild on 7 tables to add in 30 fields. Current Tables: Companies, IDC Rates, Proposals, Projects, Terms and Condits, Project Subcontractor, and Consortia. They know this request is coming and wanted to get it going through the committee.
What is the desired completion date?
Please note that projects will be completed based on resource availability and prioritization.
What are the factors driving the desired completion date?
Are there campus activities, legal requirements, dependent efforts or goals that are driving a date?
Validations for WorkDay inbound integration.
Provide the executive leader(s) who will champion this initiative?
These individuals support the success of this effort, such as removing obstacles, sending strategic communication and promoting necessary policy changes.
Jackie Twehues
What team members have been identified to help drive this initiative?
Please note that involvement of department team members is critical to the success of this inititive.
Andi Niess
Craig Harmon
Dawn Roedel
Any additional information about this request that you would like to include?
Who does this project help? What happens if this project is not completed?
see above


Alternate Manager(s)