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