OR_LNLG_VISTOR_TMS

Description:

The OR_LNLG_VISTOR_TMS table stores the in/out time information of the visitors who visited the surgery.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	VARCHAR	No
	The unique identifier (.1 item) for the record that contains the information about a single visitor who visited the surgery.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record. Each line contains in/out time for the visitor. A visitor may have multiple in/out times if he/she entered and exited the surgery multiple times. Each in/out time pair is stored as a separate line.
3	VISITOR_ST_CMT	VARCHAR	No
	Visitor start time comment
4	VISITOR_ET_CMT	VARCHAR	No
	Visitor end time comment
5	VISITOR_ST_DOCU_ID	VARCHAR	No
	The unique ID of the EMP user who documented this visitor's start time.
6	VISITOR_ST_DOCU_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	VISITOR_ET_DOCU_ID	VARCHAR	No
	The unique ID of the EMP user who documented this visitor's end time.
8	VISITOR_ET_DOCU_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.