Table Detail Report

PATIENT_DISPENSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Dispense
Definition: A record of every time a product is dispensed to a patient.
Table Type: ACTIVITY





Column Detail - PATIENT_DISPENSE


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.
BACKDATED_ON_DT_TM DATETIME Y The date and time the dispense was backdated on.
BB_ID_NBR VARCHAR(20) Y An optional column that indicates the armband number for the patient as it was entered at the time of dispense.
CUR_DISPENSE_INTL_UNITS DOUBLE Y This column only applies to derivatives, not blood products. It defines the number of international units currently dispensed to the patient on this row.
CUR_DISPENSE_QTY DOUBLE Y This column only applies to derivative products, not blood products. It defines the quantity of this derivative that is currently dispensed to this patient.
DEVICE_ID DOUBLE N The physical location to which this product was dispensed (ex. "Surgery", "ICU")
DISPENSE_COOLER_ID DOUBLE N If the product was placed in a cooler at the time of dispense, this column contains that cooler ID.
DISPENSE_COOLER_TEXT VARCHAR(40) Y If this product was dispensed in a cooler, and that specific cooler had not been defined in the reference database previously, this column contains the free textname or number of the cooler used.
DISPENSE_COURIER_ID DOUBLE N The person who took the product from the blood bank to the patient's location.
DISPENSE_COURIER_TEXT VARCHAR(100) Y A free text entry of the name of the person who took the product from the blood bank to the patient's location. This column is used when the dispense courier has not been defined in the database prior to the dispense transaction taking place.
DISPENSE_FROM_LOCN_CD DOUBLE N The location of the product when it was dispensed.
DISPENSE_PROV_ID DOUBLE N The provider (physician) who ordered this product to be dispensed to this patient.
DISPENSE_REASON_CD DOUBLE N The reason the product was dispensed to this patient.
DISPENSE_STATUS_FLAG DOUBLE Y The current status of this dispense transaction. Defines whether it has resulted in a transfusion, a return of the product to the blood bank, or is still dispensed.
DISPENSE_TO_LOCN_CD DOUBLE N Defines the location to which this product was dispensed (ex. "Surgery", "ICU").
DISPENSE_VIS_INSP_CD DOUBLE N The outcome of the visual inspection as recorded by the technologist who dispensed the product.
ORIG_DISPENSE_INTL_UNITS DOUBLE Y The number of international units originally dispensed in this transaction. Since some of the batch dispensed could be returned and some transfused, this value could be greater than the number currently dispensed.
ORIG_DISPENSE_QTY DOUBLE Y The quantity of this derivative originally dispensed in this transaction. Since some of the batch dispensed could be returned and some transfused, this value could be greater than the quantity currently dispensed.
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, from the PRODUCT_EVENT table.
PRODUCT_ID DOUBLE N This is the value of the unique primary identifier of the product table. It is an internal system-assigned number. On this table, it denotes the product dispensed to the patient.
TAG_VERIFY_FLAG DOUBLE Y This field indicates the status of tag verification on dispensed product. 0 - Not configured, 1- Tag verified, 2 - Tag verify overridden
UNKNOWN_PATIENT_IND DOUBLE Y Determines whether the product was dispensed to an unknown patient (as in the case of an emergency).
UNKNOWN_PATIENT_TEXT VARCHAR(50) Y If the product was dispensed to an unknown patient (as in the case of an emergency, where there is no medical record number), it contains free textidentifying the patient's name.
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 - PATIENT_DISPENSE


Child Column in PATIENT_DISPENSE(FK) Parent Table Name Parent Column Name
Parents: DEVICE_ID BB_INV_DEVICE BB_INV_DEVICE_ID
DISPENSE_COOLER_ID BB_INV_DEVICE BB_INV_DEVICE_ID
PERSON_ID PERSON PERSON_ID
PRODUCT_ID PRODUCT PRODUCT_ID
PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID


PRODUCT_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Product Event
Definition: Contains a row for every event that ever happened to product over its entire history, e.g., crossmatched, assigned, etc.
Table Type: ACTIVITY





Column Detail - PRODUCT_EVENT


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.
BB_RESULT_ID DOUBLE N An internal system-assigned number (but not a primary key to any table). Since multiple instances of a procedure can be resulted on the same patient, same accession, and same product, the BB_RESULT_ID is used to make these instances unique.
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 The date and time when this event occurred.
EVENT_PRSNL_ID DOUBLE N This column represents the person_id of the person from the personnel table (prsnl) who recorded this event for this product.
EVENT_STATUS_FLAG DOUBLE Y Applies only to the disposed event. The status of the disposed event, whether it has been destroyed yet or not.
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.
EVENT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
INVENTORY_AREA_CD DOUBLE N Contains the inventory area associated with product event.
ORDER_ID DOUBLE N This column represents the order_id of the order from the order table (ORDERS), if there is one associated with this event. Only certain events such as crossmatches will involve an order.
ORGANIZATION_ID DOUBLE N Contains the identifier of the organization associated with the product event.
OVERRIDE_IND DOUBLE Y Indicates whether or not an exception was overridden by the user in order to cause this event to happen with the product. Exceptions occur in the Resut Entry and Dispense applications.
OVERRIDE_REASON_CD DOUBLE N If an exception occurred with this event (as indicated by the OVERRIDE_IND column), this column records the reason it was overridden by the user.
OWNER_AREA_CD DOUBLE N Contains the owner area associated with the product 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 to the PRODUCT table. An internal system-assigned number. On this table, it identifies the product involved in the event.
RELATED_PRODUCT_EVENT_ID DOUBLE N This column represents the PRODUCT_EVENT_ID, which is the primary key to the PRODUCT_EVENT table. This column is used when it is necessary to associate different events with each other. One example is associating the crossmatch event with the dispense event for that patient, in which case the related product event ID on the dispense event is updated with the product_event_id from the crossmatch event.
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_EVENT


Child Column in PRODUCT_EVENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORDER_ID ORDERS ORDER_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PRODUCT_ID PRODUCT PRODUCT_ID
RELATED_PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID
EVENT_PRSNL_ID PRSNL PERSON_ID




Parent Column in PRODUCT_EVENT (PK) Child Table Name Child Column Name
Children: PRODUCT_EVENT_ID ABO_TESTING PRODUCT_EVENT_ID
ASSIGN PRODUCT_EVENT_ID
ASSIGN_RELEASE PRODUCT_EVENT_ID
AUTO_DIRECTED PRODUCT_EVENT_ID
BB_DEVICE_TRANSFER PRODUCT_EVENT_ID
BB_EXCEPTION PRODUCT_EVENT_ID
BB_EXC_CXM_PRODUCT PRODUCT_EVENT_ID
BB_INVENTORY_TRANSFER PRODUCT_EVENT_ID
BB_INVENTORY_TRANSFER TO_PRODUCT_EVENT_ID
BB_SHIP_EVENT PRODUCT_EVENT_ID
BB_SPEC_EXP_OVRD_PROD PRODUCT_EVENT_ID
CORRECTED_PRODUCT PRODUCT_EVENT_ID
CROSSMATCH PRODUCT_EVENT_ID
DESTRUCTION PRODUCT_EVENT_ID
DISPENSE_RETURN PRODUCT_EVENT_ID
DISPOSITION PRODUCT_EVENT_ID
MODIFICATION PRODUCT_EVENT_ID
PATIENT_DISPENSE PRODUCT_EVENT_ID
PRODUCT_EVENT RELATED_PRODUCT_EVENT_ID
QUARANTINE PRODUCT_EVENT_ID
RECEIPT PRODUCT_EVENT_ID
TRANSFER PRODUCT_EVENT_ID
TRANSFUSION PRODUCT_EVENT_ID


PRSNL_CURRENT_LOC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Current Personnel Location
Definition: Contains a record for the current location of person that has logged onto the system.
Table Type: ACTIVITY





Column Detail - PRSNL_CURRENT_LOC


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.
CERNER_PRODUCT_CD DOUBLE N The specific product that the user is signing on for. (TRANSFUSION, DONOR)
CURRENT_LOC_ID DOUBLE N Unique identifier for this table.
LOCATION_CD DOUBLE N This field identifies the current location for a person.
LOCATION_TYPE_CD DOUBLE N This field identifies the current location type for a person.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
ROOT_LOC_CD DOUBLE N This field identifies the root location code for the current location.
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 - PRSNL_CURRENT_LOC


Child Column in PRSNL_CURRENT_LOC(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
PERSON_ID PRSNL PERSON_ID


QUARANTINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Quarantine
Definition: Every quarantine ever placed on a product is contained in this table.
Table Type: ACTIVITY





Column Detail - QUARANTINE


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_QUAR_INTL_UNITS DOUBLE Y This column applies only to derivative products. It is the number of international units in the batch that is currently quarantined.
CUR_QUAR_QTY DOUBLE Y This column applies only to derivative products. It is the quantity of the batch that is currently quarantined.
ORIG_QUAR_INTL_UNITS DOUBLE Y This column applies only to derivative products. It is the number of international units in the batch that was originally quarantined (since some of the batch might be released from quarantine at one time, and some at another time).
ORIG_QUAR_QTY DOUBLE Y This column applies only to derivative products. It is the quantity of the batch that was originally quarantined (since some of the batch might be released from quarantine at one time, and some at another time).
PRODUCT_EVENT_ID DOUBLE N The primary key of this table. An internal system-assigned number that ensure the uniqueness of each row.
PRODUCT_ID DOUBLE N The primary key of the PRODUCT table. An internal system-assigned number. On this table, it identifies the product that was quarantined.
QUAR_REASON_CD DOUBLE N The reason this product was quarantined (a product may be quarantined multiple times for different reasons).
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 - QUARANTINE


Child Column in QUARANTINE(FK) Parent Table Name Parent Column Name
Parents: PRODUCT_ID PRODUCT PRODUCT_ID
PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID




Parent Column in QUARANTINE (PK) Child Table Name Child Column Name
Children: PRODUCT_EVENT_ID QUARANTINE_RELEASE PRODUCT_EVENT_ID


QUARANTINE_RELEASE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Quarantine Release
Definition: Every quarantine released from being on a product is contained in this table
Table Type: ACTIVITY





Column Detail - QUARANTINE_RELEASE


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.
PRODUCT_EVENT_ID DOUBLE N The Product_Event_ID of the quarantine that was released. The quarantine has a corresponding row on the Product_Event table, as well as the Quarantine table.
PRODUCT_ID DOUBLE N The ID of the product that was released from quarantine. This number corresponds to a row on the PRODUCT table.
QUAR_RELEASE_ID DOUBLE N The personnel ID of the person who released the quarantine on this product.
RELEASE_DT_TM DATETIME Y The date and time this quarantine was released on this product.
RELEASE_INTL_UNITS DOUBLE Y This column only applies to derivative types of products. It is the number of international units released from quarantine. (The entire number of international units quarantined may not be released from quarantine)
RELEASE_PRSNL_ID DOUBLE N The personnel ID of the person who released this quarantine on this product.
RELEASE_QTY DOUBLE Y This column only applies to derivative types of products. It is the quantity of the derivative batch that was released from quarantine (the quantity originally quarantined may not be completely released, only partially)
RELEASE_REASON_CD DOUBLE N The reason this quarantine was released from this product.
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 - QUARANTINE_RELEASE


Child Column in QUARANTINE_RELEASE(FK) Parent Table Name Parent Column Name
Parents: PRODUCT_ID PRODUCT PRODUCT_ID
RELEASE_PRSNL_ID PRSNL PERSON_ID
PRODUCT_EVENT_ID QUARANTINE PRODUCT_EVENT_ID