HNO_INFO

Description: |
This table contains common information from General Use Notes items. This table focuses on time-insensitive, once-per-record 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 unique ID of the note record.
2 | NOTE_TYPE_NOADD_C_NAME | VARCHAR | No |
Starting in November 2025 this column has the value for Note - Type No-Add (I HNO 51) to identify the type of note this record is for non clinical notes. For clinical notes, instead use the column IP_NOTE_TYPE_C in table HNO_INFO to get the UCN note type (I HNO 34033) value. Versions prior to November 2025 used the following logic: This virtual item (I HNO 17051) is populated with a category value from Note - Type No-Add (I HNO 51) according to the following logic: * if Note - Type No-Add (I HNO 51) is populated, use the value directly * if Note - Type No-Add (I HNO 51) is null and the note is not ambulatory, return null * if Note - Type No-Add (I HNO 51) is null and the note has an ambulatory encounter context, obtain a category from the UCN note type (I HNO 34033) and map that value to an equivalent category from Note - Type No Add (I HNO 51), if possible
May contain organization-specific values: Yes
Category Entries:
General
Phone Message
Letter
Message
Telephone Encounter
Provider Comments
RTF Letter
Routing Comments
Specialty Comments
Charting Text
MyChart Message
Eligibility Message
Criteria Review
AP Claim Code Edit
Patient Flag
Nurse Triage Message
Dental Soft Tissue Note
ABN INFORMATION
Progress Note
Nursing Note
Consult/Results - Findings
Consult/Results - Impression
Consult/Results - Recommendations/Plans
Chart Sync Patient Summary Report
Chart Sync Admission Summary Report
H&P Note
Procedure Note
Communication Body
Anesthesia
Department Message
Assessment & Plan Note
Problem Overview
Subjective & Objective
Care Coordination
Home Care Admit
Home Care Non-Admit
CTI Order
Bookmark
Hospice Discharge Remarks
Charge Homing Guarantor Inquiry
Patient Genomic Indicator Overview Note
Home Health Face to Face Attestation
Hospice Face to Face Attestation
Sticky Note
Coding Query
Address Verification Message
Intake Communication
Pharmacy Enrollment Note
Patient Instructions
Discharge Attachment
Previous Reports
Result Order Report
Home Care Intervention
Home Health Plan of Care Header
Dermatology Finding Description
Specimen Tracking Comments
Radiology Study Results
Translation
Auth/Cert Update
Phenotype Comment
VECOZO Authorization Update
OR Instructions
Dermatology Skin Cancer History
In Basket Conversation
Incoming Message Pend Notes
Xtenity Patient Portal Message
Outside Organization Note
Outside Organization Update
Outside Organization Document
Cosign with Attestation Text
Simple Med Note
Medication History
ANSI 278 Information
History Overview
ED Disposition Edit Trail
Lab
Intervention Data from External System
Event Note
Treatment Summary
Rehabilitation Potential
Discharge Plans
History Event Details
Referral Transaction Record
Happy Together Result Transcription
Group Note
Care Advice Text
Infection Case
Prior Auth Decision Note
Clinical Note Summary
Transplant
Organ
Reg History Event
Interfaced Result
Outside Organization Coverage Information
3 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for the patient encounter to which the note is attached. This number is unique across all patient encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
4 | ENTRY_USER_ID | VARCHAR | No |
The unique ID of the user who created this note. This column is frequently used to link to the CLARITY_EMP table.
5 | ENTRY_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | NOTE_DESC | VARCHAR | No |
This is a free text description of the note.
7 | IP_NOTE_TYPE_C_NAME | VARCHAR | No |
The note type associated with this note.
May contain organization-specific values: Yes
Category Entries:
Progress Notes
Consults
Procedures
H&P
Discharge Summary
ED Notes
Initial Assessments
ED Triage Notes
Case Communication
OR Nursing
OR Surgeon
OR PreOp
OR PostOp
OR Anesthesia
Ambulatory Progress Notes
Ambulatory H&P Notes
Ambulatory Procedure Notes
Discharge Instructions
ED Provider Notes
Decision
Note to Patient via Portal
Anesthesia Preprocedure Evaluation
Anesthesia Postprocedure Evaluation
H&P (View-Only)
Interval H&P Note
Anesthesia Procedure Notes
Addendum Note
Care Plan
Hospital Course
Subjective & Objective
L&D Delivery Note
Telephone Encounter
Patient Instructions
Assessment & Plan Note
Communication Body
ED AVS Snapshot
Letter
Lactation Note
Committee Review
IP AVS Snapshot
MR AVS Snapshot
Pharmacy Enrollment Note
Pre-Procedure Assessment
Discharge Instr - Supplementary Instructions
Discharge Instr - AVS First Page
Discharge Instr - Meds
Discharge Instr - Pharmacy
Discharge Instr - Activity
Discharge Instr - Diet
Discharge Instr - Appointments
Discharge Instr - Lab
Discharge Instr - Other Orders
Discharge Instr - Other Info
CAA (Care Area Assessment)
Nursing Note
ACP (Advance Care Planning)
ERAS
Organ Offer
Result Encounter Note
Radiation Planning Notes
Radiation Completion Notes
Radiation Therapy Simulation Directive
Radiation Treatment Planning Directive
Radiation Treatment Management
Radiation Treatment Summary
Home Infusion
Form
BH Treatment Plan
Group Note
Video Visit Routing Comment
E-Visit Routing Comment
Claim Note
Multi-Disciplinary Team Discussion
Dialysis Plan of Care Note
Home Health Plan of Care Certification Statement
Home Health Plan of Care
Dialysis Monthly Comprehensive Note
Dialysis Rounding Note
SMD Notes
Unmapped External Note
Filtered External Note
Code Documentation
Sedation Documentation
JDT PCOD
Dental Procedure Details
Performed Procedure
Appeal Review
Appeal MD Review
Appeal Intake
Appeal Creation
Appeal External Review
Grievance Review
Grievance Resolution
Grievance Intake
Grievance Creation
Home Health
LTC Provider Review
Chart Abstraction
MR Safety Technologist Evaluation
MR Safety Medical Physics Exam Customization
MR Safety Implant Electronics Preparation
MR Safety Implant Positioning and Immobilization
Inpatient Self-Administration Sheet
Outpatient Self-Administration Sheet
Inpatient Medication Chart
Outpatient Medication Chart
Hospice
Hospice Plan of Care
Hospice Non-Covered
Hard Deleted Note
8 | ORIGINAL_HP_ID | VARCHAR | No |
For View-Only H&P notes only - original note record identifier
9 | ORIG_HP_DATE_REAL | NUMERIC | No |
For View-Only H&P notes only - original note record contact
10 | SOURCE_HP_ID | VARCHAR | No |
For Interval H&P only - ID of H&P Note being modified by interval note
11 | SOURCE_HP_DATE_REAL | NUMERIC | No |
For Interval H&P only - contact of H&P Note being modified by interval note
12 | ECG_TECHNICIAN_ID | VARCHAR | No |
The Electrocardiogram/Spirometry Technician
13 | PAT_LINK_ID | VARCHAR | No |
Virtual item that will check all HNO items linked to EPT and return the first EPT ID it finds. The items are checked in the following order: 505, 38970, 21001, 600 (which gives us an order, then we look at ord 210), 1605, 1643, 1640.
14 | LETTER_SUMMARY | VARCHAR | No |
The summary of the letter.
15 | TX_IB_FOLDER_C_NAME | NUMERIC | No |
Stores the Type of Message (I EOW 30) In Basket folder to be used by the Transcription interface to generate In Basket messages
May contain organization-specific values: Yes
Category Entries:
Staff Message
Schedule List
Send a Letter
Phone Calls
Transcription
Patient Calls
Results
Charts
Dictations
Overdue Rslt
Orders
Med. Cosign
Referral Verification
Open Orders
Station Msg
Credential
Order Cosign
CRM
Claims
Referral Notice
Patient Call Back
Patient Reminder
Canceled Orders
Chart Cosign
Open Encounters
Charge Review
Charge Update
Case Creation
Case Review
Case Overdue
Rx Auth
Rx Response
Addendum
Break-the-Glass
Overdue Rx Auth
CDS alert
Charge Pending
Merge Notification for Patients with Histories Contacts
Incomplete Note
Preadmission Schedule List
Claim Letter
Referral Letter
Results Follow-Up
Collection Tickler
Appointment Notification
Unmerge Notification for Patients with Histories Contacts
Order Based Transcription
CC'd Result Message
Overdue Notice
Receipt
Patient Schedule Request
Patient Refill Request
Patient Medical Advice Request
Patient CRM Request
Hospital ADT
Progress Notes
Length of Stay Alert
Clinical Letter
Letter Dictation
Voice Message
Preadmission Form
Covered Work
Verbal Order Cosign
Open Letters
Follow-up Reminder
Chart Deficiencies
Overdue Releases
Timeout Message
Charge Review Information
Add-on Orders
Expiring Orders
Progress Note Cosign
Work Queue Message
Nurse Triage Call Back
PCP Change Review
Incomplete Progress Note
Nurse Triage/Routing
Admission Notice
Discharge Notice
Transfer Notice
Initiate Call Back
Referral Status Change
Help Desk
Case Message
Log Message
HH Order
HH Order Alert
Home Health Discharge
CC Charts
Declined Deficiencies
Deficiency Update Errors
Expiring Referrals
ADT Orders Error
IP Cosign Note
Inpatient Transcriptions
Cancer Staging
ERefill
Inpatient ND Consultation Alert
Send Page
Outstanding Page
Rejected Transcription
Claim Refund Due
Overdue Transcription
MR Encounter form
Device data
Referral Notification Letter
Letter Review
Unsigned Orders
Encounter Report
Completed Orders
ADT Light
CRM Reply Message
First Access Notification
Web: New Patient
Referral Message
INR Reminder
Anticoagulation Enrollment
Restricted Messages
Medication Messages
Unverified Medication Messages
Order set notifications
Preference Card Change Request
HH Visit Set Auth
Reporting Workbench
HH Visit Set Scheduling
Home Care Schedule
HH UNLOCKED ASSESSMENT WARNING
HH THERAPY UPCODE MESSAGE
Bed Requested Notice
Bed Assigned Notice
Bed Request Completed Notice
Home Care Admit
HH Auth Cert
ADT Integrity Message
Unviewed Test Results Message
New User Request
Community File Upload
Overdue Message
ERefill Follow-up
Refill Errors
UNOS Notification
Post Mortem Notification
ERefill Cosign
Home Care Referral
Hospice Plan of Care Review
File Chart
File Restricted
Referral Triage
Multi-step Order Entry Task
E-Prescribing Errors
E-Prescribing Sig Map
Admin Request
Rx Adjudication Error
Continued Care and Services Request
eReferrals Errors
Hospice Complete Intake
INR Encounters
Episode Notification
Letter Queue
Comm Mgmt-New Provider Request
DBC Alert
Bulk Actions
Documentation Validation Checks
Group Review
Orders 2
Orders 3
Negative Application Receipts
Claim Notification Messages
REVIEW REPORTS
Medication Cancellation
Nurse Triage Encounter
Claims and Remittance Message
Radiology Messages
Rule Compiler Error Report
Claim 9999 Error
Overlay Resolution Message
ChartSync Conflict Message
Studies to Sign
CRM Notification
Rx Billing Errors
Rx Build Errors
RX Adjust Times Notification
Rx ADT Notification
Rx Patient Stored Medications
Rx Barcode Validation
Notification
Health Maintenance
Home Health Approved Discharge
Order Releasing Failures
Treatment Plan Verbal Order Cosign
Orders Second Sign Required
Orders Second Sign Rejected
Orders Second Sign Modify
Orders Second Sign Notify
MyChart Administration Message
MyChart IMH Questionnaire Message
MyChart Patient Entered Flowsheet Messages
Message to Patient
Unread Patient Message Notification
Patient Questionnaire Submission (OLD)
Patient Insurance Information Update
Patient Information Update
WPR merge unmerge summary message
Patient Access Notification
E-Visit Payment Received
Patient History Questionnaire Submission
Patient Access Login Admin Alert
Proxy Access Level Transition Locked Records Message
E-Visit Message
Clinical Update Message
Patient Preference Update
Patient Activation Code Request
ABN Follow Up
Kiosk Demographics Verification
Kiosk Insurance Verification
Kiosk Emergency Contact Verification
Kiosk Patient Photo Verification
Patient PCP Verification
Rx SAP Inventory Errors
Rx Test Adjudication
Event Mon - Outpatient
Event Mon - Inpatient
Event Mon - New Managed Access Patient
Event Mon - Lab Results
Event Mon - Emergency Department
Event Mon - Referrals
Event Mon - Financial
Event Mon - Patient Status
Event Mon - Enrollment
Home Care Case Communication
Medication Management
E-Consult
Prior Authorization
Interfaced Call Center
Nurse Triage/Routing Follow-up
Failed Fax
Chart Completion
Cosign - Clinic Orders
Treatment Plan Order Removal Cosign
Document Signatures
Translation Request
Lab Cancel Item
Lab TAT Warning
Lab Verification Message
Lab Redraw Test
Lab Hold Message
Lab Ship Message
Lab Auto Result Checking Message
Media Manager
Research Recruitment
Research Provider Approval
Quality Improvement Message
Adverse Event Review
Research ADT Event Notification
POC Update Notification
Video Visit
Proxy Upgrade Request
AC SIGNIFICANT WEIGHT CHANGE
ED Charts
ED Charting Reminder
ED Note Accepted
Follow-Up Charts
IP ROUTING
IP CONSULT ORDER ALERT
MR ALLERGIES INTERACTION ALERT
Patient Drug-Disease Interactions
IP INCOMPLETE NOTE
MR ALLERGEN LIST
Dual Sign Orders
Chart Correction Message
ID Chart Correction Message
OurPractice
Feedback
Procedure Messages
Procedure Prep
Block Notification
Cardiology Message
Imaging Peer Review Message
Actionable Findings Escalation
Lab-AP: Surgical Pathology
Lab-AP: Cytology
Lab-AP: Cytology Rescreen
Lab-AP: QA Review
Lab-AP: Pathology Review
Lab-AP: Gross
Lab-AP: Histology
Lab Add-ons
OUT OF CONTACT NOTIFICATION
Registry Data Import
Coding Query
Professional Coding Query
Route Plan
Treatment Summary
MR Coding Query
Patient Non-Clinical Update
Patient Clinical Update
MyChart Administration Notification
MyChart Notifications
Patient Questionnaire Submission
Patient Escalation
Patient Pharmacy Message
Therapy Plan Notifications
Update Diagnosis
Treatment Approval
Pending Orders
Kanta Document Signatures
Studies to Read
Overdue Results Errors
Results Error Message
Instant Orders Errors
Dictate Later
Order Transmittal Mapping Errors
CE Event Notification
CE Request Notification
CE Outgoing Patient Query Notification
CE Incoming Patient Query Notification
CE Outside Messages
CE Outside Referral Updates
CE International Messages
CE Failed Direct Message Notification
External Chart Correction Message Notification
Multidose
Advance Care Plan Update
Bulk Letters
eMessaging Notifications
eMessaging Reports
eMessaging Dialog
Compass Rose Failed Request
Push Notification
Swiss Cost Assurance Notification
Appointment Request
Site Maintenance
Charge Router Message
Pending Mobile Charge Notification
Broadcast Message
ORTHO MISSING VISITS
Look-Alikes Saved Search
Look-Alikes Collaboration
Anesthesia Messages
Open Anesthesia Record
Med Review
Anesthesia Addendum Messages
Round Table
Anesthesia Emergency
Employer Message
Unidentified Client Concern
Treatment Team Message
Patient Request
Second-Level Review
Cell Therapy Infusion Plan
16 | CREATE_INSTANT_DTTM | DATETIME (UTC) | No |
The note's create instant.
17 | UNSIGNED_YN | VARCHAR | No |
A flag for if the note record is considered an unsigned note.
May contain organization-specific values: No
Category Entries:
No
Yes
18 | DELETE_INSTANT_DTTM | DATETIME (UTC) | No |
The instant when the note is deleted.
19 | DELETE_USER_ID | VARCHAR | No |
User who deleted the note
20 | DELETE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
21 | COSIGNED_NOTE_LINK | NUMERIC | No |
Contains a contact serial number (CSN) that points to the resident's note being cosigned. Cosigning Note Link (I HNO 34158) is a link for the opposite direction.
22 | DATE_OF_SERVIC_DTTM | DATETIME (UTC) | No |
The note's date of service.
23 | SIGNED_NOTE_ID | VARCHAR | No |
This item points to the ID of the signed note that this note is addending/editing/cosigning.
24 | LST_FILED_INST_DTTM | DATETIME (UTC) | No |
The instant the note was last edited.
25 | UPDATE_DATE | DATETIME (Local) | No |
The date and time when this row was created or last updated in Clarity.
26 | CURRENT_AUTHOR_ID | VARCHAR | No |
This item stores the current author of the note for indexing purposes.
27 | CURRENT_AUTHOR_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
28 | LETTER_TYPE_C_NAME | VARCHAR | No |
Type of professional billing letter.
May contain organization-specific values: Yes
Category Entries:
Account Letter
Follow-up Letter
Campaign Letter
29 | VISIT_NUM | VARCHAR | No |
Professional billing visit number attached to this note.
30 | CRT_INST_LOCAL_DTTM | DATETIME (Local) | No |
This is a virtual item that gets the create instant (I HNO 17105), in local time format.
31 | PRIORITY_YN | VARCHAR | No |
The priority of the note (Yes = High, No = Routine).
May contain organization-specific values: No
Category Entries:
Yes
No
32 | ACTIVE_FROM_DT | DATETIME | No |
The date on which the note becomes active.
33 | ACTIVE_TO_DT | DATETIME | No |
The date after which the note becomes inactive.
34 | TREAT_SUM_RLS_TO_MYC_YN | VARCHAR | No |
Indicates whether a Treatment Summary is released to MyChart.
The category values for this column were already listed for column: UNSIGNED_YN
35 | TREAT_SUM_RLS_TO_MYC_CSN | NUMERIC | No |
Stores the CSN of the Treatment Summary (HNO) that is released to MyChart. If you use IntraConnect, this column stores the Unique Contact Identifier (UCI).
36 | COMMENT_USER_ID | VARCHAR | No |
The unique ID of the last user to edit the internal comment in either the Continued Care and Services Coordination or Payer Communication workflows.
37 | COMMENT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
38 | COMMENT_EDIT_INST_DTTM | DATETIME (UTC) | No |
Instant the comment was last edited in either the Continued Care and Services Coordination or Payer Communication workflows. In UTC.
39 | CONVERSATION_MSG_ID | VARCHAR | No |
The record for the message that was also filed as a note. The text filed in the message and the quicknote will be the same and displaying one of these to the end user should be sufficient.