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. |