Table Detail Report
PRODUCT_CATEGORY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Product Category |
Definition: | A user-defined reference of all categories (groupings) of like products, e.g., the red cell category. |
Table Type: | REFERENCE |
Column Detail - PRODUCT_CATEGORY
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. |
COMPONENT_TAG_IND | DOUBLE | Y | Indicates whether a component tag should be printed for all product types within this category, at the time the product is assigned or dispensed to a patient. |
CONFIRM_REQUIRED_IND | DOUBLE | Y | Indicates whether an ABORh confirmatory test is required of all product types within this category. This indicator determines whether the Receive Products application will automatically order the confirmatory test defined for products logged into inventory. This indicator also determines whether the Result Entry and Dispense applications will validate that the ABORh has been confirmed on the product. |
CROSSMATCH_TAG_IND | DOUBLE | Y | Indicates whether a crossmatch tag should be printed for all product types within this category, at the time the product is crossmatched or dispensed to a patient. |
DEFAULT_SHIP_COND_CD | DOUBLE | N | Defines the shipping condition that should be displayed as a default for all product types within this category, at the time the products are logged into inventory with the Receive Products application. |
DEFAULT_UNIT_MEASURE_CD | DOUBLE | N | Defines the unit of measure that should be displayed as a default for all product types within this category, at the time the products are logged into inventory with the Receive Products application. |
DEFAULT_VIS_INSP_CD | DOUBLE | N | Defines the visual inspection that should be displayed as a default for all product types within this category, at the time the products are logged into inventory with the Receive Products application. |
DONOR_LABEL_ABORH_CNT | DOUBLE | N | Defines the number of ABO/Rh tests that are required for a product type to be label verified. |
PILOT_LABEL_IND | DOUBLE | Y | Indicates whether pilot labels should be generated whenever a product within this category is received into inventory via the Receive Products application. A value of 1 indicates pilot labels should be printed. A value of 0 indicates pilot labels should NOT be printed. Pilot labels are small labels that are affixed to the tubes. |
PRODUCT_CAT_CD | DOUBLE | N | The code value for the actual product category defined. Combined wth the PRODUCT_CLASS, it makes each row unique. Product categories provide a way to group individual types of similar products into categories. Examples of product categories are: "Red Cell Products", "Plasma", "Platelets", etc. |
PRODUCT_CLASS_CD | DOUBLE | N | The code value of the product class, as defined on code set 1606. Product classes are currently pre-defined by Cerner. Two product classes are currently provided: "Blood Products", and "Derivatives". |
PROMPT_ALTERNATE_IND | DOUBLE | Y | Indicates whether the Receive Products application should prompt for an alternate number for all types of products within this category. Alternate numbers are used when site choose to renumber their products, and still wish to retain a record of the original number from the supplier. |
PROMPT_SEGMENT_IND | DOUBLE | Y | Indicates whether the Receive Products application should allow the user to enter the segment number when product types within this category are logged into inventory. |
PROMPT_VOL_IND | DOUBLE | Y | Indicates whether the Receive Products application should allow the user to enter the volume when product types within this category are logged into inventory. |
RED_CELL_PRODUCT_IND | DOUBLE | Y | Indicates whether all product types built within this category are red cell products. This indicator is used throughout the system to determine when certain validation should occur, and also in reports. |
RH_REQUIRED_IND | DOUBLE | Y | Indicates whether an Rh type is required on all product types built within this category. |
SPECIAL_TESTING_IND | DOUBLE | Y | Indicates whether the Receive Products application should allow the user to enter special testing when product types within this category are logged into inventory. |
STORAGE_TEMP_CD | DOUBLE | N | Defines the storage temperature that should be associated with all product types within this category, at the time the products are logged into inventory with the Receive Products application. (Currently, this value is automatically attached to the product and the Receive Products application does not prompt the user for a different storage temperature.) |
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. |
VALID_ABORH_COMPAT_IND | DOUBLE | Y | Indicates whether ABORh compatibility should be validated for all product types within this category, at the time a product is assigned, crossmatched, or dispensed to a patient. |
XMATCH_REQUIRED_IND | DOUBLE | Y | Indicates whether a crossmatch is required on any types of products within this product category, before dispensing it to a patient. |
Relationship Detail - PRODUCT_CATEGORY
Child Column in PRODUCT_CATEGORY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRODUCT_CLASS_CD | PRODUCT_CLASS | PRODUCT_CLASS_CD |
Parent Column in PRODUCT_CATEGORY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PRODUCT_CAT_CD | PRODUCT_BARCODE | PRODUCT_CAT_CD |
PRODUCT_INDEX | PRODUCT_CAT_CD |
PRODUCT_CLASS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Product Class |
Definition: | A reference table of all classes (groupings) of similar product categories. Classes are pre-defined by Cerner, and currently two classes exist: 1) blood products, and 2) derivatives. |
Table Type: | REFERENCE |
Column Detail - PRODUCT_CLASS
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. |
DESCRIPTION | VARCHAR(100) | Y | A description of the product class, either "Blood Products" or "Derivatives". This description will display in the Product Tool application, where categories can be built for each class of products. |
PRODUCT_CLASS_CD | DOUBLE | N | The code value of the product class, as defined on code set 1606. Product classes are currently pre-defined by Cerner. Two product classes are currently provided: "Blood Products", and "Derivatives". |
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 - PRODUCT_CLASS
Parent Column in PRODUCT_CLASS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PRODUCT_CLASS_CD | PRODUCT_BARCODE | PRODUCT_CLASS_CD |
PRODUCT_CATEGORY | PRODUCT_CLASS_CD | ||
PRODUCT_INDEX | PRODUCT_CLASS_CD |
PRODUCT_INDEX
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Product Index |
Definition: | Contains a reference of all types of products defined at a site, e.g., red blood cells, platelets, etc. Determines how the system will validate that product in certain transactions. |
Table Type: | REFERENCE |
Column Detail - PRODUCT_INDEX
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. |
ALIQUOT_IND | DOUBLE | N | Indicates whether this type of product is aliquot, i.e., a product that is broken into fractional units (pediatric, syringe, etc.) |
ALLOW_DISPENSE_IND | DOUBLE | Y | Indicates whether or not this type of product should be dispensed to patients. |
AUTOLOGOUS_IND | DOUBLE | Y | Indicates whether this type of product is autologous, i.e., a product that was donated by a person to be transfused to himself/herself later. So, for autologous products the designated recipient is the same person who donated the product. |
AUTO_BILL_ITEM_CD | DOUBLE | N | Not currently used. |
AUTO_QUARANTINE_MIN | DOUBLE | Y | The number of elapsed minutes for this type of product to be used in the Return Products application as criteria for quarantining a returned product, i.e., if the returned product has been out of the blood bank for more than the number of minutes defined here, the Return Products application will quarantine the product. |
DEFAULT_SUPPLIER_ID | DOUBLE | N | The supplier that should be defaulted for this product when it is 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. |
DEFAULT_VOLUME | DOUBLE | Y | The volume that should be defaulted for this product. Used in the ReceiveProducts application as a default volume for the user to either enter or change. |
DIRECTED_IND | DOUBLE | Y | Indicates whether this type of product is directed, i.e., a product that was donated by a person to be transfused to a designated recipient (ex. relative or friend) later. |
DIR_BILL_ITEM_CD | DOUBLE | N | Not currently used at this time. |
DRAWN_DT_TM_IND | DOUBLE | Y | Indicates whether or not the drawn_dt_tm should be used to calculate a product's expriation date/time in ReceiveProducts. |
INTL_UNITS_IND | DOUBLE | Y | This column applies only to derivative products. It indicates whether or not this product should be tracked by international units. (If not tracked by international units, it will be tracked by quantity) |
MAX_DAYS_EXPIRE | DOUBLE | Y | Defines the maximum number of days to expiration for this product type. This column is used in the ReceiveProducts application to assist in detecting clerical errors in the expiration date/time entered on products received. The ReceiveProducts application adds this number of days and the MAX_HRS_EXPIRE to the current date/time, and if the expiration date/time entered for a product of this type exceeds that date, the user is warned. |
MAX_HRS_EXPIRE | DOUBLE | Y | Defines the maximum number of hours to expiration for this product type. This column is used in the ReceiveProducts application to assist in detecting clerical errors in the expiration date/time entered on products received. The ReceiveProducts application adds the MAX_DAYS_EXPIRE and this number of hours to the current date and time, and if the expiration date and time entered for a product of this type exceeds that date/time, the user is warned. |
PRODUCT_CAT_CD | DOUBLE | N | The product category to which this type of product belongs. An example of a category is "Red Blood Cells", to which a product type of "RBC CPDA1" might belong. |
PRODUCT_CD | DOUBLE | N | The type of product defined. In the case of blood products, the product type is labeled on the actual bag of blood. |
PRODUCT_CLASS_CD | DOUBLE | N | Defines the class of products to which this type of product belongs. Currently, the classes are defined by Cerner only. Two classes have been pre-defined: blood products and derivatives. |
STORAGE_TEMP_CD | DOUBLE | N | Indicates the temperature at which a product should be stored |
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 received into inventory. 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. |
VALIDATE_AG_AB_IND | DOUBLE | Y | Indicates whether the red cell antigens should be validated against the person's antibodies at the time of dispense. |
VALIDATE_TRANS_REQ_IND | DOUBLE | Y | Indicates whether the attributes of the product should be validated against the person's transfusion requirements at the time of dispense. |
Relationship Detail - PRODUCT_INDEX
Child Column in PRODUCT_INDEX(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID |
DEFAULT_SUPPLIER_ID | ORGANIZATION | ORGANIZATION_ID | |
PRODUCT_CAT_CD | PRODUCT_CATEGORY | PRODUCT_CAT_CD | |
PRODUCT_CLASS_CD | PRODUCT_CLASS | PRODUCT_CLASS_CD |
Parent Column in PRODUCT_INDEX (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PRODUCT_CD | BB_DSPNS_BLOCK | PRODUCT_CD |
BB_DSPNS_BLOCK_PRODUCT | PRODUCT_CD | ||
COMPONENT | PRODUCT_CD | ||
MODIFY_OPTION | ORIG_PRODUCT_CD | ||
MODIFY_OPTION_TESTING | NEW_PRODUCT_CD | ||
POOL_OPTION | NEW_PRODUCT_CD | ||
PRODUCT_ABORH | PRODUCT_CD | ||
PRODUCT_BARCODE | PRODUCT_CD | ||
PRODUCT_PATIENT_ABORH | PRODUCT_CD | ||
PROD_ORD_PROD_IDX_R | PRODUCT_CD | ||
TRANSFUSION_COMMITTEE | PRODUCT_CD |
PRODUCT_PATIENT_ABORH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Product Patient Aborh |
Definition: | A reference table of the valid combinations of a type of product and its aborh with a certain aborhof the patient. Used at the time the product is assigned, crossmatched, or dispensed to the patient. |
Table Type: | REFERENCE |
Column Detail - PRODUCT_PATIENT_ABORH
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. |
PRODUCT_CD | DOUBLE | N | The type of product being defined for patient ABORh compatibility (ex. "Red Blood Cells"). |
PROD_ABORH_CD | DOUBLE | N | The product's ABORh that is being defined with a certain product type for patient ABORh compatibility (ex. "O Neg"). |
PRSN_ABORH_CD | DOUBLE | N | The person's ABORh that is being defined with a certain product type for patient ABORh compatibility (ex. "O Neg"). By being listed, it means that it is valid to assign, crossmatch, or dispense this product type and ABORh to a person with this ABORh. |
SEQUENCE_NBR | DOUBLE | N | An internal number which, when combined with the product type, product's ABORh, and person's ABORH, makes each row unique. It begins at 1 and is incremented by 1. It is needed because the user may choose to inactivate a product and ABORh combination, and later add it again as active. |
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. |
WARN_IND | DOUBLE | Y | Indicates whether or not the user should be warned when a product of this product type and this ABORh is associated (assigned, crossmatched, or dispensed) to a person with the ABORh defined. |
Relationship Detail - PRODUCT_PATIENT_ABORH
Child Column in PRODUCT_PATIENT_ABORH(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRODUCT_CD | PRODUCT_INDEX | PRODUCT_CD |
PROD_ORD_PROD_IDX_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Product Orderable Product Index Relationshp |
Definition: | A relationship between product orderables and product types. The information in this table will be used to validate if the type of product(s) being dispensed/modified are applicable for the dispense/modification product order(s). |
Table Type: | REFERENCE |
Column Detail - PROD_ORD_PROD_IDX_R
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. |
CATALOG_CD | DOUBLE | N | The product orderable code value. |
PRODUCT_CD | DOUBLE | N | Identifies the associated product type |
PROD_ORD_PROD_IDX_R_ID | DOUBLE | N | Uniquely identifies a relationship between a product orderable and a product type. |
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 - PROD_ORD_PROD_IDX_R
Child Column in PROD_ORD_PROD_IDX_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
PRODUCT_CD | PRODUCT_INDEX | PRODUCT_CD |