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. |