HNO_INFO_2
Description:
This table contains common information from General Use Notes items. This table focuses on one time only data while other HNO tables (e.g., NOTES_ACCT, CODING_CLA_NOTES) contain the data for different note types.

Primary Key
Column Name Ordinal Position
NOTE_ID 1

Column Information
Name Type Discontinued?
1 NOTE_ID VARCHAR No
The note ID for the note record.
2 RELEVANT_REC_EVENT_ID VARCHAR No
Holds the Events (IEV) record which contains records marked relevant to the Note such as problems, allergies, lab results, etc.
3 GROUP_NOTE_ID VARCHAR No
This item stores the group note ID for notes that are created in a group documentation context.
4 LETTER_DEST_C_NAME VARCHAR No
The letter destination category ID for the note. This column is only populated if this row is for a Customer Relationship Management letter.
May contain organization-specific values: No
Category Entries:
Patient Portal
Print
Print and Portal
Email
Patient Portal Retracted
Print and Portal Retracted
5 LETTER_FINAL_UTC_DTTM DATETIME (UTC) No
The instant the letter was finalized. This column is only populated if this row is for a Customer Relationship Management letter.
6 HNO_RECORD_TYPE_C_NAME VARCHAR No
Record type.
May contain organization-specific values: No
Category Entries:
PB Guarantor Note
PB Guarantor Letter
PB Insurance Follow-up Letter
PB Hospital Account Note
PB Visit Account Letter
CRM Letter
CRM Envelope
CRM Email
HB Guarantor Note
HB Hospital Account Note
HB Guarantor Letter
HB Hospital Account Letter
HB Liability Bucket Letter
HB Liability Bucket Note
HB Contractual History Note
EB Guarantor Note
EB Appeal Letter
Reg Financial Assistance Letter
Reg Financial Assistance Tracker Note
Reg Financial Assistance Case Note
7 RFL_LETTER_ENC_CSN NUMERIC No
Stores the encounter in which the referral communication letter was written
8 CONV_MSG_CID NUMERIC No
This item contains the Community ID (CID) of a related In Basket Message (EOW) record.
9 OUTREACH_TEMPLATE_ID NUMERIC No
This item stores the campaign outreach template that created the letter.
10 SOURCE_EDITS_CSN NUMERIC No
Stores a Contact Serial Number (CSN) pointer to the General Use Notes (HNO) record that holds edits to the parent note while an attestation is in progress.
11 EXT_DOC_EVNT_ID VARCHAR No
External autoreconciled note event identifier
12 EXT_NOTE_TYPE VARCHAR No
Autoreconciled external note type name
13 EXT_DUP_NOTE_ID VARCHAR No
Autoreconciled extneral note duplicate source note
14 EXT_DUP_NOTE_C_NAME VARCHAR No
Autoreconciled external note duplicate note type
May contain organization-specific values: No
Category Entries:
Same reference ID
Duplicate text
Same globally unique ID
15 PARENT_NOTE_ID VARCHAR No
The parent note ID of a soft-deleted transcription record.
16 ACTIVE_C_NAME VARCHAR No
Whether the note is active. This item is not populated for all notes.
May contain organization-specific values: No
Category Entries:
Active
Inactive
17 EXT_AUTHOR VARCHAR No
Name of the external note's author. The name is stored as pieces delimited by character 127 and is ordered as follows: Last Name, Last Name from Spouse, First Name, Middle Name, Last Name Prefix, Spouse Last Name Prefix, Title, Suffix, Academic Initials.
18 NOTE_UPDATE_INST_UTC_DTTM DATETIME (UTC) No
The last time this note was received through Care Everywhere. The value of Received Assessment and Plan Existence Days (I DXC 17000) defines how long notes with this item set exist before they are deleted. Scheduled task Remove HNO Records (E1J 88032) deletes notes and all of their references that have not been received within the amount of days defined by Received Assessment and Plan Existence Days (I DXC 17000) Received Assessment and Plan Existence Days (I DXC 17000) defaults to 30 days if not set.
19 ROUT_RECPNT_COMMUNICATION_ID NUMERIC No
This is a Communication Management (LCA) record that contains information about recipients that users selected for routing in the clinical note editor.
20 EXTERNAL_SOURCE_IDENT VARCHAR No
If this note is associated with information in an outside system, the ID of that information can be stored here.
21 EXTERNAL_PROBLEM_IDENT VARCHAR No
The reference ID for the external problem linked to the note.
22 TRANSLATION_IDENTIFIER VARCHAR No
Stores the unique identifier to link back to the source information that the note is a translation for. This should only be set on Translation (Item HNO 50 = 61) type HNO records. The format of the identifier is intended to capture the INI and ID of the source record, along with the requested language to be translated in.
23 TRANSLATION_LANGUAGE_ID NUMERIC No
The unique identifier (.1 item) for the Epic Languages record associated with a translation HNO record. Should only be set for Translation (Item HNO 50 = 61) type notes.
24 TRANSLATION_LANGUAGE_ID_LANGUAGE_NAME VARCHAR No
The language name. If the language is written and uses more than one script to represent it, the name will contain the script in parentheses after the language name.