Table Detail Report

BR_DATA_OPS_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: BEDROCK DATA OPS LOG
Definition: BEDROCK OPS LOG DATA
Table Type: REFERENCE





Column Detail - BR_DATA_OPS_LOG


Column Name Type Null? Definition
END_DT_TM DATETIME Y Time process completed
ERROR_MSG VARCHAR(1000) Y Holds error message
EXCEPTION_IND DOUBLE Y Indicates table is not to participate in client fill process
LOGFILE_NAME VARCHAR(40) Y Name of log file, if there's an error
RUN_ID DOUBLE N Foreign key to data_data_ops
SRC_ROW_CNT DOUBLE Y Number of rows selected from start data
START_DT_TM DATETIME Y Time process started
STATUS VARCHAR(30) Y Holds values of COMPLETE, READY_TO_RUN, ERROR, RUNNING
TABLE_NAME VARCHAR(30) N Name of table being processed
TGT_ROWS_WRITTEN DOUBLE Y Number of rows inserted for client
TTL_SRC_TBL_ROWS DOUBLE Y DB Stats for individual table
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_DATA_OPS_LOG


Child Column in BR_DATA_OPS_LOG(FK) Parent Table Name Parent Column Name
Parents: RUN_ID BR_DATA_OPS RUN_ID


BR_DEFAULT_PERSON_SEARCH



Column Section Top of Page


Table-level Detail

Description: Bedrock default person search
Definition: default settings for person search filters and results
Table Type: REFERENCE





Column Detail - BR_DEFAULT_PERSON_SEARCH


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
BR_DEFAULT_PERSON_SEARCH_ID DOUBLE N Unique id for the table
DISPLAY VARCHAR(50) Y name of filter or result
EMPI_IND DOUBLE Y indicator to determine the defaults that are used
SEQUENCE DOUBLE Y orders the display of the filters or results
SETTING_MEAN VARCHAR(20) Y meaning to link types of rows
START_VERSION_NBR DOUBLE Y Identifies which version of start has been loaded
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_DELETE_HIST



Column Section Top of Page


Table-level Detail

Description: Bedrock Delete History
Definition: Stores the primary keys of items that have been deleted. This is for Lighthouse Reporting.
Table Type: ACTIVITY





Column Detail - BR_DELETE_HIST


Column Name Type Null? Definition
BR_DELETE_HIST_ID DOUBLE N Unique, generated number that identifies a single row on the BR_DELETE_HIST table.
CREATE_DT_TM DATETIME N The date that this row was created.
PARENT_ENTITY_ID DOUBLE N The primary key that was deleted.
PARENT_ENTITY_NAME VARCHAR(32) N The table that the primary key being deleted was from.
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_DRUG_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Drug Group
Definition: Method to group drugs. Used in Multiple Drug Resistance Organisms Bedrock Wizard.
Table Type: REFERENCE





Column Detail - BR_DRUG_GROUP


Column Name Type Null? Definition
BR_DRUG_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the BR_DRUG_GROUP table.
DRUG_GROUP_NAME VARCHAR(150) N The name assigned to the drug group.
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




Parent Column in BR_DRUG_GROUP (PK) Child Table Name Child Column Name
Children: BR_DRUG_GROUP_ID BR_DRUG_GROUP_ANTIBIOTIC BR_DRUG_GROUP_ID
BR_DRUG_GROUP_ORGANISM BR_DRUG_GROUP_ID


BR_DRUG_GROUP_ANTIBIOTIC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Drug Group Antibiotic
Definition: Used in Multiple Drug Resistance Organisms Bedrock Wizard. Contains the antibiotics grouped together in a drug_group.
Table Type: REFERENCE





Column Detail - BR_DRUG_GROUP_ANTIBIOTIC


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N The antibiotic that is a part of this drug group.
BR_DRUG_GROUP_ANTIBIOTIC_ID DOUBLE N Unique generated number that identifies a single row on the BR_DRUG_GROUP_ANTIBIOTIC table.
BR_DRUG_GROUP_ID DOUBLE N The drug group that this antibiotic is a part of.
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_ANTIBIOTIC


Child Column in BR_DRUG_GROUP_ANTIBIOTIC(FK) Parent Table Name Parent Column Name
Parents: BR_DRUG_GROUP_ID BR_DRUG_GROUP BR_DRUG_GROUP_ID




Parent Column in BR_DRUG_GROUP_ANTIBIOTIC (PK) Child Table Name Child Column Name
Children: BR_DRUG_GROUP_ANTIBIOTIC_ID BR_ORGANISM_DRUG_RESULT BR_DRUG_GROUP_ANTIBIOTIC_ID