Database Tables
• DERMS_FORECAST_UPDATES: Input RDBMS table with forecast updates on the enterprise service network.
• PF_DERMS_FORECAST_UPDATES: Input RDBMS table with forecast updates on the operational service network.
• PF_DER_FORECAST, PF_DER_DEMAND_RESPONSE_FORECAST, PF_WEATHER_ZONE_FORECAST, PF_GEN_LOAD_FORECAST: The NMS runtime database tables that the processed data is loaded into.
• PF_DER_FORECAST_ST, PF_DER_DEMAND_RESPONSE_FORECAST_ST, and PF_WEATHER_ZONE_FORECAST_ST, PF_GEN_LOAD_FORECAST_ST: The staging tables before merging the forecast data into the run time NMS tables.
• DERMS_BIDS: Runtime per-DER bid input, including availability and utilization prices, kW, kVAr, minimum output, and start/end times.
• DERMS_BIDS_ST: Staging table for DER bid input loaded by the adapter.
• DERMS_DOE_SCHEDULES: Runtime DOE limits for individual DERs, including DEV_CLS, DEV_IDX, MAX_IMPORT_KW, MAX_EXPORT_KW, START_DATE, and END_DATE.
• DERMS_DOE_SCHEDULES_ST: Staging table for DOE schedule CSV imports. Staged data is merged into DERMS_DOE_SCHEDULES and cleared after the merge.
The following tables support the downstream day-ahead market workflow and are not CSV destinations of this adapter:
• DERMS_DER_GROUP_OFFER: Generated aggregate group capacity limits by offer generation and interval.
• DERMS_DER_GROUP_OFFER_CURVE: Generated cumulative MW/price points for the aggregate offer.
• DERMS_UC_AWARDS: Imported group award target profile used for unit commitment, keyed by group, offer generation, and forecast date.