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