OPE_CASELOG_ADDL_INFO

Description:

The OPE_CASELOG_ADDL_INFO table is an extension of the OR management system log procedures (OR_LOG_ALL_PROC) table. It contains additional information about log procedures.

Primary Key

Column Name	Ordinal Position
OPE_ID	1

Column Information

	Name	Type	Discontinued?
1	OPE_ID	NUMERIC	No
	The unique identifier for the orders performed record.
2	CASELOG_DATATYPE_C_NAME	VARCHAR	No
	Determines if this is a case or log procedure additional data record. May contain organization-specific values: No Category Entries: Case Log
3	CASELOG_LOG_ID	VARCHAR	No
	The log record ID when the procedure additional data item is for a log.
4	CASELOG_PROC_DATE	DATETIME	No
	The date of the procedure.
5	CASELOG_CASE_ID	VARCHAR	No
	The case record ID when the procedure additional data item is for a case.