Table Detail Report

BR_AUTO_RLI_SYNONYM



Column Section Top of Page


Table-level Detail

Description: Bedrock Auto RLI Synonym
Definition: stores additional synonyms for each reference lab orderable item
Table Type: REFERENCE





Column Detail - BR_AUTO_RLI_SYNONYM


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
RLI_ORDER_ID DOUBLE N stores the id of the related parent row on the br_auto_rli_order table
SUPPLIER_FLAG DOUBLE N stores the value identifying the reference lab interface
SYNONYM_NAME VARCHAR(100) Y Name of the synonym
SYNONYM_SEQ DOUBLE N a sequence number used to make the row unique
SYNONYM_TYPE_FLAG DOUBLE Y stores a flag value identifying the synonym type
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_BB_MODEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: BR_BB_MODEL
Definition: Stores proposed models for bloodbank aliasing
Table Type: REFERENCE





Column Detail - BR_BB_MODEL


Column Name Type Null? Definition
BR_BB_MODEL_ID DOUBLE N Unique id for the row
MODEL_CD DOUBLE N Code value from code set 73 if the proposed model has a millennium match
MODEL_NAME VARCHAR(60) N Name of the proposed model
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_BB_MODEL




Parent Column in BR_BB_MODEL (PK) Child Table Name Child Column Name
Children: BR_BB_MODEL_ID BR_BB_MODEL_ALIAS BR_BB_MODEL_ID


BR_BB_MODEL_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: BR_BB_MODEL_ALIAS
Definition: Stores proposed alias for bloodbank models
Table Type: REFERENCE





Column Detail - BR_BB_MODEL_ALIAS


Column Name Type Null? Definition
ABORH_CD DOUBLE N Code value from code set 1640 for a matching aborh
BR_BB_MODEL_ALIAS VARCHAR(40) N Name of the bloodbank aborh alias
BR_BB_MODEL_ALIAS_ID DOUBLE N Unique id for the row
BR_BB_MODEL_ID DOUBLE N Id from the br_bb_model 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.



Relationship Detail - BR_BB_MODEL_ALIAS


Child Column in BR_BB_MODEL_ALIAS(FK) Parent Table Name Parent Column Name
Parents: BR_BB_MODEL_ID BR_BB_MODEL BR_BB_MODEL_ID


BR_BB_PRODCAT



Column Section Top of Page


Table-level Detail

Description: Bedrock Blood Bank Product Category
Definition: Blood bank transfusion product reference data.
Table Type: REFERENCE





Column Detail - BR_BB_PRODCAT


Column Name Type Null? Definition
ABORH_CONF_REQ_IND DOUBLE Y Indicates whether aborh confirmation is required.
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.
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.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ALTERNATE_ID_IND DOUBLE Y Indicates whether an alternate id number is required.
AUTOBUILD_IND DOUBLE N Indicates if value is part of autobuild
BR_CLIENT_ID DOUBLE N Identifies which bedrock client the data belongs to.
COMP_TAG_REQ_IND DOUBLE Y Indicates whether a component tag must be print
DESCRIPTION VARCHAR(100) Y Product category description.
DISPLAY VARCHAR(100) Y Display name of the product category.
NEW_PRODCAT_IND DOUBLE N Indicator used to define whether the product category was added during the current wizard conversation.
PILOT_LABEL_REQ_IND DOUBLE Y Indicates whether a pilot label must be printed.
PRODCAT_CD DOUBLE N Product category code value.
PRODCAT_ID DOUBLE N Unique identifier for the table.
PRODUCT_CLASS_MEAN VARCHAR(100) Y CDF meaning of the category's product class.
PROMPT_FOR_VOL_IND DOUBLE Y Indicates whether the system will prompt for the unit volume.
RED_CELL_IND DOUBLE Y Indicates whether this is a red cell product.
RH_REQ_IND DOUBLE Y Indicates whether this is an RH required product.
SEG_NUM_IND DOUBLE Y Indicates whether the system will prompt for a segment number.
SELECTED_IND DOUBLE Y Indicates whether the product category has been selected in the Wizard.
SHIP_COND_DEF VARCHAR(100) Y Default shipping condition for the products in the category.
START_VERSION_NBR DOUBLE N Indicates which version of start has been loaded.
UOM_DEF VARCHAR(100) Y Default unit of measure for the products in the category.
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.
VAL_COMPAT_IND DOUBLE Y Indicates whether compatibility validation is required.
XM_REQ_IND DOUBLE Y Indicates whether a crossmatch is required.
XM_TAG_REQ_IND DOUBLE Y Indicates whether a crossmatch tag must be printed.


BR_BB_PRODUCT



Column Section Top of Page


Table-level Detail

Description: BEDROCK BLOOD BANK PRODUCT
Definition: Blood bank transfusion product reference data.
Table Type: REFERENCE





Column Detail - BR_BB_PRODUCT


Column Name Type Null? Definition
ABORH_CONF_TEST_NAME VARCHAR(100) Y Name (Synonym) of the ABORH confirmation test.
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.
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.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ALIQUOT_IND DOUBLE N Indicates if value has an aliquot
AUTOBUILD_IND DOUBLE N Indicates if value is part of autobuild
AUTO_IND DOUBLE Y Indicates whether the product is an autologous product.
BAR_CODE_VAL VARCHAR(100) Y Bar code value for product identification.
BR_CLIENT_ID DOUBLE N Identifies which bedrock client the data belongs to
CALC_EXP_FROM_DRAW_IND DOUBLE Y Indicates whether the product expiration date should be calculated from the drawn date.
DEF_STORAGE_TEMP VARCHAR(100) Y Default storage temperature for this product.
DEF_SUPPLIER VARCHAR(100) Y Default supplier for the product.
DESCRIPTION VARCHAR(100) Y Long description for the product.
DIRECTED_IND DOUBLE Y Indicates whether the product is a directed donation product.
DISPENSE_IND DOUBLE Y Indicates whether the product can be dispensed.
DISPLAY VARCHAR(100) Y Display value for the product.
INT_UNITS_IND DOUBLE Y Indicates whether international units are applicable for this product.
MAX_EXP_UNIT VARCHAR(100) Y Hours or Days - the units of time before the product expires.
MAX_EXP_VAL DOUBLE Y The value of the unit of time before the product expires.
MIN_BEF_QUAR DOUBLE Y Number of minutes before the product is quarantined.
PRODCAT_ID DOUBLE N Identifier for the product category to which this product is related.
PRODUCT_CD DOUBLE N Code value for the product.
PRODUCT_ID DOUBLE N Unique identifier for the table.
SELECTED_IND DOUBLE Y Indicates whether the product has been selected.
START_VERSION_NBR DOUBLE N Identifies which version of start has been loaded.
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.
VALIDATE_ANTIBODY_IND DOUBLE Y Indicates whether antibody validation is required for the product.
VALIDATE_TRANSF_REQ_IND DOUBLE Y Indicates whether transfusion requirements must be validated.
VOLUME_DEF DOUBLE Y Default volume for the product.