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 |