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 | TRANSCRIPTION_DTTM | DATETIME (Local) | No |
The transcription date and time.
54 | CSGN_RECPNT_USER_ID | VARCHAR | No |
The unique ID associated with the user who is supposed to cosign the note.
55 | CSGN_RECPNT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
56 | TREAT_SUMM_PAT_DTTM | DATETIME (UTC) | No |
This column stores the UTC instant that a treatment summary note is given to the patient.
57 | 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.
58 | TREAT_SUMM_CPLT_DTTM | DATETIME (UTC) | No |
This column saves the UTC instant that a treatment summary note is marked as complete.
59 | 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.
60 | END_OF_TREAT_DATE | DATETIME | No |
This column saves the end of treatment date for a treatment summary.
61 | UNMERGE_SRC_NOTE_ID | VARCHAR | No |
The source note ID before patient merge.
62 | 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
63 | NOTE_TYPE_C_NAME | VARCHAR | No |
Identifies what type of note this record is.
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
Treatment Note
Patient Instructions
Discharge Attachment
Previous Reports
Date-Specific Sticky Note
PA Denial Reason
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
Electronic Authorization 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
64 | POC_NOTE_DISC_C_NAME | VARCHAR | No |
This item stores the hospice Plan of Care note discipline.
May contain organization-specific values: Yes
65 | COSIGN_INST_LOCAL_DTTM | DATETIME (Local) | No |
The instant in local time when the note was cosigned.
66 | 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
67 | LINK_DXR_CSN_ID | NUMERIC | No |
Link to the DXR contact that holds the NoteReader data for this note's contact.
68 | CLINICAL_NOTE_SUMMARY | VARCHAR | No |
This item stores a plain text summary of the note contents.
69 | BLOCK_REASON_C_NAME | VARCHAR | No |
Stores a discrete reason why a note was blocked from the patient.
May contain organization-specific values: Yes
70 | BLOCK_REASON_TXT | VARCHAR | No |
Stores a free text comment with additional information about why a note was blocked from the patient.