Study design-related reports fail due to form rules

The Study Design and Annotated Case reports run successfully even when forms include Must be validation rules or null code list values. Previously, reports failed to handle null values returned by reporting queries, causing errors in the report generation process, unless form data was excluded from the reports. This fix includes robust handling of null data and consistent validation across form sections, allowing study team members to include all desired report sections and generate reports successfully.

(Issue 38245796)

The Subject Data Extract now includes all expected fields

Users with the required data classifications permissions now consistently receive complete Subject Data Extract reports, including hidden fields. Previously, running this extract multiple times or after logging in sometimes caused certain headers and columns to be missing. This occurred because the system inaccurately assessed the user's assigned data classifications, which meant that some fields the user had permission to view were not included in the report. The fix ensures the report data is always complete and unaffected by other users' actions or previous runs.

(Issue 38372054)

Oracle CRF Submit archives' Subject Event History show NULL values

Now, the Subject Event History in Oracle CRF Submit archive requests no longer displays a value of NULL for events. Previously, when a request containing multiple selected subjects, and subject events were performed by different users, the Subject Event History showed a value of NULL for majority of events.

(Issue 38272631)

Study Design report shows incorrect dates for kits added to treatment arms

Now, the Study Design report reflects the specific date of when a kit type was added to a treatment arm. Previously, the report showed the latest modified date, instead of the date the kit types were added.

(Issue 36343281)

Undo skip visit now records correctly as a single entry

Now, only one entry appears in your CRF Submit archives, in the Event History section, after an Undo Skip Visit action is performed. Previously, performing this action displayed three duplicate entries with missing details, which could confuse users reviewing a subject’s event history. This fix ensures that each undo skip visit action is shown just once, providing accurate and clear tracking of visit status changes. The improvement eliminates unnecessary duplicate records and streamlines the event history for better user understanding.

(Issue 38288851)

The Study Design report is not generated as expected

The Study Design report now appears under the Download Reports sidebar, as expected, when run in Testing mode. Previously, the report failed to generate due to missing data in some columns returned by the system, caused by a recent change to the reporting SQL. The issue occurred because the number of data points did not match the number of expected columns. The underlying code and SQL query were corrected to ensure consistent column and data alignment.

(Issue 37842526)