Table Detail Report

MIC_STAT_MEDICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Statistical Medication
Definition: This summary table is comprised of records extracted from the MIC_MEDS_ACTIVITY table. This information is utilized by the Microbiology Statistical Reporting package.
Table Type: ACTIVITY





Column Detail - MIC_STAT_MEDICATION


Column Name Type Null? Definition
MEDICATION_CD DOUBLE N This field contains the internal identification code for the antibiotic associated with the orderable procedure.
ORDER_ID DOUBLE N This field contains the internal identification code for the order to which this medication is associated. This could be used to join to the MIC_STAT_ORDER table.
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 - MIC_STAT_MEDICATION


Child Column in MIC_STAT_MEDICATION(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID MIC_STAT_ORDER ORDER_ID


MIC_STAT_ORDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Statistical Order
Definition: This summary table is comprised of Microbiology order level information, which is used in the Microbiology Statistical Reporting package.
Table Type: ACTIVITY





Column Detail - MIC_STAT_ORDER


Column Name Type Null? Definition
ACCESSION_NBR VARCHAR(20) Y This field uniquely identifies an order or a group of orders.
BODY_SITE_CD DOUBLE N This field contains the internal identification code identifying the body site from which this specimen was drawn.
CATALOG_CD DOUBLE N This field contains the internal identification code of the orderable procedure. This could be used to join to the ORDER_CATALOG table.
CATALOG_SEQ DOUBLE N This field is used in conjunction with the MIC_STAT_ORDER.CATALOG_CD field in order to ensure uniqueness within an accession. For example, if an accession contained to C Wound orders then this field would be valued with '1' for the first C Wound and '2' for the second C Wound.
COLLECT_DT_NBR DOUBLE N The date number when the orderable procedure was collected. Used to gather date information from the OMF_DATE table.
COLLECT_DT_TM DATETIME Y This field contains the date and time at which the orderable procedure was collected.
COLLECT_LOC_BUILDING_CD DOUBLE N This field contains the internal identification code for the building location at which this order was collected. This could be used to join to the LOCATION table.
COLLECT_LOC_FACILITY_CD DOUBLE N This field contains the internal identification code for the facility location at which this order was collected. This could be used to join to the LOCATION table.
COLLECT_LOC_NURSE_UNIT_CD DOUBLE N This field contains the internal identification code for the nurse unit location at which this order was collected. This could be used to join to the LOCATION table.
COLLECT_MIN_NBR DOUBLE N The minute number when the orderable procedure was collected. Used to get time information from the OMF_TIME table.
COLLECT_PRSNL_ID DOUBLE N This field contains the internal identification code for the person whom collected the order. This could be used to join to the PRSNL table.
COMPLETE_DT_NBR DOUBLE N The date number when the orderable procedure was completed. Used to gather date information from the OMF_DATE table.
COMPLETE_DT_TM DATETIME Y This field contains the date and time at which the orderable procedure was completed.
COMPLETE_MIN_NBR DOUBLE N The minute number when the orderable procedure was completed. Used to get time information from the OMF_TIME table.
COMPLETE_PRSNL_ID DOUBLE N This field contains the internal identification code for the person whom completed the order. This could be used to join to the PRSNL table.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DAYS_TO_POSITIVE DOUBLE N This field contains the number of days from which a culture was started to when it was identified as positive.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EXT_ACCESSION_NBR VARCHAR(30) Y This field contains the accession number value from a foreign system. This field is only populated for records uploaded from a foreign system.
FREETEXT_SOURCE_ID DOUBLE N This field contains the internal identification code to the LONG_TEXT row, which contains a textual value for free textsource associated with this orderable procedure.
INTERP_TEXT_ID DOUBLE N This field contains the internal identification code to the LONG_TEXT row, which contains a textual value for interpretive data associated with this orderable procedure.
NOSOCOMIAL_IND DOUBLE N This field indicates whether an infection was acquired during a hospital stay. Valid values include: 0 = No nosocomial infection 1 = Nosocomial infection
ORDER_COMMENT_ID DOUBLE N This field contains the internal identification code to the LONG_TEXT row, which contains a textual value for order comment associated with this orderable procedure.
ORDER_DT_NBR DOUBLE N The date number when the orderable procedure was ordered. Used to gather date information from the OMF_DATE table.
ORDER_DT_TM DATETIME Y This field contains the date and time at which the orderable procedure was ordered.
ORDER_ID DOUBLE N This field contains the unique value assigned to each orderable procedure associated with an order. For example: if there are two procedures on the same accession number, then each procedure will have a unique order id.
ORDER_LOC_BUILDING_CD DOUBLE N This field contains the internal identification code for the building location at which this order was placed. This could be used to join to the LOCATION table.
ORDER_LOC_FACILITY_CD DOUBLE N This field contains the internal identification code for the facility location at which this order was placed. This could be used to join to the LOCATION table.
ORDER_LOC_NURSE_UNIT_CD DOUBLE N This field contains the internal identification code for the nurse unit location at which this order was placed. This could be used to join to the LOCATION table.
ORDER_MIN_NBR DOUBLE N The minute number when the orderable procedure was ordered. Used to get time information from the OMF_TIME table.
ORDER_NOTE_ID DOUBLE N This field contains the internal identification code to the LONG_TEXT row, which contains a textual value for order note associated with this orderable procedure.
ORDER_PROVIDER_FT VARCHAR(100) Y This field contains the name of a free text ordering provider. This column is ONLY populated from a historical upload.
ORDER_PROVIDER_ID DOUBLE N This field contains the internal identification code for the ordering provider. This could be used to join to the PRSNL table.
ORDER_PRSNL_ID DOUBLE N This field contains the internal identification code for the person whom placed the order. This could be used to join to the PRSNL table.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
POSITIVE_IND DOUBLE Y This field indicates whether or not the procedure is considered positive. Microbiology procedures are considered positive when a preliminary or final report is issued that includes a positive response or organism. Valid values include: 0 = Not positive 1 = Positive
PURGE_DT_TM DATETIME Y This field contains the date at which this order will be eligible to purge.
RECEIVE_DT_NBR DOUBLE N The date number when the orderable procedure was received. Used to gather date information from the OMF_DATE table.
RECEIVE_DT_TM DATETIME Y This field contains the date and time at which the orderable procedure was received.
RECEIVE_MIN_NBR DOUBLE N The minute number when the orderable procedure was received. Used to get time information from the OMF_TIME table.
RECEIVE_PRSNL_ID DOUBLE N This field contains the internal identification code for the person whom received the order. This could be used to join to the PRSNL table.
SERVICE_RESOURCE_CD DOUBLE N This field contains the internal identification code for the service resource at which this order was performed. This could be used to join to the SERVICE_RESOURCE table.
SOURCE_CD DOUBLE N This field contains the internal identification code of the source to which this specimen was drawn.
START_DT_NBR DOUBLE N The date number when the orderable procedure was started. Used to gather date information from the OMF_DATE table.
START_DT_TM DATETIME Y This field identifies the start date and time of the orderable procedure.
START_MIN_NBR DOUBLE N The minute number when the orderable procedure was started. Used to get time information from the OMF_TIME table.
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 - MIC_STAT_ORDER


Child Column in MIC_STAT_ORDER(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
FREETEXT_SOURCE_ID LONG_TEXT LONG_TEXT_ID
INTERP_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_COMMENT_ID LONG_TEXT LONG_TEXT_ID
ORDER_NOTE_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID
COLLECT_PRSNL_ID PRSNL PERSON_ID
COMPLETE_PRSNL_ID PRSNL PERSON_ID
ORDER_PROVIDER_ID PRSNL PERSON_ID
ORDER_PRSNL_ID PRSNL PERSON_ID
RECEIVE_PRSNL_ID PRSNL PERSON_ID




Parent Column in MIC_STAT_ORDER (PK) Child Table Name Child Column Name
Children: ORDER_ID MIC_STAT_MEDICATION ORDER_ID
MIC_STAT_PATHOGEN ORDER_ID
MIC_STAT_TASK ORDER_ID


MIC_STAT_ORGANISM_ID



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Statistical Organism Identification
Definition: This summary table is comprised of records extracted from the MIC_ORGANISM_ID table. This information is utilized by the Microbiology Statistical Reporting package.
Table Type: ACTIVITY





Column Detail - MIC_STAT_ORGANISM_ID


Column Name Type Null? Definition
BIO_TYPE_NUMBER VARCHAR(100) Y This field identifies the organism bio-type code sent from the susceptibility instrument interface.
ID_ORGANISM_CD DOUBLE N This field identifies the code value of the organism associated with the organism id task. This is the organism code that was sent to the Cerner system from the susceptibility instrument interface. The organism code received from the instrument is translated from the mic_instr_trans table and the corresponding code value is placed in this field.
ID_THRESHOLD DOUBLE N This field identifies the probability percentage for the organism identification. The probability is the instrument's confidence percentage on which identification is the most likely based on its biochemical reactions. This information is sent to the Cerner system from some of the susceptibility instrument interfaces.
SEQUENCE DOUBLE N This field contains a unique value that uniquely identifies more than one organism identification for the same TASK_LOG_ID. Some instruments can send multiple identifications from which the user will make a selection as to the actual identification of the organism.
TASK_LOG_ID DOUBLE N This field contains the internal identification code assigned to the 'organism ID' task from the MIC_STAT_TASK table.
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 - MIC_STAT_ORGANISM_ID


Child Column in MIC_STAT_ORGANISM_ID(FK) Parent Table Name Parent Column Name
Parents: TASK_LOG_ID MIC_STAT_TASK TASK_LOG_ID


MIC_STAT_ORG_OBSERVATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Statistical Organism Observation
Definition: This summary table is comprised of records extracted from the MIC_ORGANISM_OBSERVATION table. This information is utilized by the Microbiology Statistical Reporting package.
Table Type: ACTIVITY





Column Detail - MIC_STAT_ORG_OBSERVATION


Column Name Type Null? Definition
MEDIA_CD DOUBLE N This field contains the internal identification code of the specific type of media identified for this procedure.
OBSERVATION VARCHAR(100) Y This field identifies the morphological description of the organism for each piece of media.
QUANTITATION_CD DOUBLE N This field identifies the internal identification code of the quantity associated with the media and organism.
REPORT_IND DOUBLE N This field idocuments whether or not the quantity for the associated organism should be linked to the report. Only one quantity may be linked per organism.
SEQUENCE DOUBLE N This field contains a unique value that uniquely identifies more than occurrence of the same media code for a given organism.
TASK_LOG_ID DOUBLE N This field contains the internal identification code assigned to the organism task from the MIC_STAT_TASK table.
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 - MIC_STAT_ORG_OBSERVATION


Child Column in MIC_STAT_ORG_OBSERVATION(FK) Parent Table Name Parent Column Name
Parents: TASK_LOG_ID MIC_STAT_TASK TASK_LOG_ID


MIC_STAT_PATHOGEN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Statistical Pathogen
Definition: This summary table is comprised of records extracted from the MIC_PATHOGEN table
Table Type: ACTIVITY





Column Detail - MIC_STAT_PATHOGEN


Column Name Type Null? Definition
ORDER_ID DOUBLE N This field contains the internal identification code for the order to which this pathogen is associated. This could be used to join to the MIC_STAT_ORDER table.
PATHOGEN_CD DOUBLE N This field contains the internal identification code for the organism associated with the orderable procedure.
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 - MIC_STAT_PATHOGEN


Child Column in MIC_STAT_PATHOGEN(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID MIC_STAT_ORDER ORDER_ID