Table Detail Report

BB_INVENTORY_AREA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Inventory Area
Definition: Reference of locations within the blood bank that keep inventory. Locations that stock blood to be dispensed.
Table Type: REFERENCE





Column Detail - BB_INVENTORY_AREA


Column Name Type Null? Definition
BB_BARCODE_ID DOUBLE N Obsolete - This column is no longer being used.
BB_DEVICE_TYPE_CD DOUBLE N
BB_MONITORED_TEMP_HI DOUBLE Y
BB_MONITORED_TEMP_LO DOUBLE Y
BB_PROD_IND DOUBLE Y
SERVICE_RESOURCE_CD DOUBLE N The service resource with which this inventory area is associated.
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_INVENTORY_AREA


Child Column in BB_INVENTORY_AREA(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


BB_INVENTORY_TRANSFER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Inventory Transfer
Definition: Used to record the transfer of a product from one owner and inventory area to another.
Table Type: ACTIVITY





Column Detail - BB_INVENTORY_TRANSFER


Column Name Type Null? Definition
EVENT_TYPE_CD DOUBLE N This column is only applicable to derivative products. The product event code for the event type copied to the product in the transfer.
FROM_INV_AREA_CD DOUBLE N The blood bank inventory area where the product was located at the time it was transferred to another blood bank inventory area.
FROM_OWNER_AREA_CD DOUBLE N The blood bank owner area where the product was located at the time it was transferred to another blood bank owner area.
PRODUCT_EVENT_ID DOUBLE N Provides a link to the product's transferred event on PRODUCT_EVENT.
TO_INV_AREA_CD DOUBLE N The blood bank inventory area to which the product was transferred.
TO_OWNER_AREA_CD DOUBLE N The blood bank owner area to which the product was transferred.
TO_PRODUCT_EVENT_ID DOUBLE N Only applicable to derivative Products. The product event id for the transferred_from event for the to product in the transfer.
TRANSFERRED_INTL_UNIT DOUBLE Y Only applicable to derivative products. The international units of the product transferred.
TRANSFERRED_QTY DOUBLE Y Only applicable to derivative products. The quantity of the product transferred.
TRANSFER_REASON_CD DOUBLE N Reason the product was transferred from one blood bank inventory to another.
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_INVENTORY_TRANSFER


Child Column in BB_INVENTORY_TRANSFER(FK) Parent Table Name Parent Column Name
Parents: PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID
TO_PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID


BB_INV_DEVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Inventory Device
Definition: Defines the inventory devices used by the blood bank. This includes refrigerators and coolers to which blood is dispensed. In the future, this table will be used for any device in which blood is stored, even at the time the product is received.
Table Type: REFERENCE





Column Detail - BB_INV_DEVICE


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.
BB_INV_DEVICE_ID DOUBLE N A system-generated number that ensures the uniqueness of every row on this table.
DESCRIPTION VARCHAR(40) N A textual description of the inventory device.
DEVICE_TYPE_CD DOUBLE N The type of device - a refrigerator, cooler, etc.
INTERFACE_FLAG DOUBLE Y This indicates whether the device is interfaced to Millennium. 0 - Not Interfaced; 1 - Blood Track
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 - BB_INV_DEVICE




Parent Column in BB_INV_DEVICE (PK) Child Table Name Child Column Name
Children: BB_INV_DEVICE_ID BB_INV_DEVICE_R BB_INV_DEVICE_ID
MODIFY_DEVICE DEVICE_ID
PATIENT_DISPENSE DEVICE_ID
PATIENT_DISPENSE DISPENSE_COOLER_ID


BB_INV_DEVICE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Inventory Device Relationship
Definition: Defines the relationship between the inventory devices stored on the inventory_device table and thelocation, service resource, or inventory area with which it is associated.
Table Type: REFERENCE





Column Detail - BB_INV_DEVICE_R


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.
BB_INV_DEVICE_ID DOUBLE N The system-generated number that uniquely identifies every row on the bb_inv_device table. It exists on this table to link the actual inventory device to each relationship which exists for it (ex. location "SURG" has device "Refrig #1" associated with it).
BB_INV_DEVICE_R_ID DOUBLE N A system-generated number that uniquely identifies every row on this table.
DEVICE_R_CD DOUBLE N The code value that identifies the place that is associated with this inventory device. Currently this is only used for dispensed products dispensed to a certain location (nursing station). This column defines the location with which this device is associated.
DEVICE_R_TYPE_CD DOUBLE N Defines what type of relationship applies to this inventory device and item (blood bank inventory area, service resource, or nursing station 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 - BB_INV_DEVICE_R


Child Column in BB_INV_DEVICE_R(FK) Parent Table Name Parent Column Name
Parents: BB_INV_DEVICE_ID BB_INV_DEVICE BB_INV_DEVICE_ID


BB_LABEL_VERIFY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Label Verify
Definition: Contains a record for each blood bank product label that was verified, indicating date and time of verification and personnel_id of user performing the verification.
Table Type: ACTIVITY





Column Detail - BB_LABEL_VERIFY


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.
BB_LABEL_VERIFY_ID DOUBLE N Unique identifier for bb_label_verify table
LABEL_VERF_DT_TM DATETIME N Indicates the date and time the blood product label was verified.
PERSONNEL_ID DOUBLE N Unique identifier for the personnel performing the label verification.
PRODUCT_ID DOUBLE N Unique identifier for the product being verified.
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_LABEL_VERIFY


Child Column in BB_LABEL_VERIFY(FK) Parent Table Name Parent Column Name
Parents: PRODUCT_ID PRODUCT PRODUCT_ID
PERSONNEL_ID PRSNL PERSON_ID