Table Detail Report

CROSSMATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Crossmatch
Definition: A record of every time a product was updated to a crossmatch status for a patient, in result entry.
Table Type: ACTIVITY





Column Detail - CROSSMATCH


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.
BB_ID_NBR VARCHAR(20) Y The patient's Blood Bank ID number, usually a wristband number or Hollister-Fenwal number, entered at the time of crossmatch.
CROSSMATCH_EXP_DT_TM DATETIME Y The date and time when this crossmatch will expire.
CROSSMATCH_QTY DOUBLE Y This column only applies to derivative types of products. It contains the quantity of the derivative that was crossmatched. ***NOT USED AT THIS TIME
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 This is the value of the unique primary identifier of the product_event table. It is an internal system-assigned number.
PRODUCT_ID DOUBLE N This is the value of the unique primary identifier of the product table. It is an internal system-assigned number. On this table, it denotes the product crossmatched.
REINSTATE_REASON_CD DOUBLE N If this crossmatch was released and then later reinstated, it is the reason for that reinstatement.
RELEASE_DT_TM DATETIME Y If this crossmatch was released, it denotes the date and time it was released.
RELEASE_PRSNL_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that released this crossmatch.
RELEASE_QTY DOUBLE Y This column only applies to derivative types of products. It contains the quantity of the derivative that was released from being crossmatched. ***NOT USED AT THIS TIME
RELEASE_REASON_CD DOUBLE N The reason this crossmatch was released from the patient.
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.
XM_REASON_CD DOUBLE N The reason this product was crossmatched to this patient (ex. "Surgery", etc.)



Relationship Detail - CROSSMATCH


Child Column in CROSSMATCH(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
RELEASE_PRSNL_ID PRSNL PERSON_ID


DESTRUCTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Destruction
Definition: Contains a record of every time a product was destroyed. For every row on this table, there is a corresponding row on the Product_Event table.
Table Type: ACTIVITY





Column Detail - DESTRUCTION


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.
AUTOCLAVE_IND DOUBLE Y Indicates whether or not the product was autoclaved as part of the destruction process.
BOX_NBR VARCHAR(50) Y The number of the box into which the product was placed for destruction. This column may be empty.
DESTROYED_QTY DOUBLE Y This column applies only to derivative types of products. It is the quantity of the derivative batch that was destroyed.
DESTRUCTION_ORG_ID DOUBLE N Corresponds to the primary key of the ORGANIZATION table. An internal system-assigned number. On this table, if the product was picked up to be destroyed by another organization, then this column contains the ID of that organization.
MANIFEST_NBR VARCHAR(50) Y The manifest number from the destruction process.
METHOD_CD DOUBLE N The method that was used to destroy the product, ex. "burned", etc.
PRODUCT_EVENT_ID DOUBLE N The primary key to this table. An internal system-assigned number that makes it unique. The value in this column also corresponds to a row on the Product Event table.
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 destroyed.
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 - DESTRUCTION


Child Column in DESTRUCTION(FK) Parent Table Name Parent Column Name
Parents: DESTRUCTION_ORG_ID ORGANIZATION ORGANIZATION_ID
PRODUCT_ID PRODUCT PRODUCT_ID
PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID


DISPENSE_RETURN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dispense Return
Definition: Contains a record of every time a dispensed product was returned to the blood bank.
Table Type: ACTIVITY





Column Detail - DISPENSE_RETURN


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.
DISPENSE_RETURN_ID DOUBLE N This is the value of the unique primary identifier of this table. It is an internal system-assigned number.
PRODUCT_EVENT_ID DOUBLE N This is the value of the unique primary identifier of the product _event table, for which there is a corresponding row. It is an internal system-assigned number.
PRODUCT_ID DOUBLE N This is the value of the unique primary identifier of the product table. It is an internal system-assigned number. On this table, it denotes the product returned to the blood bank after being dispensed previously.
RETURN_COURIER_ID DOUBLE N The person who returned the product from the patient's location to the blood bank.
RETURN_COURIER_TEXT VARCHAR(100) Y A free text entry of the person who returned the product to the blood bank. This column is used when the courier has not been previously defined in the database.
RETURN_DT_TM DATETIME Y The date and time the product was returned to the blood bank from being dispensed to a patient.
RETURN_INTL_UNITS DOUBLE Y This column only applies to derivative types of products. It contains the number of international units returned to the blood bank.
RETURN_PRSNL_ID DOUBLE N The person who entered the return transaction into the system.
RETURN_QTY DOUBLE Y This column only applies to derivative types of products. It contains the quantity of the derivative returned to the blood bank (ex. 10 vials)
RETURN_REASON_CD DOUBLE N The reason the product was returned to the blood bank and not transfused to the patient.
RETURN_TEMPERATURE_DEGREE_CD DOUBLE N Indicates the return temperature degree unit of measure at the time the product was returned.
RETURN_TEMPERATURE_TXT VARCHAR(15) Y Free text entry capturing return temperature.
RETURN_TEMPERATURE_VALUE DOUBLE Y ** obsolete - no longer used ** Indicates the temperature of the product at the time the product was returned.
RETURN_VIS_INSP_CD DOUBLE N The outcome of the visual inspection done on the product at the time it was returned to the blood bank.
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 - DISPENSE_RETURN


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


DISPOSITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Disposition
Definition: Contains a record of every time a product is disposed.
Table Type: ACTIVITY





Column Detail - DISPOSITION


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.
DISPOSED_INTL_UNITS DOUBLE Y This column only applies to derivative types of products. It is the number of international units disposed.
DISPOSED_QTY DOUBLE Y This column only applies to derivative types of products. It is the quantity of the derivative batch that was disposed.
PRODUCT_EVENT_ID DOUBLE N The primary key of this table. An internal system-assigned number that is the ID of the corresponding row of the PRODUCT_EVENT table.
PRODUCT_ID DOUBLE N Identifies the product that was disposed. This number is the primary key of the PRODUCT table.
REASON_CD DOUBLE N The reason this product was disposed of.
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 - DISPOSITION


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


MODIFICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Modification
Definition: A record of every time a product is modified. A product can be modified into a different type of product, modified to have an attribute(s), or modified to have additional products split out of it. Corresponding row exists on the Product_Event table.
Table Type: ACTIVITY





Column Detail - MODIFICATION


Column Name Type Null? Definition
ACCESSORY VARCHAR(60) Y Free text accessory item used during a modification.
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.
CROSSOVER_REASON_CD DOUBLE N If this modification was a "crossover" type (changing autologous or directed products to allogeneic products), then this reason records why the crossover was done.
CUR_EXPIRE_DT_TM DATETIME Y The expiration date and time that was updated on the product at the time of this modification.
CUR_UNIT_MEAS_CD DOUBLE N The unit of measure that was updated on the product at the time of this modification.
CUR_VOLUME DOUBLE Y The volume that was updated on the product at the time of this modification.
DEVICE_TYPE_CD DOUBLE N Defines the device that was used in processing the modification.
LOT_NBR VARCHAR(60) Y Free text lot number associate with an accessory item used during a modification.
MODIFIED_QTY DOUBLE Y This column applies only to derivative types of products. It is the quantity of the derivative batch that was modified. ***NOT USED AT THIS TIME.
OPTION_ID DOUBLE N Links the modification that occurred for a product with the modification option that was selected by the user during the Modify Products conversation.
ORIG_EXPIRE_DT_TM DATETIME Y The expiration date and time of the product as it existed before if was modified.
ORIG_UNIT_MEAS_CD DOUBLE N The unit of measure for the product as it existed before if was modified.
ORIG_VOLUME DOUBLE Y The volume of the product as it existed before if was modified.
PRODUCT_EVENT_ID DOUBLE N The primary key to this table and the PRODUCT_EVENT table. An internal system-assigned number that makes this row unique. For every row written to this table, there is a corresponding row on the Product_Event table for the modification 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 modified.
START_DT_TM DATETIME Y The modification start date and time.
STOP_DT_TM DATETIME Y The modification stop date and time.
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 Defines the visual inspection of the product at the time of modification.



Relationship Detail - MODIFICATION


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