REI_RES_PERSONNEL_AUDIT

Description: |
This table contains audit events that tracks changes made to an embryology result's personnel documentation.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
RESULT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | RESULT_ID | VARCHAR | No |
The unique identifier (.1 item) for the result record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | EMB_PRS_AUDIT_EVENT_C_NAME | VARCHAR | No |
An audit event for changes to personnel for this embryology result.
May contain organization-specific values: No
Category Entries:
Added with authentication
Added without authentication
Authentication added
Removed
Free-text modified
Specimen association modified
Authentication removed
Requirement overridden
Requirement override cleared
4 | REI_EMB_RESPONSIBILITY_C_NAME | VARCHAR | No |
The embryology procedure responsibility for the associated personnel audit event.
May contain organization-specific values: Yes
Category Entries:
Performed Procedure
Witnessed Procedure
Checked Patient ID
Checked Specimen IDs
Checked Plate IDs
Performed Tubing
Witnessed Tubing
Performing Embryologist
5 | PERSONNEL_AUDIT_USER_ID | VARCHAR | No |
The user personnel that is being modified in the associated personnel audit event.
6 | PERSONNEL_AUDIT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | PERSONNEL_AUDIT_TEXT_PREVIOUS | VARCHAR | No |
The previous value of the free text personnel being modified in the associated personnel audit event.
8 | PERSONNEL_AUDIT_TEXT_NEW | VARCHAR | No |
The new value of the free text personnel being modified in the associated personnel audit event.
9 | PERSONNEL_AUDIT_EDIT_USER_ID | VARCHAR | No |
The user that made an edit to this embryology result's personnel to trigger the associated personnel audit event.
10 | PERSONNEL_AUDIT_EDIT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
11 | PERSONNEL_AUDIT_EDIT_UTC_DTTM | DATETIME (UTC) | No |
The instant for the associated personnel audit event.
12 | AUDIT_RESP_REQ_OVRIDE_REASON_C_NAME | VARCHAR | No |
The requirement override reason for the associated personnel audit event.
May contain organization-specific values: Yes
Category Entries:
Requirement not completed by anyone
User not available to authenticate
13 | PERS_AUDIT_OVRD_CMT | VARCHAR | No |
The requirement override comment for the associated personnel audit event.