Table Detail Report

BB_MOD_SPECIAL_TESTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Modification Special Testing
Definition: Stores a list of special testing attributes associated with the new products for a given modification option.
Table Type: REFERENCE





Column Detail - BB_MOD_SPECIAL_TESTING


Column Name Type Null? Definition
MOD_NEW_PROD_ID DOUBLE N The internal system assigned number that uniquely identifies a new blood bank product.
SPECIAL_TESTING_CD DOUBLE N The code value that uniquely identifies the special testing attribute to be applied to the new 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_SPECIAL_TESTING


Child Column in BB_MOD_SPECIAL_TESTING(FK) Parent Table Name Parent Column Name
Parents: MOD_NEW_PROD_ID BB_MOD_NEW_PRODUCT MOD_NEW_PROD_ID


COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Component
Definition: A reference table of product types defined as valid components of certain pooled products.
Table Type: REFERENCE





Column Detail - COMPONENT


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.
OPTION_ID DOUBLE N The primary key of this table. An internal system-assigned number that ensures the uniqueness of each row.
PRODUCT_CD DOUBLE N The code value representing the product type defined as a valid component of this particular pooled 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 - COMPONENT


Child Column in COMPONENT(FK) Parent Table Name Parent Column Name
Parents: OPTION_ID POOL_OPTION OPTION_ID
PRODUCT_CD PRODUCT_INDEX PRODUCT_CD


MODIFY_DEVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Modify Device
Definition: Indicates the device a product was associated with when the product was modified.
Table Type: ACTIVITY





Column Detail - MODIFY_DEVICE


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.
DEVICE_ID DOUBLE N The primary key to the BB_INV_DEVICE table. Uniquely identifies device associated with a product modification.
MODIFY_DEVICE_ID DOUBLE N Unique identifier for MODIFY_DEVICE table
PRODUCT_ID DOUBLE N %Uniquily%
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 - MODIFY_DEVICE


Child Column in MODIFY_DEVICE(FK) Parent Table Name Parent Column Name
Parents: DEVICE_ID BB_INV_DEVICE BB_INV_DEVICE_ID
PRODUCT_ID PRODUCT PRODUCT_ID


MODIFY_OPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Modify Option
Definition: A reference of all types of modifications that a site could perform on products.
Table Type: REFERENCE





Column Detail - MODIFY_OPTION


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.
ALLOW_EXTEND_EXP_IND DOUBLE N Indicates if the new product's expiration date can be extended beyond the original product's expiration date in Modify Products.
BAG_TYPE_CD DOUBLE N The type of bag in which the product must have been drawn, in order to perform this type of modification on it.
BAG_TYPE_VALID_IND DOUBLE Y Indicates whether the system should validate that the bag type of the product entered matches the bag type defined for this modification option.
CALC_EXP_DRAWN_IND DOUBLE Y Indicates whether the system should calculate the new expiration date and time from the date and time the product was drawn, instead of from the date and time of the modification.
CALC_ORIG_EXP_DRAWN_IND DOUBLE N Indicates if the drawn date should be used to calculated the original product's expiration date
CHG_ORIG_EXP_DT_IND DOUBLE Y Indicates whether the original product's expiration date and time should be changed or not.
CROSSOVER_REASON_CD DOUBLE N This column only applies to modification options of the crossover type. It defines the default reason products are being "crossed over" from autologous or directed to allogeneic types of products. This reason is displayed in the modification application at the time this option is chosen.
DESCRIPTION VARCHAR(40) Y %modifcati
DISPOSE_ORIG_IND DOUBLE Y Indicates whether the original product should be disposed when performing this type of modification.
DIVISION_TYPE_FLAG DOUBLE Y The type of division of the original product.
OPTION_ID DOUBLE N The primary key of this table. An internal system-assigned number that ensures the uniqueness of each row.
ORIG_NBR_DAYS_EXP DOUBLE Y Determines how the system should calculate the new expiration date and time of the original product. The system will add the number of days defined here to the modification date and time, to calculate the new expiration date and time of the original product. (The system uses the value in the ORIG_NBR_HRS_EXP column as well)
ORIG_NBR_HRS_EXP DOUBLE Y Determines how the system should calculate the new expiration date and time of the original product. The system will add the number of hours defined here to the modification date and time, to calculate the new expiration date and time of the original product. (The system uses the value in the ORIG_NBR_DAYS_EXP column as well)
ORIG_PRODUCT_CD DOUBLE N The product type that must be entered as the original product, in order to perform this type of 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.
VALIDATE_VOL_IND DOUBLE Y Indicates whether the system should validate the volume entered for the new product(s). If this indicator is set, the system will subtract the volume of the new product(s) from the original product, and display the new remaining volume of the original product.



Relationship Detail - MODIFY_OPTION


Child Column in MODIFY_OPTION(FK) Parent Table Name Parent Column Name
Parents: ORIG_PRODUCT_CD PRODUCT_INDEX PRODUCT_CD




Parent Column in MODIFY_OPTION (PK) Child Table Name Child Column Name
Children: OPTION_ID MODIFY_OPTION_TESTING OPTION_ID
NEW_PRODUCT OPTION_ID


MODIFY_OPTION_DEVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Modify Option Device Type Relationship
Definition: This table is used to store the device types which may be associated with a specific modification option.
Table Type: REFERENCE





Column Detail - MODIFY_OPTION_DEVICE


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.
CREATE_DT_TM DATETIME N This is the date and time the row was created.
DEVICE_TYPE_CD DOUBLE N This field will contain the code value associated with the type of device used during the modification process for the modification option defined.
NBR_OF_DEVICE DOUBLE N This field indicates the number of the specific devices used during the modification process.
OPTION_DEVICE_ID DOUBLE N This is the unique identifier for the row on the table.
OPTION_ID DOUBLE N This is the unique identifier for the modification option the row defines.
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 - MODIFY_OPTION_DEVICE


Child Column in MODIFY_OPTION_DEVICE(FK) Parent Table Name Parent Column Name
Parents: DEVICE_TYPE_CD CODE_VALUE CODE_VALUE