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 |