INSTRUCTIONTYPE

Dispatch instruction (GD instruct) has types and subtypes. INSTRUCTIONTYPE, together with INSTRUCTIONSUBTYPE, sets out valid instruction types.

Package

GD_INSTRUCT

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
INSTRUCTIONTYPEID	varchar(10)	varchar(10)	Dispatch instruction type for example FCAS service.
DESCRIPTION	varchar(64)	varchar(64)	Description of instruction type
REGIONID	varchar(10)	varchar(10)	Region id if regional instruction only.
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
INSTRUCTIONTYPE_LCX	nonclustered	LASTCHANGED
INSTRUCTIONTYPE_PK	clustered, unique, primary key	INSTRUCTIONTYPEID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_INSTRUCTIONTYPE_LASTCHANGED	nonclustered	LASTCHANGED
PK_INSTRUCTIONTYPE	clustered, unique, primary key	INSTRUCTIONTYPEID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
INSTRUCTIONTYPE_LCX	nonclustered	LASTCHANGED
INSTRUCTIONTYPE_PK	clustered, unique, primary key	INSTRUCTIONTYPEID