BI - Cognos: Add address view containing PO and RB to CRS pack

100%

Status

Completed [Completed]

100% complete, updated on Mon 3/22/21 7:25 PM by Jackie Twehues

Changed Status from In Process to Completed.
Changed Percent Complete from 95% to 100%.
Dawn confirmed view deployed to production.

Details

Dates
Wed 1/13/21 - Mon 3/22/21

Acct/Dept

Information Technology

Service

Banner / Integration Issue

Type

IT-General / BI/DBA

Health

Green - On track

Classification

Grow

Requirements

adding some columns to locations table and load scripts.

Created

Thu 1/14/21 2:13 PM

Modified

Mon 3/22/21 7:25 PM

Closed

Mon 3/22/21 7:25 PM

New Project Request

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?

table/data change

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?

unknown

What is the desired completion date?

Please note that projects will be completed based on resource availability and prioritization.

01/29/2021

What are the factors driving the desired completion date?

Are there campus activities, legal requirements, dependent efforts or goals that are driving a date?

time

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.

unknown

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.

charmon

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?

I'm going to meet with Dawn to get details

Description

There is currently a feed from Banner to the CRS (Contract Research System, vendor is ESM Solutions) that I would like to adjust. When the feed was set up, we excluded foreign addresses from populating into CRS. I would like to include foreign addresses in the feed. In CRS, the table to updated is the Locations table. Happy to meet when you have a chance to dig into this if you need more info. Thank you! - Dawn

Manager

Jackie Twehues

Alternate Manager(s)

Mike Pusey

Sponsor

Dawn Roedel

Stakeholders (3)

Angie Reyes

Assoc Dir Workday ERP Tech Ops

Consulted, Informed

Wed 1/13/21 3:26 PM

Craig Harmon

Oracle Database Admin

Consulted

Requestor

Wed 1/13/21 3:25 PM