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 |