20200902 - RAH Start UAT

From: Parnell, Sarah
Sent:
To: RA-BI-Developers <RA-BI-Developers@ucsd.edu>
Cc: ITS-BIA <its-bia@ucsd.edu>; Urrutia, Gonzalo <gonzalo@ucsd.edu>; Armenta, Eduardo <earmenta@ucsd.edu>; Kettnich, Cheryl <ckettnich@health.ucsd.edu>; Joyce, Nicole <njoyce@ucsd.edu>; ITS-DataIntergrationServices <ITS-DataIntergrationServices@AD.UCSD.EDU>
Subject: RAH enhancements - UAT available - due Sept 9th

Hello RAH Developers - We are excited to release a number of enhancements for you to test between now and end of day September 9.  If you find an issue, please email busintel@ucsd.edu right away so we can address it prior to September 9.

In Cognos DEV run the report and select Hana QA.  Do not select Hana Prod as the report will fail.  Using Hana QA will allow you to see the below enhancements.  RAH data is the same in Hana Prod and Hana QA.

Sign into Tableau QA on your Tableau desktop tool and open your report.  Add a new data source with the same name and -QA at the end of the title.  Replace the original data source with the –QA data source.  Using the –QA data source will allow you to see the below enhancements.  RAH data is the same in Hana prod and Hana QA.

If you find an issue, please include in your email to busintel@ucsd.edu the following:

  • What browser are you using?
  • What environment are you using?  Cognos DEV, QA or PROD?  Tableau QA or Prod?
  • What data source / package are you using?
  • What results were you expecting?  What departments were you approved for via the new EAH row level security?


View
Epic
Research Administration - Developer Package - Award – KUALI

New field Award Investigator Eligibility Status

New field Award Key Person Eligibility Status

New field Award Principal Investigator Eligibility Status

New field Historical Award Principal Investigator Employee ID

New field Historical Award Investigator Employee ID

New field Historical Award Key Person Employee ID

New field Award Principal Investigator Home Division

New field Award Principal Investigator Home Division Code

New field Award Principal Investigator Home Unit VC Unit

New field Award Principal Investigator Home Unit VC Unit Code

New field Award Investigator Home Division

New field Award Investigator Home Division Code

New field Award Investigator Home Unit VC Unit

New field Award Investigator Home Unit VC Unit Code

New field Award Key Person Home Division

New field Award Key Person Home Division Code

New field Award Key Person Home Unit VC Unit

New field Award Key Person Home Unit VC Unit Code

Updated logic for Award Principal Investigator Employee ID

Updated logic for Award Principal Investigator Name and Employee ID

Updated logic for Award Investigator Employee ID

Updated logic for Award Investigator Name and Employee ID

Updated logic for Award Key Person Employee ID

Updated logic for Award Key Person Name and Employee ID

RAHMAINT-153

RAHMAINT-259

RAHMAINT-276

Research Administration - Developer Package - IP – KUALI

New field IP Investigator Eligibility Status

New field IP Key Person Eligibility Status

New field IP Principal Investigator Eligibility Status

New field Historical IP Principal Investigator Employee ID

New field Historical IP Investigator Employee ID

New field Historical IP Key Person Employee ID

New field IP Principal Investigator Home Division

New field IP Principal Investigator Home Division Code

New field IP Principal Investigator Home Unit VC Unit

New field IP Principal Investigator Home Unit VC Unit Code

New field IP Investigator Home Division

New field IP Investigator Home Division Code

New field IP Investigator Home Unit VC Unit

New field IP Investigator Home Unit VC Unit Code

New field IP Key Person Home Division

New field IP Key Person Home Division Code

New field IP Key Person Home Unit VC Unit

New field IP Key Person Home Unit VC Unit Code

Updated logic for IP Principal Investigator Employee ID

Updated logic for IP Principal Investigator Name and Employee ID

Updated logic for IP Investigator Employee ID

Updated logic for IP Investigator Name and Employee ID

Updated logic for IP Key Person Employee ID

Updated logic for IP Key Person Name and Employee ID

RAHMAINT-153

RAHMAINT-259

RAHMAINT-276

Research Administration - Developer Package - PD – KUALI

New field PD Investigator Eligibility Status

New field PD Key Person Eligibility Status

New field PD Principal Investigator Eligibility Status

New field Historical PD Principal Investigator Employee ID

New field Historical PD Investigator Employee ID

New field Historical PD Key Person Employee ID

New field PD Principal Investigator Home Division

New field PD Principal Investigator Home Division Code

New field PD Principal Investigator Home Unit VC Unit

New field PD Principal Investigator Home Unit VC Unit Code

New field PD Investigator Home Division

New field PD Investigator Home Division Code

New field PD Investigator Home Unit VC Unit

New field PD Investigator Home Unit VC Unit Code

New field PD Key Person Home Division

New field PD Key Person Home Division Code

New field PD Key Person Home Unit VC Unit

New field PD Key Person Home Unit VC Unit Code

Updated logic for PD Principal Investigator Employee ID

Updated logic for PD Principal Investigator Name and Employee ID

Updated logic for PD Investigator Employee ID

Updated logic for PD Investigator Name and Employee ID

Updated logic for PD Key Person Employee ID

Updated logic for PD Key Person Name and Employee ID

RAHMAINT-153

RAHMAINT-259

RAHMAINT-276