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 |