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
| Environment |
Release Date and Time (times shown in Pacific Standard Time) |
UAT-SG |
Apr 1, 2026 @ 12:00 AM PST |
UAT-AU |
Apr 1, 2026 @ 12:00 AM PST |
UAT-CA |
Apr 1, 2026 @ 12:00 AM PST |
UAT-US |
Completed incrementally in Q3/4 25 - Q1 26 |
Prod-SG |
Apr 20, 2026 @ 12:00 AM PST |
Prod-AU |
Apr 20, 2026 @ 12:00 AM PST |
Prod-CA |
Apr 20, 2026 @ 12:00 AM PST |
Prod-US |
Apr 22, 2026 @ 12:00 AM PST |
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)