April 20, 2026 - Report Connector Release Notes

Things to Know

• Status: These notes are subject to change. Last update made on April 15, 2026.
• Feature Availability: New data is not available in the Report Connector until the UAT or PROD release dates shown below.

Release Summary

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

• Human Ethics (IRB): PUBLISHED_HE schema is now available.
• Outside Interests: Campaign and deletion tracking improvements added.
• Platform/Admin: Login activity, Training, and Task views added to PUBLISHED_ADMIN.
• Proposals (S2S): Data Dictionary updates and replication enhancements applied.
• SP Classic: F&A rate precision improvements made.
• Sponsored Projects: FUND_ID column added and mapping updates applied.

Release Dates and Downtime

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

Downtime required: None

Detailed Release Notes

New: Human Ethics

• Data are now available in the PUBLISHED_IRB schema, including Studies, Submissions, Checklists, Templates, History, and Roles. The FCT_SUBMISSION_CONTENT view provides all Submission questions and answers. Off-platform HE instances are available in the LIVE schema; UAT environments are not currently available. Please note: Please view the Data Dictionary for special instructions for how to use it.

New: Outside Interests

• Added a DELETED column to PUBLISHED_COI.FCT_DISCLOSURE to track disclosures removed via the Outside Interests UI.
• Added two Campaign-related views to DATASETS for internl use by the OI team:
  • CAMPAIGN_DISCLOSURE_NOT_STARTED – Eligible Disclosees without an Annual Disclosure
  • CAMPAIGN_DISCLOSURE_STARTED – Disclosees who have created an Annual Disclosure
• Added three Campaign tracking views to PUBLISHED_COI:
  • DIM_CAMPAIGN_SETTINGS – Current Campaign configurations
  • DIM_CAMPAIGN_UNSUBMITTED_ANNUALS – Annual Disclosures not yet submitted
  • DIM_CAMPAIGN_NO_ANNUAL – Disclosures created after the latest Campaign start date

New and Updated: Platform and Admin

• A new data view was added to the PUBLISHED_ADMIN schema: DIM_LOGIN_ACTIVITY. This view tracks login activity with timestamps.
• Training data in the PUBLISHED_ADMIN schema were not properly populating in some cases. A fix was applied so all non-CITI Training data now appear in the relevant Training views.
• Added new Task data views to PUBLISHED_ADMIN for Report Connector:
  • FCT_TASKS_ADMIN – Ad hoc Tasks and Admin Milestones
  • FCT_TASKS_SP – SP routing and SP record Tasks
  • FCT_TASKS_COI – COI disclosure and review Tasks

New: Proposals (S2S)

• Added new Proposal fields to the Sponsored Projects Data Dictionary, expanding columns in PUBLISHED_SP.FCT_PROPOSALS. New items can be found here and are highlighted in blue.

New: SP Classic

• Adjusted the F&A effective rate fields to remove excess decimal precision and prevent import or transformation issues:
  • PUBLISHED_SPC.PROPOSAL_BUDGET.CURRENT_PERIOD_EFFECTIVE_FA_RATE
  • PUBLISHED_SPC.PROPOSAL_BUDGET.PROJECT_EFFECTIVE_FA_RATE

New: Sponsored Projects

• Added the FUND_ID column to PUBLISHED_SP.FCT_AWARDS, enabling joins to BRG_AWARDS_FUND_ID for Fund Manager reporting. Available when Fund Manager is enabled on Platform and Funds are linked on the Award form.

Change Log:

April 15: Removal of Sync Monitoring from release

(Ref ID: v2.8)