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 |