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.