IMPLANT_OT
Description:
This table contains implant information that changes over time.

Primary Key
Column Name Ordinal Position
IMPLANT_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 IMPLANT_ID VARCHAR No
The unique identifier for the implant 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 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
4 CONTACT_NUMBER INTEGER No
The contact number of the implant record.
5 CM_CT_OWNER_ID VARCHAR No
The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
6 LINKED_ORDER_ID NUMERIC No
A link to the order record with relevant information for the implant on a contact (e.g. the interrogation report for a pacemaker).
7 PACE_MODE_C_NAME VARCHAR No
The category ID for the pacing mode of an implanted pacemaker.
May contain organization-specific values: Yes
Category Entries:
AAI
AAIR
AAT
AATR
AOO
AOOR
DAD
DDD
DDDR
DDI
DDIR
DOO
DOOR
DVI
DVIR
VAT
VDD
VDDR
VOO
VOOR
VVI
VVIR
VVT
OOO
OOOR
VDI
VDIR
ODO
VVTR
DDTR
OVO
DVTR
DDT
VDTR
VDT
ADIR
ADI
8 PACE_LOW_RATE INTEGER No
A pacemaker's lower pacing rate.
9 PACE_UPPER_RATE INTEGER No
A pacemaker's upper pacing rate.
10 PACE_VT_RATE INTEGER No
The VT detection rate of an implanted pacemaker.
11 PACE_VF_RATE INTEGER No
The VF detection rate of an implanted pacemaker.
12 PACE_LEAD_SECURE_C_NAME VARCHAR No
The category ID for the method used to secure the leads to the pacemaker.
May contain organization-specific values: Yes
Category Entries:
1 set screw torqued
2 set screws torqued
3 set screws torqued
4 set screws torqued
5 set screws torqued
6 set screws torqued
7 set screws torqued
8 set screws torqued
Toolless connector closed
13 LEAD_SENSE_MV NUMERIC No
The sensing threshold of the lead in mV.
14 LEAD_LOC_C_NAME VARCHAR No
The category ID for the anatomical location of the lead.
May contain organization-specific values: Yes
Category Entries:
Anterolateral cardiac vein
Atrial septum
Cardiac vein
Coronary sinus
High RA
Innominate vein
Lateral cardiac vein
LA
Low RA
LV
LV apex
Mid RA
Pericardial phrenic vein
Posterior (middle) cardiac vein
Posterolateral cardiac vein
Pulmonary outflow tract
RA
RA appendage
RV
RV apex
RV outflow tract
RV septum
Subcutaneous/anterior chest
Subcutaneous/left lateral
Other
15 LEAD_CAPTURE_V NUMERIC No
The capture threshold of the lead in V.
16 LEAD_CAPTURE_MA NUMERIC No
The capture threshold of the lead in mA.
17 LEAD_PACING_OHM INTEGER No
The pacing impedance of the lead in Ohms.
18 LEAD_SLEW_RATE INTEGER No
The slew rate of the lead.
19 LEAD_EXTRACT_RES_C_NAME VARCHAR No
The category ID for the result of extracting the lead.
May contain organization-specific values: Yes
Category Entries:
Inablilty to extract the lead, with retention of the lead
Complete removal of the lead
Removal of the lead with electrode retained in the RV
Removal of the lead with electrode retained in the SVC
Removal of the lead with electrode retained in the subclavian vein
Breakage of the lead and retention of a lead fragment
Removal of the lead with electrode tip left in the atrium
Removal of the electrode and part of the wire
20 ICD_HIGH_VOLT_OHMS INTEGER No
The high voltage impedance of the ICD in Ohms.
21 CNCT_LOG_ID VARCHAR No
The log where this specific contact on the implant was used. For example, if an implant was implanted in log 100, this will contain the value 100 for that contact. If it is then adjusted in another log, that contact will point to that log.
22 ICD_BATT_VOLT_V NUMERIC No
Records the battery voltage of a generator in volts.
23 PACE_FAST_VT_RATE INTEGER No
The Fast VT detection rate of an implanted pacemaker.
24 LEAD_SHOCK_OHM INTEGER No
The shock impedance of the lead in Ohms.
25 CNCT_SURGERY_CSN_ID NUMERIC No
The Contact Serial Number (CSN) of the log where this specific contact on the implant was used. For example, if an implant was implanted in log 100 having CSN 120, this will contain the value 120 for that contact. If it is then adjusted in another log, that contact will point to the CSN of that log.
26 STATUS_C_NAME VARCHAR No
The category ID for the implant status as of a given contact.
May contain organization-specific values: Yes
Category Entries:
Received
Implanted
Explanted
Loaned
Returned
Destroyed
Recalled
Wasted
Implanted - Out of Service
27 REASON_EVAL VARCHAR No
Reason why device is being evaluated. Potential reasons would include: pre-op eval, post-op eval
28 ICD_PRESENT_RHYTH_C_NAME VARCHAR No
The category ID for the ICD behavior prior to making adjustments.
May contain organization-specific values: Yes
No Entries Defined
29 ICD_UNDERLY_RHYTHM VARCHAR No
Stores free text documenting underlying rhythm.
30 ICD_MNTR_OFF_PROC_C_NAME VARCHAR No
The category ID for the ICD monitoring status for procedure.
May contain organization-specific values: Yes
No Entries Defined
31 ICD_VOLT_CMT VARCHAR No
Free text comment to document comments regarding the voltage setting for the ICD.
32 ICD_CHARGE_TIME NUMERIC No
Numeric value of time in seconds it takes for device to charge to full power.
33 LEAD_PSA_WAVE NUMERIC No
Numeric measurement through lead when not attached to the device.
34 LEAD_PSA_THRESH NUMERIC No
Numeric measurement of the threshold through lead when not attached to the device.
35 LEAD_PSA_DEVICE_WAV NUMERIC No
Numeric measurement of the Lead through the device connection
36 LEAD_P_WAVE NUMERIC No
Numeric value associated with lead for the P wave when connected to the device.
37 LEAD_P_WAVE_CMT VARCHAR No
Free-text comment associated with Lead P Wave.
38 LEAD_R_WAVE NUMERIC No
Numeric value associated with lead for the R wave when connected to the device.
39 LEAD_R_WAVE_CMT VARCHAR No
Free-text comment associated with Lead R Wave.
40 ICD_MODE_SWITCH NUMERIC No
Stores the mode switch parameter of ICD
41 ICD_MODE_SWTCH_CMT VARCHAR No
Free-text comment associated with ICD Mode Switch value.
42 ICD_V_TACH_THERAPY VARCHAR No
Stores programmed therapies to treat potentially fatal rhythms
43 ICD_FST_V_TCH_THERA VARCHAR No
Summary of programmed therapies to treat potentially fatal rhythms in a rate zone.
44 ICD_V_TACH_MONT_ZON NUMERIC No
Detection rate for device to record arrhythmia
45 ICD_V_FIB_THERAPIES VARCHAR No
Summary of programmed therapies to treat potentially fatal rhythms in this rate zone
46 ICD_PARAMETER_CMT VARCHAR No
Stores the comment for ICD parameters
47 LEAD_PSA_CAP_THRESH NUMERIC No
Stores the test for lead functionality separate from the device
48 PSA_CURRENT NUMERIC No
Stores the test for lead current separate from device
49 P_WAVE_CMT VARCHAR No
Comments for non-numeric P wave documentation
50 R_WAVE_CMT VARCHAR No
Comments for non-numeric R wave documentation
51 THRESHOLD_CMT VARCHAR No
Stores the comments for non-numeric documentation for threshold testing
52 LEAD_CAPTURE_MS NUMERIC No
The capture threshold of the lead in ms.
53 LEAD_ACCESS_LOC_C_NAME VARCHAR No
The category ID for the vein accessed for lead implant.
May contain organization-specific values: Yes
Category Entries:
Femoral vein
Subclavian vein
Axillary vein
medial axillary vein
Cephalic vein
Internal jugular vein
Other
54 ICD_MONITOROFF_C_NAME VARCHAR No
The category ID that indicates if the device was turned off for comfort of care.
May contain organization-specific values: Yes
No Entries Defined
55 ICD_EVENT_DT DATETIME No
The date of an event or therapy delivered by the device.
56 ICD_EVENTDELIV_C_NAME VARCHAR No
The category ID for the events/therapy that the ICD device delivered.
May contain organization-specific values: Yes
No Entries Defined
57 NUM_ATP INTEGER No
Number of ATPs.
58 NUM_SHOCK INTEGER No
Number of shocks.
59 RHYTHM_C_NAME VARCHAR No
The category ID for the rhythm that the device attempted to correct.
May contain organization-specific values: Yes
No Entries Defined
60 APPROP_THERAPY_YN VARCHAR No
Indicates if the therapy was appropriate.
May contain organization-specific values: No
Category Entries:
No
Yes
61 ATRIAL_IMPD INTEGER No
Atrial impedance in ohms.
62 RV_IMPD INTEGER No
Right ventricle impedance in ohms.
63 LV_IMPD INTEGER No
LV impedance in ohms.
64 RV_COIL_IMPD INTEGER No
Right ventricle coil impedance in ohms.
65 SVC_COIL_IMPD INTEGER No
SVC coil impedance in ohms.
66 ICD_SWITCH_PERC NUMERIC No
Mode switch percentage.
67 DFT_ENERGY INTEGER No
Minimum Defibrillation Threshold (DFT) energy in Joules.
68 AS_VS NUMERIC No
AS-VS percentage paced.
69 AS_VP NUMERIC No
AS-VP percentage paced.
70 AP_VP NUMERIC No
AP-VP percentage paced.
71 AP_VS NUMERIC No
AP-VS percentage paced.
72 VSR NUMERIC No
VSR percentage paced.
73 BIV_PACED NUMERIC No
Bi-ventricular paced percentage.
74 VENT_PACED NUMERIC No
Ventricular paced percentage.
75 VENT_SENSE NUMERIC No
Ventricular sense.
76 LV_PACED NUMERIC No
LV paced percentage.
77 LEAD_DIAM INTEGER No
Diameter of lead.
78 LEAD_LENGTH INTEGER No
Length of lead.
79 MAGNET_RATE NUMERIC No
Stores the pacemaker magnet rate
80 REASON_PLACEMENT_C_NAME VARCHAR No
The category ID for the reason for the placement of an implant.
May contain organization-specific values: Yes
No Entries Defined
81 PROGRAMMABLE_YN VARCHAR No
Indicates whether the implant is programmable.
May contain organization-specific values: No
Category Entries:
Yes
No
82 NONPROG_SETTINGS_C_NAME VARCHAR No
The category ID for the settings of a non-programmable implant.
May contain organization-specific values: Yes
No Entries Defined
83 SHUNT_SETTINGS_C_NAME VARCHAR No
The category ID for the settings related to a shunt.
May contain organization-specific values: Yes
No Entries Defined
84 DIAPHRAGMATIC_CAP_V NUMERIC No
The diaphragmatic capture threshold of the lead in V.
85 MATERIAL_C_NAME VARCHAR No
The category ID for the type of breast implant material or lumen type, populated via SmartForm, when describing an implant.
May contain organization-specific values: Yes
Category Entries:
Saline
Silicone: Intact
Silicone: Ruptured
Other
Lumen type
Not Applicable
86 LOCATION_C_NAME VARCHAR No
The category ID for the breast implant location, populated via SmartForm, when describing an implant.
May contain organization-specific values: Yes
Category Entries:
Retroglandular
Retropectoral
Not Applicable
87 CONTOUR_C_NAME VARCHAR No
The category ID for the breast implant contour, populated via SmartForm, when describing an implant.
May contain organization-specific values: Yes
Category Entries:
Focal bulge
Not Applicable
88 RADIAL_FOLDS_YN VARCHAR No
Indicates whether there is an intracapsular radial folds silicone finding for a breast implant. This is populated via SmartForm (R LQF 52002) and is a non-defaulted, unrequired field.
The category values for this column were already listed for column: APPROP_THERAPY_YN
89 SUBCAPSULAR_LINE_YN VARCHAR No
Indicates whether there is an intracapsular subcapsular line silicone finding for a breast implant. This is populated via SmartForm (R LQF 52002) and is a non-defaulted, unrequired field.
The category values for this column were already listed for column: APPROP_THERAPY_YN
90 LINGUINE_SIGN_YN VARCHAR No
Indicates whether there is an intracapsular linguine sign silicone finding for a breast implant. This is populated via SmartForm (R LQF 52002) and is a non-defaulted, unrequired field.
The category values for this column were already listed for column: APPROP_THERAPY_YN
91 EXTRACAPSULAR_SILICONE_C_NAME VARCHAR No
The category ID for the breast implant extracapsular silicone findings, populated via SmartForm, when describing an implant.
May contain organization-specific values: Yes
Category Entries:
Breast
Lymph Node
Not Applicable
92 WATER_DROPLETS_C_NAME VARCHAR No
The category ID for the flag describing the presence of water droplets associated with breast implants. This is populated via SmartForm when describing an implant.
May contain organization-specific values: Yes
Category Entries:
No
Yes
Unknown
93 PERI_IMP_FLUID_C_NAME VARCHAR No
The category ID for the flag describing the presence of peri-implant fluid associated with breast implants. This is populated via SmartForm when describing an implant.
The category values for this column were already listed for column: WATER_DROPLETS_C_NAME
94 KEYHOLE_SIGN_YN VARCHAR No
Indicates whether there is an intracapsular keyhole sign silicone finding for a breast implant. This is populated via SmartForm (R LQF 52002) and is a non-defaulted, unrequired field.
The category values for this column were already listed for column: APPROP_THERAPY_YN
95 GUDID_MRI_SAFETY_INFO VARCHAR No
This column stores the MRI safety information obtained from the Global Unique Device Identification Database (GUDID) for an implant.
96 PAT_ENC_CSN_ID NUMERIC No
This item stores the Contact Serial Number (CSN) of the patient encounter where this specific contact on the implant was created. For example, for an implant was edited in an office visit encounter with CSN 120, this item will contain a value of 120 for that contact.