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 |