IMPLANT_HISTORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: IMPLANT HISTORY
Definition: Contains information about the alert set for the rule
Table Type: ACTIVITY





Column Detail - IMPLANT_HISTORY


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BIOLOGICAL_IMP_SRC_CD DOUBLE N Indicates the Biological source of an implant mfr catalog item
BODY_SITE_CD DOUBLE N Site of the Implanted Item
DEVICE_IDENTIFIER_TXT VARCHAR(50) Y The Device Identifier (if any) for the implanted item. This would be the unique_id from a scanned barcode.
DONOR_NUMBER_TXT VARCHAR(255) Y Textt field which contains the donor number
ENCNTR_ID DOUBLE N Encounter Id of the person
EXPIRATION_DT_TM DATETIME Y Indicates the item expire date time
EXPLANT_DT_TM DATETIME Y Explanted Date
EXPLANT_DT_TM_PREC_FLAG DOUBLE N Precision of date/time: 0=precise to time, 1=precise to day, 2=precise to month, 3=precise to year
EXPLANT_REASON_CD DOUBLE N Explanted Reason
GMDN_PT_NAME VARCHAR(4000) Y Indicates the "Global Medical Device Nomenclature Preferred Term" name of the implant item.
IMPLANTED_DT_TM DATETIME Y Indicates the Implanted date time
IMPLANTED_DT_TM_PREC_FLAG DOUBLE N Precision of date/time: 0=precise to time, 1=precise to day, 2=precise to month, 3=precise to year
IMPLANTED_FACILITY_CD DOUBLE N Location Type defines the kind of location (i.e., nurse unit, room, inventory location, etc.). Location types have Cerner defined meanings in the common data foundation
IMPLANTED_FACILITY_FT VARCHAR(255) Y Location as free text value
IMPLANTED_PRSNL_FT VARCHAR(255) Y The Provider name as free text value who implanted the Item
IMPLANTED_PRSNL_ID DOUBLE N The Provider who implanted the Item
IMPLANTED_QUANTITY DOUBLE N The quantity of the items Implanted
IMPLANT_DATA_SOURCE_CD DOUBLE N Data Source of the Implant Item
IMPLANT_HISTORY_ID DOUBLE N PRIMARY KEY
IMPLANT_INSTANCE_GRP_ID DOUBLE N Group Implants for audit history
IMPLANT_INSTANCE_SEQ DOUBLE N Sequencing of Implants
IMPLANT_ITEM_FT VARCHAR(255) Y Item identifier as free text value
IMPLANT_ITEM_ID DOUBLE N Indicates the associated item identifier in ITEM_MASTER table
IMPLANT_TYPE_CD DOUBLE N Implanted Implant Type
LONG_TEXT_ID DOUBLE N Stores the long text identifier
LOT_NUMBER_TXT VARCHAR(255) Y Lot Number of an added item
MANUFACTURED_DT_TM DATETIME Y Manufactured date of an implanted item
MANUFACTURER_CD DOUBLE N Manufacturer code of an item
MANUFACTURER_FT VARCHAR(255) Y The manufacturer name as free text value
MANUFACTURER_MODEL_NBR_TXT VARCHAR(255) Y The manufacturer model number text
MR_CLASSIFICATION_CD DOUBLE N Manufacturer MR classification of an Item
NON_BIOLOGICAL_IMP_TYPE_CD DOUBLE N Indicates the Non-Biologic Implant type of an implant mfr catalog item
ORIGINATING_ENCNTR_ID DOUBLE N Indicates the "Originating Encounter ID" for implant item added in Implant History Tab.
PARENT_ENTITY_ID DOUBLE N Used to Store the identifier of the parent table named in PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(32) Y Used to Store the name of the parent Table for the ID value in PARENT_ENTITY_ID
PERSON_ID DOUBLE N The person_id of the person from the person table for whom Implant is being added
PROCEDURE_CD DOUBLE N Scheduled Surgical Procedure Code
PROCEDURE_FT VARCHAR(255) Y Scheduled Surgical Procedure Name
PROCEDURE_NOMEN_ID DOUBLE N Codified value of the Procedure Nomenclature against which Implant item has been documented.
SERIAL_NUMBER_TXT VARCHAR(255) Y Serial and Donor Number
SNOMEDCT_DESCRIPTION VARCHAR(255) Y An association between a human-readable phrase(term) and a particular SNOMED CT concept.
SNOMED_IDENTIFIER DOUBLE N A unique integer identifier applied to each SNOMED CT component (Concept, Description, or Relationship)
SURG_CASE_PROC_ID DOUBLE N The unique identifier of the procedure documented in the surgical case
UDI_TXT VARCHAR(255) Y Unique device identifier,This would be a numeric value representing a bar coded unique identifier for each instance of an item
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - IMPLANT_HISTORY


Child Column in IMPLANT_HISTORY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORIGINATING_ENCNTR_ID ENCOUNTER ENCNTR_ID
IMPLANT_ITEM_ID ITEM_DEFINITION ITEM_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PROCEDURE_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
PERSON_ID PERSON PERSON_ID
IMPLANTED_PRSNL_ID PRSNL PERSON_ID
SURG_CASE_PROC_ID SURG_CASE_PROCEDURE SURG_CASE_PROC_ID




Parent Column in IMPLANT_HISTORY (PK) Child Table Name Child Column Name
Children: IMPLANT_HISTORY_ID IMPLANT_HISTORY_MATERIAL IMPLANT_HISTORY_ID
IMPLANT_HISTORY_REVIEW IMPLANT_HISTORY_ID


IMPLANT_HISTORY_MATERIAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: IMPLANT HISTORY MATERIAL
Definition: Contains information about the alert set Material component for the rule
Table Type: ACTIVITY





Column Detail - IMPLANT_HISTORY_MATERIAL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
IMPLANT_HISTORY_ID DOUBLE N implant_history_id from implant_history table
IMPLANT_HISTORY_MATERIAL_ID DOUBLE N PRIMARY KEY
MATERIAL_CD DOUBLE N Material type used for an Implant
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - IMPLANT_HISTORY_MATERIAL


Child Column in IMPLANT_HISTORY_MATERIAL(FK) Parent Table Name Parent Column Name
Parents: IMPLANT_HISTORY_ID IMPLANT_HISTORY IMPLANT_HISTORY_ID


IMPLANT_HISTORY_REVIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: IMPLANT_HISTORY_REVIEW
Definition: This table tracks the review of the items that are permanently implanted in the patient
Table Type: ACTIVITY





Column Detail - IMPLANT_HISTORY_REVIEW


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
IMPLANT_HISTORY_ID DOUBLE N implant_history_id from implant_history table
IMPLANT_HISTORY_REVIEW_ID DOUBLE N PRIMARY KEY
PRSNL_ID DOUBLE N The Provider who reviewed an implanted Item
REVIEW_DT_TM DATETIME Y Indicates the review date time
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - IMPLANT_HISTORY_REVIEW


Child Column in IMPLANT_HISTORY_REVIEW(FK) Parent Table Name Parent Column Name
Parents: IMPLANT_HISTORY_ID IMPLANT_HISTORY IMPLANT_HISTORY_ID
PRSNL_ID PRSNL PERSON_ID