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
Stent
Graft
Aneurysm
Incidental Finding
Other Finding
Vascular Ablation
Varicose Veins
Pseudoaneurysm
Post-Exercise
Post-Cold Immersion
Popliteal Entrapment
Additional Stenosis
Kidney Cyst
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
Existing tattoo
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
Transoral incisionless fundoplication
Rendezvous
Scope change
Stool
Fluid aspiration
Minor papilla
Endoscopic ultrasound-directed transgastric ERCP
Existing tube
Achalasia
Inflammatory bowel disease
Crohn's disease
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
Inverted T
Inverted TAP
Inverted Crush
Inverted DK Crush
Inverted Mini-Crush
Inverted Culotte
Other
14 | HEMO_DATASET_FORM_COMP_ID_NESTCOMP_NAME | VARCHAR | No |
The record name for the component.