DENT_ORTH_EXAM_NOTES

Description: |
Table for storing the HNO record IDs that store notes for a patient's comprehensive oral exam.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 | 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.
3 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
4 | CM_CT_OWNER_ID | VARCHAR | No |
The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
5 | ORTH_EXAM_NOTE_ID | VARCHAR | No |
Rich text representation of an oral exam conducted on the patient as part of an orthodontic treatment.