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 |