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 column 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.
30 | IMPLANT_WIDTH | NUMERIC | No |
This column stores the width of the implant.
31 | WOUND_LENGTH | NUMERIC | No |
This column stores the length of the wound.
32 | WOUND_WIDTH | NUMERIC | No |
This column stores the width of the wound.