Table Detail Report

MIC_STAT_SUS_CROSS_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Micro Susceptibility DC Cross Reference
Definition: This statistical reference table contains duplicate check information between susceptibility details based on susceptibility duplicate checking(DC) criteria. This is a child table of mic_stat_sus_dc_param.
Table Type: REFERENCE





Column Detail - MIC_STAT_SUS_CROSS_REF


Column Name Type Null? Definition
SUS_DC_PARAM_ID DOUBLE N This field contains a foreign key value used to join sus DC parameter information stored on mic_stat_sus_dc_param table.
SUS_DETAIL1_CD DOUBLE N This field contains the code_value of the first sus detail to be cross referenced.
SUS_DETAIL2_CD DOUBLE N This field contains the code_value of the second sus detail to be cross referenced.
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_SUS_CROSS_REF


Child Column in MIC_STAT_SUS_CROSS_REF(FK) Parent Table Name Parent Column Name
Parents: SUS_DC_PARAM_ID MIC_STAT_SUS_DC_PARAM SUS_DC_PARAM_ID


MIC_STAT_SUS_DC_AB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Micro Susceptibility Duplicate Checking Antibiotic Information
Definition: This statistical reference table contains antibiotic information for susceptibility results duplicate checking (DC) values based on the defined criteria.
Table Type: REFERENCE





Column Detail - MIC_STAT_SUS_DC_AB


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N This field contains the code_value of the antibiotic used to define sus DC value criteria.
SUS_DC_VALUE_ID DOUBLE N This field contains a foreign key value used to join susceptibility DC value information stored on mic_stat_sus_dc_value, mic_stat_sus_dc_result and mic_stat_sus_dc_numeric tables.
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_SUS_DC_AB


Child Column in MIC_STAT_SUS_DC_AB(FK) Parent Table Name Parent Column Name
Parents: SUS_DC_VALUE_ID MIC_STAT_SUS_DC_VALUE SUS_DC_VALUE_ID




Parent Column in MIC_STAT_SUS_DC_AB (PK) Child Table Name Child Column Name
Children: ANTIBIOTIC_CD MIC_STAT_SUS_DC_NUMERIC ANTIBIOTIC_CD
SUS_DC_VALUE_ID MIC_STAT_SUS_DC_NUMERIC SUS_DC_VALUE_ID
ANTIBIOTIC_CD MIC_STAT_SUS_DC_RESULT ANTIBIOTIC_CD
SUS_DC_VALUE_ID MIC_STAT_SUS_DC_RESULT SUS_DC_VALUE_ID


MIC_STAT_SUS_DC_NUMERIC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Micro Susceptibility Duplicate Checking Numeric Result
Definition: This statistical reference table contains susceptibility duplicate checking(DC) values information defined for each numeric range based on criteria and antibiotic. This is a child table of mic_stat_sus_dc_ab.
Table Type: REFERENCE





Column Detail - MIC_STAT_SUS_DC_NUMERIC


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N This field contains the code_value of the antibiotic used to define sus DC value criteria.
BEGIN_RANGE DOUBLE N This field indicates the beginning value in the range. This value cannot exceed the maximum value defined for the numeric susceptibility detail.
END_RANGE DOUBLE N This field indicates the ending value in the range. This value cannot exceed the maximum value defined for the numeric susceptibility detail.
SUS_DC_VALUE_ID DOUBLE N This field contains a foreign key value used to join sus DC value information stored on mic_stat_sus_dc_value and mic_stat_sus_dc_ab tables.
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.
VALUE DOUBLE N This field indicates the DC value assigned to the particular result range.



Relationship Detail - MIC_STAT_SUS_DC_NUMERIC


Child Column in MIC_STAT_SUS_DC_NUMERIC(FK) Parent Table Name Parent Column Name
Parents: ANTIBIOTIC_CD MIC_STAT_SUS_DC_AB ANTIBIOTIC_CD
SUS_DC_VALUE_ID MIC_STAT_SUS_DC_AB SUS_DC_VALUE_ID


MIC_STAT_SUS_DC_PARAM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Micro Susceptibility Duplicating Checking Parameter
Definition: This statistical reference table contains criteria information for susceptibility results duplicate checking (DC) parameters such as tolerances and across susceptibilities. This is a parent table of mic_stat_sus_cross_ref and mic_stat_sus_limit_tolerance.
Table Type: REFERENCE





Column Detail - MIC_STAT_SUS_DC_PARAM


Column Name Type Null? Definition
ACROSS_ENCOUNTER_IND DOUBLE Y This field indicates if duplicate checking should occur within encounters or across encounters. Default 0 = duplicate checking should be within encounters. 1 = duplicate checking should be across encounters.
ACROSS_SOURCE_IND DOUBLE Y This field indicates if duplicate checking should occur within sources or across sources. Default 0 = duplicate checking should be within sources. 1 = duplicate checking should be across sources.
LOOKBACK_HOURS DOUBLE N This field indicates how many days to look back for duplicates from the update date and time of the current susceptibility method.
MATCHING_AB_IND DOUBLE Y This field indicates if antibiotic duplicate checking should match on different panels. 0 = if an antibiotic that has duplicate checking parameters defined on it but does not have a match in the second panel, the organism will automatically be considered unique. 1 = allow user to define the number of antibiotics that have to be compared between panels before the organism can be considered a duplicated.
MATCHING_AB_NBR DOUBLE N This field indicates the number of antibiotics that have to match for the panels to be duplicate checked.
ORGANISM_CD DOUBLE N This field contains the code_value of the organism used to define sus DC parameter criteria.
SERVICE_RESOURCE_CD DOUBLE N This field contains the code_value of the service resource used to define sus DC parameter criteria.
SOURCE_CD DOUBLE N This field contains the code_value of the source used to define sus DC parameter criteria.
SUS_DC_PARAM_ID DOUBLE N This field contains a unique value that identifies sus DC parameter criteria. This value is used to join to mic_stat_sus_cross_ref and mic_stat_sus_tolerance tables.
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_SUS_DC_PARAM




Parent Column in MIC_STAT_SUS_DC_PARAM (PK) Child Table Name Child Column Name
Children: SUS_DC_PARAM_ID MIC_STAT_SUS_CROSS_REF SUS_DC_PARAM_ID
MIC_STAT_SUS_LIMIT_TOLERANCE SUS_DC_PARAM_ID


MIC_STAT_SUS_DC_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Micro Susceptibility Duplicate Checking Result
Definition: This statistical reference table contains susceptibility duplicate checking(DC) values information defined for each valid results based on criteria and antibiotic. This is a child table of mic_stat_sus_dc_ab.
Table Type: REFERENCE





Column Detail - MIC_STAT_SUS_DC_RESULT


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N This field contains the code_value of the antibiotic used to define sus DC value criteria.
RESULT_CD DOUBLE N This field contains the code_value of the alpha results and interp results used to define sus DC value.
SUS_DC_VALUE_ID DOUBLE N This field contains a foreign key value used to join sus DC value information stored on mic_stat_sus_dc_value and mic_stat_sus_dc_ab tables.
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.
VALUE DOUBLE N This field indicates the DC value assigned to the particular result.



Relationship Detail - MIC_STAT_SUS_DC_RESULT


Child Column in MIC_STAT_SUS_DC_RESULT(FK) Parent Table Name Parent Column Name
Parents: ANTIBIOTIC_CD MIC_STAT_SUS_DC_AB ANTIBIOTIC_CD
SUS_DC_VALUE_ID MIC_STAT_SUS_DC_AB SUS_DC_VALUE_ID