Skip to Main Content
SEI Idea Portal
Status Submitted
Workspace HC-DPS-EI: CPACS
Created by John Stammis
Created on Jul 2, 2024

IMS schema trigger to keep study_sts_stat.last_viewed_dttm in sync with exam_sts_stat

No description provided
Description

Adding a trigger to the ims schema to copy any value update of the exam_sts_stat.last_viewed_dttm column to all related studies in the study_sts_stat table which would allow CAM to purge without issues, and not require any rework on other products like RA1000 or AIM.