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

100%

Status

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

Details

Dates
Fri 5/6/22 - Tue 8/8/23

Acct/Dept

Information Technology

Service

Project & Portfolio Management / Project Request

Type

IT-General / BI/DBA

Health

None - No health has been set

Created

Thu 5/5/22 3:31 PM

Modified

Tue 8/8/23 2:34 PM

Closed

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.

Dawn Roedel

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.

10/31/2022

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

Manager

Jackie Twehues

Alternate Manager(s)

Craig Harmon

Andi Niess

Sponsor