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 |