REGION

REGION sets out valid region IDs.

Package

MARKET_CONFIG

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
REGIONID	varchar(10)	varchar(10)	Differentiates this region from all other regions
DESCRIPTION	varchar(64)	varchar(64)	Full description of region
REGIONSTATUS	varchar(8)	varchar(8)	Status of the region e.g. working, inactive, archive.
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
REGION_LCX	nonclustered	LASTCHANGED
REGION_PK	clustered, unique, primary key	REGIONID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_REGION_LASTCHANGED	nonclustered	LASTCHANGED
PK_REGION	clustered, unique, primary key	REGIONID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
REGION_LCX	nonclustered	LASTCHANGED
REGION_PK	clustered, unique, primary key	REGIONID