LB data

This section outlines details for LB Bup Data, LB summary data, LB Temporary Data, LB Pre Bup Data, and LB Temporary Forecasting Data.

LB Bup Data

Archive or Purge
Archive
Commit Type (Default)
EVERY_X_RECORDS
Commit Parameters (Default)
BATCH_RECORD_COUNT=1000
Default Aging Days

LB BUP DATA 822 days

LB PRE BUP DATA 1096 days

LB SUMMARY DATA 1096 days

LB TEMPORARY DATA 1096 days

LB TEMPORARY FORECASTING DATA 1096 days

Tables affected
FCST_ATTR_DETAIL
FCST_HISTORY
FCST_ITEM
FCST_LAYOUT
FCST_LITEM_COL
FCST_LOC_SUMMARY
FCST_PUB_FORECAST
FORECAST
Description/Notes

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

  1. All data from the FORECAST table where Forecast type is ‘BOTTOM UP’ 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.

LB Summary Data

Archive or Purge
Purge
Commit Type (Default)
EVERY_X_RECORDS
Commit Parameters (Default)
BATCH_RECORD_COUNT=1000
Tables affected
FCST_DRIVER_IMPORT
FCST_NONPROD_SMRY
Description/Notes

Removes all LB summary data. This process involves removing:

  1. All data from the FCST_NONPROD_SMRY table where FCNPS_ID is in all the data from FCST_NONPROD_SMRY table where all the data from DATE_VALUE table where FCNPS_CAL_YEAR +3 = CAST(DTVAL_YEAR AS INTEGER) group by DTVAL_YEAR is before the data from forecast and fcst_time_period tables where forecast.FCTP_ID = fcst_time_period.FCTP_ID AND forecast type is ‘BOTTOM UP’.
  2. All data from FCST_DRIVER_IMPORT table where FCTP_ID is in the list from FCST_TIME_PERIOD table where FCTP_END_DATE is before the data from forecast and fcst_time_period tables where forecast.FCTP_ID = fcst_time_period.FCTP_ID AND forecast type is ‘BOTTOM UP’.

LB Temporary Data

Archive or Purge
Purge
Commit Type (Default)
EVERY_X_RECORDS
Commit Parameters (Default)
BATCH_RECORD_COUNT=1000
Tables affected
FCST_WORKLOAD_SMRY
Description/Notes

Removes all LB temporary data. This process involves removing:

  1. All data from the FCST_WORKLOAD_SMRY table where FC_ID is in the forecasts where forecast type is ‘BOTTOM UP’ AND FCLK_ID IS NULL and forecasts are not in the data from FCST_FCLK_FC table and FC_CREATED_DATE before the aging date.

LB Pre Bup Data

Archive or Purge
Purge
Commit Type (Default)
EVERY_X_RECORDS
Commit Parameters (Default)
BATCH_RECORD_COUNT=1000
Tables affected
FCST_DRIVER
Description/Notes

Removes all LB pre bup data. This process involves removing:

  1. All data from the FCST_DRIVER table where FC_ID is in the forecasts where FC_CREATED_DATE is before the aging date.

LB Temporary Forecasting Data

Archive or Purge
Purge
Commit Type (Default)
EVERY_X_RECORDS
Commit Parameters (Default)
BATCH_RECORD_COUNT=1000
Tables affected
FCST_ITEM
FCST_LOC_SUMMARY
FORECAST
Description/Notes

Removes all LB temporary forecasting data. This process involves removing:

  1. All data from the FORECAST table where FCVER_ID is not 1 and FC_MASTER_FC_ID is null and FC_CREATED_DATE is before the aging date.
  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.