NOTE_ENC_INFO

Description:

This table contains information from overtime single-response items about General Use Notes (HNO) records. Contact creation logic for clinical notes is as follows: 1. If a note doesn't exist, a new note is created. This represents the first contact on that note. 2. If a revision is filed by the incoming transcription interface, a new contact is created on the note being revised regardless of note status.

Primary Key

Column Name	Ordinal Position
CONTACT_SERIAL_NUM	1

Column Information

	Name	Type	Discontinued?
1	NOTE_ID	VARCHAR	No
	The unique identifier for the note record.
2	CONTACT_SERIAL_NUM	NUMERIC	No
	The contact serial number (CSN) of the contact.
3	CONTACT_DATE_REAL	FLOAT	No
	A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
4	COSIGN_INSTANT_DTTM	DATETIME (UTC)	No
	The instant when the note was cosigned.
5	COSIGNUSER_ID	VARCHAR	No
	The user who cosigned the note.
6	COSIGNUSER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	COSIGN_NOTE_LINK	NUMERIC	No
	A note contact serial number (CSN) that points to the attending's note that cosigned this one.
8	COSIGN_REQUIRED_C_NAME	VARCHAR	No
	The cosign requirement for the current note contact. May contain organization-specific values: Yes Category Entries: Cosign Required Cosign Not Required Cosigned
9	AUTH_LNKED_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
10	AUTHOR_SERVICE_C_NAME	VARCHAR	No
	The author's clinical service. May contain organization-specific values: Yes
11	ENTRY_INSTANT_DTTM	DATETIME (UTC)	No
	UTC formatted instant of entry for a note.
12	UPD_AUTHOR_INS_DTTM	DATETIME (UTC)	No
	UTC instant of update by a specific user.
13	SPEC_NOTE_TIME_DTTM	DATETIME (UTC)	No
	The note's specified date paired with the specified time.
14	NOTE_FILE_TIME_DTTM	DATETIME (UTC)	No
	UTC formatted instant of when a note is filed.
15	AUTHOR_PRVD_TYPE_C_NAME	VARCHAR	No
	Author's provider type on a specific contact. May contain organization-specific values: Yes Category Entries: Resource Physician
16	NOTE_STATUS_C_NAME	VARCHAR	No
	The status of the note. May contain organization-specific values: Yes Category Entries: Incomplete Signed Addendum Deleted Revised Cosigned Finalized Unsigned Cosign Needed Incomplete Revision Cosign Needed Addendum Shared
17	UPDATE_USER_ID	VARCHAR	No
	The id of the user who updated this contact of the note.
18	UPDATE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
19	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
20	TRN_DOC_AVAIL_STA_C_NAME	VARCHAR	No
	The availability status of the transcription. May contain organization-specific values: Yes Category Entries: Available Unavailable Obsolete Deleted Obsolete/Available Obsolete/Unavailable Soft Deleted
21	TRN_DOC_TYPE_C_NAME	VARCHAR	No
	The document type of the transcription. May contain organization-specific values: Yes
22	SENSITIVE_STAT_C_NAME	VARCHAR	No
	Sensitive status of a note. May contain organization-specific values: Yes Category Entries: Sensitive Not Sensitive
23	AUTHOR_USER_ID	VARCHAR	No
	The unique ID associated with the user who is the author of the note.
24	AUTHOR_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
25	NOTE_FORMAT_C_NAME	VARCHAR	No
	The format of the note text like Plain Text, Rich Text, HTML etc. May contain organization-specific values: Yes Category Entries: Plain Text Rich Text HTML Epic HTML EpicML
26	UPD_BY_AUTH_DTTM	DATETIME (Local)	No
	The instant when the note is updated by the author.
27	ACTIVITY_DTTM	DATETIME (Local)	No
	The activity date and time of the partial dictation/transcription.
28	AUTH_STAT_C_NAME	VARCHAR	No
	The authentication status category number for this activity if this note is a transcription. This is also known as the completion status. May contain organization-specific values: Yes Category Entries: Dictated In Progress Incomplete Pre-authenticated Authenticated Legally Authenticated
29	CONTACT_NUM	VARCHAR	No
	Contact number for the record.
30	UPD_AUT_LOCAL_DTTM	DATETIME (Local)	No
	Update by author instant in local format.
31	ENT_INST_LOCAL_DTTM	DATETIME (Local)	No
	Note entry instant in local format.
32	SPEC_TIME_LOC_DTTM	DATETIME (Local)	No
	Note specified instant in local format.
33	NOT_FILETM_LOC_DTTM	DATETIME (Local)	No
	Note file time in local format.
34	EDIT_USER_ID	VARCHAR	No
	The unique ID associated with the user record who edited the note for this particular contact. This is populated for notes with note type 76-Simple Med Note, 77-Medication History, etc. This column is frequently used to link to the CLARITY_EMP table.
35	EDIT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
36	DOCUMENT_NAME	VARCHAR	No
	Contains the name of the multi-part document.
37	UMRG_SRC_MEDPROB_ID	NUMERIC	No
	The unique ID of the Med Problem List record.
38	ECG_COMMENTS	VARCHAR	No
	Comments about the Electrocardiogram (ECG/EKG).
39	ECG_EDITED_USER_ID	VARCHAR	No
	The person who edited the Electrocardiogram (ECG/EKG).
40	ECG_DIASTOLIC_BP	VARCHAR	No
	The diastolic blood pressure taken from the Electrocardiogram (ECG/EKG).
41	ECG_SYSTOLIC_BP	VARCHAR	No
	The systolic blood pressure taken from the Electrocardiogram (ECG/EKG).
42	ECG_HEARTRATE	VARCHAR	No
	The heartrate from the Electrocardiogram (ECG/EKG).
43	ECG_PR_INTERVAL	VARCHAR	No
	The interval from the beginning of the P wave to the beginning of the QRS wave on the Electrocardiogram (ECG/EKG).
44	ECG_PWAVEAXIS	VARCHAR	No
	The P wave axis on the Electrocardiogram (ECG/EKG).
45	ECG_QRS_DURATION	VARCHAR	No
	The duration of the QRS complex/wave on the Electrocardiogram (ECG/EKG).
46	ECG_QRS_WAVEAXIS	VARCHAR	No
	The QRS complex/wave axis on the Electrocardiogram (ECG/EKG).
47	ECG_QT_INTERVAL	VARCHAR	No
	The interval from the start of the QRS complex/wave to the end of the T wave on the Electrocardiogram (ECG/EKG).
48	ECG_QTC_INTERVAL	VARCHAR	No
	The corrected QT interval for the Electrocardiogram (ECG/EKG).
49	ECG_T_WAVEAXIS	VARCHAR	No
	The T wave axis for the Electrocardiogram (ECG/EKG).
50	SPIRO_BRON	VARCHAR	No
	Stores the type of bronchodilator given to the patient (ex: Albuterol).
51	CARE_PLAN_CSN_ID	NUMERIC	No
	Link to care plan contact. Used to recreate historic versions of care plan.
52	PROGRESS_NOTE_ID	VARCHAR	No
	Progress note ID for the careplan goal note.
53	PRE_UCN_NOTE_TYPE_C_NAME	VARCHAR	No
	This virtual item is populated with a category value from the note type (I HNO 50) according to the following logic: * if the note type (I HNO 50) is populated, use the value directly * if the note type (I HNO 50) is null and the note is not ambulatory, return null * if the note type (I HNO 50) 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 the note type (I HNO 50), 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 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 Clinical Note Summary Transplant Organ Reg History Event Interfaced Result Outside Organization Coverage Information
54	TRANSCRIPTION_DTTM	DATETIME (Local)	No
	The transcription date and time.
55	CSGN_RECPNT_USER_ID	VARCHAR	No
	The unique ID associated with the user who is supposed to cosign the note.
56	CSGN_RECPNT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
57	TREAT_SUMM_PAT_DTTM	DATETIME (UTC)	No
	This column stores the UTC instant that a treatment summary note is given to the patient.
58	TREAT_SUMM_PROV_DTTM	DATETIME (UTC)	No
	This column stores the UTC instant that a treatment summary note is given to the follow-up provider.
59	TREAT_SUMM_CPLT_DTTM	DATETIME (UTC)	No
	This column saves the UTC instant that a treatment summary note is marked as complete.
60	PAT_ENC_CSN_ID	NUMERIC	No
	This column stores the patient encounter contact serial number (CSN) in which the note was edited. Used for persistent notes to determine in which encounter the note was edited.
61	END_OF_TREAT_DATE	DATETIME	No
	This column saves the end of treatment date for a treatment summary.
62	UNMERGE_SRC_NOTE_ID	VARCHAR	No
	The source note ID before patient merge.
63	NOTE_SHARED_W_PAT_HX_YN	VARCHAR	No
	Was this note contact marked as eligible for sharing with the patient when it was last saved? Notes will only be displayed in MyChart if their most recent contact is marked for sharing. If you want to determine if a note is currently shared, use the NOTE_SHARED_W_PAT_YN column in the HNO_INFO table instead of this one. May contain organization-specific values: No Category Entries: No Yes
64	NOTE_TYPE_C_NAME	VARCHAR	No
	Identifies what type of note this record is. The category values for this column were already listed for column: PRE_UCN_NOTE_TYPE_C_NAME
65	POC_NOTE_DISC_C_NAME	VARCHAR	No
	This item stores the hospice Plan of Care note discipline. May contain organization-specific values: Yes
66	COSIGN_INST_LOCAL_DTTM	DATETIME (Local)	No
	The instant in local time when the note was cosigned.
67	IS_PRECHARTED_YN	VARCHAR	No
	This indicates whether or not the note is currently a pre-charted note (in appointment encounter). The category values for this column were already listed for column: NOTE_SHARED_W_PAT_HX_YN
68	LINK_DXR_CSN_ID	NUMERIC	No
	Link to the DXR contact that holds the NoteReader data for this note's contact.
69	CLINICAL_NOTE_SUMMARY	VARCHAR	No
	This item stores a plain text summary of the note contents.
70	BLOCK_REASON_C_NAME	VARCHAR	No
	Stores a discrete reason why a note was blocked from the patient. May contain organization-specific values: Yes
71	BLOCK_REASON_TXT	VARCHAR	No
	Stores a free text comment with additional information about why a note was blocked from the patient.