IMPLANT_OT_3
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 (.1 item) 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 PCMKR_PACE_MODE_CMT VARCHAR No
Free text comment on the pacing mode of an implanted pacemaker
4 PCMKR_PV_DELAY_MS INTEGER No
P-V delay in milliseconds
5 PCMKR_AV_DELAY_MS INTEGER No
A-V delay in milliseconds
6 PCMKR_LV_EARLY_YN VARCHAR No
Indicate if the left ventricle contraction was early
May contain organization-specific values: No
Category Entries:
No
Yes
7 PCMKR_RV_EARLY_YN VARCHAR No
Indicate if the right ventricle contraction was early
The category values for this column were already listed for column: PCMKR_LV_EARLY_YN
8 PCMKR_VV_DELAY INTEGER No
V-V delay in milliseconds
9 PCMKR_VV_DELAY_CMT VARCHAR No
Free text comment on the V-V delay
10 PCMKR_HYST_C_NAME VARCHAR No
Indicate if hysteresis is active
May contain organization-specific values: Yes
Category Entries:
On
Off
Not Applicable
11 PCMKR_HYST_CMT VARCHAR No
Free text comment on hysteresis
12 PCMKR_HYST_A_RATE INTEGER No
Indicate the atrial rate for hysteresis
13 PCMKR_HYST_RATE_C_NAME VARCHAR No
Indicate the rate-drop for hysteresis
The category values for this column were already listed for column: PCMKR_HYST_C_NAME
14 PCMKR_HYST_RATE_CMT VARCHAR No
Free text comment on rate-drop hysteresis
15 PCMKR_GEN_PACE_CMT VARCHAR No
Free text comment on pacing parameters
16 PCMKR_RV_SENSE_C_NAME VARCHAR No
Indicate the sensing polarity of the RV lead
May contain organization-specific values: Yes
Category Entries:
Bipolar
Unipolar
17 PCMKR_ATR_SENSE_C_NAME VARCHAR No
Indicate the sensing polarity of the atrial lead
The category values for this column were already listed for column: PCMKR_RV_SENSE_C_NAME
18 PCMKR_LV_SENSE_C_NAME VARCHAR No
Indicate the sensing polarity of the LV lead
The category values for this column were already listed for column: PCMKR_RV_SENSE_C_NAME
19 PCMKR_RV_PACE_C_NAME VARCHAR No
Indicate the pacing polarity of the RV lead
The category values for this column were already listed for column: PCMKR_RV_SENSE_C_NAME
20 PCMKR_ATR_PACE_C_NAME VARCHAR No
Indicate the pacing polarity of the atrial lead
The category values for this column were already listed for column: PCMKR_RV_SENSE_C_NAME
21 PCMKR_LV_PACE_C_NAME VARCHAR No
Indicate the pacing polarity of the LV lead
The category values for this column were already listed for column: PCMKR_RV_SENSE_C_NAME
22 PCMKR_POLARITY_CMT VARCHAR No
Free text comment on lead polarities
23 PCMKR_PR_AMPLITUDE INTEGER No
Indicate the amplitude of the P/R wave in millivolts
24 PCMKR_MODE_SWTCH_C_NAME VARCHAR No
Indicate if mode switching is active
The category values for this column were already listed for column: PCMKR_HYST_C_NAME
25 PCMKR_MD_SWTCH_CMT VARCHAR No
Free text comment on mode switching
26 PCMKR_A_RATE_SWTCH INTEGER No
Indicate the atrial rate for mode switching
27 DENT_PLATFRM_SIZE_C_NAME VARCHAR No
Dental implant platform size.
May contain organization-specific values: No
Category Entries:
Regular
Narrow
Wide
Other
28 DENT_DRILL_PROT_C_NAME VARCHAR No
Dental implant drill protocol.
May contain organization-specific values: No
Category Entries:
Conventional
Simplified
29 DENT_CONNECT_TYPE_C_NAME VARCHAR No
Dental implant connection type.
May contain organization-specific values: No
Category Entries:
Internal
External
30 DENT_COLLAR_SURF_C_NAME VARCHAR No
Dental implant collar surface.
May contain organization-specific values: No
Category Entries:
Rough
Polished
31 DENT_IMP_TAPER_C_NAME VARCHAR No
Dental implant taper.
May contain organization-specific values: No
Category Entries:
Tapered
Straight Wall
32 DENT_DIAMETER INTEGER No
Dental implant diameter.
33 DENT_IMP_INS_TORQUE INTEGER No
Dental implant insertion torque.
34 DENT_IMP_SITE_RECORD_ID NUMERIC No
Dental implant site.
35 DENT_IMP_SITE_RECORD_ID_RECORD_NAME VARCHAR No
Stores record name (.2)
36 DENT_IMP_CODE_PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.
37 DENT_IMP_BILL_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
38 DENT_IMP_AUTH_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
39 DENT_GUIDE_USED_YN VARCHAR No
Stores whether a guide was used to place a dental implant.
The category values for this column were already listed for column: PCMKR_LV_EARLY_YN