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. |