Table Detail Report
MIC_ORGANISM_DATA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Organism Data |
Definition: | This table contains reference information relating to organisms defined on code set 1021. |
Table Type: | REFERENCE |
Column Detail - MIC_ORGANISM_DATA
Column Name | Type | Null? | Definition |
---|---|---|---|
ORGANISM_ID | DOUBLE | N | This field identifies the code value of the organism from code set 1021. |
ORGANISM_TYPE | DOUBLE | Y | This field indicates the type of organism associated with this record. Valid values include: 1 = Bacteria 2 = Mycobacteria 3 = Fungus 4 = Parasite 5 = Virus 6 = Yeast |
ORG_CLASS_FLAG | DOUBLE | Y | This field identifies the classification of the organism associated with this record. Organisms are associated with a classification at the time they are defined in the Organism tool. |
PARENT_CD | DOUBLE | N | This field identifies the code value of the parent organism associated with this record. For example, if this is an organism record its parent organism would be the genus to which it is associated.The hierarchical levels associated with organisms is organisms are associated with genuses. Genuses are associated with families. Families are associated with sections. All hierarchical relationshi |
POSITIVE_IND | DOUBLE | Y | This field indicates whether the organism if used in a report task should set the culture to positive. Valid values include: 0 = Negative 1 = Positive |
QC_IND | DOUBLE | Y | This field is not used at this time. |
REPORT_NAME | CHAR(15) | Y | This field is not used at this 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 - MIC_ORGANISM_DATA
Parent Column in MIC_ORGANISM_DATA (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ORGANISM_ID | MIC_ABN_SUS_RESULT | ORGANISM_CD |
MIC_EVENT_LOG | ORGANISM_CD | ||
MIC_ORGANISM_ID | ID_ORGANISM_CD | ||
MIC_PATHOGEN | PATHOGEN_CD | ||
MIC_REQUIRED_TASK | ORGANISM_CD | ||
MIC_SUS_FIRST_LEVEL_INTERP | ORGANISM_GROUPING_CD | ||
MIC_TASK_LOG | ORGANISM_CD | ||
MIC_VALID_SUS_PANEL | ORGANISM_GROUPING_CD | ||
MIC_VALID_SUS_RESULT | ORGANISM_CD |
MIC_ORGANISM_ID
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Organism Identification |
Definition: | This table contains information regarding organism identifications performed on an instrument and transmitted to the Cerner system. |
Table Type: | ACTIVITY |
Column Detail - MIC_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. Organisms are defined on code set 1021. |
ID_SEQ | 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. |
ID_THRESHOLD | DOUBLE | Y | 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. |
TASK_LOG_ID | DOUBLE | N | This field identifies the unique value assigned to the organism id task from the mic_task_log table thus associating the organism information with the organism id task. |
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_ORGANISM_ID
Child Column in MIC_ORGANISM_ID(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ID_ORGANISM_CD | MIC_ORGANISM_DATA | ORGANISM_ID |
TASK_LOG_ID | MIC_TASK_LOG | TASK_LOG_ID |
MIC_ORGANISM_OBSERVATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Organism Observation |
Definition: | This table contains the quantity and the morphological description of each organism observed. |
Table Type: | ACTIVITY |
Column Detail - MIC_ORGANISM_OBSERVATION
Column Name | Type | Null? | Definition |
---|---|---|---|
COMMENT_SEQ | DOUBLE | Y | This field is not used at this time. |
CRITICAL_IND | DOUBLE | Y | ** Obsolete ** This column is no longer being used. This column mirrors the critical indicator in micdbtools. The selection value is captured here so that if the user changes the selection in the critical indicator checkbox in micdbtool the history is captured in this column. ** Obsolete ** |
MEDIA_CD | DOUBLE | N | This field contains the code value of the specific type of media identified for this procedure. Media types are defined on code set 2051 Specimen Containers. |
MEDIA_SEQ | DOUBLE | N | This field contains a unique value that uniquely identifies more than occurrence of the same media code for a given organism. |
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 code value of the quantity associated with the media and organism. Organism quantity codes are defined on code set 1023 Quantitations. |
REPORT_IND | DOUBLE | Y | This field includes an indicator documenting whether or not the quantity for the associated organism should be linked to the report. Only one quantity may be linked per organism. |
TASK_LOG_ID | DOUBLE | N | This field contains the unique value assigned to the organism observation task from the mic_task_log table thus associating the organism quantity and description with the organism observation task. |
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 - MIC_ORGANISM_OBSERVATION
Child Column in MIC_ORGANISM_OBSERVATION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_LOG_ID | MIC_TASK_LOG | TASK_LOG_ID |
Parent Column in MIC_ORGANISM_OBSERVATION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | MEDIA_SEQ | MIC_MEDIA_LOT_RELTN | MEDIA_SEQ |
TASK_LOG_ID | MIC_MEDIA_LOT_RELTN | TASK_LOG_ID |
MIC_PATHOGEN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Suspected Pathogens |
Definition: | This table contains information regarding the suspected pathogens(organisms) added to the order during the microbiology log in conversation. |
Table Type: | ACTIVITY |
Column Detail - MIC_PATHOGEN
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | This field contains the code value assigned to the procedure as defined in the DCPtools.exe application. Ordered procedure code values are stored on code set 200 Order Catalog. |
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. |
PATHOGEN_CD | DOUBLE | N | This field identifies the code value of the organism associated with the orderable procedure. Organisms are defined on code set 1021. |
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_PATHOGEN
Child Column in MIC_PATHOGEN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_ID | MIC_ORDER_LAB | ORDER_ID |
PATHOGEN_CD | MIC_ORGANISM_DATA | ORGANISM_ID | |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
MIC_POS_STAIN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Positive Stain |
Definition: | This reference table contains a single record for every positive stain criteria included in the PathNet Microbiology system. |
Table Type: | REFERENCE |
Column Detail - MIC_POS_STAIN
Column Name | Type | Null? | Definition |
---|---|---|---|
BODY_SITE_CD | DOUBLE | N | This field identifieds the internal identification code of body site to which the positive stain criteria is set up. |
POS_STAIN_ID | DOUBLE | N | This field contains the internal identification code that uniquely identifies the positive stain criteria (and it's associated parameters). This value is used to join to another table (mic_pos_stain_report). |
PROCEDURE_CD | DOUBLE | N | This field identifies the code_value of the procedure used to define positive stains. |
SERVICE_RESOURCE_CD | DOUBLE | N | This field contains the internal identification code of the service resource to which the positive stain criteria is assigned. This could be used to join to the service_resource table. |
SOURCE_CD | DOUBLE | N | This field identifies the code_value of the source used to define positive stains. |
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_POS_STAIN
Parent Column in MIC_POS_STAIN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | POS_STAIN_ID | MIC_POS_STAIN_REPORT | POS_STAIN_ID |