BB_ALPHA_TRANSLATION



Column Section Top of Page


Table-level Detail

Description: Blood Bank Alpha Translation
Definition: This table only applies to blood products, not derivatives. It allows the system to translate the barcoded version of the unit number into the eye-readable version. Mostly applies to products from American Red Cross.
Table Type: REFERENCE





Column Detail - BB_ALPHA_TRANSLATION


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 N 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.
ALPHA_BARCODE_VALUE CHAR(5) N The value of the barcode which should be translated into a different character. Usually it is 2 digits that are translated into a letter for Red Cross units.
ALPHA_TRANSLATION_ID DOUBLE N An internal system-assigned number that ensures the uniqueness of each row.
ALPHA_TRANSLATION_VALUE CHAR(5) Y Only applies to blood products. Defines the letter(s) into which the first two digits of the product number should be translated, e.g., "G" for 12. This way the product number can be barcoded in as "1212345" and translated into "G12345" which is the eye-readable number on the bag.
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.


BB_FACILITY_PRINTER_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Facility Printer Relationship
Definition: Contains information to relate a specific printer to a specific blood bank facility.
Table Type: REFERENCE





Column Detail - BB_FACILITY_PRINTER_R


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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 N 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_FACILITY_PRINTER_R_ID DOUBLE N Contains a number internally assigned by the system that uniquely identifies a blood bank facility and printer relationship.
BB_ORGANIZATION_ID DOUBLE N Uniquely identifies the blood bank organization involved in this relationship.
BB_PRINTER_ID DOUBLE N Uniquely identifies the blood bank printer involved in this relationship.
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_FACILITY_PRINTER_R


Child Column in BB_FACILITY_PRINTER_R(FK) Parent Table Name Parent Column Name
Parents: BB_PRINTER_ID BB_PRINTER BB_PRINTER_ID
BB_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


BB_ICCBBA_MAPPING



Column Section Top of Page


Table-level Detail

Description: Blood Bank ICCBBAA Mapping
Definition: This table will store the various database mappings used by the ICCBBA database.
Table Type: REFERENCE





Column Detail - BB_ICCBBA_MAPPING


Column Name Type Null? Definition
BB_ICCBBA_MAPPING_ID DOUBLE N This is the unique identifier of specific table/column mapping
COLUMN_NAME VARCHAR(60) N This is the name of the column on the e ICCBBA database.
COLUMN_TYPE_DESC VARCHAR(12) N This is the type of column referenced in the column_name column.
TABLE_NAME VARCHAR(60) N This is the name of the table on the ICCBBA database.
TABLE_TYPE_DESC VARCHAR(12) N This is the type of table referenced in the table_name column.
UNIQUE_VERSION_IND DOUBLE N This indicates whether or not the column contains a concatenation of values to maintain uniqueness.
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.
VERSION_NBR DOUBLE N This is the version number of the ICCBBA database mapping. This number will be incremented with each new database release.


BB_ISBT_ADD_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Child table of bb_isbt_product_type
Definition: Child table of bb_isbt_product_type that tells the system what attributes to put on the product if the parent ISBT barcode is entered.
Table Type: REFERENCE





Column Detail - BB_ISBT_ADD_INFO


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.
ATTRIBUTE_CD DOUBLE N User defined attribute or modifier that is present when using parent record.
BB_ISBT_ADD_INFO_ID DOUBLE N Number to keep each record unique
BB_ISBT_PRODUCT_TYPE_ID DOUBLE N Foreign key that associates this records attribute to the parent record (which is the ISBT barcode).
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_ISBT_ADD_INFO


Child Column in BB_ISBT_ADD_INFO(FK) Parent Table Name Parent Column Name
Parents: BB_ISBT_PRODUCT_TYPE_ID BB_ISBT_PRODUCT_TYPE BB_ISBT_PRODUCT_TYPE_ID


BB_ISBT_ATTRIBUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: BLOOD BANK ISBT ATTRIBUTE
Definition: Cerner defined table that matches various ISBT records
Table Type: REFERENCE





Column Detail - BB_ISBT_ATTRIBUTE


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.
ATTRIBUTE_GROUP VARCHAR(40) N Each ISBT attribute is part of an attribute group. When printing an ISBT label, the attribute group determines which order the label prints in. This field would act like a cdf_meaning field. It could be hard coded in the program.
BB_ISBT_ATTRIBUTE_ID DOUBLE N Unique number to keep each record unique.
LABEL_DISPLAY VARCHAR(40) N Each ISBT attribute will be displayed on the ISBT label. This field will be the text that gets displayed on the label.
STANDARD_DISPLAY VARCHAR(40) N This field should match exactly to what is in the ICCBBA ISBT database. This field acts like a cdf_meaning and can be hard coded.
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_ISBT_ATTRIBUTE




Parent Column in BB_ISBT_ATTRIBUTE (PK) Child Table Name Child Column Name
Children: BB_ISBT_ATTRIBUTE_ID BB_ISBT_ATTRIBUTE_R BB_ISBT_ATTRIBUTE_ID