BOOKMARK_INFO

Description: |
This table will extract bookmarks from the HNO database.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | NOTE_ID | VARCHAR | No |
The unique identifier (.1 item) for the note record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | TAG_EXTERNAL_LOCAL_IDENT | VARCHAR | No |
The locally-assigned unique identifier of the tagged external note.
4 | TAG_EXTERNAL_SOURCE_DXR_CSN_ID | NUMERIC | No |
The ID of the tagged note's source DXR contact.
5 | TAG_EXTERNAL_ENC_START_DTTM | DATETIME (Local) | No |
The start instant of the encounter associated with the tagged external note.
6 | TAG_EXTERNAL_ENC_END_DTTM | DATETIME (Local) | No |
The end instant of the encounter associated with the tagged external note.
7 | TAG_EXTERNAL_ENC_TYPE_C_NAME | VARCHAR | No |
The mapped encounter type ID of the encounter associated with the tagged external note.
May contain organization-specific values: Yes
Category Entries:
Registration
Walk-In
Hospital Encounter
Canceled
Unmerge
Contact Moved
Intake
EMPTY
Research Encounter
Radiation Treatment
Recurring Plan
Billing Exchange
Health Plan
Update
PCP/Clinic Change
Wait List
Enrollment
Social Care Application
Service Decision Registration
Leader Rounds
Clerical Orders
Patient-Selected Community Resource
Mother Baby Link
Lactation Encounter
Appointment
Surgery
Anesthesia
Anesthesia Event
Guardian Screening
Ancillary Procedure
Anticoagulation Discharge Documentation
Health Maintenance Letter
Patient Message
E-Visit
Mobile Order Only
Questionnaire Series Submission
Travel
Patient Self-Triage
Organ Offer
Community Care Management
Patient Outreach
Telephone
Nurse Triage
E-Consult
E-Consult Community Order
Results Follow-Up
Clinical Documentation Only
Telemedicine
Plan of Care Documentation
External Communication
Reconciled Outside Data
External Contact
Ophth Exam
Dialysis Calendar Documentation
Pre-Admission Testing
Episode Documentation Update
Hospice Admission
Home Infusion
Home Infusion Billing
Episode Update
Home Health Resumption of Care Planning
Home Health Admission
Home Care Visit
Home Care Update
Kanta Service Event
Remote Monitoring Data Collection
Patient Web Update
Community Orders
Committee Review
Post Mortem Documentation
Billing Encounter
Lab Requisition
Office Visit
Consent Form
Procedure Pass
External Hospital Admission
Letter (Out)
Hospital
Refill
Immunization
History
Referral
Orders Only
Rx Refill Authorize
Meds Only (Web)
Meds Void (Web)
Resolute Professional Billing Hospital Prof Fee
Episode Changes
Ancillary Orders
Pharmacy Visit
OurPractice Advisory
Abstract
8 | TAG_EXTERNAL_ENC_TYPE | VARCHAR | No |
The free-text encounter type name of the encounter associated with the tagged external note.
9 | TAG_EXTERNAL_ENC_REF_IDENT | VARCHAR | No |
The reference ID of the encounter associated with the tagged external note.