NOTE_ENC_INFO_2
Description:
This table extends HNO_ENC_INFO.

Primary Key
Column Name Ordinal Position
NOTE_CSN_ID 1

Column Information
Name Type Discontinued?
1 NOTE_CSN_ID NUMERIC No
The contact serial number (CSN) of the contact.
2 NOTE_ID VARCHAR No
The unique identifier (.1 item) for the note record.
3 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 CONTACT_NUM VARCHAR No
Contact number
6 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.
7 EXT_SHARED_W_PT_YN VARCHAR No
Autoreconciled external note share with patient status
May contain organization-specific values: No
Category Entries:
No
Yes
8 EXT_AUTH_NAME VARCHAR No
Autoreconciled external note author free text name
9 EXT_AUTH_SPEC_C_NAME VARCHAR No
Autoreconciled external note author specialty
May contain organization-specific values: Yes
10 EXT_AUTH_TYPE VARCHAR No
Autoreconciled external note author type
11 EXT_AUTH_SERV VARCHAR No
Autoreconciled external note author service text
12 EXT_LAST_SIGNER VARCHAR No
(DEPRECATED) The column EXT_NOTE_SIGNER_NAME[E0000000000443DBD2742EBE5C1C92EA0] in table NOTE_EXT_SIGNERS [E0000000000443DB52742EBE5C1C92EA0] should be used instead. Autoreconciled external note last signer name.
13 EXT_LAST_SIGN_UTC_DTTM DATETIME (UTC) No
(DEPRECATED) The column EXT_NOTE_SIGNING_UTC_DTTM [E0000000000443DBE2742EBE5C1C92EA0] in table NOTE_EXT_SIGNERS [E0000000000443DB52742EBE5C1C92EA0] should be used instead. External note signer instant.
14 NOTE_AUTHOR_TYPE_C_NAME VARCHAR No
The internal provider type of a note's author, mapped from the transmitted NUCC code.
May contain organization-specific values: Yes
Category Entries:
Resource
Physician