DOCS_RCVD_ENDO_PROC_INFO

Description:

Contains information about endoscopy procedures extracted from customer systems for use in Cosmos.

Primary Key

Column Name	Ordinal Position
DOCUMENT_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	DOCUMENT_ID	NUMERIC	No
	The unique identifier (.1 item) for the document record.
2	CONTACT_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.
3	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	ENDO_PROC_REF_IDENT	VARCHAR	No
	This item stores the unique reference id associated with the endoscopy procedure.
6	ENDO_PROC_ENC	NUMERIC	No
	This item stores the procedures encounter as a link to an EPT CSN.
7	ENDO_PROC_SOURCE_ORG_ID	NUMERIC	No
	This item contains the ID of the source organization of the record.
8	ENDO_PROC_SOURCE_ORG_ID_EXTERNAL_NAME	VARCHAR	No
	Organization's external name used as the display name on forms and user interfaces.
9	ENDO_PROC_INST_DTTM	DATETIME (Attached)	No
	Stores the finalizing instant of the procedure in the local timezone.
10	ENDO_PROC_BPA_YN	VARCHAR	No
	Stores the bowel prep adequacy metric for colonoscopy procedures. May contain organization-specific values: No Category Entries: No Yes
11	ENDO_PROC_CR_YN	VARCHAR	No
	Stores the cecum reached metric for colonoscopy procedures. The category values for this column were already listed for column: ENDO_PROC_BPA_YN
12	ENDO_PROC_POLYP_YN	VARCHAR	No
	Stores the poylp detected metric for colonoscopy procedures. The category values for this column were already listed for column: ENDO_PROC_BPA_YN
13	ENDO_PROC_CWT	NUMERIC	No
	Stores the cecal withdrawal time for colonoscopy procedures.
14	ENDO_PROC_ADR_YN	VARCHAR	No
	Stores the adenoma detection metric for colonoscopy procedures. The category values for this column were already listed for column: ENDO_PROC_BPA_YN
15	ENDO_PROC_SCR_COL_YN	VARCHAR	No
	Stores whether or not the colonoscopy procedure was a screening. The category values for this column were already listed for column: ENDO_PROC_BPA_YN
16	ENDO_PROC_TYPE_C_NAME	VARCHAR	No
	Stores the procedure type category value. May contain organization-specific values: No Category Entries: Trendable Exception Culture Blood Bank Unit Non-Trendable Colonoscopy EGD EUS (Upper) ERCP Antegrade Enteroscopy Sigmoidoscopy Lower EUS Retrograde Enteroscopy Pouchoscopy Ileoscopy Bronchoscopy Generic Lumens Procedure Molecular Generic Radiology Procedure Generic Interventional Radiology Procedure Point of Care Ultrasound Cardiac Catheterization Cardiac Ventriculography Aortography Catheterization Coronary Angiography Coronary Catheterization Left Heart Catheterization Right Heart Catheterization Transcatheter Mitral Valve Repair Transcatheter Aortic Valve Replacement Percutaneous Coronary Intervention Pericardiocentesis Cardiac Catheterization Intervention Cardiac Catheterization Intervention with Implant Structural Heart Procedure Pediatric Cardiology Conference Congenital Catheterization Invasive Vascular Invasive Vascular - Lower Extremity Arteries Computed Tomography Angiography - Lower Extremity Arteries Invasive Vascular - Abdominal Arteries Computed Tomography Angiography - Abdominal Arteries Invasive Vascular - Carotid Arteries Computed Tomography Angiography - Carotid Arteries Invasive Vascular - Whole Body Arteries Computed Tomography Angiography - Whole Body Arteries Extremity Invasive Vascular Diagnostic Extremity Invasive Vascular Intervention Extremity Invasive Vascular Intervention with Implant Abdominal Invasive Vascular Diagnostic Abdominal Invasive Vascular Intervention Abdominal Invasive Vascular Intervention with Implant Carotid Invasive Vascular Diagnostic Carotid Invasive Vascular Intervention Carotid Invasive Vascular Intervention with Implant Whole Body Invasive Vascular Diagnostic Whole Body Invasive Vascular Intervention Whole Body Invasive Vascular Intervention with Implant Electrophysiology Electrophysiology Study Implantable Cardiac Device Ablation Implantable Loop Recorder ICD Implant/Upgrade ICD Generator Change/Removal Lead Implant/Replacement Lead Revision/Removal PPM Implant/Upgrade PPM Generator Change/Removal Occlusion Device Implant/Upgrade Other Cardiac Device Implant/Replacement Other Cardiac Device Revision/Removal Arm Invasive Vascular Diagnostic Arm Invasive Vascular Intervention Arm Invasive Vascular Intervention with Implant Echocardiography Stress Echocardiography Doppler Echocardiography 2D Echocardiography Transthoracic Echocardiography Transesophageal Echocardiography Congenital Echocardiography Congenital Transthoracic Echocardiography Congenital Transesophageal Echocardiography Fetal Echocardiography Fetal Doppler Echocardiography Fetal 2D Echocardiography Vascular Ultrasound Non-Invasive Peripheral Vascular Cardiac Nuclear Medicine Stress Nuclear Medicine Cardiac Computed Tomography Computed Tomography Angiography Cardiac Magnetic Resonance Imaging Magnetic Resonance Angiography Multigated Acquisition Scan Cardiac Positron Emission Tomography Cardiac Single-Photon Emission Computed Tomography Electrocardiogram Cardiac X-Ray Cardiac Event Monitoring Holter Tilt Table Cardioversion Cardiac Device Check Cardiac Stress Test Phonocardiogram Generic Cardiovascular Procedure Genomic Tumor Profiling with Companion Biomarkers Cardiology Non-Invasive Grouper Cardiology Invasive Grouper Generic Imaging Grouper
17	ENDO_PROC_FND_YN	VARCHAR	No
	Stores whether or not the procedure includes discrete findings data. The category values for this column were already listed for column: ENDO_PROC_BPA_YN
18	ENDO_PROC_ENC_DEDUP	VARCHAR	No
	This item stores the procedures encounter deduplicated reference ID.