ORD_GEN_PALETTE

Description:

Table to hold items regarding note (HNO) records stored against order (ORD) records.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique identifier for the order record.
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	GENERIC_NOTES_ID	VARCHAR	No
	Note IDs that contain text generated from Generic Palette SmartForms
4	GEN_PAL_NOTE_DAT	NUMERIC	No
	Stores the contact date (DAT) of the note used in the generic palette to document the order.
5	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.