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 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 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.