D Appendix: Innovation Workbench

The Innovation Workbench tables follow this convention: the RSE prefix is used for core foundation tables, the PRO prefix is used for Promotion and Markdown Optimization tables, and the PRO_REG prefix is used for Regular Pricing Optimization tables.

For Rules Based Regular Pricing, the following Regular Pricing tables are the most relevant for validation, diagnostics, recommendation review, integration tracking, and reporting. These tables are exposed in read-only mode and can be used to analyze run setup, rule application, generated recommendations, export status, and run failures.

Table D-1 Innovation Workbench Tables for Rules Based Regular Pricing

Table Name	Use in Rules Based Regular Pricing
PRO_REG_RUN_HDR	Contains run-level information such as run ID, run name, run status, strategy, scope, optimization dates, created user, modified user, and execution details.
PRO_BATCH_REG_RUN_QUEUE	Contains batch queue information for scheduled Regular Pricing runs.
PRO_REG_RUN_PRODUCT	Contains the merchandise or product scope included in the run.
PRO_REG_RUN_LOC_PZ	Contains the location or price zone scope included in the run.
PRO_REG_RUN_REC_ITEM	Contains item-level recommendation records generated for the run.
PRO_REG_RUN_REC_ITEM_DATE	Contains effective date information for item-level regular price recommendations.
PRO_REG_RUN_RECOM_OPT_RESULT	Contains optimized Regular Pricing recommendation results, including recommended price, override price where applicable, recommendation status, effective date, and export-related information.
PRO_REG_RUN_RECOM_DENORMALIZE	Contains denormalized recommendation information used for reporting and analysis.
PRO_REG_RUN_RESULT_METRIC	Contains run result metrics available for Regular Pricing runs. For Rules Based runs, forecast-dependent projected metrics may not be populated.
PRO_REG_RUN_SANITY_CHECK_RES	Contains validation, warning, alert, and error information generated for a run. Review this table when a run ends in Failed status or recommendations are not generated as expected.
PRO_REG_RUN_PRICERECOM_INT_ERR	Contains integration error information related to regular price recommendation export.
PRO_REG_RUN_OPT_RULES	Contains the rules evaluated during optimization for the run.
PRO_REG_RUN_OPT_RULES_REC_DTL	Contains item-level rule evaluation details for generated recommendations.
PRO_REG_RUN_OPT_RULES_RELAX	Contains relaxed or violated rule information when the best feasible recommendation is generated.
PRO_REG_OPT_RULES_BAD	Contains rule validation issues identified before or during optimization.
PRO_REG_RUN_PRICE_LADDER	Contains price ladder information applied during the run.
PRO_REG_RUN_PRICE_MATRIX	Contains price matrix information applied during the run.
PRO_REG_PRICE_MATRIX_HDR	Contains price matrix header setup information.
PRO_REG_PRICE_MATRIX_DTL	Contains price matrix detail setup information.
PRO_REG_PRICE_MATRIX_BAD	Contains price matrix validation issues.
PRO_REG_COMP_PRICE	Contains competitor price information used by competitor-based Non-Forecast rules.
PRO_REG_PRICE_COST	Contains price and cost information used by margin, cost change, and price range rules.
PRO_REG_PROD_PACK	Contains pack item information used when pack pricing rules are applicable.
PRO_REG_RUN_PCM_OVRD	Contains run-level override information used when recommendation prices are overridden.
PRO_REG_RUN_ORULE_REC_PR_RANGE	Contains optimized rule recommendation price range information used during rule evaluation.
PRO_REG_PROD_LOC_CDA	Contains product-location custom data attributes that can support reporting and analysis.
PRO_REG_RUN_REC_PROD_LOC_CDA	Contains run-level product-location custom data attributes associated with generated recommendations.
PRO_REG_BASE_PERIOD, PRO_REG_RUN_FCST, PRO_REG_INVENTORY, PRO_REG_PRICING_OBJECTIVE	These tables are primarily associated with Forecast-Based Regular Pricing and are generally not required for Rules Based Regular Pricing analysis.