B Appendix: Regular - Run Overview
This table provides information about table columns and calculations for Regular Optimization runs.
Table B-1 B-1 Column Details
| Column Heading | Default | Definition | DB Reference / Calculation |
|---|---|---|---|
| Run Id | Y | System-generated unique identifier for the run. | RUN_HDR_ID |
| Finalized | Y | Flag indicating that recommendations from the run are finalized and used in Manage Recommendations. | FINALIZED_FLG |
| Run Name | Y | User provided name for the run. | RUN_NAME |
| Run Description | Y | User provided description for the run. | RUN_DESCR |
| Department | Y | A description of the Department. | CONCAT(PROD_HIER_EXT_CODE, '-', PROD_HIER_NAME) |
| Price Zone Group | Y | Price zone group of the item recommendation. Corresponds to the run setup level. | CONCAT(PRICE_ZONE_GRP_EXT_CODE, '-', PRICE_ZONE_GRP_NAME) |
| Price Zone | Y | Price zone of the item recommendation. Corresponds to the run setup level. | CONCAT(PRICE_ZONE_EXT_CODE, '+', PRICE_ZONE_NAME) |
| Company | Y | Location of the item recommendation, such as Region or Channel. Will be chain when using price zones. | CONCAT(LOC_HIER_EXT_CODE, '+', LOC_HIER_NAME) |
| Opt Start Dt | Y | The start date of optimization. | START_CAL_FROM_DT |
| Opt End Dt | Y | The end date of optimization. | END_CAL_TO_DT |
| Strategy | Y | The strategy used for optimization. It can be DEFAULT STRATEGY or another custom strategy. | RULE_SET_NAME |
| Total Item Cnt | Y | Total item count. | ITEM_OPTIMIZED_COUNT |
| Non-fcst Item Cnt | Y | Number of non-forecast item recommendations included in the run. | NON_FCST_ITEM_CNT |
| No Rec Item Cnt | Y | Total items that are in No Recommendation status. | ITEM_NOREC_COUNT |
| Reg Item Cnt | Y | Regular items count. | ITEM_REGULAR_COUNT |
| User Ovrd Item Cnt | Y | Total items that are overridden by user. | ITEM_USR_OVRD_COUNT |
| Run Status | Y | Status of the run. | RUN_STATUS_DESCR |
| Optimized On | Y | The date when the run was optimized. | LAST_EXECUTION_DATE |
| Modified By | Y | Login ID of the user who modified the run. | CHANGED_BY_USER |
| Created By | Y | Login ID of the user who created the run. | CREATED_BY_USER |
| Created Date | Y | The date when the run was first created. | CREATED_ON_DT |