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 |