NOTES_HISTORY_LOG

Description:

This table contains the Edit History Information for all Notes (HNO records). Shows information about the type of edit, when the note was edited, and the user who made the edit.

Primary Key

Column Name	Ordinal Position
NOTE_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	NOTE_CSN_ID	NUMERIC	No
	A unique serial number identifier for this note contact.
2	LINE	INTEGER	No
	The line number of data, within the note contact.
3	NOTE_ID	VARCHAR	No
	The Note ID, or General Use Notes (HNO) record number.
4	CONTACT_DATE_REAL	FLOAT	No
	This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
5	CONTACT_DATE	DATETIME	No
	The date (calendar format) on which the encounter took place.
6	EDIT_HX_INSTANT	DATETIME (Local)	No
	The instant at which the History Edit Action was performed.
7	EDIT_HX_ACTION_C_NAME	VARCHAR	No
	The edit action that was performed on the note. Examples include Activate, Inactivate, and Edit. May contain organization-specific values: No Category Entries: Activate Inactivate Edit Create
8	EDIT_HX_INFO	VARCHAR	No
	This item can contain additional general edit information about the edit.