Table Detail Report

MIC_VALID_RESPONSE_MBR



Column Section Top of Page


Table-level Detail

Description: Valid Response members
Definition: This table lists the valid coded responses for a given valid_response id.
Table Type: REFERENCE





Column Detail - MIC_VALID_RESPONSE_MBR


Column Name Type Null? Definition
CODED_RESPONSE_CD DOUBLE N Code value that relates to coded response and codeset 1022.
STATISTICS_IND DOUBLE Y Indicator which represents whether or not a coded response should be sent to archive for statistical purposes. 1- Yes 0 - No
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.
VALID_RESPONSE_ID DOUBLE N Id which represents a unique service resource, procedure, and source combination for valid responses


MIC_VALID_SUS_PAIR



Column Section Top of Page


Table-level Detail

Description: Microbiology Valid Susceptibility Pairs
Definition: This reference table holds the list of valid pairings for ordering identification and susceptibility tests.
Table Type: REFERENCE





Column Detail - MIC_VALID_SUS_PAIR


Column Name Type Null? Definition
PANEL_CD DOUBLE N The Panel code is the code set value that identifies the susceptibility panel that can be ordered for the valid_panel_id.
TASK_ASSAY_CD DOUBLE N The Task Assay code is the code set value that identifies the group biochemical ID that can be ordered in conjunction with the susceptibility panel.
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.


MIC_VALID_SUS_PANEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Valid Susceptibility Panel Criteria
Definition: This table takes the combination of procedure/service resource/source and organism and creates a unique identifier that is used to define the valid susceptibility antibiotic or ID panels.
Table Type: REFERENCE





Column Detail - MIC_VALID_SUS_PANEL


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.
METHOD_CD DOUBLE N This field identifies the code_value of the susceptibility method for which valid susceptibility panels are defined. Susceptibility methods are defined on code set 65.
ORGANISM_GROUPING_CD DOUBLE N This field identifies the code_value of the organism for which valid susceptibility panels are defined. Organisms are defined on code set 1021, Organisms.
SERVICE_RESOURCE_CD DOUBLE N This field identifies the code value of the service resource to which valid panels are defined. Service resources are defined on code set 221.
SOURCE_GROUPING_CD DOUBLE N This field identifies the code_value of the source used to define valid susceptibility panels. All three levels of source hierarchy (source, section, category) can be used in defining valid panels.
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.
VALID_PANEL_ID DOUBLE N This field identifies a unique value for each set of valid susceptibility panels defined for an orderable procedure/service resource/source and organism combination.



Relationship Detail - MIC_VALID_SUS_PANEL


Child Column in MIC_VALID_SUS_PANEL(FK) Parent Table Name Parent Column Name
Parents: ORGANISM_GROUPING_CD MIC_ORGANISM_DATA ORGANISM_ID
METHOD_CD MIC_TASK TASK_ASSAY_CD
CATALOG_CD ORDER_CATALOG CATALOG_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in MIC_VALID_SUS_PANEL (PK) Child Table Name Child Column Name
Children: VALID_PANEL_ID MIC_REF_BILLING_PANEL VALID_PANEL_ID
MIC_VALID_PANEL VALID_PANEL_ID


MIC_VALID_SUS_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Valid Susceptibility Results
Definition: This table contains information regarding the valid susceptibility results for each organism/antibiotic/susceptibility detail procedure combination.
Table Type: REFERENCE





Column Detail - MIC_VALID_SUS_RESULT


Column Name Type Null? Definition
DISPLAY_ORDER DOUBLE Y This field identifies a unique value for each valid susceptibility result that indicates the order in which the results are to be displayed in the susceptibility result help window.
ORGANISM_CD DOUBLE N This field identifies the code_value of the organism for which valid susceptibility results are defined. Valid susceptibility results are specific to the organism and the susceptibility detail procedure. Organisms are defined on code set 1021, Organisms.
SUS_RESULT_CD DOUBLE N This field identifies the code_value of the susceptibility result being defined as valid for the antibiotic.
SUS_TYPE_CD DOUBLE N This field identifies of the susceptibility detail procedure for which valid susceptibility resultsare defined. Susceptibility detail procedures are defined on code set 1004.
TASK_COMPONENT_CD DOUBLE N This field identifies the code_value of the detail task. Valid detail tasks include biochemicals, susceptibility detail procedures and antibiotics.
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_VALID_SUS_RESULT


Child Column in MIC_VALID_SUS_RESULT(FK) Parent Table Name Parent Column Name
Parents: SUS_TYPE_CD MIC_DETAIL_TASK TASK_COMPONENT_CD
TASK_COMPONENT_CD MIC_DETAIL_TASK TASK_COMPONENT_CD
ORGANISM_CD MIC_ORGANISM_DATA ORGANISM_ID


MIC_WORKCARD_CORRELATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Workcard Correlation
Definition: This reference table contains a single record for every correlation check for a workcard at a service resource that needs to occur.
Table Type: REFERENCE





Column Detail - MIC_WORKCARD_CORRELATION


Column Name Type Null? Definition
CATALOG_CD DOUBLE N This field contains the internal identification code of the procedure to which the correlation is assigned. This could be used to join to the order_catalog table.
FAILURE_REASON_CD DOUBLE N This field contains the internal identification code assigned to the type of failure the correlation rule is checking.
SERVICE_RESOURCE_CD DOUBLE N This field contains the internal identification code of the service resource to which the stain correlation rule is assigned. This could be used to join to the service_resource 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.
WARN_ONLY_IND DOUBLE Y This field contains an indicator documenting whether or not the correlation will only issue a warning or lock the accession until another report is issued.



Relationship Detail - MIC_WORKCARD_CORRELATION


Child Column in MIC_WORKCARD_CORRELATION(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD