Auditing

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

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.