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.