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