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 |