Table Detail Report

MIC_BPA_PLATE_WELL



Column Section Top of Page


Table-level Detail

Description: Microbiology Breakpoint Plate Well
Definition: This reference table contains row and column positions for a Breakpoint plate definition.
Table Type: REFERENCE





Column Detail - MIC_BPA_PLATE_WELL


Column Name Type Null? Definition
COLUMN_POSITION DOUBLE N This field defines active well positions. This field is used in conjunction with the ROW_POSITION column.
PLATE_CD DOUBLE N This field identifies the code value associated with the Breakpoint Plate Definition.
ROW_POSITION DOUBLE N This field defines active well positions. This field is used in conjunction with the COLUMN_POSITION column.
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_SUS_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Breakpoint Susceptibility Result
Definition: This table stores the microbiology breakpoint susceptibility results.
Table Type: ACTIVITY





Column Detail - MIC_BPA_SUS_RESULT


Column Name Type Null? Definition
ACTIVE_WELL_IND DOUBLE Y Indicates whether the individual well is active or not.
ANTIBIOTIC_CD DOUBLE N Internal identification code for the susceptibility antibiotic. (CS 1011)
ANTIBIOTIC_PLATE_CD DOUBLE N Internal identification code for the breakpoint antibiotic plate. (CS 28082)
BPA_RESULT_CD DOUBLE N Internal identification code for the breakpoint susceptibility result. (CS 28083)
LOCKED_RESULT_IND DOUBLE Y Indicates whether the result can be updated or not.
PANEL_CD DOUBLE N Internal identification code for the susceptibility panel.(CS 1010)
PARENT_ENTITY_ID DOUBLE N Unique ID to the PARENT_ENTITY_NAME table.
PARENT_ENTITY_NAME VARCHAR(32) N Table to which this row is linked.
RESULT_DT_TM DATETIME N The date/time the breakpoint result was last updated
RESULT_PRSNL_ID DOUBLE N The internal identification code for the personnel who last updated the 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_SUS_RESULT


Child Column in MIC_BPA_SUS_RESULT(FK) Parent Table Name Parent Column Name
Parents: RESULT_PRSNL_ID PRSNL PERSON_ID


MIC_BPA_WORKLIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Breakpoint Worklist
Definition: Stores the "parent-level" criteria for Microbiology BPA Worklists.
Table Type: ACTIVITY





Column Detail - MIC_BPA_WORKLIST


Column Name Type Null? Definition
BEGIN_TASK_DT_TM DATETIME Y User-defined date/time which will be used to autogenerate the worklist details.
DESCRIPTION VARCHAR(60) Y Description of the worklist
DISPLAY VARCHAR(40) N Display value of the worklist
FINALIZED_IND DOUBLE Y Indicates whether of not the worklist has been finalized
GROUP_BIOCHEMICAL_CD DOUBLE N The internal identification code for the group biochemical that will be used in the worklist. (CS 1002)
PLATE_CD DOUBLE N The internal identification code for the plate definition. (CS 28081)
QC_PANEL_CD DOUBLE N The internal identification code for the QC panel that will be used in the worklist. (CS 28080)
SUSCEPTIBILITY_METHOD_CD DOUBLE N The internal identification code for the susceptibility method that will be used in the worklist. (CS 65)
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.
WORKLIST_DT_TM DATETIME N User-defined date associated with the worklist
WORKLIST_ID DOUBLE N Internal identification code assigned to each breakpoint worklist.



Relationship Detail - MIC_BPA_WORKLIST




Parent Column in MIC_BPA_WORKLIST (PK) Child Table Name Child Column Name
Children: WORKLIST_ID MIC_BPA_WORKLIST_DETAIL WORKLIST_ID
MIC_BPA_WORKLIST_PANEL WORKLIST_ID


MIC_BPA_WORKLIST_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Breakpoint Worklist Detail
Definition: Stores the details (tasks and qc organisms) for a specific worklist.
Table Type: ACTIVITY





Column Detail - MIC_BPA_WORKLIST_DETAIL


Column Name Type Null? Definition
ACTIVE_WELL_IND DOUBLE Y Indicates whether the well are active or not.
PARENT_ENTITY_ID DOUBLE N This field contains the primary identifier for the parent table.
PARENT_ENTITY_NAME VARCHAR(32) N This field contains the table name of the parent.
PLATE DOUBLE N The breakpoint plate number assigned to the worklist detail.
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.
WELL DOUBLE N The breakpoint well number assigned to the worklist detail.
WORKLIST_COMMENT VARCHAR(250) Y Stores the internal comment for an individual worklist detail.
WORKLIST_DETAIL_ID DOUBLE N Internal identification code assigned to each breakpoint worklist detail.
WORKLIST_ID DOUBLE N Internal identification code assigned to each breakpoint worklist.



Relationship Detail - MIC_BPA_WORKLIST_DETAIL


Child Column in MIC_BPA_WORKLIST_DETAIL(FK) Parent Table Name Parent Column Name
Parents: WORKLIST_ID MIC_BPA_WORKLIST WORKLIST_ID


MIC_BPA_WORKLIST_PANEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Breakpoint Worklist Panel
Definition: This table stores the susceptibility panel(s) associated with an individual breakpoint worklist.
Table Type: ACTIVITY





Column Detail - MIC_BPA_WORKLIST_PANEL


Column Name Type Null? Definition
PANEL_CD DOUBLE N Internal identification code for the susceptibility panel. (CS 1010)
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.
WORKLIST_ID DOUBLE N Internal identification code assigned to each breakpoint worklist.



Relationship Detail - MIC_BPA_WORKLIST_PANEL


Child Column in MIC_BPA_WORKLIST_PANEL(FK) Parent Table Name Parent Column Name
Parents: WORKLIST_ID MIC_BPA_WORKLIST WORKLIST_ID