OR_LOG_VERIF

Description:

The OR_LOG_VERIF table contains OR management system log verification information.

Primary Key

Column Name	Ordinal Position
LOG_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	LOG_ID	VARCHAR	No
	The unique ID of the surgical log the log verification refers to
2	LINE	INTEGER	No
	The number of the line of the log verification in the surgical log.
3	VERIF_STAFF_ID	VARCHAR	No
	The ID of the staff member who verified the log.
4	VERIF_STAFF_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	VERIFICATION_DATE	DATETIME (Local)	No
	The date on which the log was verified.
6	OR_VERIFY_TYPE_C_NAME	VARCHAR	No
	The type of verification performed. May contain organization-specific values: Yes Category Entries: Verify Log Post Log Complete Log Addendum
7	VERIFY_ANSWER_ID	VARCHAR	No
	The answer (HQA) record for the verification.
8	ATTEST_FLT_ID	VARCHAR	No
	Holds the flowsheet template (FLT) ID used for documenting flowsheet information for the current attestation.
9	ATTEST_FLT_ID_DISPLAY_NAME	VARCHAR	No
	The display name associated with this template.
10	ATTEST_FLOWSHT_INST	DATETIME (Local)	No
	Holds the flowsheet instant at which the flowsheet documentation is stored for the current attestation.