ANSWER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Answer (reference table)
Definition: Contains answers to reference database questions. Used by DBPreferenceWizard (database tool) to store answers to questions on Transfusion's system-wide parameters. Read by applications throughout Blood Bank Transfusion.
Table Type: REFERENCE





Column Detail - ANSWER


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME Y The date and time that this row became active, usually the date and time that it was inserted.
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.
ANSWER VARCHAR(200) Y Contains the answer to a system-wide preference question. This column may contain a code value to a valid response code, or a code value to a code set, or free-text.
ANSWER_ID DOUBLE N The primary key of this table. An internal system-assigned number that ensures the uniqueness of each row.
INACTIVE_DT_TM DATETIME Y If the row has been updated to an inactive status (as determined by the ACTIVE_IND), then this column is the date and time when that occurred.
MODULE_CD DOUBLE N The module to which the database preference questions apply (ex. Blood Bank Transfusion").
PROCESS_CD DOUBLE N The process within the module for which the preference questions apply (ex. "Result Entry", "Dispense").
QUESTION_CD DOUBLE N The question that is being asked of the user concerning a certain process within the module.
SEQUENCE DOUBLE N The sequence in which the DBPreferenceWizard should display this answer.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - ANSWER


Child Column in ANSWER(FK) Parent Table Name Parent Column Name
Parents: QUESTION_CD QUESTION QUESTION_CD


BB_AUTODIR_EXCEPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Autologous/Directed Exception
Definition: Contains a row for each autologous or directed product for which an allogeneic product was dispensed to the same patient (by overriding the exception).
Table Type: ACTIVITY





Column Detail - BB_AUTODIR_EXCEPTION


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_AUTODIR_EXC_ID DOUBLE N An internal system-assigned number that ensures the uniqueness of every row on this table.
BB_EXCEPTION_ID DOUBLE N This column links the row for the actual allogeneic blocking exception that occurred (on the bb_exception table) to the row on this table. This links the exception to the autologous and/or directed products that existed when an allogeneic product was dispensed.
PRODUCT_ID DOUBLE N This column links the row for the actual autologous and/or directed product that existed when an allogeneic product was dispensed.
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_AUTODIR_EXCEPTION


Child Column in BB_AUTODIR_EXCEPTION(FK) Parent Table Name Parent Column Name
Parents: BB_EXCEPTION_ID BB_EXCEPTION EXCEPTION_ID
PRODUCT_ID PRODUCT PRODUCT_ID


BB_EXCEPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Exception
Definition: Contains a record of every blood bank exception that occurred with the system.
Table Type: ACTIVITY





Column Detail - BB_EXCEPTION


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.
DEFAULT_EXPIRE_DT_TM DATETIME Y Defines the default expiration date and time that was generated by the system at the time of product modification.
DONATION_IDENT VARCHAR(20) Y This field contains the previous donation number prior to it being updated to another value.
DONOR_CONTACT_ID DOUBLE N This field is a link to the donor contact table.
DONOR_CONTACT_TYPE_CD DOUBLE N This column will indicate the type of donor contact the exception occurred upon.
EVENT_TYPE_CD DOUBLE N The type of event that occurred with this product that caused this exception. These events are pre-defined by Cerner. Examples of events are: crossmatched, assigned, dispensed, etc.
EXCEPTION_DT_TM DATETIME Y Date and time that exception occurred.
EXCEPTION_ID DOUBLE N The primary key to this table. An internal system-assigned number that makes each row unique.
EXCEPTION_PRSNL_ID DOUBLE N Person_Id of person/tech performing the exception. Unique identifier from PERSON table
EXCEPTION_TYPE_CD DOUBLE N The type of exception that occurred. Exception types are pre-defined by Cerner. Examples are: a product dispensed with no crossmatch, an expired product that was crossmatched, etc.
FROM_ABO_CD DOUBLE N If the exception was for when a patient's ABORh is resulted differently than the previous ABORh, then this column will contain the patient's ABO group as it existed before the exception occurred.
FROM_RH_CD DOUBLE N If the exception was for when a patient's ABORh is resulted differently than the previous ABORh, then this column will contain the patient's Rh type as it existed before the exception occurred.
INELIGIBLE_UNTIL_DT_TM DATETIME Y This field will be used to indicate the next date the donor will be eligible to donate.
ORDER_ID DOUBLE N Order_Id uniquely identifying order for which exception occurred. Unique identifier from ORDERS table
OVERRIDE_REASON_CD DOUBLE N The reason the exception was overridden in the application (Dispense or Result Entry), for example, the patient's life was in danger.
PERFORM_RESULT_ID DOUBLE N The primary key to the PERFORM_RESULT table. An internal system-assigned number. On this table, it corresponds to the performed result if a result was involved in the exception.
PERSON_ABO_CD DOUBLE N Code_Value for ABO of patient at the time the exception occurred. From Code_Set 1641.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PERSON_RH_CD DOUBLE N Code_Value for Rh of patient at time the exception occurred. From Code Set 1642.
PROCEDURE_CD DOUBLE N This field will be used to indicate the donation procedure the donor was registered for at the time of the exception.
PRODUCT_ABO_CD DOUBLE N Code_Value for ABO of product at the time the exception occurred. From Code Set 1641
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 product event that was involved in the exception.
PRODUCT_RH_CD DOUBLE N Code_Value for Rh of product at the time the exception occurred. From Code Set 1642.
RESULT_ID DOUBLE N The primary key to the RESULT table. An internal system-assigned number. On this table, it corresponds to the result if a result was involved in the exception (ex. patient's ABORh result different from historical ABORh).
REVIEW_BY_PRSNL_ID DOUBLE N This field will contain the unique identifier of the user who review the exception.
REVIEW_DOC_ID DOUBLE N This field will be the unique id from the row of the Long Text table which contains the comments entered by the person who reviewed the exception.
REVIEW_DT_TM DATETIME Y This is the date and time the exception was reviewed.
REVIEW_STATUS_CD DOUBLE N This field indicates the review status of the exception. (Inprocess, Completed, Required Action)
TO_ABO_CD DOUBLE N If the exception was for when a patient's ABORh is resulted differently than the previous ABORh, then this column will contain the patient's new ABO group as it now exists since the exception occurred.
TO_RH_CD DOUBLE N If the exception was for when a patient's ABORh is resulted differently than the previous ABORh, then this column will contain the patient's new Rh type as it now exists since the exception occurred.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - BB_EXCEPTION


Child Column in BB_EXCEPTION(FK) Parent Table Name Parent Column Name
Parents: REVIEW_DOC_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
PERFORM_RESULT_ID PERFORM_RESULT PERFORM_RESULT_ID
PERSON_ID PERSON PERSON_ID
PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID
RESULT_ID RESULT RESULT_ID




Parent Column in BB_EXCEPTION (PK) Child Table Name Child Column Name
Children: EXCEPTION_ID BB_AUTODIR_EXCEPTION BB_EXCEPTION_ID
BB_EDN_DSCRPNCY_OVRD EXCEPTION_ID
BB_EXCEPT_CXM BB_EXCEPTION_ID
BB_EXC_CXM_PRODUCT BB_EXCEPTION_ID
BB_INVLD_PROD_ORD_EXCEPTN EXCEPTION_ID
BB_REQS_EXCEPTION EXCEPTION_ID
BB_SPEC_EXPIRE_OVRD EXCEPTION_ID
BB_TAG_VERIFY_EXCPN EXCEPTION_ID


BB_EXCEPT_CXM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains Exception Override information for Computer Crossmatches
Definition: Blood Bank Comptuer Crossmatch Exception Override
Table Type: ACTIVITY





Column Detail - BB_EXCEPT_CXM


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_EXCEPTION_ID DOUBLE N Unique identifier for the parent BB_EXCEPTION row.
BB_EXCEPT_CXM_ID DOUBLE N Uniquely identifies a BB_EXCEPT_CXM row
MESSAGE_CD DOUBLE N Code_Value for the message associated with the exception override. From Code Set 19269.
OVERRIDE_REASON_CD DOUBLE N Code_Value for the override reason for the exception. From Code Set 1614.
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_EXCEPT_CXM


Child Column in BB_EXCEPT_CXM(FK) Parent Table Name Parent Column Name
Parents: BB_EXCEPTION_ID BB_EXCEPTION EXCEPTION_ID


BB_EXC_CXM_PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains products crossmatched with exception for parent BB_EXCEPTION row
Definition: Blood Bank Computer Crossmatch Exception Product
Table Type: ACTIVITY





Column Detail - BB_EXC_CXM_PRODUCT


Column Name Type Null? Definition
ABO_CD DOUBLE N Code_Value for ABO of product at the time of the computer crossmatch exception. From Code Set 1641.
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_EXCEPTION_ID DOUBLE N Uniquely identifies the parent BB EXCEPTION row.
BB_EXC_CXM_PRODUCT_ID DOUBLE N This is the primary key to this file. Uniquely identifies a BB_EXC_CXM_PRODUCT row
CROSSMATCH_EXPIRE_DT_TM DATETIME Y Crossmatch expiration of the computer crossmatch at the time of the exception.
EVENT_DT_TM DATETIME Y Date and Time the Computer Crossmatch was performed.
PRODUCT_CD DOUBLE N Code Value for the product type. From Code Set 1604.
PRODUCT_EVENT_ID DOUBLE N Unique identifier for PRODUCT_EVENT row for crossmatch event.
PRODUCT_ID DOUBLE N Unique identifier for product.
RH_CD DOUBLE N Code_Value for Rh of product at the time of the computer crossmatch exception.
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_EXC_CXM_PRODUCT


Child Column in BB_EXC_CXM_PRODUCT(FK) Parent Table Name Parent Column Name
Parents: BB_EXCEPTION_ID BB_EXCEPTION EXCEPTION_ID
PRODUCT_ID PRODUCT PRODUCT_ID
PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID