ORD_CV_FINDING

Description:

This table contains information about a single finding.

Primary Key

Column Name	Ordinal Position
CV_FINDING_ID	1

Column Information

	Name	Type	Discontinued?
1	CV_FINDING_ID	NUMERIC	No
	The unique identifier for the finding record.
2	FORM_DATE_REAL	FLOAT	No
	The contact date real (DTE) of the associated contact in the Forms (LQF) master file. This is 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	WALL_STAGE	INTEGER	No
	The stage number for wall motion scoring.
4	WALL_SCORE	NUMERIC	No
	The average of the wall motion scoring.
5	WALL_NORMAL	NUMERIC	No
	The normal index of the wall motion scoring.
6	WALL_MOTION_VIEW_C_NAME	VARCHAR	No
	The wall motion views select category ID for the finding record. May contain organization-specific values: Yes Category Entries: LAO RAO Both
7	FINDING_SEQUENCE	NUMERIC	No
	Defines a relative order among result records (RES) in a report segment. For instance, a record with a value of 5 in this item will appear earlier in the report segment than a record with a value of 7 in this item.
8	EP_TYPE_C_NAME	VARCHAR	No
	The category number for the electrophysiology finding type. This is usually the same as the internal ID. If you use IntraConnect, this is the Community ID (CID). May contain organization-specific values: Yes Category Entries: Intervals Ablation Ablation Summary Ventricular Arrhythmia Supraventricular Arrhythmia Atrial Function Cardioversion ECG Rhythm Sinus Node Function His-Purkinje Function Ventricular Function AV Node Function Atrial Pacing Ventricular Pacing Accessory Pathway Ablation for Atrial Fibrillation Refractory Period Conduction Block Transcatheter Aortic Valve Replacement Access Transcatheter Aortic Valve Replacement Pre-Intervention Assessment Transcatheter Aortic Valve Replacement Intervention Transcatheter Aortic Valve Replacement Post-Intervention Assessment Mitral Valve Transcatheter Edge to Edge Repair Access Mitral Valve Transcatheter Edge to Edge Repair Pre-Intervention Assessment Mitral Valve Transcatheter Edge to Edge Repair Transseptal Puncture Mitral Valve Transcatheter Edge to Edge Repair Intervention Mitral Valve Transcatheter Edge to Edge Repair Post-Intervention Assessment Left Atrial Appendage Occlusion Access Left Atrial Appendage Occlusion Pre-Intervention Assessment Left Atrial Appendage Occlusion Transseptal Puncture Left Atrial Appendage Occlusion Intervention Left Atrial Appendage Occlusion Post-Intervention Assessment
9	ENDOSCOPY_TYPE_C_NAME	VARCHAR	No
	The category number for the endoscopy finding type. This is usually the same as the internal ID. If you use IntraConnect, this is the Community ID (CID). 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 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 Random 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
10	SEC_FORM_ID	VARCHAR	No
	The unique identifier for the secondary SmartForm associated with the finding record.
11	SEC_FORM_ID_FORM_NAME	VARCHAR	No
	The name of the form associated with the questionnaire.
12	SEC_FORM_DATE_REAL	FLOAT	No
	The contact date real (DTE) of the associated contact of the secondary SmartForm. This is 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.
13	INTVN_BIFURC_TECHNIQUE_C_NAME	VARCHAR	No
	This item is used to store the technique used in the bifurcation of an intervention. May contain organization-specific values: Yes Category Entries: No Technique Selected Provisional T TAP Crush DK Crush Mini-crush Culotte V-Stenting Kissing Other
14	HEMO_DATASET_FORM_COMP_ID	NUMERIC	No
	The unique ID associated with the hemodynamic dataset definition for this row. This column is used to link to the NESTED_FORM_COMPONENT table.