ABO_TESTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: ABO Testing
Definition: Contains information for every time an ABO/Rh procedure was resulted on a product.
Table Type: ACTIVITY





Column Detail - ABO_TESTING


Column Name Type Null? Definition
ABO_GROUP_CD DOUBLE N The ABO group that was found present in the blood product through the testing performed on it (ex. "A", "B", "O", or "AB").
ABO_TESTING_ID DOUBLE N Uniquely identifies information for every time an ABO/Rh procedure was resulted on a product.
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.
CURRENT_UPDATED_IND DOUBLE Y Defines whether or not the blood product's current ABORh type was updated due to the results of the testing performed.
PRODUCT_EVENT_ID DOUBLE N This column will be updated if the ABORh testing performed was the testing that confirmed the product's ABORh. If so, the product_event_id will be the key to the product_event table for the "confirmed" event.
PRODUCT_ID DOUBLE N The product_id for the blood product tested, from the product table.
RESULT_ID DOUBLE N The result_ID of the results performed on the blood product, from the result table.
RH_TYPE_CD DOUBLE N Defines the Rh type of the blood product tested (ex. "Pos" or "Neg"). If only the ABO group of the blood product was tested, this column will be zero.
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 - ABO_TESTING


Child Column in ABO_TESTING(FK) Parent Table Name Parent Column Name
Parents: PRODUCT_ID BLOOD_PRODUCT PRODUCT_ID
PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID
RESULT_ID RESULT RESULT_ID


BLOOD_PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood product
Definition: Attributes that are specific to a blood product (as opposed to a derivative).
Table Type: ACTIVITY





Column Detail - BLOOD_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.
AUTOLOGOUS_IND DOUBLE Y Indicates whether this blood product is an autologous product. Indicates whether this product was donated by a person to be transfused at a later time.
CUR_ABO_CD DOUBLE N Current ABO group of this blood product, whether entered at the time it was received, or confirmed through testing.
CUR_RH_CD DOUBLE N The current Rh for this blood product, whether it was entered at time of receiving it or confirmed through testing (ex. "Pos", "Neg")
CUR_VOLUME DOUBLE Y Indicates the current volume for this blood product. Entered at the time it was received, and updated during any product modification.
DIRECTED_IND DOUBLE Y Indicates whether this blood product was donated as a directed product, intended for a designated recipient.
DONOR_PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
DRAWN_DT_TM DATETIME Y This field contains the date and time the product was drawn from the donor. It is only filled out if the site has the Cerner Blood Bank Donor module and the product was drawn in house.
LOT_NBR VARCHAR(25) Y The lot number of the bag of the blood product.
ORIG_EXPIRE_DT_TM DATETIME Y The expiration date and time that was originally entered for the blood product at the time it was received into the blood bank.
ORIG_LABEL_ABO_CD DOUBLE N The ABO of the blood product as it was originally labeled when it was received into the blood bank.
ORIG_LABEL_RH_CD DOUBLE N The RH of the blood product as it was originally labeled when it was received into the blood bank (ex. "Pos", "Neg").
ORIG_VOLUME DOUBLE Y The volume of the blood product as it was when it was originally entered into the blood bank.
PRODUCT_CD DOUBLE N Indicates the exact type of blood product, e.g., "Red Blood Cells CPDA1", "Fresh Frozen Plasma", etc.
PRODUCT_ID DOUBLE N The ID of the product from the PRODUCT table to uniquely identify this blood product.
SEGMENT_NBR VARCHAR(25) Y The segment number of the blood product as entered from the bag at the time it was received into the blood bank.
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".
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 - BLOOD_PRODUCT


Child Column in BLOOD_PRODUCT(FK) Parent Table Name Parent Column Name
Parents: DONOR_PERSON_ID PERSON PERSON_ID
PRODUCT_ID PRODUCT PRODUCT_ID




Parent Column in BLOOD_PRODUCT (PK) Child Table Name Child Column Name
Children: PRODUCT_ID ABO_TESTING PRODUCT_ID


CORRECTED_PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Corrected Product
Definition: All corrections that have been made on a blood bank product.
Table Type: ACTIVITY





Column Detail - CORRECTED_PRODUCT


Column Name Type Null? Definition
ABO_CD DOUBLE N If the product's ABO group was corrected, then this column will contain the product's original ABO group before it was corrected.
ALTERNATE_NBR VARCHAR(20) Y If the product's alternate number was corrected, then this column will contain the product's original alternate number before it was corrected.
AUTOCLAVE_IND DOUBLE Y If the product's autoclave indicator was corrected, then this column will contain the product's original autoclave indicator before it was corrected.
BARCODE_NBR CHAR(20) Y Defines the original value of the "raw" barcoded version of the product number before it was corrected to a different value. The barcode number (ex. "5012345") is NOT the number with the alpha translation value (ex. "G12345") in it.
CORRECTION_FLAG DOUBLE Y This flag delineates the correction type further. It is currently only used to define types of pooled product changes.
CORRECTION_ID DOUBLE N The primary key to this table. An internal system-assigned number that makes each row unique.
CORRECTION_NOTE VARCHAR(255) Y A free text entry for the user to make comments regarding the correction made.
CORRECTION_REASON_CD DOUBLE N The reason the product had to be corrected.
CORRECTION_TYPE_CD DOUBLE N The type of correction that took place with this product. These correction types are pre-defined by Cerner. Examples are: demographic changes, emergency dispense correction, etc.
CORR_DISP_PROD_ORDER_ID DOUBLE N Uniquely identifies the related corrected dispense product order.
CUR_AVAIL_QTY DOUBLE Y Only applicable to derivative products. The available quantity before it was corrected.
CUR_INTL_UNITS DOUBLE Y Only applicable to derivative products. The number of international units before it was corected.
CUR_INV_AREA_CD DOUBLE N Identifies the code value for the current inventory area where the product resided, prior to it being corrected. 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_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".
DESTRUCTION_METHOD_CD DOUBLE N If the product's destruction method was corrected, then this column will contain the product's original destruction method before it was corrected.
DESTRUCTION_ORG_ID DOUBLE N If the product's destruction organization was corrected, then this column will contain the product's original destruction organization before it was corrected.
DESTRUCTION_ORG_ID_FLAG DOUBLE N This column value indicates whether the value of 'destruction_org_id' column has changed or not.
DISEASE_CD DOUBLE N If the disease was corrected, then this column will store the unique identifier of the disease associated with the product before it was corrected.
DONATED_BY_RELATIVE_IND DOUBLE Y Applies to a person associated to a directed product indicating whether the product was donated by a relative, before it was corrected.
DONATION_TYPE_CD DOUBLE N If the donation type was corrected, then this column will store the unique identifier of the donation type associated with the product before it was corrected.
DRAWN_DT_TM DATETIME Y Original Drawn Date/Time of product prior to correction of Drawn Date/Time
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 Y If the product's event date/time was corrected, then this column will contain the product's original event date/time before it was corrected.
EXPECTED_USAGE_DT_TM DATETIME Y The expected usage date and time that was entered for the autologous or directed product, before it was corrected.
EXPIRE_DT_TM DATETIME Y If the product's expire date/time was corrected, then this column will contain the product's original expire date/time before it was corrected.
FLAG_CHARS CHAR(2) Y This column hols the flag characters of an ISBT-128 donation number
INTENDED_USE_PRINT_PARM_TXT VARCHAR(1) Y This information is copied from the field named the same on the PRODUCT table.
MANIFEST_NBR VARCHAR(50) Y If the product's manifest number was corrected, then this column will contain the product's original manifest number before it was corrected.
MANUFACTURER_ID DOUBLE N Only applicable to derivative products. The original manufacturer of this product before it was corrected.
ORIG_DISP_PROD_ORDER_ID DOUBLE N Uniquely identifies the original dispense product order.
ORIG_DISP_PROV_ID DOUBLE N Uniquely identifies the original provider (physician) who ordered the product to be dispensed.
ORIG_LOT_NBR VARCHAR(25) N This column contains the product's original lot number before any corrections were made.
ORIG_UPDT_APPLCTX DOUBLE Y The product's original application context number from the record info block, as it existed before it was corrected.
ORIG_UPDT_CNT DOUBLE Y The product's original update count, as it existed before it was corrected.
ORIG_UPDT_DT_TM DATETIME Y The product's original update date and time, as it existed before it was corrected.
ORIG_UPDT_ID DOUBLE N The product's original update ID, as it existed before it was corrected.
ORIG_UPDT_TASK DOUBLE Y The product's original update task, as it existed before it was corrected.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
POOLED_PRODUCT_ID DOUBLE N If this product had previously been a component of a pooled product, and was removed from that pool, this number is the product_id of that pooled product.
PRODUCT_CAT_CD DOUBLE N If the product type was corrected, then this column will contain the product's original category before it was corrected.
PRODUCT_CD DOUBLE N If the product type was corrected, then this column will contain the product's original type before it was corrected.
PRODUCT_CLASS_CD DOUBLE N If the product type was corrected, then this column will contain the product's original class before it was corrected.
PRODUCT_EVENT_ID DOUBLE N The primary key to the PRODUCT_EVENT table. An internal system-assigned number. On this table, if the product was corrected for emergency dispense information or changing the final disposition state, then this column will contain the product event ID of that dispense or disposition transaction that was corrected.
PRODUCT_ID DOUBLE N The primary key to the PRODUCT table. An internal system-assigned number. On this table, it identifies the product that was corrected.
PRODUCT_NBR VARCHAR(20) Y If the product number from the label on the bag was corrected, then this column will contain the product's original number before it was corrected.
PRODUCT_SUB_NBR CHAR(5) Y If the product's sub number was corrected, then this column will contain the product's original sub number before it was corrected.
PRODUCT_TYPE_BARCODE VARCHAR(22) Y This is the barcode value that was entered in BBReceiveProducts or corrected in Correct Inventory.
REASON_CD DOUBLE N If the product's final disposition state was corrected, then this column will contain the product's original final disposition reason before it was corrected.
RECV_DT_TM DATETIME Y If the product's receipt date and time was corrected, then this column will contain the product's original receipt date and time before it was corrected.
RELATED_CORRECTION_ID DOUBLE N The correction ID of another row on the Corrected_Product table that is related to this row. This column is currently only used to tie the correction on a component of the pool to a correction of the pooled product. This allows the system to know the pooled product to which a component was added, or the pooled product from which a component was removed.
RH_CD DOUBLE N If the product's Rh type was corrected, then this column will contain the product's original Rh type before it was corrected.
SEGMENT_NBR VARCHAR(25) Y If the product's segment number was corrected, then this column will contain the product's original segment number before it was corrected.
SERIAL_NUMBER_TXT VARCHAR(22) Y Contains GS1 serial number for derivative products when applicable.
SHIP_COND_CD DOUBLE N If the shipping condition was corrected, then this field will contain the product shipping condition prior to the correction.
SUPPLIER_ID DOUBLE N If the product's supplier ID was corrected, then this column will contain the product's original supplier ID before it was corrected.
SUPPLIER_PREFIX CHAR(5) Y Defines the original value of the originating supplier prefix before it was corrected to a different value.
UNITS_PER_VIAL_CNT DOUBLE N This value is only applicable to derivative products. The units per vial before the product was corrected.
UNIT_MEAS_CD DOUBLE N If the product's unit of measure was corrected, then this column will contain the product's original unit of measure before it was corrected.
UNKNOWN_PATIENT_TEXT VARCHAR(50) Y If the product was corrected for emergency dispense information, then this column will contain the unknown patient text of that dispense transaction as it existed before it was corrected.
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.
VIS_INSP_CD DOUBLE N If the product's visual inspection was corrected, then this field will contain the visual inspection prior to the correction
VOLUME DOUBLE Y If the product's volume was corrected, then this column will contain the product's original volume as it existed before it was corrected.



Relationship Detail - CORRECTED_PRODUCT


Child Column in CORRECTED_PRODUCT(FK) Parent Table Name Parent Column Name
Parents: RELATED_CORRECTION_ID CORRECTED_PRODUCT CORRECTION_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
CORR_DISP_PROD_ORDER_ID ORDERS ORDER_ID
ORIG_DISP_PROD_ORDER_ID ORDERS ORDER_ID
DESTRUCTION_ORG_ID ORGANIZATION ORGANIZATION_ID
MANUFACTURER_ID ORGANIZATION ORGANIZATION_ID
SUPPLIER_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
POOLED_PRODUCT_ID PRODUCT PRODUCT_ID
PRODUCT_ID PRODUCT PRODUCT_ID
PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID
ORIG_DISP_PROV_ID PRSNL PERSON_ID
ORIG_UPDT_ID PRSNL PERSON_ID




Parent Column in CORRECTED_PRODUCT (PK) Child Table Name Child Column Name
Children: CORRECTION_ID CORRECTED_PRODUCT RELATED_CORRECTION_ID
CORRECTED_SPECIAL_TESTS CORRECTION_ID


CORRECTED_SPECIAL_TESTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Corrected special testing
Definition: The special testing corrected on a product. The original special testing on the product that was changed or removed.
Table Type: ACTIVITY





Column Detail - CORRECTED_SPECIAL_TESTS


Column Name Type Null? Definition
CORRECTION_ID DOUBLE N The Correction ID from the CORRECTED_PRODUCT table, which identifies the correction transaction that took place.
CORRECT_SPEC_TESTS_ID DOUBLE N The primary key of this table. A unique internal system-assigned number.
NEW_SPEC_TEST_IND DOUBLE N Determines whether the special testing on this row was a new one added to the product.
ORIG_SPECIAL_TESTING_ID DOUBLE N Defines the special testing ID of the SPECIAL_TESTING table for the product, where the original special testing existed.
SPECIAL_TESTING_CD DOUBLE N The special testing that was corrected (ex. "FYA-", "Jka+", etc.)
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 - CORRECTED_SPECIAL_TESTS


Child Column in CORRECTED_SPECIAL_TESTS(FK) Parent Table Name Parent Column Name
Parents: CORRECTION_ID CORRECTED_PRODUCT CORRECTION_ID
ORIG_SPECIAL_TESTING_ID SPECIAL_TESTING SPECIAL_TESTING_ID


DERIVATIVE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Derivative
Definition: Attributes that are specific to a derivative (as opposed to a blood product).
Table Type: ACTIVITY





Column Detail - DERIVATIVE


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.
CUR_AVAIL_QTY DOUBLE Y The current quantity available for use and not already designated for other uses (ex. 80 vials of Factor VIII, 5 bottles of Rhogam, etc.)
CUR_INTL_UNITS DOUBLE Y The number of international units currently available for use.
ITEM_UNIT_MEAS_CD DOUBLE N The unit of measure for each item within the derivative batch (ex. "VL" for vial)
ITEM_VOLUME DOUBLE Y The volume of each item within the derivative batch.
MANUFACTURER_ID DOUBLE N The ID of the organization which manufactured this derivative batch.
PRODUCT_CD DOUBLE N The exact type of derivative product in this batch (ex. "Rhogam", "Factor VIII").
PRODUCT_ID DOUBLE N The Product ID from the PRODUCT table, which makes this table unique.
UNITS_PER_VIAL DOUBLE Y Number of international units per vial
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 - DERIVATIVE


Child Column in DERIVATIVE(FK) Parent Table Name Parent Column Name
Parents: MANUFACTURER_ID ORGANIZATION ORGANIZATION_ID
PRODUCT_ID PRODUCT PRODUCT_ID