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 |