Auditing Tables
The bulk of the auditing information is readily accessible through the application. Below are the tables used to capture the complete set of auditing data and a brief description of each.
- Encounter: When an encounter is deleted, the flag IsDeleted is set to 1 in this table.
- EncounterVariableAuditLog: For each subject, records new, modified, and deleted values for encounter variables.
- EncounterVariableDoubleAuditLog: For each subject, records new, modified, and deleted values for secondary encounter variables.
- EncounterVariableGroupAuditLog: For each subject, records signing / unsigning of encounter variable groups.
- ProjectSubjectAuditLog: Records when a subject is screened, enrolled, failed screening, passed screening, or was un-enrolled. If the project uses randomization, enrolled and un-enrolled correspond to randomized and un-randomized, respectively.
- ProjectSubjectDeleted: Captures information about subjects removed from a project.
- ProjectSubjectVariableAuditLog: For each subject, records new, modified, and deleted values for project variables.
- ProjectSubjectVariableGroupAuditLog: For each subject, records signing / unsigning of project variable groups.
- Subject: When a subject is deleted, the flag IsDeleted is set to 1 in this table.
- SubjectMedicationAuditLog: Captures changes made to subject medication records.
- SubjectVariableAuditLog: For each subject, records new, modified, and deleted values for universal variables.
- Users: When a user is deleted, the flag IsDeleted is set to 1 in this table.
- VariableGroupAuditLog: For projects with versioning enabled, records when a variable group revision is publised and unpublished.