Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

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.

  1. Encounter: When an encounter is deleted, the flag IsDeleted is set to 1 in this table.
  2. EncounterVariableAuditLog: For each subject, records new, modified, and deleted values for encounter variables.
  3. EncounterVariableDoubleAuditLog: For each subject, records new, modified, and deleted values for secondary encounter variables.
  4. EncounterVariableGroupAuditLog: For each subject, records signing / unsigning of encounter variable groups.
  5. LoginLog: Records when a login attempt is made and whether it was successful.
  6. 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.
  7. ProjectSubjectDeleted: Captures information about subjects removed from a project.
  8. ProjectSubjectVariableAuditLog: For each subject, records new, modified, and deleted values for project variables.
  9. ProjectSubjectVariableGroupAuditLog: For each subject, records signing / unsigning of project variable groups.
  10. Subject: When a subject is deleted, the flag IsDeleted is set to 1 in this table.
  11. SubjectMedicationAuditLog: Captures changes made to subject medication records.
  12. SubjectVariableAuditLog: For each subject, records new, modified, and deleted values for universal variables.
  13. SubjectView: Caputures the user viewing a subject record and the type of record being viewed.
  14. SubjectViewSubject: Caputures the subject(s) being viewed.
  15. Users: When a user is deleted, the flag IsDeleted is set to 1 in this table.
  16. UserRoleAuditLog: Records when a user's role was assigned, removed, or had the expiration date changed.
  17. UsersAuditLog: Records changes to user records.
  18. VariableGroupAuditLog: For projects with versioning enabled, records when a variable group revision is publised and unpublished.


  • No labels