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
	This virtual item 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 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 Auth/Cert Update VECOZO Authorization Update OR Instructions 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 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 Result Encounter Note Radiation Planning Notes Radiation Completion Notes Radiotherapy Simulation Directive Radiotherapy Planning Directive Radiotherapy Management Radiotherapy 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 SMD Notes Unmapped External Note Filtered External Note Code Documentation Sedation Documentation JDT PCOD Dental Procedure Details Home Health LTC Provider Review Chart Abstraction 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	ADDENDUM_PARENT_CSN	NUMERIC	No
	Contains the contact serial number (CSN) of the parent document.
14	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.
15	LETTER_SUMMARY	VARCHAR	No
	The summary of the letter.
16	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 Result Notes 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 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 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 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 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 Employer Message Unidentified Client Concern Treatment Team Message Patient Request Secondary UR Review
17	CREATE_INSTANT_DTTM	DATETIME (UTC)	No
	The note's create instant.
18	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
19	DELETE_INSTANT_DTTM	DATETIME (UTC)	No
	The instant when the note is deleted.
20	DELETE_USER_ID	VARCHAR	No
	User who deleted the note
21	DELETE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
22	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.
23	DATE_OF_SERVIC_DTTM	DATETIME (UTC)	No
	The note's date of service.
24	SIGNED_NOTE_ID	VARCHAR	No
	This item points to the ID of the signed note that this note is addending/editing/cosigning.
25	LST_FILED_INST_DTTM	DATETIME (UTC)	No
	The instant the note was last edited.
26	UPDATE_DATE	DATETIME (Local)	No
	The date and time when this row was created or last updated in Clarity.
27	CURRENT_AUTHOR_ID	VARCHAR	No
	This item stores the current author of the note for indexing purposes.
28	CURRENT_AUTHOR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
29	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
30	VISIT_NUM	VARCHAR	No
	Professional billing visit number attached to this note.
31	CRT_INST_LOCAL_DTTM	DATETIME (Local)	No
	This is a virtual item that gets the create instant (I HNO 17105), in local time format.
32	NOTE_PURPOSE_C_NAME	VARCHAR	No
	This is a virtual item that displays the note purpose. It was previously stored in Note - Purpose (INP-5045). May contain organization-specific values: No Category Entries: NORMAL COSIGN ADDENDUM Non Authorized Transcription Resident Authorized Transcription Authorized Transcription Transcriptions with No recepient id
33	PRIORITY_YN	VARCHAR	No
	The priority of the note (Yes = High, No = Routine). May contain organization-specific values: No Category Entries: Yes No
34	ACTIVE_FROM_DT	DATETIME	No
	The date on which the note becomes active.
35	ACTIVE_TO_DT	DATETIME	No
	The date after which the note becomes inactive.
36	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
37	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).
38	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.
39	COMMENT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
40	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.
41	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.