Table Detail Report

MIC_BPA_ANTIBIOTIC_PLATE_R



Column Section Top of Page


Table-level Detail

Description: Microbiology Breakpoint Antibiotic Plate Resolution
Definition: This reference table contains Breakpoint antibiotic plates that are associated to a susceptibility panel and antibiotic combination.
Table Type: REFERENCE





Column Detail - MIC_BPA_ANTIBIOTIC_PLATE_R


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N This field identifies the code value associated with the antibiotic.
ANTIBIOTIC_PLATE_CD DOUBLE N This field identifies the code value associated with the Breakpoint Antibiotic Plate.
SEQUENCE DOUBLE N This field identified the order in which the antibiotic plates will display.
SUSC_PANEL_CD DOUBLE N This field identifies the code value associated 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_BPA_INTERP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Breakpoint Interpretation
Definition: This reference table contains a combination of an organism, susceptibility panel, antibiotic, and susceptibility detail for which breakpoint interpretive data is defined.
Table Type: REFERENCE





Column Detail - MIC_BPA_INTERP


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N This field identifies the code value associated with the antibiotic.
INTERP_ID DOUBLE N This field contains the internal identification code that uniquely identifies the 'breakpoint interpretive' data for an organism/susceptibility panel/antibiotic/susceptibility detail combination. This value is used to join to the MIC_BPA_INTERP_RESULT and MIC_BPA_INTERP_PLATE_RESULT table.
ORGANISM_CD DOUBLE N This field identifies the code value associated with the organism.
SUSC_DETAIL_CD DOUBLE N This field identifies the code value associated with the susceptibility detail.
SUSC_PANEL_CD DOUBLE N This field identifies the code value associated 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.



Relationship Detail - MIC_BPA_INTERP




Parent Column in MIC_BPA_INTERP (PK) Child Table Name Child Column Name
Children: INTERP_ID MIC_BPA_INTERP_RESULT INTERP_ID


MIC_BPA_INTERP_PLATE_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Breakpoint Interp Plate Result
Definition: This reference table contains a breakpoint result value for a breakpoint antibiotic plate. The combination of these entries define a growth pattern, which results in the dilution result value contained in the MIC_INTERP_RESULT table.
Table Type: REFERENCE





Column Detail - MIC_BPA_INTERP_PLATE_RESULT


Column Name Type Null? Definition
ANTIBIOTIC_PLATE_CD DOUBLE N This field identifies the code value associated with the Breakpoint antibiotic plate.
BPA_RESULT_CD DOUBLE N This field identifies the code value associated with the Breakpoint plate result.
INTERP_ID DOUBLE N This field contains the foreign key value used to join to the MIC_BPA_INTERP table. This column in conjunction with the SEQUENCE column can be used to join to the MIC_BPA_INTERP_RESULT table.
SEQUENCE DOUBLE N This field is used in conjunction with the INTERP_ID to identify a unique breakpoint result growth pattern/dilution result.
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_BPA_INTERP_PLATE_RESULT


Child Column in MIC_BPA_INTERP_PLATE_RESULT(FK) Parent Table Name Parent Column Name
Parents: INTERP_ID MIC_BPA_INTERP_RESULT INTERP_ID
SEQUENCE MIC_BPA_INTERP_RESULT SEQUENCE


MIC_BPA_INTERP_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Breakpoint Interp Result
Definition: This reference table contains a dilution result value for a define breakpoint result growth pattern. The biochemical result values that make up the growth pattern are contained in the MIC_INTERP_PLATE_RESULT table.
Table Type: REFERENCE





Column Detail - MIC_BPA_INTERP_RESULT


Column Name Type Null? Definition
INTERP_ID DOUBLE N This field contains the foreign key value used to join to the parent MIC_BPA_INTERP table.
RESULT_CD DOUBLE N This field identifies the code value associated with the susceptibility alpha result.
SEQUENCE DOUBLE N This field is used in conjunction with the INTERP_ID to identify a unique breakpoint result growth pattern/dilution result.
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_BPA_INTERP_RESULT


Child Column in MIC_BPA_INTERP_RESULT(FK) Parent Table Name Parent Column Name
Parents: INTERP_ID MIC_BPA_INTERP INTERP_ID




Parent Column in MIC_BPA_INTERP_RESULT (PK) Child Table Name Child Column Name
Children: INTERP_ID MIC_BPA_INTERP_PLATE_RESULT INTERP_ID
SEQUENCE MIC_BPA_INTERP_PLATE_RESULT SEQUENCE


MIC_BPA_PANEL_ORGANISM



Column Section Top of Page


Table-level Detail

Description: Microbiology Breakpoint Panel Organism
Definition: This reference table contains organisms assigned to a Breakpoint QC Panel.
Table Type: REFERENCE





Column Detail - MIC_BPA_PANEL_ORGANISM


Column Name Type Null? Definition
ORGANISM_CD DOUBLE N This field identifies the code value associated with the organism.
PANEL_CD DOUBLE N This field identifies the code value associated with the Breakpoint QC panel.
SEQUENCE DOUBLE Y This field identified the order in which the organisms will display.
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.