NOTE_EXT_REL_PREDX

Description: |
This table stores information about external pre-procedure diagnoses related to an external note.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
NOTE_CSN_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | NOTE_CSN_ID | NUMERIC | No |
The unique contact serial number (CSN) of the note contact. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
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 | NOTE_ID | VARCHAR | No |
The unique identifier (.1 item) for the note record.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | EXT_REL_PREDX_NAME | VARCHAR | No |
Free text name of a pre-procedure diagnosis associated with the external note