Table Detail Report

BR_MDRO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Multi-drug resistant organism
Definition: Stores the base information about an MDRO.
Table Type: REFERENCE





Column Detail - BR_MDRO


Column Name Type Null? Definition
BR_MDRO_ID DOUBLE N Unique, generated number that identifies a single row on the BR_MDRO table.
MDRO_NAME VARCHAR(100) N Name of the multi-drug resistant organism.
MDRO_NAME_KEY VARCHAR(100) N Name of MDRO formatted in all upper case.
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_MDRO




Parent Column in BR_MDRO (PK) Child Table Name Child Column Name
Children: BR_MDRO_ID BR_MDRO_CAT_EVENT BR_MDRO_ID
BR_MDRO_CAT_ORGANISM BR_MDRO_ID


BR_MDRO_CAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Multiple Drug Resistance Organism Category
Definition: Stores MDRO Category information, used in Multiple Drug Resistance Organisms (MDRO) Bedrock Wizard
Table Type: REFERENCE





Column Detail - BR_MDRO_CAT


Column Name Type Null? Definition
BR_MDRO_CAT_ID DOUBLE N Unique generated number that identifies a single row on the BR_MDRO_CAT table.
CAT_TYPE_FLAG DOUBLE N "This field indicates whether the category is Organism - Specific or NHSN Type. 0 - NHSN , 1 - Organism - Specific."
MDRO_CAT_NAME VARCHAR(150) N Stores the name assigned to the category.
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_MDRO_CAT




Parent Column in BR_MDRO_CAT (PK) Child Table Name Child Column Name
Children: BR_MDRO_CAT_ID BR_MDRO_CAT_EVENT BR_MDRO_CAT_ID
BR_MDRO_CAT_ORGANISM BR_MDRO_CAT_ID
LH_CNT_IC_MICRO_EVENT MDRO_CAT_ID


BR_MDRO_CAT_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Multiple Drug Resistance Organism Category Event
Definition: Stores information about Events and their Multiple Drug Resistance Organism categories.
Table Type: REFERENCE





Column Detail - BR_MDRO_CAT_EVENT


Column Name Type Null? Definition
BR_MDRO_CAT_EVENT_ID DOUBLE N Unique generated number that identifies a single row on the BR_MDRO_CAT_EVENT table.
BR_MDRO_CAT_ID DOUBLE N Stores Category ID of the Category this Event CD is associated to.
BR_MDRO_ID DOUBLE N A pointer to the name and other base information of the MDRO.
EVENT_CD DOUBLE N Stores Code value of the Event cd (Serology Results) that is defined as Multiple Drug Resistant."
LOCATION_CD DOUBLE N Indicates the MDRO category and event combination is only valid for the given location code_value.
LOOKBACK_TIME_SPAN_NBR DOUBLE N Time period used for building a worklist.
LOOKBACK_TIME_SPAN_UNIT_CD DOUBLE N The unit of measure for the lookback time span.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - BR_MDRO_CAT_EVENT


Child Column in BR_MDRO_CAT_EVENT(FK) Parent Table Name Parent Column Name
Parents: BR_MDRO_ID BR_MDRO BR_MDRO_ID
BR_MDRO_CAT_ID BR_MDRO_CAT BR_MDRO_CAT_ID
LOCATION_CD LOCATION LOCATION_CD




Parent Column in BR_MDRO_CAT_EVENT (PK) Child Table Name Child Column Name
Children: BR_MDRO_CAT_EVENT_ID BR_CAT_EVENT_NORMALCY BR_MDRO_CAT_EVENT_ID


BR_MDRO_CAT_ORGANISM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Multiple Drug Resistance Organism Category Organism
Definition: Stores information about Multiple Drug Resistance Organisms and their Category information , used in Multiple Drug Resistance Organisms (MDRO) Bedrock Wizard.
Table Type: REFERENCE





Column Detail - BR_MDRO_CAT_ORGANISM


Column Name Type Null? Definition
ANTIBIOTICS_TXT VARCHAR(500) N A string representation of the antibiotics that are used for this MDRO.
BR_MDRO_CAT_ID DOUBLE N Stores Category ID of the Category this Organism is associated to.
BR_MDRO_CAT_ORGANISM_ID DOUBLE N Unique generated number that identifies a single row on the BR_MDRO_CAT_ORGANISM table.
BR_MDRO_ID DOUBLE N A pointer to the name and other base information of the MDRO.
GROUP_RESISTANT_CNT DOUBLE N Stores the number of Drug Groups this organism must be resistant to before it is classified as drug-resistant.
LOCATION_CD DOUBLE N Indicates the MDRO category and organism combination is only valid for the given location code_value.
LOOKBACK_TIME_SPAN_NBR DOUBLE N Time period used for building a worklist.
LOOKBACK_TIME_SPAN_UNIT_CD DOUBLE N The unit of measure for the lookback time span.
ORGANISM_CD DOUBLE N The organism that is defined as multiple-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_MDRO_CAT_ORGANISM


Child Column in BR_MDRO_CAT_ORGANISM(FK) Parent Table Name Parent Column Name
Parents: BR_MDRO_ID BR_MDRO BR_MDRO_ID
BR_MDRO_CAT_ID BR_MDRO_CAT BR_MDRO_CAT_ID
LOCATION_CD LOCATION LOCATION_CD




Parent Column in BR_MDRO_CAT_ORGANISM (PK) Child Table Name Child Column Name
Children: BR_MDRO_CAT_ORGANISM_ID BR_DRUG_GROUP_ORGANISM BR_MDRO_CAT_ORGANISM_ID


BR_MDRO_OUTBREAK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Multi-drug Resistant Organism Outbreak
Definition: Defines facility and unit thresholds that will determine whether there is an "outbreak" of a particular MDRO.
Table Type: REFERENCE





Column Detail - BR_MDRO_OUTBREAK


Column Name Type Null? Definition
BR_MDRO_OUTBREAK_ID DOUBLE N Unique generated number that identifies a single row on the br_mdro_outbreak table.
FACILITY_OCCURRENCE_CNT DOUBLE N Number of occurrences at a facility that must be within the facility_time_span to be an outbreak.
FACILITY_TIME_SPAN_NBR DOUBLE N Time span at a facility over which facility_occurrence_cnt must be reached to be an outbreak.
FACILITY_TIME_SPAN_UNIT_CD DOUBLE N The facility time span units of measure.
LOCATION_CD DOUBLE N The location for which this outbreak definition is applicable.
PARENT_ENTITY_ID DOUBLE N The id from the parent_entity_name table.
PARENT_ENTITY_NAME VARCHAR(32) N Name of the parent entity table, which defines the type of outbreak. Valid tables are br_mdro_name, br_mdro_cat, br_mdro_cat_event, br_mdro_cat_organism.
PROBABILITY_THEORY_IND DOUBLE N Indicates whether or not to use probability theory.
UNIT_OCCURRENCE_CNT DOUBLE N Number of occurrences at a unit that must be within the unit_time_span to be an outbreak.
UNIT_TIME_SPAN_NBR DOUBLE N Time span at a unit over which unit_occurrence_cnt must be reached to be an outbreak.
UNIT_TIME_SPAN_UNIT_CD DOUBLE N The unit time span units of measure.
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_MDRO_OUTBREAK


Child Column in BR_MDRO_OUTBREAK(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD