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:
- CSV
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’