Table Detail Report

BR_INSTR



Column Section Top of Page


Table-level Detail

Description: BEDROCK INTSTRUMENT
Definition: list of supported instruments
Table Type: REFERENCE





Column Detail - BR_INSTR


Column Name Type Null? Definition
ACTIVITY_TYPE_MEAN VARCHAR(12) Y Activity type meaning
BI_IND DOUBLE N Defined as 1 bidirectional indicator
BR_INSTR_ID DOUBLE N Unique table identifier
CODE_NAME VARCHAR(40) Y Coded name for the instrument
HQ_IND DOUBLE N Define as 1 hq indicator
MANUFACTURER VARCHAR(100) N Manufacturer of the instrument
MANUFACTURER_ALIAS VARCHAR(50) Y Manufacturer alias
MODEL VARCHAR(100) N model of the instrument
MODEL_ALIAS VARCHAR(50) Y Model alias
MULTIPLEXOR_IND DOUBLE N indicates if the instrument is a multiplexor
POINT_OF_CARE_IND DOUBLE N Defined as 1 point of care indicator
PREV_MANUFACTURER VARCHAR(100) Y filled in if the instrument used to be manufactured by someone else
ROBOTICS_IND DOUBLE N indicates if the instrument has robotics
TYPE VARCHAR(50) N Kind of instrument
UNI_IND DOUBLE N Defined as 1 unidirectional 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.


BR_INSTR_ORG_RELTN



Column Section Top of Page


Table-level Detail

Description: BEDROCK INTSTRUMENT ORGANIZATION RELATIONSHIP
Definition: instruments for each organization
Table Type: REFERENCE





Column Detail - BR_INSTR_ORG_RELTN


Column Name Type Null? Definition
ACTIVITY_TYPE_MEAN VARCHAR(12) Y the activity type meaning indicating where/how the instrument is used (i.e. chemistry)
BI_IND DOUBLE N indicates if instrument is bi-directional
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
BR_INSTR_ID DOUBLE N Identifies the instrument being associated to an org - from br_instr table
BR_INSTR_ORG_RELTN_ID DOUBLE N BEDROCK INSTR ORGANIZATION RELATION IDENTIFIER value
HQ_IND DOUBLE N indicates if instrument is hq
INTERFACE_IND DOUBLE N indicates if there is an interface to this instrument or not
MANUFACTURER VARCHAR(100) Y manufacturer of the instrument - from the br_instr table
MODEL VARCHAR(100) Y model of the instrument - from the br_instr table
MODEL_DISP VARCHAR(100) Y the display value of the model of instrument
MULTIPLEXOR_IND DOUBLE N indicates if the instrument is a multiplexor
ORGANIZATION_ID DOUBLE N the id of the organization that the instrument is associated with
POC_IND DOUBLE N indicates if instrument is a point-of-care instrument
ROBOTICS_IND DOUBLE N indicates if the instrument has robotics
TYPE VARCHAR(50) Y type of instrument - from the br_instr table
UNI_IND DOUBLE N indicates instrument is uni-directional
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_LEGACY_SR



Column Section Top of Page


Table-level Detail

Description: BR LEGACY SR
Definition: Stores relationships between Service Resources and the DTAs.
Table Type: REFERENCE





Column Detail - BR_LEGACY_SR


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.
BR_CLIENT_ID DOUBLE N Bedrock Client ID from BR_CLIENT
SERVICE_RESOURCE VARCHAR(40) N The Service Resource Description
SR_ID DOUBLE N Service Resource ID from BR_SERVICE_RESOURCE
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.


BR_LOC_WORK



Column Section Top of Page


Table-level Detail

Description: BEDROCK LOCATION WORK
Definition: legacy locations
Table Type: REFERENCE





Column Detail - BR_LOC_WORK


Column Name Type Null? Definition
ADDRESS1 VARCHAR(100) Y address of the location
ADDRESS2 VARCHAR(100) Y optional second line for address
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CITY VARCHAR(100) Y city the facility is in
COUNTRY_CD DOUBLE N country the facility is in
COUNTY_CD DOUBLE N county the facility is in
EXTENSION VARCHAR(100) Y Telephone extension
LOCATION_ID DOUBLE N Unique identifier for the table
LOC_DISPLAY VARCHAR(50) Y short name of the location
NAME VARCHAR(60) Y name of the location
ORGANIZATION_ID DOUBLE N identifies the organization the location is tied to
OUTREACH_IND DOUBLE N indicates if the facility is an outreach facility
PHONE VARCHAR(50) Y phone number of the facility
PREFIX VARCHAR(6) Y The location prefix.
SEQUENCE DOUBLE N Sequence
STATE_CD DOUBLE N state the facility is in
TYPE VARCHAR(30) Y type of location
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.
ZIP VARCHAR(25) Y zip code of the facility


BR_LONG_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: BEDROCK LONG TEXT
Definition: bedrock long text
Table Type: REFERENCE





Column Detail - BR_LONG_TEXT


Column Name Type Null? Definition
LONG_TEXT LONGTEXT Y The long text description.
LONG_TEXT_ID DOUBLE N Unique identifier for the table
PARENT_ENTITY_ID DOUBLE N The id for the value on the parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(32) N The table the long text is associated to.
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_LONG_TEXT




Parent Column in BR_LONG_TEXT (PK) Child Table Name Child Column Name
Children: LONG_TEXT_ID BR_BP_ACTIVITY BR_LONG_TEXT_ID
BR_BP_ACT_GROUP BR_LONG_TEXT_ID
BR_BP_ACT_LONG_DESC BR_LONG_TEXT_ID