Table Detail Report

BR_DRUG_GROUP_ORGANISM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Drug Group Organism
Definition: Used in Multiple Drug Resistance Organisms Bedrock Wizard. Contains the organisms that are associated with a drug_group.
Table Type: REFERENCE





Column Detail - BR_DRUG_GROUP_ORGANISM


Column Name Type Null? Definition
BR_DRUG_GROUP_ID DOUBLE N The drug group that this organism is associated with.
BR_DRUG_GROUP_ORGANISM_ID DOUBLE N Unique generated number that identifies a single row on the BR_DRUG_GROUP_ORGANISM table.
BR_MDRO_CAT_ORGANISM_ID DOUBLE N The Organism in this drug group.
DRUG_RESISTANT_CNT DOUBLE N Stores the number of drugs in this group the organism must be resistant to before it is classified as drug-resistant.
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 - BR_DRUG_GROUP_ORGANISM


Child Column in BR_DRUG_GROUP_ORGANISM(FK) Parent Table Name Parent Column Name
Parents: BR_DRUG_GROUP_ID BR_DRUG_GROUP BR_DRUG_GROUP_ID
BR_MDRO_CAT_ORGANISM_ID BR_MDRO_CAT_ORGANISM BR_MDRO_CAT_ORGANISM_ID




Parent Column in BR_DRUG_GROUP_ORGANISM (PK) Child Table Name Child Column Name
Children: BR_DRUG_GROUP_ORGANISM_ID BR_ORGANISM_DRUG_RESULT BR_DRUG_GROUP_ORGANISM_ID


BR_DTA_ALPHA_RESPONSES



Column Section Top of Page


Table-level Detail

Description: BEDROCK DTA ALPHA RESPONSES
Definition: legacy dta alpha respones
Table Type: REFERENCE





Column Detail - BR_DTA_ALPHA_RESPONSES


Column Name Type Null? Definition
AR VARCHAR(40) N The alpha response associated to the legacy assay.
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DEFAULT_IND DOUBLE N Defined as 1 the default indicator is defined.
REFERENCE_IND DOUBLE N Defined as 1 the reference is defined.
RESULT_PROCESSING_TYPE VARCHAR(40) Y Defined as 1 the result processing type is defined.
RRF_ID DOUBLE N Reference range ID.
SEQUENCE DOUBLE N Sequence
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.
USE_UNITS_IND DOUBLE N Defined as 1 the use units is defined.


BR_DTA_DATA_MAP



Column Section Top of Page


Table-level Detail

Description: BEDROCK DTA DATA MAP
Definition: legacy dta data map
Table Type: REFERENCE





Column Detail - BR_DTA_DATA_MAP


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DTA_ID DOUBLE N Legacy assay id.
MAX_DIGITS DOUBLE N The maximum digits in the data map.
MIN_DECIMAL_PLACES DOUBLE N The minimum decimal places in the data map.
MIN_DIGITS DOUBLE N The minimum digits in the data map.
SERVICE_RESOURCE VARCHAR(40) N The legacy service resource associated to the assay data map.
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.


BR_DTA_DELTA



Column Section Top of Page


Table-level Detail

Description: BEDROCK DTA DELTA
Definition: legacy dta delta information
Table Type: REFERENCE





Column Detail - BR_DTA_DELTA


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CHECK_TYPE VARCHAR(40) Y The delta check type
HIGH DOUBLE N The delta high value.
LOW DOUBLE N The delta low value.
MINUTES DOUBLE N The delta check minutes
RRF_ID DOUBLE N Reference range ID.
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 VARCHAR(10) Y The delta value


BR_DTA_EQUIVALENT



Column Section Top of Page


Table-level Detail

Description: BEDROCK DTA EQUIVALENT
Definition: legacy dta equivalents
Table Type: REFERENCE





Column Detail - BR_DTA_EQUIVALENT


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DTA_ID DOUBLE N Legacy assay id.
EQUIVALENT_ID DOUBLE N The equivalent legacy assay id.
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.