Auditing

Owned by John Paliwoda
Last updated: May 03, 2020 by john Putzke

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. SubjectVariableDocumentAuditLog: Retains deleted and changed subject images.
  14. SubjectView: Caputures the user viewing a subject record and the type of record being viewed.
  15. SubjectViewSubject: Caputures the subject(s) being viewed.
  16. Users: When a user is deleted, the flag IsDeleted is set to 1 in this table.
  17. UserRoleAuditLog: Records when a user's role was assigned, removed, or had the expiration date changed.
  18. UsersAuditLog: Records changes to user records.
  19. VariableGroupAuditLog: For projects with versioning enabled, records when a variable group revision is publised and unpublished.

All Reward points and gift card transactions are also logged.