Table Detail Report

MODIFY_OPTION_TESTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Modify Option Testing
Definition: This table contains the attributes that will be applied to the new product created for a particularmodification option.
Table Type: REFERENCE





Column Detail - MODIFY_OPTION_TESTING


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 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.
CALC_EXP_DRAWN_IND DOUBLE Y This column is not yet used within the Modify Products application. The planned use of this indicator is for a particular modification option, it will determine whether the expiration date and time should be calculated from the drawn date and time of the blood product. A value of 1 indicates that the drawn date/time should be used. A value of 0 indicates that the modified date/time should be used instead. Currently, Modify Products always uses the modified date/time to calculate expiration.
DEFAULT_EXP_DAYS DOUBLE Y The number of days that should be used to calculate the new product's expiration date/time. This number of days will be added to the modified date/time to calculate the new product's expiration date/time. This number may be zero if the user wants to use hours (Default_Exp_Hrs) instead to calculate the new product's expiration date/time.
DEFAULT_EXP_HRS DOUBLE Y The number of hours that should be used to calculate the new product's expiration date/time. This number of hours will be added to the modified date/time to calculate the new product's expiration date/time. This number may be zero if the user wants to use days (Default_Exp_Days) instead to calculate the new product's expiration date/time.
MAX_PREP_HRS DOUBLE Y This column is not yet used within the Modify Products application. Its planned use is for a number of hours to be used to validate that the original product is still valid for being used in this particular modification option. If the maximum number of hours has passed in which to prepare the new product, it should not be allowed. It will be measured from the drawn date/time of the original product. Example: Fresh Frozen Plasma cannot be created more than 8 hours after the unit was drawn.
MODIFY_OPTION_TST_ID DOUBLE N This is a system-generated number that uniquely identifies a row on this table.
NEW_PRODUCT_CD DOUBLE N The code value that represents the new product to be created during this particular modification option (ex. "Red Cells Washed"). The new product may be the same as the original product, in the case of attributes being applied to a product.
OPTION_ID DOUBLE N The number in this column corresponds to a row on the Modify_Option table, which associates the modification option to the testing defined on this table for it.
SPECIAL_TESTING_CD DOUBLE N A code value that represents the special testing which should be applied to the new product created for this particular modification option. This is used to apply attributes to the new product, such as "Irradiated", "Washed", "CMV Negative" etc.
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_TESTING


Child Column in MODIFY_OPTION_TESTING(FK) Parent Table Name Parent Column Name
Parents: OPTION_ID MODIFY_OPTION OPTION_ID
NEW_PRODUCT_CD PRODUCT_INDEX PRODUCT_CD


NEW_PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: New Product
Definition: A reference of the new products defined for each type of product modification which creates new products from the original one.
Table Type: REFERENCE





Column Detail - NEW_PRODUCT


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.
DEFAULT_EXP_DAYS DOUBLE Y Defines the default expiration that should be calculated for the new product created during modification. The system will add this number of days to the modification date and time, to calculate the default expiration date and time for the new product. (The system also uses the number of hours defined in the DEFAULT_EXP_HRS column.)
DEFAULT_EXP_HRS DOUBLE Y Defines the default expiration that should be calculated for the new product created during modification. The system will add this number of hours to the modification date and time, to calculate the default expiration date and time for the new product. (The system also uses the number of days defined in the DEFAULT_EXP_DAYS column.)
DEFAULT_MEASURE_IND DOUBLE Y Defines whether or not the unit of measure of the new product should be defaulted at the time of modification.
DEFAULT_UNIT_MEASURE_CD DOUBLE N Represents the code value for the unit of measure that should be displayed as the default value for the new product being created during the modification transaction. This column may be blank (zero) if the user does not wish to have a default unit of measure displayed at all.
DEFAULT_VOLUME DOUBLE Y Defines the volume that should be displayed as the default value for the new product being created during the modification transaction. This column may be blank (zero) if the user does not wish to have a default volume displayed at all.
DEFAULT_VOLUME_IND DOUBLE Y Defines whether or not the volume of the new product should be defaulted at the time of modification.
DFLT_ORIG_VOLUME_IND DOUBLE N Indicates that the volume of the original product should be used as the default volume for the new product.
MAX_PREP_HRS DOUBLE Y Defines the validation that should occur, if any, on whether the product is too "old" to be modified. An example is creating fresh frozen plasma, which must be done within eight hours after the original product is drawn from the donor. The system will add the number of hours defined in this column to the drawn date of the product, and validate whether the modification date and time entered is less than the maximum date and time calculated.
NEW_PRODUCT_CD DOUBLE N The code value for the new product type to be created from the
OPTION_ID DOUBLE N Part of the primary key of this table. An internal system-assigned number that is the sole primary key of the MODIFY_OPTION table. The value in this column corresponds to a row on the MODIFY_OPTION table, in order to link a specific modification option with the new products created for that option.
QUANTITY DOUBLE Y This column applies only to modification options for splitting the original product into multiple bags of the same product type (refer to the DIVISION_TYPE_FLAG column). The number in this column defines the number of new products that the modification process should generate from the original product entered.
SPECIAL_TESTING_CD DOUBLE N The code value that represents the special testing, if any, that should be added to the new product created from the modification process. This includes any product attributes, such as "Irradiated", "Washed", etc.
SUB_PROD_ID_FLAG DOUBLE Y Defines the type of sub product ID that should be assigned to each new product created during modification, in order to make each product unique for the same product number. The type of sub product number defined here will be displayed as a default on modifications with different product types created. On modifications that split the original product into multiple ones, this sub product number will be automatically assigned by the system to new products created.
SYNONYM_ID DOUBLE N This column represents the confirmatory test, if applicable, that should be automatically ordered on the product at the time it is modified. This confirmatory test is built in the order catalog and given a synonym, which this column represents. It is the primary key of the SYNONYM table, and is an internal system-assigned 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 - NEW_PRODUCT


Child Column in NEW_PRODUCT(FK) Parent Table Name Parent Column Name
Parents: OPTION_ID MODIFY_OPTION OPTION_ID


POOLED_PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pooled Product
Definition: A reference of the new types of products that can be created by pooled, by a site.
Table Type: REFERENCE





Column Detail - POOLED_PRODUCT


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.
POOL_NBR DOUBLE N The incremental number used to generate a unique product number for the newly pooled product created by the PoolProducts application. This number begins at 1 and increments by 1 every time this type of pooled product is created.
POOL_OPTION_ID DOUBLE N The primary key of the POOL_OPTION table. An internal system-assigned number. On this table, it is used to associate the product number generated with the appropriate pooling option.
POOL_OPTION_NBR_ID DOUBLE N The primary key of this table. An internal system-assigned number that ensures the uniqueness of each row.
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.
YEAR DOUBLE Y The year that should be used to generate the pooled product number. This is provided so that sites will know how many pooled products of a certain type have been created for that year.



Relationship Detail - POOLED_PRODUCT


Child Column in POOLED_PRODUCT(FK) Parent Table Name Parent Column Name
Parents: POOL_OPTION_ID POOL_OPTION OPTION_ID


POOL_OPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pool Option
Definition: A reference table of all types of pooling a site may perform.
Table Type: REFERENCE





Column Detail - POOL_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_NO_ABORH_IND DOUBLE Y Indicates whether the newly pooled product can be allowed to have no ABO group or Rh type associated with it.
CALCULATE_VOL_IND DOUBLE Y Indicates whether the volume of the newly pooled product should be automatically calculated by adding the volume of each component within the pool.
DEFAULT_EXP_HRS DOUBLE Y The number of hours that should be added to the date and time of the pooling transaction in order to calculate the default for the newly pooled product's expiration date and time.
DEFAULT_SUPPLIER_ID DOUBLE N The supplier that should be associated with the newly pooled product, since it is not received from an outside supplier. This column actually represents an ORGANIZATION_ID, which is the primary key of the ORGANIZATION table. It is an internal system-assigned number. For pooled products, the supplier is usually the organization who is actually doing the pooling, ex., the hospital.
DESCRIPTION VARCHAR(40) Y A description of this type of pooling that identifies it from other types of pooling, ex. "Pooled Platelets".
GENERATE_PROD_NBR_IND DOUBLE Y Indicates whether the product number for the newly pooled product should be generated by the system. If so, the "PoolProducts" application will generate a unique product number for it. If not, it will be manually entered by the user in the "PoolProducts" application.
NEW_PRODUCT_CD DOUBLE N The type of new product that should be created when this pooling option is used.
OPTION_ID DOUBLE N The primary key of this table. An internal system-assigned number that ensures the uniqueness of each row.
PRODUCT_NBR_PREFIX CHAR(10) Y If the product number for the newly pooled product will be generated by the system as opposed to user entry (as defined by the GENERATE_PROD_NBR_IND), then this prefix will be used to generate that number. The character in this prefix will become the leftmost characters of the new product's number, to be concatenated with a unique number to the right of the prefix. This prefix usually represents the type of product being pooled, ex. "PL" for pooled platelets, "CR" for pooled cryo, etc.
PROMPT_VOL_IND DOUBLE Y Indicates whether the "PoolProducts" application should force the user to enter the volume of the newly pooled product, with no default displayed for it.
REQUIRE_ASSIGN_IND DOUBLE Y Indicates whether the newly pooled product should be assigned to a patient. If this indicator is turned on (set to 1), then the PoolProducts application will require the newly pooled product to be assigned to a patient in order to create the 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 - POOL_OPTION


Child Column in POOL_OPTION(FK) Parent Table Name Parent Column Name
Parents: DEFAULT_SUPPLIER_ID ORGANIZATION ORGANIZATION_ID
NEW_PRODUCT_CD PRODUCT_INDEX PRODUCT_CD




Parent Column in POOL_OPTION (PK) Child Table Name Child Column Name
Children: OPTION_ID COMPONENT OPTION_ID
POOLED_PRODUCT POOL_OPTION_ID