OR_IMP_3
Description:
The OR_IMP_3 table contains implant information.

Primary Key
Column Name Ordinal Position
IMPLANT_ID 1

Column Information
Name Type Discontinued?
1 IMPLANT_ID VARCHAR No
The unique identifier for the implant record.
2 EXTRACARD_VLT NUMERIC No
This item stores the voltage measured for the extracardiac stimulation
3 EXTRACARD_PULSE NUMERIC No
This item stores pulse width for the extracardiac stimulation
4 PREVIOUS_OPERATION_LOCATION_ID_LOC_NAME VARCHAR No
The name of the revenue location.
5 SUPPORT_NET_YN VARCHAR No
Indicates whether a support net was used for this implant. Y indicates that a support net was used. An N or null value indicates a support net was not used.
May contain organization-specific values: No
Category Entries:
No
Yes
6 SCREW_COUNT INTEGER No
The count of screws used by this implant.
7 SCREW_HOLE_C_NAME VARCHAR No
The screw hole category ID for the implant.
May contain organization-specific values: Yes
No Entries Defined
8 CORE_PLUG_YN VARCHAR No
Indicates whether a core plug was used for this implant. Y indicates a core plug was used. An N or a null value indicates a core plug was not used.
The category values for this column were already listed for column: SUPPORT_NET_YN
9 EAN_NUMBER VARCHAR No
Stores the European Article Number (EAN) for an implant.
10 IMPLANT_SOURCE_C_NAME VARCHAR No
This item stores the source of the implant for the patient.
May contain organization-specific values: Yes
Category Entries:
Allogenic
Autologous
Synthetic
11 PACEMAKER_AFFECT VARCHAR No
This free text item will allow the provider to document what will happen to the mode and rate when a magnet is placed.
12 AICD_MAGNET_AFFECT VARCHAR No
This item is used to document what will happen when a magnet is placed properly.
13 SEC_COUNTRY_IDENTIFIER VARCHAR No
The country identifier present in the Donation Identification Sequence of the Single European Code (SEC) for an implant.
14 SEC_TISSUE_ESTABLISHMENT_CODE VARCHAR No
The tissue establishment code present in the Donation Identification Sequence of the Single European Code (SEC) for an implant.
15 SEC_UNIQUE_DONATION_NUMBER VARCHAR No
The unique donation number present in the Donation Identification Sequence of the Single European Code (SEC) for an implant.
16 SEC_CODING_SYSTEM_IDENTIFIER_C_NAME VARCHAR No
The coding system identifier present in the Production Identification Sequence of the Single European Code (SEC) for an implant.
May contain organization-specific values: Yes
Category Entries:
A - ISBT
B - Eurocode
E - EUTC
17 SEC_PRODUCT_CODE VARCHAR No
The product code present in the Production Identification Sequence of the Single European Code (SEC) for an implant.
18 SEC_SPLIT_NUMBER VARCHAR No
The split number present in the Production Identification Sequence of the Single European Code (SEC) for an implant.
19 FLOW_RATE NUMERIC No
Stores implant flow rate setting.
20 PRESSURE NUMERIC No
Stores implant pressure setting.
21 NUMBER_ACCESSORIES_USED INTEGER No
This item stores the number of accessories used.
22 IMPLANT_LENGTH NUMERIC No
This item stores the length of the implant.
23 TISS_IMPL_UTC_DTTM DATETIME (UTC) No
Instant that the tissue was implanted into the patient. Intended to be used with a third-party tissue tracking system.
24 IMPLANT_BRAND_C_NAME VARCHAR No
The brand of the implantable device.
May contain organization-specific values: Yes
Category Entries:
N/A
25 CALIBRATION_DATE DATETIME No
Date the implant or seed was calibrated or made radioactive.
26 RADIOACTIVE_ACTIVITY NUMERIC No
The measured amount of radioactivity in the implant.
27 NHR_LEAD_TYPE_C_NAME VARCHAR No
The type of lead, how this lead is used. Source: NHR
May contain organization-specific values: No
Category Entries:
RA lead
RV lead
LV lead
S-ICD
LBB lead
His lead
Overig
Onbekend
28 EXPLANT_REPL_STATUS_C_NAME VARCHAR No
The explant replacement status.
May contain organization-specific values: Yes
No Entries Defined
29 EXPLANT_REPL_IMPLANT_ID VARCHAR No
The explant replacement ID.