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 |