B Appendix: Innovation Workbench Tables for LPO

This appendix lists the Innovation Workbench tables used by LPO.

Innovation Workbench uses RSE prefixes for core foundation tables, PRO prefixes for Promotion and Markdown tables, and PRO_REG prefixes for Regular Pricing tables.

The following read-only tables support LPO validation, diagnostics, rule evaluation, recommendation review, integration tracking, and reporting. Availability depends on the configured Innovation Workbench workspace, permissions, and exposed schema.

Table B-1 Innovation Workbench Tables for LPO

Table Name	Use in LPO
PRO_RUN_SANITY_CHECK_RES_VW	Contains errors, alerts, and warnings generated for Promotion and Markdown optimization runs.
PRO_RUN_RECOM_OPT_RESULT	Contains optimization results for Promotion, Markdown, and Targeted Offer recommendations.
PRO_REG_RUN_SANITY_CHECK_RES_VW	Contains errors, alerts, and warnings generated for Regular Pricing optimization runs.
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 primarily support Forecast-Based Regular Pricing analysis.