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 |