Page Comparison

...

The bulk of the auditing information is readily accessible through the application.  Below are the tables used to capture auditing 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.