Table Detail Report

RECEIPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Receipt
Definition: Contains a record of every time a product was received from a supplier.
Table Type: ACTIVITY





Column Detail - RECEIPT


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.
ALPHA_TRANSLATION_ID DOUBLE N Identifies the alpha translation used to create the product number for this product. Only applies to blood products. Only applies to products received from suppliers for which alpha translation is required.
BB_SUPPLIER_ID DOUBLE N Identifies the originating supplier of this product. Only applies to blood products. This is the originating supplier, not the intermediate supplier, which is stored on the product table.
ELECTRONIC_RECEIPT_IND DOUBLE N Received through FSI Inventory Transfer Interface
ORIG_INTL_UNITS DOUBLE Y This column applies only to derivative products. It is the number of international units originally entered at the time the derivative batch was received and entered into inventory.
ORIG_RCVD_QTY DOUBLE Y This column applies only to derivative products. It is the quantity of the batch originally entered at the time the derivative batch was received and entered into inventory.
PRODUCT_EVENT_ID DOUBLE N The primary key of this table. It is an internal system-assigned number that ensure the uniqueness of each row. There is a corresponding row on the PRODUCT_EVENT table with this same value as the primary key, for the received event.
PRODUCT_ID DOUBLE N The primary key to the PRODUCT table. An internal system-assigned number. On this table, it identifies the product that was received into the blood bank's inventory.
SHIP_COND_CD DOUBLE N The original condition in which the product was shipped to the transfusion service (ex. "Dry Ice").
TEMPERATURE_DEGREE_CD DOUBLE N Indicates the shipment temperature degree unit of measure at the time the product was received.
TEMPERATURE_VALUE DOUBLE Y Indicates the shipment temperature at the time the product was received.
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.
VIS_INSP_CD DOUBLE N The original visual inspection performed on the product at the time it was received into the blood bank's inventory (ex. "OK", "Bag leaking", etc.). An unsatisfactory visual inspection can cause the product to be quarantined automatically.



Relationship Detail - RECEIPT


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


TRANSFER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transfer
Definition: Contains a record for every time a product is transferred to another facility or refrigerated location.
Table Type: ACTIVITY





Column Detail - TRANSFER


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.
LOGIN_COND_CD DOUBLE N Table is not used yet. Possibly obsolete
LOGIN_DT_TM DATETIME Y Table is not used yet. Possibly obsolete
LOGIN_PRSNL_ID DOUBLE N Table is not used yet. Possibly obsolete
LOGIN_QTY DOUBLE Y Table is not used yet. Possibly obsolete
LOGIN_VIS_INSP_CD DOUBLE N Table is not used yet. Possibly obsolete
PRODUCT_EVENT_ID DOUBLE N Table is not used yet. Possibly obsolete
PRODUCT_ID DOUBLE N Table is not used yet. Possibly obsolete
RETURN_COND_CD DOUBLE N Table is not used yet. Possibly obsolete
RETURN_DT_TM DATETIME Y Table is not used yet. Possibly obsolete
RETURN_PRSNL_ID DOUBLE N Table is not used yet. Possibly obsolete
RETURN_QTY DOUBLE Y Table is not used yet. Possibly obsolete
RETURN_REASON_CD DOUBLE N Table is not used yet. Possibly obsolete
RETURN_VIS_INSP_CD DOUBLE N Table is not used yet. Possibly obsolete
TRANSFERRING_LOCN_CD DOUBLE N Table is not used yet. Possibly obsolete
TRANSFER_COND_CD DOUBLE N Table is not used yet. Possibly obsolete
TRANSFER_QTY DOUBLE Y Table is not used yet. Possibly obsolete
TRANSFER_REASON_CD DOUBLE N Table is not used yet. Possibly obsolete
TRANSFER_VIS_INSP_CD DOUBLE N Table is not used yet. Possibly obsolete
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 - TRANSFER


Child Column in TRANSFER(FK) Parent Table Name Parent Column Name
Parents: PRODUCT_ID PRODUCT PRODUCT_ID
PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID
LOGIN_PRSNL_ID PRSNL PERSON_ID
RETURN_PRSNL_ID PRSNL PERSON_ID


TRANSFUSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transfusion
Definition: Contains a record for every time a dispensed product is recorded as being transfused to the patientto whom it was dispensed.
Table Type: ACTIVITY





Column Detail - TRANSFUSION


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.
BAG_RETURNED_IND DOUBLE Y Indicates whether or not the empty bag was returned to the blood bank from the patient's location after it was transfused.
CUR_TRANSFUSED_QTY DOUBLE Y This column applies only to derivative products. It is the quantity of the derivative batch that is currently in a transfused state.
ORIG_TRANSFUSED_QTY DOUBLE Y This column applies only to derivative products. It is the quantity of the derivative batch that was originally recorded as being in a transfused state for 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 primary key to this table, as well as the PRODUCT_EVENT table. An internal system-assigned number that ensure the uniqueness of each row. For every row on this table, there is a corresponding row on the PRODUCT_EVENT table with the same Product_Event_ID.
PRODUCT_ID DOUBLE N The primary key to the PRODUCT table. An internal system-assigned number. On this table, it represents the product that was transfused to the patient.
TAG_RETURNED_IND DOUBLE Y Indicates whether the tag attached to the bag dispensed was returned to the blood bank following the transfusion.
TRANSFUSED_INTL_UNITS DOUBLE Y This column applies only to derivative products. It is the number of international units that was transfused to the patient.
TRANSFUSED_VOL DOUBLE Y The volume of the product that was actually infused into the patient. This amount may not be the entire volume that was in the bag.
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 - TRANSFUSION


Child Column in TRANSFUSION(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