PD7DAY_MARKET_SUMMARY
PD7DAY market summary showing calculated gas fuel forecasts.
Package
PD7DAY
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Unique Timestamp Identifier for this study |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
The unique identifier for the interval within this study |
| GPG_FUEL_FORECAST_TJ |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
The total gas consumption in TJ |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PD7DAY_MARKET_SUMMARY_PK |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PD7DAY_MARKET_SUMMARY |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PD7DAY_MARKET_SUMMARY |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME |