Export audit trail in CDMS

+ More

Table of Contents

File types File contents Audit trail events Requesting an export

From the Audit Trail page in Castor CDMS, you can a copy of the study's Audit Trail in CSV format.

This export is currently available for studies created after the 2024.3.0.0 release upon request. If you want to enable the Audit Trail export, please contact Castor Support at support@castoredc.com and provide your Study ID.

File types

The Audit Trail can be exported from Castor CDMS in the following formats:

File contents

The following columns are present in the Audit Trail export file:

event_id	The unique ID (Identifier) of the event
triggered_on	The date and time when the event was triggered/performed
event_type	The type of the event, see the list below for more details
user_id	The unique ID (identifier) of the user who performed the event
user_name	The name of the user who performed the event
user_email	The email address of the user who performed the event
user_role	The name of the user's role at the site associated with the event (i.e., the site of the participant). This is included only when the role is relevant to the action performed (e.g., during data entry).
object_id	The unique ID (identifier) of the object this event relates to, see the list below for more details
event_data	The details related to the event in JSON format Please note that there is a delay in populating the event data column. After the event is triggered, it can take approximately one hour before the event data is present in the export.

Audit trail events

Type (event_type)	Description	Object ID
Audit Trail
audit_trail_viewed	Audit trail viewed	User
Dashboard
analytics_dashboard_opened	Analytics dashboard opened	User
Data Entry
data_point_validation_status_update	Validation status updated	Field Validation
field_value_decrypted	Field value decrypted	Participant
form_hidden	Form hidden	Visit Form
record_opened	Participant opened	Participant
record_randomization_reset	Participant randomization reset	Participant
record_randomized	Participant randomized	Participant
record_result	Participant result	Participant
report_instance_archived	Repeating data instance archived	Participant
report_instance_completed	Repeating data instance completed	Participant
report_instance_created	Repeating data instance created	Participant
report_instance_deleted	Repeating data instance deleted	Repeating Data Instance
report_instance_unarchived	Repeating data instance unarchived	Participant
report_instance_updated	Repeating data instance updated	Participant
report_result	Repeating data instance result	Participant
survey_instance_inserted	Sub-survey of package invitation created	Survey Instance
survey_package_instance_archived	Survey package invitation archived	Survey Package Instance
survey_package_instance_completed	Survey package invitation completed	Participant
survey_package_instance_created	Survey package invitation created	Survey Package
survey_package_instance_deleted	Survey package invitation deleted	Survey Package Instance
survey_package_instance_opened	Survey package invitation opened	Participant
survey_package_instance_unarchived	Survey package invitation unarchived	Survey Package Instance
survey_printed	Survey printed	Participant
survey_result	Survey result	Participant
survey_viewed	Survey package viewed	Participant
training_survey_package_instance_completed	Training survey package invitation completed	Participant
Data Export
export_create	Export created	Study
export_downloaded	Export downloaded	Export
export_has_expired	Export expired
field_values_decrypted_for_export	Field values decrypted for export	Study
sas_export_finished	SAS export finished	Export
sas_export_started	SAS export started	Export
study_file_uploaded	Study file uploaded	Export
Identity and access management
ip_address_added_to_2fa_allowlist	IP address added to 2FA allowlist	User
ip_address_removed_from_2fa_allowlist	IP address removed from 2FA allowlist	User
ip_address_removed_from_whitelist	IP address removed from whitelist	User
ip_address_whitelisted	IP address whitelisted	User
role_access_assigned	User role assignment updated
role_access_created	User role assignment added
role_access_deleted	User role assignment deleted
role_created	Role created	Role
role_deleted	Role deleted	Role
role_permissions_updated	Role permissions updated	Role
user_created	Permissions - User created
user_invited_to_study	Permissions - User invited to study	Study
user_rights_revoked	Permissions - User access revoked
user_rights_update	Permissions - User access updated
Monitoring
comment_created	Comment created	Participant
field_unverified	Field SDV dropped	Field
field_verified	Field SDV added	Field
participant_signed	Participant signed	Participant
participant_unsigned	Participant signature dropped	Participant
phase_locked	Visit locked	Visit
phase_signed	Visit signed	Visit
phase_unlocked	Visit unlocked	Visit
phase_unsigned	Visit signature dropped	Visit
phase_unverified	Visit verification dropped	Visit
phase_verified	Visit verified	Visit
query_created	Query created	Participant
query_remark_created	Query remark created	Participant
query_updated	Query updated	Record
record_locked	Participant locked	Participant
record_unlocked	Participant unlocked	Participant
report_instance_locked	Repeating data instance locked	Repeating Data Instance
report_instance_signed	Repeating data instance signed	Repeating Data Instance
report_instance_unlocked	Repeating data instance unlocked	Repeating Data Instance
report_instance_unsigned	Repeating data instance signature dropped	Repeating Data Instance
report_instance_unverified	Repeating data instance verification dropped	Repeating Data Instance
report_instance_verified	Repeating data instance verification added	Repeating Data Instance
report_step_locked	Repeating data form locked	Repeating Data Form
report_step_signed	Repeating data form signed	Repeating Data Form
report_step_unlocked	Repeating data form unlocked	Repeating Data Form
report_step_unsigned	Repeating data form signature dropped	Repeating Data Form
report_step_unverified	Repeating data form verification dropped	Repeating Data Form
report_step_verified	Repeating data form verification added	Repeating Data Form
step_locked	Form locked	Visit Form
step_signed	Form signed	Visit Form
step_unlocked	Form unlocked	Visit Form
step_unsigned	Form signature dropped	Visit Form
step_unverified	Form verification dropped	Visit Form
step_verified	Form verification added	Visit Form
survey_package_instance_locked	Survey package invitation locked	Participant
survey_package_instance_unlocked	Survey package invitation unlocked	Participant
Participant Management
deregistered_mobile_surveys_from_record	Deregistered mobile surveys from participant	Participant
email_address_viewed	Email address viewed	Participant
oauth_client_deregistered	Participant deregistered client app	Participant
oauth_client_registered	Participant registered client app	Participant
participant_econsent_link_dropped	Participant link with eConsent was dropped	Participant
participant_econsent_link_updated	Participant link with eConsent was updated	Participant
participant_linked_to_econsent	Participant was linked with eConsent	Participant
participant_pin_reset	Participant PIN reset	Participant
participant_pin_set	Participant PIN set	Participant
record_archive	Participant archived	Participant
record_ccr_patient_id_changed	Participant CCR patient id changed	Participant
record_created	Participant created	Participant
record_deleted	Participant hard delete	Participant
record_email_change	Participant email address updated	Participant
record_institute_change	Participant site updated	Participant
record_renamed	Participant renamed	Participant
record_subject_status_updated	Participant status updated	Participant
record_unarchive	Participant unarchived	Participant
searched_by_encrypted_field	Searched by an encrypted field	User
Study Design
crf_settings_modify	Study settings modified
crf_toggle_live	Study "Is Live" toggle
custom_export_type_was_created	Custom export type created	Export Type
custom_export_type_was_deleted	Custom export type deleted	Export Type
custom_export_type_was_updated	Custom export type updated	Export Type
domain_variable_was_created	Domain variable created	Domain
domain_variable_was_deleted	Domain variable deleted	Domain
domain_variable_was_updated	Domain variable updated	Domain
domain_was_created	Domain created	Domain
domain_was_deleted	Domain deleted	Domain
domain_was_updated	Domain updated	Domain
existing_institute_deleted	Site deleted	Site
field_copied	Field copied	Field
field_create	Field created	Field
field_delete	Field deleted	Field
field_update	Field updated	Field
form_structure_import_completed	Form structure imported
institute_changes_saved	Site updated	Site
new_institute_created	Site created	Site
option_created	Option created	Option
option_deleted	Option deleted	Option
option_group_created	Option group created	Option Group
option_group_deleted	Option group deleted	Option Group
option_group_updated	Option group updated	Option Group
option_updated	Option updated	Option
phase_create	Visit created	Visit
phase_delete	Visit deleted	Visit
phase_update	Visit updated	Visit
randomization_groups_modify	Randomization groups modified
randomization_settings_modified	Randomization settings modified
report_create	Repeating data created	Repeating Data
report_delete	Repeating data deleted	Repeating Data
report_step_copied	Repeating data form copied	Repeating Data Form
report_step_create	Repeating data form created	Repeating Data Form
report_step_delete	Repeating data form deleted	Repeating Data Form
report_step_update	Repeating data form updated	Repeating Data Form
report_update	Repeating data updated	Repeating Data
signature_statement_changed	Signature statement changed	Study
signature_statement_created	Signature statement created	Study
signature_statement_removed	Signature statement removed	Study
step_copied	Form copied	Visit Form
step_create	Form created	Visit Form
step_delete	Form deleted	Visit Form
step_update	Form updated	Visit Form
study_archived	Study archived	Study
study_linked	Linked study created	Study
study_sync_completed	Sync from source study completed	Study
study_sync_started	Sync from source study started	Study
study_unarchived	Study unarchived	Study
study_unlinked	Study unlinked	Study
survey_copied	Survey copied	Survey
survey_created	Survey created	Survey
survey_delete	Survey deleted	Survey
survey_package_create	Survey package created
survey_package_delete	Survey package deleted	Survey Package
survey_package_update	Survey package updated	Survey Package
survey_schedule_create	Survey schedule created	Survey Schedule
survey_schedule_delete	Survey schedule deleted	Survey Schedule
survey_schedule_update	Survey schedule updated	Survey Schedule
survey_step_copied	Survey form copied	Survey Form
survey_step_create	Survey form created	Survey Form
survey_step_delete	Survey form deleted	Survey Form
survey_step_update	Survey form updated	Survey Form
survey_update	Survey updated	Survey
validation_create	Validation created	Field Validation
Study opened
study_opened	Study opened	Study
Televisits
televisit_calendar_exported	Televisit calendar exported	Participant
televisit_cancelled	Scheduled televisit canceled	Participant
televisit_clinician_joined	Televisit clinician joined	Participant
televisit_clinician_left	Televisit clinician left	Participant
televisit_completed	Televisit completed	Participant
televisit_created	Televisit created	Participant
televisit_ended	Televisit ended	Participant
televisit_participant_joined	Televisit participant joined	Participant
televisit_participant_left	Televisit participant left	Participant
televisit_requested_change	Televisit participant requested change	Participant
televisit_rescheduled	Televisit edited	Participant
televisit_scheduled	Televisit scheduled	Participant
televisit_started	Televisit started	Participant

Requesting an export

Navigate to the Audit trail page.
Click the ‘Actions’ button and then click ‘Export Audit trail’

Contact Us