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