DOCS_RCVD_ENDO_FND

Description:

This table stores suggested endoscopy findings received from outside sources.

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	SUGG_FND_RESULT_RPT_TYPE_C_NAME	VARCHAR	No
	The result report type associated with the finding data in this line. 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
6	SUGG_ENDOSCOPY_TYPE_C_NAME	VARCHAR	No
	The endoscopy finding type associated with this suggestion line May contain organization-specific values: Yes Category Entries: Fistula Anal fissure Lithotripsy Angioectasia Z-line Barrett's esophagus Bile duct changes Control of bleeding Blood Brushing Calcification Sludge Celiac axis Cholangioscopy Collaterals Condyloma Gastric antral vascular ectasia ERCP Biopsy Cyst Deformity Dieulafoy's lesion Pancreatic duct changes Stone Diverticula Ectopic gastric mucosa Edema Enlarged folds Extravasation Extrinsic compression Sweeping Ablation Foreign body Common channel Hemorrhoids Hepatic duct anomaly Hiatal hernia Irregularity Lesion Lipoma Ampullary resection Lymph nodes Mallory-Weiss tear Mass Melanosis Mucosal abnormality Nodule Normal Pancreas divisum Dilated lumen Parenchymal changes Perforation Polyp Previous surgery Wall thickening Biopsy Ring Cannulation Sphincterotomy Stent placement Existing stent Dilation intervention Stricture Filling defects Ulcer Varices Ventral anlage Pseudomembranes Washing Ascites Sphincter of Oddi pressure measurement Sphincteroplasty Bronchoalveolar lavage Fluoroscopy Valve placement Airway exam Secretions Endobronchial biopsy Random brushing Transbronchial needle aspiration Dynamic airway collapse Mucus plug Botox injection Tube placement Other Transbronchial biopsy Banding Cold snare Hot snare Balloon tamponade Clips Coagulation Endoscopic sclerotherapy Endoscopic suturing Fibrin sealant Stent Esophagitis IBD Follow-Up Bile duct Pancreas Liver Scout film POEM Abdominal collection Pseudocyst Abscess Skin tag Walled-off necrosis Vasculature Poorly organized pancreatic fluid collection Major papilla Volvulus Tube removal/replacement Endoscopic mucosal resection Endoscopic full thickness resection Gallbladder Lift Tattoo Hemostatic Injection Portal hypertensive gastropathy Capsule placement Hypertrophied anal papillae Bronchial thermoplasty Contrast injection Valve removal Adrenal gland Pertinent negative Endoscopic submucosal dissection Pancreatic enzyme collection Therapeutic injection Anal sphincter Previous Polypectomy FLIP imaging Transoral outlet reduction Anastomosis creation
7	SUGG_FND_IDENT	VARCHAR	No
	Stores unique identifier for the suggested finding we received