Table Detail Report

MIC_GROUP_RESPONSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Group Response Criteria
Definition: This table contains the information regarding group report responses defined for a microbiology orderable procedure and service resource.
Table Type: REFERENCE





Column Detail - MIC_GROUP_RESPONSE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
CARRY_FORWARD_IND DOUBLE N This column represents whether group responses can be carry forwarded in successive reports or not.
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.
GROUP_DESCRIPTION VARCHAR(60) Y Description of the group response
GROUP_DISPLAY VARCHAR(40) Y Display of the group response
GROUP_RESPONSE_ID DOUBLE N This field identifies a unique value for each group response defined for an orderable procedure/service resource combination.
GRP_RESPONSE_CD DOUBLE N This field identifies the code value of the group response code associated with the procedure and service resource.
POSITIVE_IND DOUBLE Y This field indicates whether the group response is to be considered positive or negative at the group response level. Valid value include: 0 = Negative 1 = Positive
SERVICE_RESOURCE_CD DOUBLE N This field identifies the code value of the service resource to which group responses are defined.Service resources are defined on code set 221.
SOURCE_CD DOUBLE N This field identifies the code value of the source to which group responses are defined. Sources are defined on code set 2052, 1150 and 1151.
STATISTICS_IND DOUBLE Y Indicator to determine if the response should be sent to archive for statistical purposes. Marked with a 1 if detail responses should be sent or a 2 on the first detail if the group should be sent
TASK_ASSAY_CD DOUBLE N This field identifies the code value of the report associated with the group response. Reports are defined on code set 1000, Microbiology Reports.
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_GROUP_RESPONSE


Child Column in MIC_GROUP_RESPONSE(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD MIC_TASK TASK_ASSAY_CD
CATALOG_CD ORDER_CATALOG CATALOG_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in MIC_GROUP_RESPONSE (PK) Child Table Name Child Column Name
Children: GROUP_RESPONSE_ID MIC_GROUP_RESPONSE_MBR GROUP_RESPONSE_ID
MIC_REF_ANG_REPORT GROUP_RESPONSE_ID
MIC_STAT_REPORT_RESPONSE GROUP_RESPONSE_ID


MIC_GROUP_RESPONSE_MBR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Group Response Members
Definition: This table associates the coded responses with the microbiology group response/procedure and service resource.
Table Type: REFERENCE





Column Detail - MIC_GROUP_RESPONSE_MBR


Column Name Type Null? Definition
DETAIL_RESPONSE_CD DOUBLE N This field identifies the code_value of the coded response or organism associated with the group response. Fill in the blank coded responses are defined on code set 1022 with a CDF meaning of 'BLANK'.
GROUP_RESPONSE_ID DOUBLE N This field identifies the unique value for group response from the mic_group_response table.
NEW_PHRASE_IND DOUBLE Y This field indicates whether the coded response should display on a new line or display on the current line. Valid values include: 0 = Display on current line 1 = Display on a new line
RESPONSE_SEQ DOUBLE N This field identifies a unique value for each coded response included in the group response. The sequence also determines the order the coded responses were entered into the group response.
STATISTICS_IND DOUBLE Y Determines whether or not a group or details within a group are sent to the archive model for statistical purposes
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_GROUP_RESPONSE_MBR


Child Column in MIC_GROUP_RESPONSE_MBR(FK) Parent Table Name Parent Column Name
Parents: GROUP_RESPONSE_ID MIC_GROUP_RESPONSE GROUP_RESPONSE_ID


MIC_IC_ORDERS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Infection Control Candidate Orders
Definition: This activity table contains 'order' level information that is used for Infection Control Candidate reporting. This table contains information for General Lab and Microbiology orders only.
Table Type: ACTIVITY





Column Detail - MIC_IC_ORDERS


Column Name Type Null? Definition
ACCESSION_NBR VARCHAR(20) N This field uniquely identifies an order or a group of orders.
ACTIVITY_TYPE_CD DOUBLE N This field contains the internal identification code for the 'type' of order. For example, this table contains orders for both General Lab and Microbiology procedures and this field is used to differentiate between the types.
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.
COMPLETE_DT_TM DATETIME Y This field contains the date and time at which the orderable procedure was completed.
CULTURE_START_DT_TM DATETIME Y This field identifies the start date and time of the orderable procedure.
DRAWN_DT_TM DATETIME N This field contains the date and time at which the orderable procedure was collected.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
NOSOCOMIAL_IND DOUBLE Y This field indicates whether an infection was acquired during a hospital stay. Valid values include: 0 = No nosocomial infection 1 = Nosocomial infection
ORDER_ID DOUBLE N This field contains the internal identification code 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_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.
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
PROCEDURE_ORDER_DT_TM DATETIME N This field contains the date and time at which the orderable procedure was ordered.
RECEIVED_DT_TM DATETIME N This field contains the date and time at which the orderable procedure was received.
SOURCE_CD DOUBLE N This field contains the internal identification code of the source to which this specimen was drawn.
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_IC_ORDERS


Child Column in MIC_IC_ORDERS(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID
ORDER_PROVIDER_ID PRSNL PERSON_ID


MIC_INSTR_TRANS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Instrument Translation
Definition: This table contains the translation information for all codes transmitted from a susceptibility instrument interface to the Cerner system. This includes organisms, antibiotics, panels, sources, susceptibility results, susceptibility methods, and automate
Table Type: REFERENCE





Column Detail - MIC_INSTR_TRANS


Column Name Type Null? Definition
MICRO_ALIAS VARCHAR(20) N This field identifies the description of the code as it exists on the host system(instrument) and identifies how the code will be transmitted to and from the Cerner system.
MICRO_CD DOUBLE N The microbiology code is the code set value of the row. This includes translations for source, procedure, medication, panel,
MICRO_FLAG DOUBLE N This field identifies the type of translation.
SERVICE_RESOURCE_CD DOUBLE N This field identifies the code value of the instrument for which translations are defined.
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_INSTR_TRANS


Child Column in MIC_INSTR_TRANS(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


MIC_INTERP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Interpretations
Definition: This table takes the combination of interp_id from the mic_sus_first_level_interp and each susceptibility interpretation detail procedure and creates a unique identifier which is used to define the susceptibility interpretation results.
Table Type: REFERENCE





Column Detail - MIC_INTERP


Column Name Type Null? Definition
INTERP_ID DOUBLE N This field identifies a unique value for each set of susceptibility interpretations defined for an organism/source/antibiotic/susceptibility detail combination.
INTERP_RANGE_ID DOUBLE N This field identifies a unique value for each combination of interp_id and susceptibility interpretation detail procedure. This allows users to have multiple interpretations for each dilution result.
INTERP_TEST_CD DOUBLE N This field identifies the code_value of the interpretation susceptibility detail procedure for which susceptibility interpretations are defined. Susceptibility interpretation details are defined on code set 1004 and are identified on the mic_detail_task table with a task_type_flag of 7.
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_INTERP


Child Column in MIC_INTERP(FK) Parent Table Name Parent Column Name
Parents: INTERP_TEST_CD MIC_DETAIL_TASK TASK_COMPONENT_CD
INTERP_ID MIC_SUS_FIRST_LEVEL_INTERP INTERP_ID




Parent Column in MIC_INTERP (PK) Child Table Name Child Column Name
Children: INTERP_RANGE_ID MIC_INTERP_DATA INTERP_RANGE_ID