BBHIST_PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Historical Product
Definition: This activity table is a smaller version of the Product table, and is intended to store products loaded in from previous systems. It will also be used in the future to store purged products from thelive inventory.(from the Product table).
Table Type: ACTIVITY





Column Detail - BBHIST_PRODUCT


Column Name Type Null? Definition
ABO_CD DOUBLE N This number represents the ABO blood group of the product, ex. "O", "A", etc. This column will be empty for derivative products.
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.
ACTIVE_STATUS_DT_TM DATETIME Y 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_NBR VARCHAR(20) Y This column can be used to record the original number labeled on the bag of blood, in the case of sites who choose to re-number blood products received from their supplier. This way they can still track the product by its original number, which is important in the for look-backs.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CROSS_REFERENCE VARCHAR(40) Y This column is a free-text one that allows a history upload to fill this column with some value that cross-references it to a record on the previous system for the same blood product or derivative. In the case of HNA Classic as the previous system, the unique unit number from the Blood Inventory file (BI01-unit-nbr1) would be in this column.
DONOR_XREF_TXT VARCHAR(40) N This is a free-text column that allows a donor history upload to populate this column with a cross-reference value that uniquely identifies the donor in the previous contributor system.
EXPIRE_DT_TM DATETIME N Defines the date/time when the product expired.
FLAG_CHARS CHAR(2) Y Stores the flag characters of an uploaded ISBT- 128 donation number. The flag characters are used to convey specific information other than the unique identification of the product. The three provided types of flag characters represent process control (with ISBT 128-defined meaning), process control (with a local blood center-defined meaning), or data transmission check.
INV_AREA_CD DOUBLE N Identifies the code value for the current inventory area where the product resides. This inventory area is any area that keeps blood products or derivatives in an inventory, from which the products are dispensed. This means that the it could be the main blood bank, or a surgical area or emergency room that stocks blood for use in surgery. This column is optional, ex. in the case of sites with only one blood bank on the system.
MODIFIED_PRODUCT_ID DOUBLE N This column represents the PRODUCT_ID of the original product from which this product was created through product modification. The product_id is the primary key of the BBHIST_PRODUCT table. It is an internal system-assigned number that uniquely identifies a product in the blood bank.
MODIFIED_PRODUCT_IND DOUBLE Y Indicates whether the product has been modified after it was received into the blood bank's inventory. This indicator is only updated on the "parent" product, not the new "child" products created from the original parent product.
OWNER_AREA_CD DOUBLE N Identifies the code value for the blood bank owner area where the product resided. This owner area is a fully-functioning blood bank that is responsible for the blood received or drawn there. A blood bank owner area can have several inventory areas within it. An example of an owner area would be "General Hospital North", with its inventory areas being "Main BB - GH North", "Surgery - GH North", and "ER - GH North"
POOLED_PRODUCT_ID DOUBLE N This column represents the PRODUCT_ID of the new pooled product into which this product was pooled through the pooling process. The product_id is the primary key of the BBHIST_PRODUCT table. It is an internal system-assigned number that uniquely identifies a product in the blood bank.
POOLED_PRODUCT_IND DOUBLE Y Indicates whether the product is a pooled product, i.e.., a product that was created through the pooling process. This indicator should only exist on the newly created product, not the products that were components within the pool.
PRODUCT_CD DOUBLE N The type of product (ex. "Fresh Frozen Plasma") which was on the label of the bag of blood.
PRODUCT_CLASS_CD DOUBLE N The class of products to which this specific type of product belongs. Two classes of products may be used: blood products and derivatives.
PRODUCT_ID DOUBLE N An internal system-assigned number that ensures the uniqueness of every row on this table.
PRODUCT_NBR VARCHAR(20) N The number assigned to this product to identify it. Also known as "unit number". It is the number that is on the bag of blood products to identify it. In the case of derivative products, it is the lot number from the batch of derivatives.
PRODUCT_NBR_FORMAT_CD DOUBLE N Stores the uploaded product's number format (ISBT, Eurocode, None, etc.)
PRODUCT_SUB_NBR CHAR(5) Y A letter or number assigned to each product with the same product number, in order to make them unique. An example is splitting red blood cells into smaller bags of red cells. The sub number is assigned as "1", "2", "3", etc. or as "A", "B", "C", etc.
RH_CD DOUBLE N The code value which represents the Rh for this blood product (ex. "Pos", "Neg"). This column will be empty for derivative products.
SUPPLIER_ID DOUBLE N This column represents an organization_ID, which is the primary key to the ORGANIZATION table. It is an internal system-assigned number. It identifies the supplier of this product, the organization who sent the product to the transfusion service, ex. "American Red Cross".
SUPPLIER_PREFIX CHAR(5) Y This column may be empty. It represents the FDA originating supplier prefix on this bag of blood, i.e., the donor center where the blood was originally drawn from the blood donor. An example is "09", which becomes part of the product number, e.g., "09G12345".
UNIT_MEAS_CD DOUBLE N The unit of measure in which this product's volume was recorded, ex. "ML".
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.
UPLOAD_DT_TM DATETIME N The date and time the history product upload occurred.
VOLUME DOUBLE Y Indicates the final volume for this blood product at the time it was disposed of.



Relationship Detail - BBHIST_PRODUCT


Child Column in BBHIST_PRODUCT(FK) Parent Table Name Parent Column Name
Parents: MODIFIED_PRODUCT_ID BBHIST_PRODUCT PRODUCT_ID
POOLED_PRODUCT_ID BBHIST_PRODUCT PRODUCT_ID
SUPPLIER_ID ORGANIZATION ORGANIZATION_ID




Parent Column in BBHIST_PRODUCT (PK) Child Table Name Child Column Name
Children: PRODUCT_ID BBHIST_PRODUCT MODIFIED_PRODUCT_ID
BBHIST_PRODUCT POOLED_PRODUCT_ID
PRODUCT_NOTE BBHIST_PRODUCT_ID


BBHIST_PRODUCT_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank History Product Event
Definition: This activity table is a smaller version of the Product_Event table, and is intended to store disposition information on products loaded in from previous systems.
Table Type: ACTIVITY





Column Detail - BBHIST_PRODUCT_EVENT


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.
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.
BAG_RETURNED_IND DOUBLE Y Indicates whether or not the empty bag was returned to the blood bank from the patient's location after it was transfused.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EVENT_DT_TM DATETIME N The date and time when this event occurred.
EVENT_TYPE_CD DOUBLE N The type of event that occurred with the product. Pre-defined values by Cerner. Examples are: crossmatched, assigned, dispensed, etc.
INTERNATIONAL_UNIT DOUBLE Y The number of international units associated with this event.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRODUCT_EVENT_ID DOUBLE N The primary key of this table. An internal system-assigned number that makes each row unique.
PRODUCT_ID DOUBLE N The primary key of this table. An internal system-assigned number that makes each row unique.
PRSNL_ID DOUBLE N Represents the person who updated this product to its final disposition state.
QTY DOUBLE Y This column applies only to derivative products. It is the quantity of the derivative batch that was transfused.
REASON_CD DOUBLE N The reason this product was disposed of.
TAG_RETURNED_IND DOUBLE Y Indicates whether the tag attached to the bag dispensed was returned to the blood bank following the transfusion.
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.
VOLUME DOUBLE Y The volume of the product that was actually infused into the patient. This amount may not be the entire volume that was in the bag.



Relationship Detail - BBHIST_PRODUCT_EVENT


Child Column in BBHIST_PRODUCT_EVENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID


BBHIST_SPECIAL_TESTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Special Testing History
Definition: This table is used to store antigens from a product history upload.
Table Type: ACTIVITY





Column Detail - BBHIST_SPECIAL_TESTING


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.
ACTIVE_STATUS_DT_TM DATETIME Y 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.
BBHIST_SPECIAL_TESTING_ID DOUBLE N An internal system-assigned number that ensures the uniqueness of each row.
PRODUCT_ID DOUBLE N The primary key to the bbhist_product table. An internal system-assigned number. On this table, it identifies the product for which special testing (antigens or attribute) has been recorded.
SPECIAL_TESTING_CD DOUBLE N Defines the special testing item (antigen or attribute) that was recorded on the product from the upload.
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 - BBHIST_SPECIAL_TESTING


Child Column in BBHIST_SPECIAL_TESTING(FK) Parent Table Name Parent Column Name
Parents: SPECIAL_TESTING_CD CODE_VALUE CODE_VALUE


BB_UPLOAD_LONG_TEXT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: BB Upload Long Text
Definition: This table will be used in the case where multiple review documentation and actions are added to an upload review
Table Type: ACTIVITY





Column Detail - BB_UPLOAD_LONG_TEXT_R


Column Name Type Null? Definition
ACTION_CD DOUBLE N This value is from a code value from the code set 27942 BB Review Queue action, which indicates the action taken by the reviewer
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.
ACTIVE_STATUS_DT_TM DATETIME Y 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.
BB_UPLOAD_LONG_TEXT_R_ID DOUBLE N An internal system-assigned number that ensures the uniqueness of each row
BB_UPLOAD_REVIEW_ID DOUBLE N This is the value of the unique identifier to the bb_upload_review table
LONG_TEXT_ID DOUBLE N This is the value of the unique identifier for the long_text 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 - BB_UPLOAD_LONG_TEXT_R


Child Column in BB_UPLOAD_LONG_TEXT_R(FK) Parent Table Name Parent Column Name
Parents: BB_UPLOAD_REVIEW_ID BB_UPLOAD_REVIEW BB_UPLOAD_REVIEW_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID


BB_UPLOAD_PERSON_ABORH_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: BB Upload Person ABO/Rh
Definition: This table will be used in the case where multiple, active ABO/Rh rows where found prior to an upload. There will be one row per active ABO/Rh rows.
Table Type: ACTIVITY





Column Detail - BB_UPLOAD_PERSON_ABORH_R


Column Name Type Null? Definition
BB_UPLOAD_PERSON_ABORH_R_ID DOUBLE N An internal system-assigned number that ensures the uniqueness of each row.
BB_UPLOAD_REVIEW_ID DOUBLE N This is the value of the unique identifier to the bb_upload_review table.
DEMOG_ABORH_DT_TM DATETIME N Tells when the demographic ABO/Rh was last resulted/uploaded.
PERSON_ABORH_ID DOUBLE N This is the value of the unique identifier for a previously active ABO/Rh 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 - BB_UPLOAD_PERSON_ABORH_R


Child Column in BB_UPLOAD_PERSON_ABORH_R(FK) Parent Table Name Parent Column Name
Parents: BB_UPLOAD_REVIEW_ID BB_UPLOAD_REVIEW BB_UPLOAD_REVIEW_ID
PERSON_ABORH_ID PERSON_ABORH PERSON_ABORH_ID