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 |