ASSIGN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Assignment
Definition: Contains a record for every time a product was assigned (or reserved) to a person.
Table Type: ACTIVITY





Column Detail - ASSIGN


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.
ASSIGN_REASON_CD DOUBLE N The reason the product is assigned to a patient.
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_ASSIGN_INTL_UNITS DOUBLE Y If the product assigned is a derivative type of product, it is the number of international units currently assigned to the patient.
CUR_ASSIGN_QTY DOUBLE Y If the product assigned is a derivative type of product, it is the quantity of that product currently assigned to the patient.
ORIG_ASSIGN_INTL_UNITS DOUBLE Y If the product assigned is a derivative type of product, it is the quantity originally assigned to the patient.
ORIG_ASSIGN_QTY DOUBLE Y If the product assigned is a derivative type of product, it is the quantity of that product originally assigned to the patient.
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 product_event_id from the product_event table. It is the unique identifier and primary key for the assign table
PRODUCT_ID DOUBLE N Identifies the product assigned, from the product table.
PROV_ID DOUBLE N Defines the provider who ordered the product for the patient (ex. physician).
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 - ASSIGN


Child Column in ASSIGN(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PRODUCT_ID PRODUCT PRODUCT_ID
PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID


ASSIGN_RELEASE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Assignment Release
Definition: Contains a record of every time an assignment was released from a person.
Table Type: ACTIVITY





Column Detail - ASSIGN_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.
ASSIGN_RELEASE_ID DOUBLE N The primary key of this table. An internal system-assigned number that makes this row unique.
PRODUCT_EVENT_ID DOUBLE N The primary key to the PRODUCT_EVENT table. An internal system-assigned number. On this table, it corresponds to the row on the Product_Event table for the assignment.
PRODUCT_ID DOUBLE N The primary key to the PRODUCT table. An internal system-assigned number. On this table, it denotes the product for which the assignment is being released.
RELEASE_DT_TM DATETIME Y The date and time this assignment was released.
RELEASE_INTL_UNITS DOUBLE Y This column applies only to derivative types of products. It is the number of international units released from the assignment, since only part of the original number assigned may be released.
RELEASE_PRSNL_ID DOUBLE N The ID of the person who released this assignment.
RELEASE_QTY DOUBLE Y This column applies only to derivative types of products. It is the quantity released from the assignment, since only part of the original quantity assigned may be released.
RELEASE_REASON_CD DOUBLE N The reason this assignment was released.
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 - ASSIGN_RELEASE


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


AUTO_DIRECTED



Column Section Relationship Section Top of Page


Table-level Detail

Description: Autologous/Directed
Definition: Contains a record of every time an autologous or directed product was associated with a person.
Table Type: ACTIVITY





Column Detail - AUTO_DIRECTED


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.
ASSOCIATED_DT_TM DATETIME Y The date and time this product was associated with the designated recipient.
DONATED_BY_RELATIVE_IND DOUBLE Y Applies to a person associated to a directed product indicating whether the product was donated by a relative.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EXPECTED_USAGE_DT_TM DATETIME Y The date and time when it is expected that the patient will need to be transfused with this autologous or directed blood product (ex. the surgery date).
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 to the PRODUCT_EVENT table. An internal system-assigned number. On this table, it is also the primary key, and corresponds to a row on the PRODUCT_EVENT table for the autologous/directed event.
PRODUCT_ID DOUBLE N The primary key to the PRODUCT table. An internal system-assigned number. On this table, it identifies the product received that has an autologous or directed association with a person.
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 - AUTO_DIRECTED


Child Column in AUTO_DIRECTED(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PRODUCT_ID PRODUCT PRODUCT_ID
PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID


BB_DEVICE



Column Section Top of Page


Table-level Detail

Description: Blood Bank Device
Definition: Any device to which the blood bank may dispense blood that is kept at a controlled temperature.
Table Type: REFERENCE





Column Detail - BB_DEVICE


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.
DESCRIPTION VARCHAR(40) Y The description of the blood bank device, which will display in the combo box within the Dispense application.
DEVICE_ID DOUBLE N The primary key of this table. An internal system-assigned number that ensures the uniqueness of each row.
DEVICE_TYPE_CD DOUBLE N The type of device that this row represents (ex. "refrigerator", "cooler").
INVENTORY_AREA_CD DOUBLE N The blood bank inventory area that is associated with this device (ex. "Blood Bank North" inventory area with the device being "Surgery #1 Fridge").
LOCATION_CD DOUBLE N The location within the hospital that this device is associated with (ex. "Surgery Suite #1").
SERVICE_RESOURCE_CD DOUBLE N The service resource that this blood bank device is associated with.
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.


BB_DEVICE_TRANSFER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Device Transfer table
Definition: Used to record the transfer of a product from one device to another while product is dispensed.
Table Type: ACTIVITY





Column Detail - BB_DEVICE_TRANSFER


Column Name Type Null? Definition
FROM_DEVICE_ID DOUBLE N The blood bank device where the product was located at the time it was transferred to another blood bank device.
PRODUCT_EVENT_ID DOUBLE N The primary key to this table and the product_event table. An internal system-assigned number that ensures the uniqueness of each row.
PRODUCT_ID DOUBLE N The primary key to the Product table. An internal system-assigned number. On this table, it provides a link to the product that was transferred.
REASON_CD DOUBLE N The reason the product was transferred from one blood bank device to another, for example, from one refrigerator in surgery to another refrigerator.
TO_DEVICE_ID DOUBLE N The blood bank device to which the product was transferred.
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_DEVICE_TRANSFER


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