Table Detail Report

BB_PRINT_SERVER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Print Server
Definition: Contains Blood Bank print server information
Table Type: REFERENCE





Column Detail - BB_PRINT_SERVER


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_PRINT_SERVER_ID DOUBLE N Contains an internal system assigned number that uniquely identifies a blood bank print server.
IP_ADDR VARCHAR(50) N Contains the network IP address of the blood bank print server.
PORT_ADDR VARCHAR(50) N Contains the address of the listening port of the blood bank print server.
REDUN_PARENT_SERVER_ID DOUBLE N Contains the parent server identifier of the redundant server.
SERVER_DESCRIPTION_TXT VARCHAR(100) N The textual description of the blood bank print server.
SERVER_NAME VARCHAR(50) N The name of the blood bank print server.
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_PRINT_SERVER


Child Column in BB_PRINT_SERVER(FK) Parent Table Name Parent Column Name
Parents: REDUN_PARENT_SERVER_ID BB_PRINT_SERVER BB_PRINT_SERVER_ID




Parent Column in BB_PRINT_SERVER (PK) Child Table Name Child Column Name
Children: BB_PRINT_SERVER_ID BB_PRINT_SERVER REDUN_PARENT_SERVER_ID
BB_SERVER_PRINTER_R BB_PRINT_SERVER_ID


BB_SERVER_PRINTER_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Server Printer Relationship
Definition: This table will store the printers which are currently associated with a specific blood bank print server.
Table Type: REFERENCE





Column Detail - BB_SERVER_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_PRINTER_ID DOUBLE N Uniquely identifies the blood bank printer involved in this relationship.
BB_PRINT_SERVER_ID DOUBLE N Uniquely identifies the blood bank print server involved in this relationship.
BB_SERVER_PRINTER_R_ID DOUBLE N Uniquely identifies a relationship between a specific printer and a specific print server.
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_SERVER_PRINTER_R


Child Column in BB_SERVER_PRINTER_R(FK) Parent Table Name Parent Column Name
Parents: BB_PRINTER_ID BB_PRINTER BB_PRINTER_ID
BB_PRINT_SERVER_ID BB_PRINT_SERVER BB_PRINT_SERVER_ID


BB_SUPPLIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Defines the suppliers of blood for the hospital.
Definition: This table is only necessary for suppliers that use supplier prefixes and alpha translations on their product numbers.
Table Type: REFERENCE





Column Detail - BB_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.
ALPHA_TRANSLATION_IND DOUBLE Y Determines whether the first two digits of the product number should be translated to a different character(s) for this supplier. Commonly used on Red Cross blood.
BARCODE_VALUE CHAR(20) Y The actual barcode value that is the FDA originating supplier prefix for this supplier.
BB_SUPPLIER_ID DOUBLE N The primary key to this table. An internal system-assigned number that ensures the uniqueness of every row on this table.
DEFAULT_PREFIX_IND DOUBLE Y Determines whether the supplier's prefix (ex. "09") should be displayed as a default at the time products are logged into the system from this supplier.
ISBT_BARCODE VARCHAR(15) Y Obsolete. This column is no longer being used. ISBT FIN of supplier. Used to scan supplier from the DIN field.
ORGANIZATION_ID DOUBLE N Links the row on this table to the actual organization defined for the blood bank supplier.
PREFIX_IND DOUBLE Y Determines whether this blood supplier ever ships blood products with an FDA originating supplier prefix on them.
PREFIX_VALUE CHAR(5) Y Defines the value of the FDA originating supplier prefix for this blood supplier, e.g., "09", which will be displayed as the leftmost digits of the product number.
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_SUPPLIER


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