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 |