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 |