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
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.