Forecasting data

Forecasting Data

Archive or Purge

Archive

Commit Type (Default)

ALL_OR_NOTHING

Commit Parameters (Default)

Default Aging Days

365 days

Tables affected

FCST_ATTR_DETAIL

FCST_LITEM_COL

FCST_LAYOUT

FCST_HISTORY

FCST_ITEM

FCST_LOC_SUMMARY

FCST_PUB_FORECAST

FORECAST

Description/Notes

Moves all forecasting data to the archive schema. This process involves moving:

1. All data from the FORECAST table where Forecast type is ‘FORECAST and FC_CREATED_DATE is before the aging date and forecast is not a master forecast.
2. All data from fcst_loc_summary for the forecasts identified in #1.
3. All data from fcst_item for the forecasts identified in #1.
4. All data from fcst_history for the forecasts identified in #1.
5. All data from fcst_pub_forecast for the forecasts identified in #1.
6. All data from fcst_layout for the forecasts identified in #1.
7. All data from fcst_litem_col for the forecasts identified in #6.
8. All data from fcst_litem_col for the forecasts identified in #1.
9. All data from fcst_attr_detail for the forecasts identified in #1.