BB_MOD_DEVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Modification Device
Definition: Stores a list of devices associated with a modification option.
Table Type: REFERENCE





Column Detail - BB_MOD_DEVICE


Column Name Type Null? Definition
DEFAULT_IND DOUBLE Y Indicates if this device is the default device for the modification option.
DEVICE_TYPE_CD DOUBLE N The code value that uniquely identifies a device type.
MAX_CAPACITY DOUBLE Y Defines the maximum capacity for the device.
MODIFICATION_DURATION DOUBLE Y Defines the standard modification time duration to be added to the modification start time in order to default the modification stop time.
OPTION_ID DOUBLE N The internal system assigned number that uniquely identifies a modification option.
START_STOP_TIME_IND DOUBLE Y Indicates if the system requires a start/stop time to be entered for the modification.
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_MOD_DEVICE


Child Column in BB_MOD_DEVICE(FK) Parent Table Name Parent Column Name
Parents: OPTION_ID BB_MOD_OPTION OPTION_ID


BB_MOD_NEW_PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank New Product
Definition: Stores a list of new products to create as the result of a modification option.
Table Type: REFERENCE





Column Detail - BB_MOD_NEW_PRODUCT


Column Name Type Null? Definition
ALLOW_EXTEND_EXP_IND DOUBLE Y Indicates if the new product's expiration date and time can be extended beyond the original product's expiration date and time.
ALLOW_NO_ABORH_IND DOUBLE Y Indicates if the new product's ABO/Rh can be left blank when pooling products.
BAG_TYPE_CD DOUBLE N The code value that identifies the bag type that must have been drawn in order to perform the modification.
CALC_EXP_DRAWN_IND DOUBLE Y Indicates if the new product's expiration date should be calculated from the original product's drawn date and time instead of from the modification date and time.
CALC_VOL_IND DOUBLE Y Indicates if the new product's volume should automatically be calculated from the original component products when pooling products.
CODABAR_BARCODE VARCHAR(20) Y Default Codabar product type barcode for the new product created in the modification.
CROSSOVER_REASON_CD DOUBLE N The code value that identifies the default crossover reason.
DEFAULT_EXP_DAYS DOUBLE Y Defines the number of days that will be added to the modification/drawn date and time in order to calculate the new product's expiration date.
DEFAULT_EXP_HRS DOUBLE Y Defines the number of hours that will be added to the modification/drawn date and time in order to calculate the new product's expiration date and time.
DEFAULT_ORIG_EXP_IND DOUBLE Y Indicates if the new product's expiration date and time should default to the original product's expiration date and time.
DEFAULT_ORIG_VOL_IND DOUBLE Y Indicates if the new product's volume should default to the original product's volume.
DEFAULT_SUB_ID_FLAG DOUBLE Y Defines the default sub product ID that should be assigned to each new product in order to make each product unique for the same product number. 0 - No Default 1 - Uppercase alpha 2 - Lowercase alpha 3 - Numeric
DEFAULT_SUPPLIER_ID DOUBLE N Identifies the default supplier id that should be associated with the new product. The supplier is defined on the organization table.
DEFAULT_UNIT_OF_MEAS_CD DOUBLE N The code value that identifies the default unit of measure associated with the new product volume.
DEFAULT_VOLUME DOUBLE Y Defines the default volume for the new product.
ISBT_BARCODE VARCHAR(20) Y Default ISBT product type barcode for the new product created in the modification.
MAX_PREP_HRS DOUBLE Y The maximum component preparation hours defines the number of hours to be added to the drawn date and time of the original product that cannot be exceeded in order to create the new product.
MOD_NEW_PROD_ID DOUBLE N The internal system assigned number that uniquely identifies a new blood bank product.
NEW_PRODUCT_CD DOUBLE N The code value that uniquely identifies a new product.
OPTION_ID DOUBLE N The internal system assigned number that uniquely identifies a modification option.
ORIG_PLASMA_PROD_CD DOUBLE N For reconstituted product option, this is the plasma and the RBC is the Orig_product_cd field
ORIG_PRODUCT_CD DOUBLE N The code value that uniquely identifies an original component product.
PROMPT_VOL_IND DOUBLE Y Indicates if the system should prompt for the new product's volume.
QUANTITY DOUBLE Y The quantity of new products of a given type to create when performing a product split.
REQUIRE_ASSIGN_IND DOUBLE Y Indicates if the system should require the new product to be assigned to a patient.
SYNONYM_ID DOUBLE N Identifies the confirmatory test that should be automatically ordered by the system when the modification is performed.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VALIDATE_VOL_IND DOUBLE Y Indicates if the volume of the new products volume should be validated to confirm it doesn't exceed the original products volume.



Relationship Detail - BB_MOD_NEW_PRODUCT


Child Column in BB_MOD_NEW_PRODUCT(FK) Parent Table Name Parent Column Name
Parents: OPTION_ID BB_MOD_OPTION OPTION_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
DEFAULT_SUPPLIER_ID ORGANIZATION ORGANIZATION_ID




Parent Column in BB_MOD_NEW_PRODUCT (PK) Child Table Name Child Column Name
Children: MOD_NEW_PROD_ID BB_MOD_SPECIAL_TESTING MOD_NEW_PROD_ID


BB_MOD_OPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Modification Option
Definition: Stores a list of all modification options that can be performed on blood bank products
Table Type: REFERENCE





Column Detail - BB_MOD_OPTION


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.
AD_HOC_IND DOUBLE Y Indicates if the original products will be split into multiple products and the user will determine the quantity of products to create at the time of modification.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CHANGE_ATTRIBUTE_IND DOUBLE Y Indicates if additional attribute(s) will be added to the original product.
CHG_ORIG_EXP_DT_IND DOUBLE Y Indicates if the original product's expiration date and time can be changed.
CROSSOVER_IND DOUBLE Y Indicates if the original product will be crossed over from autologous/directed to an allogeneic product.
DISPLAY VARCHAR(40) N The modification option description for display.
DISPLAY_KEY VARCHAR(40) N The modification option description in all uppercase used for performing indexed searches on the table.
DISPLAY_KEY_A_NLS VARCHAR(160) Y DISPLAY_KEY_A_NLS column
DISPLAY_KEY_NLS VARCHAR(82) Y The NLS versions of the modification option description in all uppercase used for performing indexed searches on the table.
DISPOSE_ORIG_IND DOUBLE Y indicates if the original product will be disposed of as a result of the modification.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
GENERATE_ISBT_NBR_IND DOUBLE N Indicates the ISBT number should be generated for the ISBT pools.
GENERATE_PROD_NBR_IND DOUBLE Y Indicates if the system should automatically generate product number when pooling products.
LABEL_INFO_PROMPT_IND DOUBLE N Indicates if the system should prompt for label information when modifying products.
NEW_PRODUCT_IND DOUBLE Y Indicates if a new product will be created as the result of the modification.
OPTION_ID DOUBLE N The internal system assigned number that uniquely identifies a modification option.
ORIG_NBR_DAYS_EXP DOUBLE Y Number of days to be added to the modification date to calculate the original product's new expiration date and time.
ORIG_NBR_HRS_EXP DOUBLE Y Number of hours to be added to the modification time to calculate the original product's new expiration date and time.
POOL_PRODUCT_IND DOUBLE Y Indicates if the original component products will be pooled to create a new product.
PROD_NBR_CCYY_IND DOUBLE Y Pooled product number year format for system generated product numbers. Indicates whether or not the year should format to 4 digits. A value of 1 indicates the year should format to 4 digits. A value of 0 indicates the year should format to 2 digits.
PROD_NBR_PREFIX VARCHAR(10) Y Pooled product number prefix for system generated product numbers.
PROD_NBR_SEQ DOUBLE Y Pooled product number sequence for system generated product numbers.
PROD_NBR_STARTING_NBR DOUBLE Y Pooled product number starting sequence number for system generated product numbers.
PROD_NBR_YEAR DOUBLE Y Pooled product number year for system generated product numbers.
RECON_RBC_IND DOUBLE N Indicates modification option is an RBC Reconstitution option.
SPLIT_IND DOUBLE Y Indicates if the original products will be split into multiple products.
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_MOD_OPTION




Parent Column in BB_MOD_OPTION (PK) Child Table Name Child Column Name
Children: OPTION_ID BB_MOD_DEVICE OPTION_ID
BB_MOD_NEW_PRODUCT OPTION_ID
BB_MOD_ORIG_PRODUCT OPTION_ID
BB_MOD_POOL_NBR OPTION_ID


BB_MOD_ORIG_PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Original Product
Definition: Stores a list of original component products associated with a modification option.
Table Type: REFERENCE





Column Detail - BB_MOD_ORIG_PRODUCT


Column Name Type Null? Definition
OPTION_ID DOUBLE N The internal system assigned number that uniquely identifies a modification option.
ORIG_PRODUCT_CD DOUBLE N The code value that uniquely identifies an original component product.
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_MOD_ORIG_PRODUCT


Child Column in BB_MOD_ORIG_PRODUCT(FK) Parent Table Name Parent Column Name
Parents: OPTION_ID BB_MOD_OPTION OPTION_ID


BB_MOD_POOL_NBR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Modification Pooled Product Number
Definition: Stores the pooled product number sequence buckets associated with a given pooling modification option. These sequence buckets are used to by the system to automatically generate unique product numbers when pooling products.
Table Type: REFERENCE





Column Detail - BB_MOD_POOL_NBR


Column Name Type Null? Definition
ISBT_SUPPLIER_FIN VARCHAR(5) Y The Facility Identification supplier which is in the product number barcode. (Alphanumeric)
MOD_POOL_NBR_ID DOUBLE N The internal system assigned number that uniquely identifies a blood bank pooled product number sequence bucket.
OPTION_ID DOUBLE N The internal system assigned number that uniquely identifies a modification option.
ORGANIZATION_ID DOUBLE N Obsolete. This column is no longer used. Uniquely identifies the organization that is creatin the pool. It will display as supplier on the label.
PREFIX VARCHAR(10) N Pooled product number prefix for system generated product numbers.
SEQ_NBR DOUBLE N Pooled product number sequence number for system generated product numbers.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
YEAR DOUBLE N Pooled product number year for system generated product numbers.



Relationship Detail - BB_MOD_POOL_NBR


Child Column in BB_MOD_POOL_NBR(FK) Parent Table Name Parent Column Name
Parents: OPTION_ID BB_MOD_OPTION OPTION_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID