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 |