BB_EDN_ADMIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Electronic Delivery Note Administration
Definition: This table contains the administration information from an Electronic Delivery Note message structure
Table Type: ACTIVITY





Column Detail - BB_EDN_ADMIN


Column Name Type Null? Definition
ADMIN_DT_TM DATETIME N The data and time the electronic data note was dispatched or acknowledged.
BB_EDN_ADMIN_ID DOUBLE N Uniquely identifies administration information from an electronic delivery note message structure.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DESTINATION_INV_AREA_CD DOUBLE N Inventory Area where the product will be received.
DESTINATION_LOC_CD DOUBLE N Refers to the location the products in the Electronic Delivery Note to which the file will be shipped.
DISPATCH_NBR_TXT VARCHAR(12) N Contains the dispatch number from the electronic delivery note file.
EDN_COMPLETE_IND DOUBLE N Indicates if the electronic delivery note has been completed.
LONG_BLOB_ID DOUBLE N Contains the unique identifier for the long blob text corresponding to the electronic delivery note file.
ORDER_NBR_IDENT VARCHAR(12) N Uniquely identifies the order number from the electronic delivery note file.
PROTOCOL_NBR DOUBLE N Identifies the protocol (1 - 5) of the electronic delivery note file.0 if Electronic receipt (i.e. Donor Inbound)
SOURCE_ORG_ID DOUBLE N Contains the unique identifier of the organization from which the electronic delivery note was sent.
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_EDN_ADMIN


Child Column in BB_EDN_ADMIN(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID
SOURCE_ORG_ID ORGANIZATION ORGANIZATION_ID




Parent Column in BB_EDN_ADMIN (PK) Child Table Name Child Column Name
Children: BB_EDN_ADMIN_ID BB_EDN_DSCRPNCY_OVRD BB_EDN_ADMIN_ID
BB_EDN_PRODUCT BB_EDN_ADMIN_ID


BB_EDN_DSCRPNCY_OVRD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Electronic Delivery Note Discrepancy Override
Definition: This table contains override information for discrepancies that occurred with an Electronic Delivery Note file import.
Table Type: ACTIVITY





Column Detail - BB_EDN_DSCRPNCY_OVRD


Column Name Type Null? Definition
BB_EDN_ADMIN_ID DOUBLE N Uniquely identifies administration information from an Electronic Delivery Note message structure related to this override.
BB_EDN_DSCRPNCY_OVRD_ID DOUBLE N Uniquely identifies override information for discrepancies that occurred with an electronic delivery note file import.
BB_EDN_PRODUCT_ID DOUBLE N Uniquely identifies the product related to this override.
EDN_PRODUCT_NBR_IDENT VARCHAR(20) N Contains the product number of the discrepant product. This number comes from the Electronic Delivery Note file.
EXCEPTION_ID DOUBLE N Uniquely identifies the exception related to this discrepancy.
OVRD_REASON_CD DOUBLE N Contains the reason the discrepancy was overridden.
PRODUCT_CD DOUBLE N The product type of the discrepant product.
PRODUCT_ID DOUBLE N Uniquely identifies the product related to this discrepancy.
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_EDN_DSCRPNCY_OVRD


Child Column in BB_EDN_DSCRPNCY_OVRD(FK) Parent Table Name Parent Column Name
Parents: BB_EDN_ADMIN_ID BB_EDN_ADMIN BB_EDN_ADMIN_ID
BB_EDN_PRODUCT_ID BB_EDN_PRODUCT BB_EDN_PRODUCT_ID
EXCEPTION_ID BB_EXCEPTION EXCEPTION_ID
PRODUCT_ID PRODUCT PRODUCT_ID


BB_EDN_PROBLEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Electronic Delivery Note Problem
Definition: Contains a log of issues where blood bank products could not be electronically received from an FSI inbound interface.
Table Type: ACTIVITY





Column Detail - BB_EDN_PROBLEM


Column Name Type Null? Definition
BB_EDN_PROBLEM_ID DOUBLE N Uniquely identifies an issue where blood bank products could not be electronically received from an FSI inbound interface.
BB_EDN_PRODUCT_ID DOUBLE N Uniquely identifies the product from the bb_edn_product table that is associated with this problem.
PROBLEM_TYPE_CD DOUBLE N Identifies the type of problem reported.
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_EDN_PROBLEM


Child Column in BB_EDN_PROBLEM(FK) Parent Table Name Parent Column Name
Parents: BB_EDN_PRODUCT_ID BB_EDN_PRODUCT BB_EDN_PRODUCT_ID


BB_EDN_PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Electronic Delivery Note Product
Definition: This table contains the product information from an Electronic Delivery Note message structure.
Table Type: ACTIVITY





Column Detail - BB_EDN_PRODUCT


Column Name Type Null? Definition
ABO_CD DOUBLE N Contains the product's ABO value from the electronic delivery note file.
ALIAS VARCHAR(100) Y Alias used by FSI for person matching. Could be encounter or person alias.
ALIAS_POOL_CD DOUBLE N Alias pool used by FSI for person matching. Can be person or encounter.
BB_EDN_ADMIN_ID DOUBLE N Uniquely identifies the row on the Electronic Delivery Note related to this product.
BB_EDN_PRODUCT_ID DOUBLE N Uniquely identifies product information from an Electronic Delivery Note message structure.
CLINICAL_USE_IND DOUBLE N Indicates if a product is suitable for clinical use.
DATA_SOURCE_FLAG DOUBLE N Contains Source of Product Information. 0 - Unidentified Source; 1 - BloodNet GS1; 2 - BloodNet ISBT
DELIVERY_TYPE_CD DOUBLE N Contains the product's type of delivery from the Electronic Delivery Note file.
DEVICE_TXT VARCHAR(40) Y This is the value passed in an interface storage location field. It should match to a description on the BB_INV_DEVICE table.
DONATION_DT_TM DATETIME Y Contains the date and time the product was donated from the Electronic Delivery Note file.
EDN_PRODUCT_NBR_IDENT VARCHAR(20) N Contains the product number from the Electronic Delivery Note file.
ENCNTR_ID DOUBLE N The encntr of the person to be associated to the product
EVENT_DT_TM DATETIME Y If the time the action was taken is significant (i.e. transfusion), this is the date and time. If it is not significant, the EDN_Admin/ Admin date and Time will be used.
EVENT_PRSNL_ID DOUBLE N The id of the user that performed the action, or zero if not available.
EXPIRATION_DT_TM DATETIME Y Contains the product's expiration date and time from the Electronic Delivery Note file.
FLAG_CHAR_TXT VARCHAR(2) Y ISBT flag characters. Default to 00 for ISBT product numbers, no value for other formats.
ISBT_BLOOD_TYPE_BARCODE VARCHAR(200) Y contains abo/rh barcode. The format could be isbt or a format that matches the abo/rh tool.
LONG_TEXT_ID DOUBLE N Contains the ID of the product comment stored on the long text reference table.
MANUFACTURER_ID DOUBLE N the id of the organization which manufactured this derivative batch.
PERSON_ID DOUBLE N The person the product is associated to. For Transfused, this is the transfusion recipient.
PRODUCT_CD DOUBLE N Millennium product type, if the product_type_text for the bb_edn_product table was resolved to a Millennium product type. This is displayed on the problem exception report.
PRODUCT_COMMENT_TXT VARCHAR(30) N Contains the product comment from the Electronic Delivery Note file.
PRODUCT_COMPLETE_IND DOUBLE N Indicates that the product has been reconciled.
PRODUCT_ID DOUBLE N Contains the associated product identifier from the product table.
PRODUCT_IDENT VARCHAR(40) Y Identifies the product received from external service
PRODUCT_SUB_NBR_TXT VARCHAR(5) Y Indicates the division characters if the product is divided. will correspond to the product_sub_nbr on the product table if the transaction is successful.
PRODUCT_TYPE_IDENT VARCHAR(40) Y Identifies the product type identifier from an external service.
PRODUCT_TYPE_TXT VARCHAR(50) N Contains the product type from the Electronic Delivery Note file.
RECEIVED_QTY DOUBLE Y available quantity received through the interface
RH_CD DOUBLE N Contains the product's RH value from the Electronic Delivery Note file.
SERIAL_NUMBER_TXT VARCHAR(22) Y Contains GS1 serial number for derivative products when applicable.
STATUS_CD DOUBLE N Describes the status change occurring to the product. Note that this is from the process codeset, not the event_type code set.
SUB_STATUS_CD DOUBLE N If the status is transferred, this is the transfer reason.
SUPPLIER_PRODUCT_ALIAS_NAME VARCHAR(40) Y Product identifier unique to sending system.
UNITS_PER_VIAL DOUBLE Y number of international units per vial
UNIT_CONDITION_CD DOUBLE N This is the unit condition mapped to a quarantine reason on code set 1630. If there is not a value, either the condition was ok, or the condition is not aliased for inbound transaction.
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.
VOLUME_CNT DOUBLE N Contains the product volume from the Electronic Delivery Note file.



Relationship Detail - BB_EDN_PRODUCT


Child Column in BB_EDN_PRODUCT(FK) Parent Table Name Parent Column Name
Parents: BB_EDN_ADMIN_ID BB_EDN_ADMIN BB_EDN_ADMIN_ID
PERSON_ID PERSON PERSON_ID
EVENT_PRSNL_ID PRSNL PERSON_ID




Parent Column in BB_EDN_PRODUCT (PK) Child Table Name Child Column Name
Children: BB_EDN_PRODUCT_ID BB_EDN_DSCRPNCY_OVRD BB_EDN_PRODUCT_ID
BB_EDN_PROBLEM BB_EDN_PRODUCT_ID
BB_EDN_SPCL_TESTING BB_EDN_PRODUCT_ID


BB_EDN_SPCL_TESTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Electronic Delivery Note Special Testing
Definition: This table contains the special testing information from an Electronic Delivery Note message structure for a product.
Table Type: ACTIVITY





Column Detail - BB_EDN_SPCL_TESTING


Column Name Type Null? Definition
BB_EDN_PRODUCT_ID DOUBLE N Uniquely identifies the Electronic Delivery Note product related to this special test.
BB_EDN_SPCL_TESTING_ID DOUBLE N Uniquely identifies special testing information from an Electronic Delivery Note message structure for a product.
CONFIRMED_IND DOUBLE N Indicates if the product's antigen is confirmed.
ISBT_SPCL_TEST_BARCODE VARCHAR(200) Y Contains the ISBT barcode value for special testing.
ISBT_SPCL_TEST_BARCODE_TYP_TXT VARCHAR(2) Y ISBT Data identifier for the data structure populated in ISBT_SPECIAL_TESTING_BARCODE (i.e., if the format of the barcode is data structure 10, Special testing: General, '&(' is data identifier. This tells the application the expected format of the barcode and how to translate the barcode.
SPCL_TESTING_CD DOUBLE N Contains the product's special testing code value.
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_EDN_SPCL_TESTING


Child Column in BB_EDN_SPCL_TESTING(FK) Parent Table Name Parent Column Name
Parents: BB_EDN_PRODUCT_ID BB_EDN_PRODUCT BB_EDN_PRODUCT_ID