Table Detail Report

MIC_STAT_SUS_DC_VALUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Micro Susceptibility Duplicate Checking Value
Definition: This statistical reference table contains criteria information for susceptibility results duplicate checking (DC) values. This is a parent table of mic_stat_sus_dc_ab.
Table Type: REFERENCE





Column Detail - MIC_STAT_SUS_DC_VALUE


Column Name Type Null? Definition
ORGANISM_CD DOUBLE N This field contains the code_value of the organism used to define sus DC value criteria.
SERVICE_RESOURCE_CD DOUBLE N This field contains the code_value of the service resource used to define sus DC value criteria.
SOURCE_CD DOUBLE N This field contains the code_value of the source used to define sus DC value criteria.
SUS_DC_VALUE_ID DOUBLE N This field contains a unique value that identifies sus DC value criteria. This value is used to join to mic_stat_sus_dc_ab, mic_stat_sus_dc_result and mic_stat_sus_dc_numeric tables.
SUS_DETAIL_CD DOUBLE N This field contains the code_value of the susceptibility detail used to define sus DC value criteria.
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_VALUE




Parent Column in MIC_STAT_SUS_DC_VALUE (PK) Child Table Name Child Column Name
Children: SUS_DC_VALUE_ID MIC_STAT_SUS_DC_AB SUS_DC_VALUE_ID


MIC_STAT_SUS_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Micro Susceptibility Result Grouping
Definition: This statistical reference table contains criteria information for susceptibility result grouping so the more meaningful antibiogram reports can be generated. This is a parent table of mic_stat_sus_group_result and mic_stat_sus_group_numeric.
Table Type: REFERENCE





Column Detail - MIC_STAT_SUS_GROUP


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N This field contains the code_value of the antibiotic used to define result group criteria.
ORGANISM_CD DOUBLE N This field contains the code_value of the organism used to define result group criteria.
SERVICE_RESOURCE_CD DOUBLE N This field contains the code_value of the service resource used to define result group criteria.
SOURCE_CD DOUBLE N This field contains the code_value of the source used to define result group criteria.
SUS_DETAIL_CD DOUBLE N This field contains the code_value of the susceptibility detail used to define result group criteria.
SUS_GROUP_ID DOUBLE N This field contains a unique value that identifies sus group criteria. This value is used to join to mic_stat_sus_group_result and mic_stat_sus_group_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_GROUP




Parent Column in MIC_STAT_SUS_GROUP (PK) Child Table Name Child Column Name
Children: SUS_GROUP_ID MIC_STAT_SUS_GROUP_NUMERIC SUS_GROUP_ID
MIC_STAT_SUS_GROUP_RESULT SUS_GROUP_ID


MIC_STAT_SUS_GROUP_NUMERIC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Micro Susceptibility Group Numeric Result
Definition: This statistical reference table contains the numeric results grouping information based on susceptibility group criteria. This is a child table of mic_stat_sus_group.
Table Type: REFERENCE





Column Detail - MIC_STAT_SUS_GROUP_NUMERIC


Column Name Type Null? Definition
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.
GROUP_CD DOUBLE N This field indicates the code_value of the group name.
SUS_GROUP_ID DOUBLE N This field contains a foreign key value used to join sus group information stored on mic_stat_sus_dc_group 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.



Relationship Detail - MIC_STAT_SUS_GROUP_NUMERIC


Child Column in MIC_STAT_SUS_GROUP_NUMERIC(FK) Parent Table Name Parent Column Name
Parents: SUS_GROUP_ID MIC_STAT_SUS_GROUP SUS_GROUP_ID


MIC_STAT_SUS_GROUP_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Micro Susceptibility Group Alpha Result
Definition: This statistical reference table contains the alpha results grouping information based on susceptibility group criteria. This is a child table of mic_stat_sus_group.
Table Type: REFERENCE





Column Detail - MIC_STAT_SUS_GROUP_RESULT


Column Name Type Null? Definition
GROUP_CD DOUBLE N This field indicates the code_value of the group name.
RESULT_CD DOUBLE N This field indicates the code_value of the alpha results and interp results that are to be assigned to the group.
SUS_GROUP_ID DOUBLE N This field contains a foreign key value used to join sus group information stored on mic_stat_sus_dc_group 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.



Relationship Detail - MIC_STAT_SUS_GROUP_RESULT


Child Column in MIC_STAT_SUS_GROUP_RESULT(FK) Parent Table Name Parent Column Name
Parents: SUS_GROUP_ID MIC_STAT_SUS_GROUP SUS_GROUP_ID


MIC_STAT_SUS_LIMIT_TOLERANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Micro Susceptibility DC Limit Tolerance
Definition: This statistical reference table contains tolerance and change limits information based on susceptibility duplicate checking(DC) parameters criteria. This is a child table of mic_stat_sus_dc_param.
Table Type: REFERENCE





Column Detail - MIC_STAT_SUS_LIMIT_TOLERANCE


Column Name Type Null? Definition
AMOUNT_OF_CHANGE DOUBLE N This field indicates the amount of change in DC values.
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.
TOLERANCE DOUBLE N This field indicates the number of times that must be exceeded before the change will cause the organism to be considered unique.
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_LIMIT_TOLERANCE


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