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 |