OR_LNLG_PREOP_APPT

Description:

This table contains the Preop Appointments information for the Surgical Log (ORL).

Primary Key

Column Name	Ordinal Position
RECORD_ID	1

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	VARCHAR	No
	The unique ID of the line record.
2	PREOP_APPT_UID	VARCHAR	No
	The unique ID of the pre-op appointment.
3	PREOP_APPT_VT_ID	VARCHAR	No
	The visit ID of the pre-op appointment.
4	PREOP_APPT_PROC_ID	VARCHAR	No
	The procedure ID of the pre-op appointment.
5	PREOP_APPT_PROC_ID_PROC_NAME	VARCHAR	No
	The name of the surgical procedure record.
6	PREOP_APPT_PROV_ID	VARCHAR	No
	The provider ID of the pre-op appointment.
7	PREOP_APPT_DEPT_ID	NUMERIC	No
	The department ID of the pre-op appointment.