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