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 |