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 |