Table Detail Report

BB_ISBT_ATTRIBUTE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: BLOOD BANK ISBT ATTRIBUTE R
Definition: Relates the user defined attribute code with what ISBT has.
Table Type: REFERENCE





Column Detail - BB_ISBT_ATTRIBUTE_R


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 values of antigens, modifiers, and attributes.
BB_ISBT_ATTRIBUTE_ID DOUBLE N Foreign key from bb_isbt_attribute table. Ties the user defined attribute code to the ISBT attribute
BB_ISBT_ATTRIBUTE_R_ID DOUBLE N Number to keep record unique.
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_R


Child Column in BB_ISBT_ATTRIBUTE_R(FK) Parent Table Name Parent Column Name
Parents: BB_ISBT_ATTRIBUTE_ID BB_ISBT_ATTRIBUTE BB_ISBT_ATTRIBUTE_ID


BB_ISBT_LABEL_PARAM



Column Section Top of Page


Table-level Detail

Description: Blood Bank ISBT Label Parameter
Definition: This table will store the default label parameters used to print Blood Bank ISBT Labels.
Table Type: REFERENCE





Column Detail - BB_ISBT_LABEL_PARAM


Column Name Type Null? Definition
BB_ISBT_LABEL_PARAM_ID DOUBLE N Contains the unique identifier for the ISBT label parameter.
LABEL_TYPE_CD DOUBLE N Indicates the type of label used for the print option.
LICENSED_MODIFIER_IND DOUBLE N Indicates if the modifying facility is licensed for the associated product.
LICENSED_SUPPLIER_IND DOUBLE N Indicates if the supplying facility is licensed for the associated product.
NEW_PRODUCT_CD DOUBLE N Uniquely identifies the new product type associated with the label parameter.
NEW_PRODUCT_IND DOUBLE N Indicates if the associated product is created as a result of the modification or if it is the original product.
OPTION_ID DOUBLE N Uniquely identifies the modification option associated with the label parameter.
ORIG_PRODUCT_CD DOUBLE N Uniquely identifies the original product type associated with the label parameter.
PRINT_IND DOUBLE N Indicates whether or not a label should be printed for the modification option/product type combination.
SUPPLIER_IND DOUBLE N Indicates if the facility is the supplying facility.
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_ISBT_PRODUCT_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: BLOOD BANK ISBT PRODUCT TYPE
Definition: Aliases the ISBT barcode to the Cerner product_cd
Table Type: REFERENCE





Column Detail - BB_ISBT_PRODUCT_TYPE


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_ISBT_PRODUCT_TYPE_ID DOUBLE N Number to keep each record unique
ISBT_BARCODE VARCHAR(15) N ISBT barcode value. Format is E####.
PRODUCT_CD DOUBLE N User defined product type that is associated with 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_PRODUCT_TYPE




Parent Column in BB_ISBT_PRODUCT_TYPE (PK) Child Table Name Child Column Name
Children: BB_ISBT_PRODUCT_TYPE_ID BB_ISBT_ADD_INFO BB_ISBT_PRODUCT_TYPE_ID


BB_ISBT_SUPPLIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank ISBT Supplier
Definition: Holds blood supplier organizations (including transfusion facilities that pool ISBT products) and their ISBT Facility Identification numbers.
Table Type: REFERENCE





Column Detail - BB_ISBT_SUPPLIER


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.
BB_ISBT_SUPPLIER_ID DOUBLE N Uniquely identifies a blood supplier by their ISBT Facility Identification number and the organization id.
INVENTORY_AREA_CD DOUBLE N For pooling facilities, the inventory areas that should use this license and registration number with the corresponding FIN from bb_isbt_supplier. 0 means all locations for this supplier (organization) use this FIN (and the same license and registration)
ISBT_SUPPLIER_FIN VARCHAR(5) Y Facility Identification Number for an ISBT supplier which is in the product number barcode. (Alphanumeric)
LICENSE_NBR_TXT VARCHAR(15) Y The license number of a facility for licensed products.
ORGANIZATION_ID DOUBLE N Uniquely identifies the organization for this supplier.
REGISTRATION_NBR_TXT VARCHAR(15) Y Contains the FDA Registration number for supplier facility.
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_SUPPLIER


Child Column in BB_ISBT_SUPPLIER(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


BB_PRINTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Printer
Definition: Contains blood bank printer information
Table Type: REFERENCE





Column Detail - BB_PRINTER


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.
BAUD_RATE_NBR DOUBLE N Contains the baud rate of the blood bank printer.
BB_PRINTER_ID DOUBLE N Uniquely identifies a blood bank printer.
CRC_IND DOUBLE N Indicates whether or not an error detection protocol is to be used with a blood bank printer that is serially attached to a com port.
HORIZONTAL_OFFSET_NBR DOUBLE N The horizontal offset in decimal format in millimeters fom the upper left corner of the printable area of a label. An example could be: 2.35 (meaning that the image will now be shifted to the right by 2.35 mm).
LABEL_TYPE_CD DOUBLE N The label form type that is currently loaded in the printer.
MODEL_CD DOUBLE N Contains the model of the blood bank printer.
PORT_ADDR VARCHAR(50) N The printer port address of the blood bank printer.
PRINTER_ADDR VARCHAR(50) N The network address of the blood bank printer.
PRINTER_DESCRIPTION_TXT VARCHAR(100) N A textual description of the blood bank printer.
PRINTER_NAME VARCHAR(50) N Name of the blood bank printer.
PRINTER_NAME_KEY VARCHAR(50) N Stores a corresponding string values for the printer name for the purposes of searching in UPPER case, less SPACES or special characters.
PRINTER_NAME_KEY_A_NLS VARCHAR(200) Y PRINTER_NAME_KEY_A_NLS column
PRINTER_NAME_KEY_NLS VARCHAR(102) N Stores the corresponding non-English character set values for the printer_name_key column.
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.
VERTICAL_OFFSET_NBR DOUBLE N Contains the vertical offset in decimal format in millimeters from the upper left corner of the printable area of a label. An example could be: 4.35 (meaning that the image will now be shifted down from the top most position on the label by 4.35 mm).



Relationship Detail - BB_PRINTER




Parent Column in BB_PRINTER (PK) Child Table Name Child Column Name
Children: BB_PRINTER_ID BB_FACILITY_PRINTER_R BB_PRINTER_ID
BB_SERVER_PRINTER_R BB_PRINTER_ID