Table Detail Report

PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Product
Definition: Stores demographic information about all blood bank products, whether a blood product or derivative. The main parent table in the PathNet Blood Bank Transfusion. Only common attributes about all products are stored in this table.
Table Type: ACTIVITY





Column Detail - PRODUCT


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.
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.
BARCODE_NBR CHAR(20) Y The original barcoded version of the product number, e.g., "1212345", which may have been translated into "G12345", depending on the alpha translation feature.
BIOHAZARD_IND DOUBLE N Indicates that the product is biohazardous.
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.
CORRECTED_IND DOUBLE Y Indicates whether or not this product has been corrected in some way, such as its demographics changed, etc.
CREATE_DT_TM DATETIME Y Indicates the date and time the product row was created
CUR_DISPENSE_DEVICE_ID DOUBLE N An internal system-assigned number. The primary key of the BB_DEVICE table. An identification of the device to which the product was dispensed. An example is "SURG FRIDGE #1", for a refrigerator within the surgical area.
CUR_EXPIRE_DT_TM DATETIME Y Defines when the product itself will expire. The current expiration date and time is entered at the time the product is received from the label on the product, but may be updated if it is modified or corrected.
CUR_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.
CUR_INV_DEVICE_ID DOUBLE N Identifies the current inventory device where this product resides within inventory. An example would be "Freezer #1". This column is not currently used.
CUR_INV_LOCN_CD DOUBLE N The current location of this product as it relates to a patient's location. This column is only applicable when the product is actively dispensed or transfused to a patient. It is cleared out if the product is returned.
CUR_OWNER_AREA_CD DOUBLE N Identifies the code value for the current blood bank owner area where the product resides. 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".
CUR_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.
CUR_UNIT_MEAS_CD DOUBLE N The unit of measure in which this product's volume is recorded. It is entered at the time the product is received, from the label on the actual product (ex. "milliliters").
DISEASE_CD DOUBLE N This column will store the unique identifier of the disease associated with the product.
DONATED_BY_RELATIVE_IND DOUBLE Y Obsolete. No longer used. - This column only applies to directed products received into the Blood Bank. It indicates whether or not the product was donated by a relative of the recipient or not. - This information is now on the AUTO_DIRECTED and CORRECTED_PRODUCT table.
DONATION_TYPE_CD DOUBLE N This column will store the unique identifier of the donation type associated.
ELECTRONIC_ENTRY_FLAG DOUBLE N Indicates whether the primary product demographic fields were entered via Electronic Entry, and if so what form of entry was used. 0 - Product demographics are not guaranteed to have been entered electronically; 1 - Product demographics were scanned in via barcode reader
FLAG_CHARS VARCHAR(2) Y Stores the flag characters of an ISBT-128 donation number
INTENDED_USE_PRINT_PARM_TXT VARCHAR(1) N Contains the intended use of the product. It is derived from the ISBT ABORh Barcode. Valid values are:Autologous Crossover AAutologous Only 1 (one)Autologous Only Biohazard XDirected Biohazard 3Directed Only 2Directed Crossover DNot Specified 0 (zero)For Emergency Use Only !If the Product ABORH wasn't scanned in via ISBT Barcode, intended_use_print_parm_txt will be blank.
INTERFACED_DEVICE_FLAG DOUBLE N Indicates that the product is currently being tracked using an interfaced inventory tracking system. If it is set to be in a device, but the cur_dispense_device_id is 0, it means it is in transit.
INTERFACE_PRODUCT_ID DOUBLE N The product ID for a transferred product.
LOCKED_IND DOUBLE Y Indicates whether or not the product is locked for update by a particular blood bank transaction. Inquiry transactions do not update this indicator to locked.
MODIFIED_PRODUCT_ID DOUBLE N This column represents the PRODUCT_ID of the original product from which this product was created through the product modification application. The product_id is the primary key of the 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.
ORIG_INV_LOCN_CD DOUBLE N The original location of this product in the blood bank's inventory at the time it was received.
ORIG_SHIP_COND_CD DOUBLE N The original condition in which the product was shipped to the transfusion service (ex. "Dry Ice").
ORIG_UNIT_MEAS_CD DOUBLE N The unit of measure in which this product's volume was originally recorded. It is entered at the time the product is received, from the label on the actual product (ex. "milliliters").
ORIG_VIS_INSP_CD DOUBLE N The outcome of the visual inspection when this product was received (ex. "OK", "Bag leaking", etc.). This visual inspection may cause the product to need to be quarantined.
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 application. The product_id is the primary key of the 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 is only updated on the newly created product, not the products that were components within the pool.
POOL_OPTION_ID DOUBLE N If this product was created by the pooling process, it identifies the pool option chosen by the user in the pooling transaction.
PRODUCT_CAT_CD DOUBLE N The category of products to which this specific type of product belongs. An example of a product category is "Plasma", which might include a product type of "Fresh Frozen Plasma", "Thawed Plasma", and "Salvaged Plasma".
PRODUCT_CD DOUBLE N The type of product (ex. "Fresh Frozen Plasma") derived from the label on 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 The primary key to this table. An internal system-assigned number that keeps each row unique.
PRODUCT_NBR VARCHAR(20) N The number assigned to this product to identify it. Also known as "unit number". It is entered at the time the product is received into the blood bank's inventory, from the label on the actual bag of blood. In the case of derivative products, it is the lot number from the batch of derivatives.
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.
PRODUCT_TYPE_BARCODE VARCHAR(22) Y This is the barcode value that was etiered in BB Recieve Products or corrected in Correct Inventory.
RECV_DT_TM DATETIME Y The date and time the product was received into the blood bank's inventory from a supplier. This column is empty on products created from the pooling or modification process since they are not received but rather created by the blood bank.
RECV_PRSNL_ID DOUBLE N This column represents the person_id of the person from the personnel table (prsnl) that received this product into the blood bank's inventory.
REQ_LABEL_VERIFY_IND DOUBLE N Product requires label verify because a lebel was printed or mod opt was defined to print a label.
SERIAL_NUMBER_TXT VARCHAR(22) Y Contains GS1 serial number for derivative products when applicable
STORAGE_TEMP_CD DOUBLE N The temperature at which the product should be stored.
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.



Relationship Detail - PRODUCT


Child Column in PRODUCT(FK) Parent Table Name Parent Column Name
Parents: CUR_SUPPLIER_ID ORGANIZATION ORGANIZATION_ID
INTERFACE_PRODUCT_ID PRODUCT PRODUCT_ID
MODIFIED_PRODUCT_ID PRODUCT PRODUCT_ID
POOLED_PRODUCT_ID PRODUCT PRODUCT_ID




Parent Column in PRODUCT (PK) Child Table Name Child Column Name
Children: PRODUCT_ID ASSIGN PRODUCT_ID
ASSIGN_RELEASE PRODUCT_ID
AUTO_DIRECTED PRODUCT_ID
BB_AUTODIR_EXCEPTION PRODUCT_ID
BB_DEVICE_TRANSFER PRODUCT_ID
BB_EDN_DSCRPNCY_OVRD PRODUCT_ID
BB_EXC_CXM_PRODUCT PRODUCT_ID
BB_LABEL_VERIFY PRODUCT_ID
BB_ORDER_CELL PRODUCT_ID
BB_SHIP_EVENT PRODUCT_ID
BB_SPEC_EXP_OVRD_PROD PRODUCT_ID
BLOOD_PRODUCT PRODUCT_ID
CE_PRODUCT PRODUCT_ID
CORRECTED_PRODUCT POOLED_PRODUCT_ID
CORRECTED_PRODUCT PRODUCT_ID
CROSSMATCH PRODUCT_ID
DERIVATIVE PRODUCT_ID
DESTRUCTION PRODUCT_ID
DISPENSE_RETURN PRODUCT_ID
DISPOSITION PRODUCT_ID
MODIFICATION PRODUCT_ID
MODIFY_DEVICE PRODUCT_ID
ORDERS PRODUCT_ID
PATIENT_DISPENSE PRODUCT_ID
PRODUCT INTERFACE_PRODUCT_ID
PRODUCT MODIFIED_PRODUCT_ID
PRODUCT POOLED_PRODUCT_ID
PRODUCT_EVENT PRODUCT_ID
PRODUCT_NOTE PRODUCT_ID
PRODUCT_RH_PHENOTYPE PRODUCT_ID
QUARANTINE PRODUCT_ID
QUARANTINE_RELEASE PRODUCT_ID
RECEIPT PRODUCT_ID
SPECIAL_TESTING PRODUCT_ID
SPECIAL_TESTING_RESULT PRODUCT_ID
TRANSFER PRODUCT_ID
TRANSFUSION PRODUCT_ID


PRODUCT_ABORH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Product Aborh
Definition: A user-defined reference table that defines the combinations of product and aborhs to be used in patient/product compatibility checking throughout the PathNet Blood Bank Transfusion system.
Table Type: REFERENCE





Column Detail - PRODUCT_ABORH


Column Name Type Null? Definition
ABORH_OPTION_FLAG DOUBLE Y When associating this product type and ABORh with a patient, this flag defines whether the patient's entire ABORh should be validated, or just the patient's Rh type.
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.
BBD_NO_GT_DIR_PRSN_FLAG DOUBLE N OBSOLETE ** NO LONGER BEING USED ** Defines whether or not to allow a product of this type and ABORh to be associated to a person with no ABORh, within the "ReceiveProducts" application, when entering the recipient information in the Autologous/Directed window.
DISP_NO_CURRABORH_PRSN_FLAG DOUBLE N Defines whether or not to allow a product of this type and ABORh to be dispensed to a person with no current ABO.
NO_GT_AUTODIR_PRSN_FLAG DOUBLE Y Defines whether or not to allow a product of this type and ABORh to be associated to a person with no ABORh, within the "ReceiveProducts" application, when entering the recipient information in the Autologous/Directed window.
NO_GT_ON_PRSN_FLAG DOUBLE Y Defines whether or not to allow a product of this type and ABORh to be assigned, crossmatched, or dispensed. to a person with no ABORh.
PRODUCT_ABORH_CD DOUBLE N The product's ABORh that is being defined with a certain product type for patient ABORh compatibility (ex. "O Neg").
PRODUCT_CD DOUBLE N The type of product defined for patient compatibility (ex. "Red Blood Cells").
SEQUENCE_NBR DOUBLE N An internal number which, when combined with the product type and product's ABORh. is used to make each row unique. It begins at 1 and is incremented by 1. It is needed because the user may choose to inactivate a product and ABORh combination, and later add it again as active.
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 - PRODUCT_ABORH


Child Column in PRODUCT_ABORH(FK) Parent Table Name Parent Column Name
Parents: PRODUCT_CD PRODUCT_INDEX PRODUCT_CD


PRODUCT_NOTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Product Note
Definition: Contains all notes (comments, freetext) entered on products.
Table Type: ACTIVITY





Column Detail - PRODUCT_NOTE


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_PRODUCT_ID DOUBLE N The primary key to the BBHIST_PRODUCT table (Product_ID). An internal system-assigned number. On this table, it identifies the product_id from the BBHIST_PRODUCT table for which the comment is associated with.
LONG_TEXT_ID DOUBLE N The primary key to the LONG_TEXT table. An internal system-assigned number. On this table, it identifies the text entered for this product.
PRODUCT_ID DOUBLE N The primary key to the PRODUCT table. An internal system-assigned number. On this table, it identifies the product for which comments were entered.
PRODUCT_NOTE_ID DOUBLE N The primary key to this table. An internal system-assigned number that makes each row unique.
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 - PRODUCT_NOTE


Child Column in PRODUCT_NOTE(FK) Parent Table Name Parent Column Name
Parents: BBHIST_PRODUCT_ID BBHIST_PRODUCT PRODUCT_ID
PRODUCT_ID PRODUCT PRODUCT_ID


PRODUCT_RH_PHENOTYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Product Rh Phenotype
Definition: This table contains the Rh phenotype tested on the product.
Table Type: ACTIVITY





Column Detail - PRODUCT_RH_PHENOTYPE


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 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.
NOMENCLATURE_ID DOUBLE N Links this row for this product's Rh phenotype to the actual nomenclature (alpha response) entered, e.g., "CDE/CDE".
PRODUCT_ID DOUBLE N Links this row to the actual product for which this Rh phenotype is being stored. It is the primary key to the Product table.
PRODUCT_RH_PHENOTYPE_ID DOUBLE N The primary key to this table. An internal system-assigned number that ensures the uniqueness of each row.
RH_PHENOTYPE_ID DOUBLE N Links this row to the reference table on which Rh phenotypes are defined by the user. An example is "CDE/CDE". This column is the primary key to the bb_Rh_phenotype 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 - PRODUCT_RH_PHENOTYPE


Child Column in PRODUCT_RH_PHENOTYPE(FK) Parent Table Name Parent Column Name
Parents: RH_PHENOTYPE_ID BB_RH_PHENOTYPE RH_PHENOTYPE_ID
PRODUCT_ID PRODUCT PRODUCT_ID




Parent Column in PRODUCT_RH_PHENOTYPE (PK) Child Table Name Child Column Name
Children: PRODUCT_RH_PHENOTYPE_ID SPECIAL_TESTING PRODUCT_RH_PHENOTYPE_ID


SPECIAL_TESTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Special Testing
Definition: Contains all special testing done on a product, whether from the base label on the bag, or from resulting procedures on the product. This includes antigen typings as well as any other special testing, e.g., CMV negative, etc.
Table Type: ACTIVITY





Column Detail - 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.
BARCODE_VALUE_TXT VARCHAR(20) N Contains the ISBT barcode associated with the special testing attribute.
CONFIRMED_IND DOUBLE Y Indicates whether or not this antigen or attribute of the product has is considered confirmed or not. ***NOT USED AT THIS TIME
MODIFIABLE_FLAG DOUBLE N Indicates if the user can remove the special testing from the product. 0 = Special Testing was added manually and can be modified by the user. 1 = Special Testing was added via barcode scan, and can NOT be modified by the user.
PRODUCT_ID DOUBLE N The primary key to the PRODUCT table. An internal system-assigned number. On this table, it identifies the product for which special testing (antigens or attributes) has been recorded.
PRODUCT_RH_PHENOTYPE_ID DOUBLE N Links the antigen on this row to the Rh phenotype to which it belongs. Links this row to a row on the Product_rh_phenotype table. An example is C+ on this row originating from the Rh phenotype of "CDE/cde".
SPECIAL_TESTING_CD DOUBLE N Defines the special testing item (antigen or attribute) that was recorded on the product, whether it was done at the time the product was received into the blood bank's inventory, or at the time the results were verified for the testing.
SPECIAL_TESTING_ID DOUBLE N The primary key of this table. An internal system-assigned number to ensure the uniqueness of each 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 - SPECIAL_TESTING


Child Column in SPECIAL_TESTING(FK) Parent Table Name Parent Column Name
Parents: PRODUCT_ID PRODUCT PRODUCT_ID
PRODUCT_RH_PHENOTYPE_ID PRODUCT_RH_PHENOTYPE PRODUCT_RH_PHENOTYPE_ID




Parent Column in SPECIAL_TESTING (PK) Child Table Name Child Column Name
Children: SPECIAL_TESTING_ID CORRECTED_SPECIAL_TESTS ORIG_SPECIAL_TESTING_ID
SPECIAL_TESTING_RESULT SPECIAL_TESTING_ID