OR_IMP
Description:
The OR_IMP 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 ID of the implant record.
2 IMPLANT_NAME VARCHAR No
The name of the implant record.
3 IMPLANT_TYPE_C_NAME VARCHAR No
The implant type category number for the implant record.
May contain organization-specific values: Yes
4 MANUFACTURER_C_NAME VARCHAR No
The manufacturer category number for the implant record.
May contain organization-specific values: Yes
5 STATUS_C_NAME VARCHAR No
The implant status category number for the implant record.
May contain organization-specific values: Yes
Category Entries:
Received
Implanted
Explanted
Loaned
Returned
Destroyed
Recalled
Wasted
Implanted - Out of Service
6 SMDA_YN VARCHAR No
Indicates whether the implant conforms to the Safe Medical Device Act (SMDA). Y indicates that the implant conforms to the SMDA. A null indicates that no value is documented. N indicates that the implant does not conform to the SMDA.
May contain organization-specific values: No
Category Entries:
Yes
No
7 ACTIVE_YN VARCHAR No
Indicates whether the implant record is active. Y indicates that the implant is active. A null indicates that no value is documented. N indicates that the implant is not active.
The category values for this column were already listed for column: SMDA_YN
8 MODEL_NUMBER VARCHAR No
The model number of the implant.
9 SERIAL_NUMBER VARCHAR No
The serial number of the implant.
10 LOT_NUMBER VARCHAR No
The lot number of the implant.
11 EXPIRATION_DATE DATETIME No
The expiration date of the implant.
12 RECEIVED_DATE DATETIME No
The date the implant was received.
13 RECPT_NOTIFY_DATE DATETIME No
The date the manufacturer was notified of implant receipt.
14 RECALLED_DATE DATETIME No
The date the implant was recalled.
15 RECALLED_NOT_DATE DATETIME No
The date the manufacturer was notified of implant recall.
16 PAT_EXPIRY_DATE DATETIME No
The date the patient with the implant expired.
17 PAT_EXP_NOTIF_DATE DATETIME No
The date the manufacturer was notified of the patient's expiration.
18 INVENTORY_ITEM_ID VARCHAR No
The unique ID of the supply linked to the implant record.
19 INVENTORY_ITEM_ID_SUPPLY_NAME VARCHAR No
The name of the inventory item.
20 PACEMAKER_RATE NUMERIC No
The pacemaker rate of the implant.
21 IMPLANT_AREA_C_NAME VARCHAR No
The implant area category number for the implant record.
May contain organization-specific values: Yes
22 PASS_THROUGH_CODE VARCHAR No
The pass through code used for billing.
23 CHARGE_CODE_EAP_ID_PROC_NAME VARCHAR No
The name of each procedure.
24 IMPLANT_SIZE VARCHAR No
The size of the implant.
25 TISSUE_TYPE_C_NAME VARCHAR No
The tissue type category number for the implant record.
May contain organization-specific values: Yes
Category Entries:
Skin
Bone
Other
26 PREP_START_DTTM DATETIME (Attached) No
The date and time when the tissue preparation was started.
27 IMPLANT_TEMP NUMERIC No
Temperature at implantation of tissue, in degrees Fahrenheit.
28 INFECTED_DATE DATETIME No
The date the tissue was infected.
29 SURG_NOTIFIED_DATE DATETIME No
The date the surgeon was notified about the infection.
30 TISSUE_YN VARCHAR No
Indicates whether this is a tissue implant. Y indicates that this is a tissue implant. A null indicates that no value is documented. N indicates that this is not a tissue implant.
May contain organization-specific values: No
Category Entries:
No
Yes
31 PAT_ID VARCHAR No
The unique ID of the patient record for this implant. This column is frequently used to link to the PATIENT table.
32 IMPLANT_LAT_C_NAME VARCHAR No
The laterality category number for the implant record.
May contain organization-specific values: Yes
Category Entries:
Left
Right
Bilateral
N/A
Default
33 PACE_INITIAL_YN VARCHAR No
Indicates whether this pacemaker is the initial device implanted in a patient. Y indicates that this is the initial device. A null indicates that no value is documented. N indicates that this is not the initial device.
The category values for this column were already listed for column: TISSUE_YN
34 PACE_POCKET_LOC_C_NAME VARCHAR No
The category number for the pocket location in which this pacemaker is implanted.
May contain organization-specific values: Yes
Category Entries:
Pre-pectoral
Pre-pectoral (below fascia)
Sub-pectoral
Subcuticular
Pre-rectus
Pre-rectus (below sheath)
Sub-rectus/abdominal
No pocket present
35 TEMP_PACE_YN VARCHAR No
Indicates whether this is a temporary pacemaker. Y indicates that this is a temporary pacemaker. A null indicates that no value is documented. N indicates that this is not a temporary pacemaker.
The category values for this column were already listed for column: TISSUE_YN
36 PACE_PREVENTION_C_NAME VARCHAR No
The prevention type category number for the implant record. Only stores the prevention type if the implant type is pacemaker.
May contain organization-specific values: Yes
Category Entries:
Primary prevention
Secondary prevention
37 TEMP_PACE_CHAMBER_C_NAME VARCHAR No
The temporary pacemaker chamber category number for the implant record.
May contain organization-specific values: Yes
Category Entries:
RA
RV
LA
LV
SubQ
Patch
Lateral cardiac vein
38 RECORD_STATUS_C_NAME VARCHAR No
The record status category number for the implant record.
May contain organization-specific values: No
Category Entries:
Active
Inactive
Deleted
Inactive and Deleted
Hidden
Inactive and Hidden
Deleted and Hidden
Inactive Deleted and Hidden
39 MANUF_NUM VARCHAR No
The manufacturer number of the supply linked to the implant record.
40 SUP_CAT_NUM VARCHAR No
The supplier catalog number of the supply linked to the implant record.
41 PREP_INSTR_SOURCE_C_NAME VARCHAR No
The "source of tissue preparation instructions" category number for the tissue implant.
May contain organization-specific values: Yes
Category Entries:
Manufacturer
Surgeon
Other
N/A
42 STATIC_UDI VARCHAR No
The static piece of the unique device identifier, obtained from the implant barcode. This is the Global Trade Item Number (GTIN) for General Specifications (GS1) barcodes and the combination of the labeler identification code and the catalog number for Health Industry Bar Code (HIBC) barcodes.
43 STATIC_UDI_TYPE_C_NAME VARCHAR No
The type of the static unique device identifier, based on the format of the barcode it was obtained from.
May contain organization-specific values: No
Category Entries:
GS1
HIBC
ICCBBA
44 TISSUE_AUTOLOGOU_YN VARCHAR No
Stores whether a tissue implant was taken from the patient.
The category values for this column were already listed for column: TISSUE_YN
45 EXPLANT_DISPOSITN_C_NAME VARCHAR No
This item stores the where the implant was sent after being explanted.
May contain organization-specific values: Yes
Category Entries:
sent to pathology/lab
sent to lab
discarded
given to patient
returned to manufacturer
46 SKIN_SUB_USAGE_C_NAME VARCHAR No
Document how the skin substitute was used.
May contain organization-specific values: Yes
Category Entries:
Graft
Tissue
47 SKIN_SUB_AREA_USED NUMERIC No
Document the area of the skin substitute used.
48 SKIN_SUB_AREA_WASTE NUMERIC No
Document the area of the skin substitute wasted.
49 TISSUE_INSPC_RSLT_C_NAME VARCHAR No
Document result of inspecting the tissue
May contain organization-specific values: Yes
No Entries Defined
50 RADIOACTIVE_C_NAME VARCHAR No
This field will be used by the nurse to document when an implant is radioactive.
May contain organization-specific values: Yes
Category Entries:
Yes
No
51 REPLACE_EXISTING_C_NAME VARCHAR No
This column displays whether the given implant is replacing an existing implant.
May contain organization-specific values: No
Category Entries:
No (Old)
Yes (Old)
N/A (Old)
Yes
No
N/A
52 TISSUE_EXPANDER_VOLUME NUMERIC No
The volume (mL) the tissue expander was inflated.
53 REMOVE_BY_DATE DATETIME No
Date implant needs to be removed from patient.
54 IMPLANT_VOLUME NUMERIC No
This documents the volume of the implant.
55 IMP_VOLUME_UNIT_C_NAME VARCHAR No
Choose which unit to use for volume measurements.
May contain organization-specific values: Yes
No Entries Defined
56 SUPPLY_TYPE_C_NAME VARCHAR No
This is the type of inventory item for the implant. This is used for one-time implants, which do not have an inventory item, to determine what markup table to use for charging.
May contain organization-specific values: Yes
57 EXPLANT_WARRANTY_COMPLETION_DT DATETIME No
This item stores the explant warranty completion date.