AREA
Table containing static metadata for the Areas, which are sub-regions used in load forecasting and rooftop PV forecasting. The latest metadata can be obtained for each AreaID using the most recent EffectiveDate and then VersionNo. If an AreaID is not mapped to an active RegionID in the corresponding REGION_AREA table, then that AreaID can be considered inactive.
Package
MARKET_CONFIG
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| AREAID |
varchar(10)  |
varchar(10) |
Area identifier |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
Calendar date from when this record set is effective. |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version number for the same effectivedate. |
| AREA_NAME |
varchar(20) |
varchar(20) |
Area name |
| AREA_DESCRIPTION |
varchar(200) |
varchar(200) |
Area description |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AREA_PK |
clustered, unique, primary key |
AREAID, EFFECTIVEDATE, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_AREA |
clustered, unique, primary key |
AREAID, EFFECTIVEDATE, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_AREA |
clustered, unique, primary key |
AREAID, EFFECTIVEDATE, VERSIONNO |