Table Detail Report

BR_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Group Relation
Definition: Stores a relationship between items and the groups they belong to.
Table Type: REFERENCE





Column Detail - BR_GROUP_RELTN


Column Name Type Null? Definition
BR_GROUP_ID DOUBLE N The group that is related to the other object in this relationship.
BR_GROUP_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the BR_GROUP_RELTN table.
PARENT_ENTITY_ID DOUBLE N The id for the item that belongs in the group.
PARENT_ENTITY_NAME VARCHAR(32) N The name of the table for the item being placed in the 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_GROUP_RELTN


Child Column in BR_GROUP_RELTN(FK) Parent Table Name Parent Column Name
Parents: BR_GROUP_ID BR_GROUP BR_GROUP_ID


BR_HCO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Health Care Organization
Definition: Stores information about HCO numbers, which are unique identifiers issued by the Joint Commission to a healthcare organization.
Table Type: REFERENCE





Column Detail - BR_HCO


Column Name Type Null? Definition
BR_HCO_ID DOUBLE N Unique, generated number that identifies a single row on the BR_HCO table.
HCO_NAME VARCHAR(150) N The name associated with the HCO_NBR.
HCO_NBR DOUBLE N The number assigned by The Joint Commission to a healthcare 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.



Relationship Detail - BR_HCO




Parent Column in BR_HCO (PK) Child Table Name Child Column Name
Children: BR_HCO_ID BR_HCO_LOC_RELTN BR_HCO_ID


BR_HCO_LOC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Health Care Organization Location Relation
Definition: Stores locations associated with an HCO Number.
Table Type: REFERENCE





Column Detail - BR_HCO_LOC_RELTN


Column Name Type Null? Definition
BR_HCO_ID DOUBLE N The HCO related to this location.
BR_HCO_LOC_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the BR_HCO_LOC_RELTN table.
LOCATION_CD DOUBLE N The location associated with this Healthcare 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.



Relationship Detail - BR_HCO_LOC_RELTN


Child Column in BR_HCO_LOC_RELTN(FK) Parent Table Name Parent Column Name
Parents: BR_HCO_ID BR_HCO BR_HCO_ID
LOCATION_CD LOCATION LOCATION_CD


BR_HLTH_SNTRY_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Health Sentry Item
Definition: Data items from Health Sentry.
Table Type: REFERENCE





Column Detail - BR_HLTH_SNTRY_ITEM


Column Name Type Null? Definition
BR_HLTH_SNTRY_ITEM_ID DOUBLE N Unique, generated number that identifies a single row on the BR_HLTH_SNTRY_ITEM table.
CODE_SET DOUBLE N The Millennium code set that this item would map to.
DESCRIPTION_1 VARCHAR(255) Y The first description for this item. From health sentry/health facts mapping.
DESCRIPTION_2 VARCHAR(255) Y The second description for this item. From health sentry/health facts mapping.
DESCRIPTION_3 VARCHAR(255) Y The third description for this item. From health sentry/health facts mapping.
DESCRIPTION_4 VARCHAR(255) Y The fourth description for this item. From health sentry/health facts mapping.
DESCRIPTION_5 VARCHAR(255) Y The fifth description for this item. From health sentry/health facts mapping.
DESCRIPTION_6 VARCHAR(255) Y The sixth description for this item. From health sentry/health facts mapping.
DIM_ITEM_IDENT DOUBLE N Identifier of the item in the Health Sentry/Health Facts dimension tables.
IGNORE_IND DOUBLE N Indicates if this item needs to be mapped or if the user elected to ignore it.
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_HLTH_SNTRY_ITEM




Parent Column in BR_HLTH_SNTRY_ITEM (PK) Child Table Name Child Column Name
Children: BR_HLTH_SNTRY_ITEM_ID BR_HLTH_SNTRY_MILL_ITEM BR_HLTH_SNTRY_ITEM_ID


BR_HLTH_SNTRY_MILL_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Health Sentry Millennium Item
Definition: Stores the relationships between Health Sentry items and Millennium items.
Table Type: REFERENCE





Column Detail - BR_HLTH_SNTRY_MILL_ITEM


Column Name Type Null? Definition
BR_HLTH_SNTRY_ITEM_ID DOUBLE N The Health Sentry item that is related to this Millennium item.
BR_HLTH_SNTRY_MILL_ITEM_ID DOUBLE N Unique, generated number that identifies a single row on the BR_HLTH_SNTRY_MILL_ITEM table.
CODE_VALUE DOUBLE N The Millennium item that maps to the Health Sentry item on a row.
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_HLTH_SNTRY_MILL_ITEM


Child Column in BR_HLTH_SNTRY_MILL_ITEM(FK) Parent Table Name Parent Column Name
Parents: BR_HLTH_SNTRY_ITEM_ID BR_HLTH_SNTRY_ITEM BR_HLTH_SNTRY_ITEM_ID