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