Table Detail Report

BR_EVENT_GROUPER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Event Grouper
Definition: Defined groups
Table Type: REFERENCE





Column Detail - BR_EVENT_GROUPER


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BR_EVENT_GROUPER_ID DOUBLE N Unique, generated number that identifies a single row on the BR_EVENT_GROUPER table.
GROUPER_NAME VARCHAR(255) N Name string describing 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_EVENT_GROUPER




Parent Column in BR_EVENT_GROUPER (PK) Child Table Name Child Column Name
Children: BR_EVENT_GROUPER_ID BR_EVENT_GROUPER_RELTN BR_EVENT_GROUPER_ID


BR_EVENT_GROUPER_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Event Grouper Relation
Definition: Event Codes that have been grouped.
Table Type: REFERENCE





Column Detail - BR_EVENT_GROUPER_RELTN


Column Name Type Null? Definition
BR_EVENT_GROUPER_ID DOUBLE N The group that this event code belongs to.
BR_EVENT_GROUPER_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the BR_EVENT_GROUPER_RELTN table.
PARENT_ENTITY_ID DOUBLE N The event that is being grouped
PARENT_ENTITY_NAME VARCHAR(32) N The name of the table where PARENT_ENTITY_ID is sourced 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.



Relationship Detail - BR_EVENT_GROUPER_RELTN


Child Column in BR_EVENT_GROUPER_RELTN(FK) Parent Table Name Parent Column Name
Parents: BR_EVENT_GROUPER_ID BR_EVENT_GROUPER BR_EVENT_GROUPER_ID


BR_EXAM_SEGMENT_INFO



Column Section Top of Page


Table-level Detail

Description: BR_EXAM_SEGMENT_INFO
Definition: Stores orderables of type Radiology and then used to determine dta's that can be associated to the orderables.
Table Type: REFERENCE





Column Detail - BR_EXAM_SEGMENT_INFO


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CATALOG_CD DOUBLE N Unique id for an orderable. Comes from the order_catalog table.
MULTI_SEGMENT_IND DOUBLE Y Indicator set by the user to determine if an orderable can have multiple dta's associated to it.
PRIMARY_MNEMONIC VARCHAR(100) Y Name of the orderable from the order_catalog 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.


BR_FOREIGN_ALIAS



Column Section Top of Page


Table-level Detail

Description: Bedrock Foreign Alias
Definition: Table to store foreign system alias values
Table Type: REFERENCE





Column Detail - BR_FOREIGN_ALIAS


Column Name Type Null? Definition
ACTIVITY_TYPE VARCHAR(40) N The activity type associated to the order catalog item
ALIAS_TYPE VARCHAR(50) N Type of alias
BR_FOREIGN_ALIAS_ID DOUBLE N Unique id for each row
CATALOG_TYPE VARCHAR(40) N Catalog type for the alias
FACILITY VARCHAR(40) N Name of the foreign system facility
INBOUND_ALIAS VARCHAR(255) N Foreign system inbound alias value
INTERFACE_NAME VARCHAR(40) N Name of the foreign system interface
LONG_NAME VARCHAR(100) N Long name of the alias
MATCH_IND DOUBLE N Indicates if a match has been made
OUTBOUND_ALIAS VARCHAR(255) N Foreign system outbound alias value
SHORT_NAME VARCHAR(100) N Short name of the alias
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_FSI



Column Section Top of Page


Table-level Detail

Description: BEDROCK FSI
Definition: FSI Supplier Information
Table Type: REFERENCE





Column Detail - BR_FSI


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ADT_IND DOUBLE Y Define as 1 for ADT indicator
ALLERGY_IND DOUBLE Y Define as 1 for allergy indicator
CHARGE_IND DOUBLE Y Define as 1 for charge indicator
CLAIMS_IND DOUBLE Y Define as 1 for claims indicator
DICTATION_IND DOUBLE Y Define as 1 for dictation indicator
DOCUMENT_IND DOUBLE Y Define as 1 for document indicator
FSI_ID DOUBLE N Unique identifier for the table
FSI_SUPPLIER_NAME VARCHAR(100) Y Supplier name
FSI_SYSTEM_NAME VARCHAR(100) Y System name
IMMUN_IND DOUBLE Y Define as 1 for immunization indicator
MISC_TYPE_DESC VARCHAR(100) Y Define as 1 for misc type description
MISC_TYPE_IND DOUBLE Y Define as 1 for misc type indicator
ORDER_IND DOUBLE Y Define as 1 for order indicator
PHYS_MFN_IND DOUBLE Y Define as 1 for phys mfn indicator
PROBLEM_IND DOUBLE Y Define as 1 for problem indicator
RESULT_IND DOUBLE Y Define as 1 for result indicator
RLI_IND DOUBLE Y Define as 1 for RLI indicator
SCHEDULE_IND DOUBLE Y Define as 1 for schedule indicator
SUPPLY_IND DOUBLE Y Define as 1 for supply indicator
TRANSCRIPTION_IND DOUBLE Y Define as 1 for transcription indicator
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.