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 |