LNO_NOADD_SINGLE

Description:

The LNO_NOADD_SINGLE table contains information about your patient note records. This includes patient summary extracts, lab result reports, and other generated patient documents. All LNO records are included in this table.

Primary Key

Column Name	Ordinal Position
EXTRACT_ID	1

Column Information

	Name	Type	Discontinued?
1	EXTRACT_ID	NUMERIC	No
	The unique ID of the patient summary extract record.
2	EXTRACT_NAME	VARCHAR	No
	The internal name of the patient summary extract.
3	TRANSFER_DATE	DATETIME	No
	The date that the extract was transferred to the external document management system.
4	EXT_DOC_LINK	VARCHAR	No
	The link to the document stored in an external document management system.
5	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
6	EXTRACT_INSTANT	DATETIME (Local)	No
	The instant in which the patient summary extract was created.
7	TRIGGER_USER_ID	VARCHAR	No
	The user who triggered the extract. Contains the internal ID of that user.
8	TRIGGER_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.