Table Detail Report

BR_ORGANISM_DRUG_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Organism Drug Result
Definition: The possible results from the use of an antibiotic for an MDRO.
Table Type: REFERENCE





Column Detail - BR_ORGANISM_DRUG_RESULT


Column Name Type Null? Definition
BR_DRUG_GROUP_ANTIBIOTIC_ID DOUBLE N The antibiotic that applies this result to this organism.
BR_DRUG_GROUP_ORGANISM_ID DOUBLE N The organism that this antibiotic is used for.
BR_ORGANISM_DRUG_RESULT_ID DOUBLE N Unique generated number that identifies a single row on the br_organism_drug_result table.
RESULT_CD DOUBLE N The code value of an interpretation result associated with the drug and the organism. Possible code sets are 64, 10025, and 10027
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_ORGANISM_DRUG_RESULT


Child Column in BR_ORGANISM_DRUG_RESULT(FK) Parent Table Name Parent Column Name
Parents: BR_DRUG_GROUP_ANTIBIOTIC_ID BR_DRUG_GROUP_ANTIBIOTIC BR_DRUG_GROUP_ANTIBIOTIC_ID
BR_DRUG_GROUP_ORGANISM_ID BR_DRUG_GROUP_ORGANISM BR_DRUG_GROUP_ORGANISM_ID


BR_ORGANIZATION



Column Section Top of Page


Table-level Detail

Description: BEDROCK ORGANIZATIONANIZATION
Definition: organization prefixes
Table Type: REFERENCE





Column Detail - BR_ORGANIZATION


Column Name Type Null? Definition
ACUTE_CARE_IND DOUBLE Y org marked as acute care if = 1
BR_CLIENT_ID DOUBLE N *** OBSOLETE ***
BR_PREFIX VARCHAR(5) Y The prefix defined for the organization
ORGANIZATION_ID DOUBLE N identifies the organization
OUTREACH_IND DOUBLE Y org marked as outreach if =1
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_ORG_ALIAS_GROUP



Column Section Top of Page


Table-level Detail

Description: BEDROCK ORGANIZATION ALIAS GROUP
Definition: Grouping table for organizations for alias pool creation
Table Type: REFERENCE





Column Detail - BR_ORG_ALIAS_GROUP


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
ORGANIZATION_ID DOUBLE N Identifies the organization
PARENT_ORG_ID DOUBLE N The id of the organization from which this organization was derived
PATIENT_SEQ DOUBLE N A number defining the grouping of the organization for patient number alias pools
PHYS_SEQ DOUBLE N A number defining the grouping of the organization for physician number alias pools
PROCESS_FLAG DOUBLE Y A flag indicating the processing status of the org alias group
PRSNL_SEQ DOUBLE N A number defining the grouping of the organization for personnel number alias pools
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.
VISIT_SEQ DOUBLE N A number defining the grouping of the organization for visit number alias pools


BR_ORG_WORK



Column Section Top of Page


Table-level Detail

Description: BEDROCK ORGANIZATION WORK
Definition: legacy organizations
Table Type: REFERENCE





Column Detail - BR_ORG_WORK


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
LAB_IND DOUBLE N If the indicator is a 1 then the location is a laboratory, if 0 then it is not
NAME VARCHAR(60) Y name of the organization
ORGANIZATION_ID DOUBLE N identifies the organization
ORG_DISPLAY VARCHAR(50) Y short name of the organization
PREFIX VARCHAR(4) Y prefix name for the org
START_IND DOUBLE N indicates if the org should replace the START org
STATUS_IND DOUBLE N 1 = completed.
TAX_ID_NBR VARCHAR(100) Y tax number of the organization
TIME_ZONE_ID DOUBLE N time zone for the organization
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_OTHER_NAMES



Column Section Top of Page


Table-level Detail

Description: BEDROCK OTHER NAMES
Definition: Common names orderables may also be referred as
Table Type: REFERENCE





Column Detail - BR_OTHER_NAMES


Column Name Type Null? Definition
ALIAS_NAME VARCHAR(100) Y The other name.
ALIAS_NAME_KEY_CAP VARCHAR(100) N The other name in key caps
PARENT_ENTITY_ID DOUBLE N Unique value for the parent entity name table.
PARENT_ENTITY_NAME VARCHAR(32) N Table the other name is associated to
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.