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 |