Table Detail Report

BB_INVLD_PROD_ORD_EXCEPTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Product Order Exception
Definition: Contains information for blood bank exceptions which are generated for dispense/modification without a valid product order.
Table Type: ACTIVITY





Column Detail - BB_INVLD_PROD_ORD_EXCEPTN


Column Name Type Null? Definition
BB_INVLD_PROD_ORD_EXCEPTN_ID DOUBLE N Uniquely identifies information for blood bank exceptions which are generated for dispense/modification without a valid product order.
EXCEPTION_ID DOUBLE N Uniquely identifies the related blood bank exception from the BB_EXCEPTION table.
PRODUCT_ORDER_ID DOUBLE N Uniquely identifies the related product order which was used at dispense/modification.
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_INVLD_PROD_ORD_EXCEPTN


Child Column in BB_INVLD_PROD_ORD_EXCEPTN(FK) Parent Table Name Parent Column Name
Parents: EXCEPTION_ID BB_EXCEPTION EXCEPTION_ID
PRODUCT_ORDER_ID ORDERS ORDER_ID


BB_REQS_EXCEPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Requirements Exceptions
Definition: Contains a record of every blood bank exception that involved transfusion requirements on the patient.
Table Type: ACTIVITY





Column Detail - BB_REQS_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.
EXCEPTION_ID DOUBLE N The primary key to the BB_EXCEPTION table. An internal system-assigned number. On this table, it corresponds to the exception that involved a patient's transfusion requirements not being met.
REQS_EXCEPTION_ID DOUBLE N The primary key to this table. An internal system-assigned number that makes each row unique.
REQUIREMENT_CD DOUBLE N The transfusion requirement that was not met during the dispense transaction with a product.
SPECIAL_TESTING_CD DOUBLE N The special testing attribute that should have existed on the product dispensed, in order to meet the transfusion requirement of 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.



Relationship Detail - BB_REQS_EXCEPTION


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


BB_REVIEW_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Review Queue
Definition: When persons are combined and certain situations occur, a record is kept in this table, so that it can be reviewed by the appropriate personnel, including: 1) persons combined had different ABO/Rh's,2) persons combined had conflicting antibodies.
Table Type: ACTIVITY





Column Detail - BB_REVIEW_QUEUE


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_REVIEW_QUEUE_ID DOUBLE N Primary key to table, unique identifier.
FROM_ENCNTR_ID DOUBLE N The primary key to the ENCOUNTER table. An internal system-assigned number. On this table, it corresponds to the ENCOUNTER row for from encounter being combined
FROM_PARENT_ENTITY_ID DOUBLE N The ID of the table from which this transaction was generated, e.g., the ID of the row on the antibody table that caused this transaction.
FROM_PERSON_ID DOUBLE N The ID of the person whose record was combined into another person's record.
PARENT_ENTITY_NAME VARCHAR(32) Y The name of the table from which this transaction was generated, e.g., "person_antibody".
REVIEW_DOC_ID DOUBLE N The primary key to the LONG_TEXT table. An internal system-assigned number. On this table, it points to the row on the LONG_TEXT table for the text entered for the documentation of the review of the exception.
REVIEW_DT_TM DATETIME Y Date and Time exception was reviewed.
REVIEW_OUTCOME_CD DOUBLE N The outcome of the combine exception being reviewed by the blood bank, e.g., the combine was done in error, the ABORh or antibody that caused the exception was in error, etc.
REVIEW_PRSNL_ID DOUBLE N The ID of the person who reviewed this blood bank combine exception.
REV_CMB_IND DOUBLE N This indicates the direction of combine.
TO_ENCNTR_ID DOUBLE N The primary key to the ENCOUNTER table. An internal system-assigned number. On this table, it corresponds to the ENCOUNTER row for to encounter being combined
TO_PARENT_ENTITY_ID DOUBLE N The ID of the table for the "to" person from which this transaction was generated, e.g., the ID of the row on the antibody table for the "to" person that caused this transaction. (The "to" person being the one for whom another person's record was combined into.)
TO_PERSON_ID DOUBLE N The "to" person of the combine transaction that caused this exception.
UNCOMBINE_IND DOUBLE Y Indicates whether the combine transaction that caused this exception was "uncombined" or "undone".
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_REVIEW_QUEUE


Child Column in BB_REVIEW_QUEUE(FK) Parent Table Name Parent Column Name
Parents: REVIEW_DOC_ID LONG_TEXT LONG_TEXT_ID
REVIEW_PRSNL_ID PRSNL PERSON_ID


BB_SPEC_EXPIRE_OVRD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Specimen Expiration Override
Definition: This table records when the user overrides (shortens or extends) the default specimen expiration date and time or when the system overrides the specimen expiration using a flex parameter.
Table Type: ACTIVITY





Column Detail - BB_SPEC_EXPIRE_OVRD


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_SPEC_EXPIRE_OVRD_ID DOUBLE N Uniquely identifies a row created when the user overrides (shorten or extends) the default specimen expiration date and time or when the system overrides the specimen expiration using a flex parameter.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EXCEPTION_ID DOUBLE N Uniquely identifies the corresponding row on the BB_EXCEPTION table.
NEW_SPEC_EXPIRE_DT_TM DATETIME Y The date and time a specimen has expired and a new specimen is required for a person.
OVERRIDE_DT_TM DATETIME N Date and Time the override occurred either by system override or user override.
OVERRIDE_REASON_CD DOUBLE N Reason the specimen expiration was overridden.
PERSON_ID DOUBLE N Person related to this specimen expiration override.
PREV_SPEC_EXPIRE_DT_TM DATETIME Y The date and time associated with the specimen before the override. This may have been based on the default or flex expiration or the date from a previous override.
SPECIMEN_ID DOUBLE N Contains the identifier related to this specimen override record.
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_SPEC_EXPIRE_OVRD


Child Column in BB_SPEC_EXPIRE_OVRD(FK) Parent Table Name Parent Column Name
Parents: EXCEPTION_ID BB_EXCEPTION EXCEPTION_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
SPECIMEN_ID V500_SPECIMEN SPECIMEN_ID




Parent Column in BB_SPEC_EXPIRE_OVRD (PK) Child Table Name Child Column Name
Children: BB_SPEC_EXPIRE_OVRD_ID BB_SPEC_EXP_OVRD_PROD BB_SPEC_EXPIRE_OVRD_ID


BB_SPEC_EXP_OVRD_PROD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Specimen Expire Override Product
Definition: This table records the crossmatches affected when the user overrides (shortens or extends) the default specimen expiration date and time or when the system overrides the specimen expiration using a flex parameter.
Table Type: ACTIVITY





Column Detail - BB_SPEC_EXP_OVRD_PROD


Column Name Type Null? Definition
BB_SPEC_EXPIRE_OVRD_ID DOUBLE N Uniquely relates this product to the bb_spec_expire_ovrd table.
BB_SPEC_EXP_OVRD_PROD_ID DOUBLE N Uniquely identifies the crossmatch affected when the user overrides the default specimen or when the system overrides the specimen expiration using a flex parameter.
NEW_XM_EXPIRE_DT_TM DATETIME Y Date and time a specimen were collected for a person.
PREV_XM_EXPIRE_DT_TM DATETIME Y New Specimen expire date as it existed before the override. This may have been based on the default or flex expiration or the date from a previous override.
PRODUCT_EVENT_ID DOUBLE N Contains the identifier relating this specimen override to a unique product event.
PRODUCT_ID DOUBLE N Uniquely identifies the product related to this specimen override.
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_SPEC_EXP_OVRD_PROD


Child Column in BB_SPEC_EXP_OVRD_PROD(FK) Parent Table Name Parent Column Name
Parents: BB_SPEC_EXPIRE_OVRD_ID BB_SPEC_EXPIRE_OVRD BB_SPEC_EXPIRE_OVRD_ID
PRODUCT_ID PRODUCT PRODUCT_ID
PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID