July 1, 2024 - Report Connector Release Notes v1

Things to Know

• Information on this page is subject to change. This page was last updated June 13, 2024.
• Features below are not functional in the application until UAT release date.

Important

In response to recent Snowflake data security issues, we encourage our users who have not done so to set up Multi-factor authentication (MFA) for Report Connector. For more information, see Security - Multi-factor Authentication (MFA).

Release Summary

Here's a quick overview of the updates in this release:

• New SP 4.0 Entity Relationship Diagram (ERD) is available
• New COI view added for Disclosure Forms
• Standard form field updates

Release Dates and Downtime

Release dates are subject to change. Release date changes will be noted in the Change Log below.

Downtime required: None

Change Log:

Detailed Release Notes

New: SP 4.0

We're introducing a new Entity Relationship Diagram (ERD) that is available on the Cayuse Support site. 

The diagram illustrates the relationships among the available SP views and certain Admin views located within the PUBLISHED_ADMIN schema.

New: COI

A new view has been added to the PUBLISHED_COI schema for the content of Disclosure Forms.

This breaks out all questions and their answers in all submitted Disclosures into one report, including a flag for SFI related content.

New and Updated: Standard Form Fields

There are several potential breaking changes in PUBLISHED_SP fact tables where standard fields previously identified as single value in Report Connector were in reality leveraged as multi-value for the vast majority of customers. This change primarily affects SP4.0 form fields that leverage Cayuse object finders (e.g. Unit finders, Person finders, etc.). These updated fields are indicated below, as well as in updated SP4.0 Data Dictionaries and a help article outlining how adjusting SP4 form fields from single to multi-select (and vice versa) affects Report Connector. 

• FCT_PROPOSALS: ADMIN_UNIT, PRIME_SPONSOR, and SPONSOR

• FCT_AWARDS: ADMIN_UNIT, SPONSOR, PRIME_SPONSOR, TERMS_AND_CONDITIONS, ON_SITE_FA_RATE, and OFF_SITE_FA_RATE

• FCT_SUBAWARDS: ADMIN_UNIT, SUBAWARD_ADMINISTRATOR, and SUBAWARDEE

New standard fields have been added to SP4.0 Proposals, Awards, and Subawards, including new _JSON fields that deliver smaller subsets of source JSON data for easier parsing. This is an interim step before the addition of additional bridge tables that deliver this data in tabular format in future releases. See SP4.0 Data Dictionaries for further details as well as a help article on parsing JSON data.

• PARENT_PROJECT_ID in FCT_AWARDS had a mis-identified JSON key and was null for most customers. This has been corrected.

• The NOTES field in FCT_AWARDS has been updated to NOTES_JSON to correctly identify the JSON it previously contained.

• The TYPE field in FCT_PROPOSALS had been misconfigured with the incorrect value parameter for the source standard form field. This has been corrected.

(Ref ID: V2.4)