INSTRUCTIONSUBTYPE

Each Dispatch instruction (GD instruct) has a type and subtype. INSTRUCTIONSUBTYPE, together with INSTRUCTIONTYPE, 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)	Instruction type
INSTRUCTIONSUBTYPEID	varchar(10)	varchar(10)	Subtype for each dispatch instruction type, for example governor off.
DESCRIPTION	varchar(64)	varchar(64)	Description of instruction subtype
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
INSTRUCTIONSUBTYPE_LCX	nonclustered	LASTCHANGED
INSTRUCTIONSUBTYPE_PK	clustered, unique, primary key	INSTRUCTIONTYPEID, INSTRUCTIONSUBTYPEID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_INSTRUCTIONSUBTYPE_LASTCHANGED	nonclustered	LASTCHANGED
PK_INSTRUCTIONSUBTYPE	clustered, unique, primary key	INSTRUCTIONTYPEID, INSTRUCTIONSUBTYPEID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
INSTRUCTIONSUBTYPE_LCX	nonclustered	LASTCHANGED
INSTRUCTIONSUBTYPE_PK	clustered, unique, primary key	INSTRUCTIONTYPEID, INSTRUCTIONSUBTYPEID