INCOMPLETE_NOTE_EPT

Description: |
Table created for the visit narrative data stored in the patient masterfile. No longer used since we use UCN now since 2010, exporting these items as a formality.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4 | PAT_ENC_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. The integer portion of the number indicates the date of 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.
5 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
6 | INC_NOTE_USER_ID | VARCHAR | No |
The user ID for an incomplete note, not used since 2010 and only exported as a formality.
7 | INC_NOTE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
8 | INC_NOTE_NOTE_ID | VARCHAR | No |
The note ID for an incomplete note, not used since 2010 and only exported as a formality.
9 | INC_NOTE_TYPE_C_NAME | VARCHAR | No |
The note type for an incomplete note, not used since 2010 and only exported as a formality.
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
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
Prior Auth Decision Note
Clinical Note Summary
Transplant
Organ
Reg History Event
Interfaced Result
Outside Organization Coverage Information
10 | INC_NOTE_MSG_ID | VARCHAR | No |
The inbasket message ID for an incomplete note, not used since 2010 and only exported as a formality.
11 | INC_NOTE_START_DATE_UTC_DTTM | DATETIME (UTC) | No |
The start date for an incomplete note, not used since 2010 and only exported as a formality.
12 | INC_NOTE_LAST_EDIT_UTC_DTTM | DATETIME (UTC) | No |
The end date for an incomplete note, not used since 2010 and only exported as a formality.