GDINSTRUCT
GDINSTRUCT shows all manually issued dispatch instructions for a dispatchable unit. Ancillary Service instructions are to enable and to disable (i. e. 2 separate instructions) a service. Non-conforming units are also instructed via this facility. However, this facility is not the same as the market notice.
Package
GD_INSTRUCT
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| ID |
numeric(22, 0)  |
int |
Instruction ID (sequential number) |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable unit identifier |
| STATIONID |
varchar(10) |
varchar(10) |
Station Identifier |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| INSTRUCTIONTYPEID |
varchar(10) |
varchar(10) |
Instruction type |
| INSTRUCTIONSUBTYPEID |
varchar(10) |
varchar(10) |
Instruction sub type |
| INSTRUCTIONCLASSID |
varchar(10) |
varchar(10) |
Instruction class |
| REASON |
varchar(64) |
varchar(64) |
Reason |
| INSTLEVEL |
numeric(6, 0) |
smallint |
Instruction target level |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Authorised date |
| AUTHORISEDBY |
varchar(15) |
varchar(15) |
User authorised by |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Unique participant identifier |
| ISSUEDTIME |
datetime(3) |
datetime2(0) |
Date / time issued |
| TARGETTIME |
datetime(3) |
datetime2(0) |
Date / time instruction to apply |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GDINSTRUCT_LCX |
nonclustered |
LASTCHANGED |
| GDINSTRUCT_NDX2 |
nonclustered |
DUID |
| GDINSTRUCT_NDX3 |
nonclustered |
TARGETTIME |
| GDINSTRUCT_PK |
clustered, unique, primary key |
ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_GDINSTRUCT_DUID |
nonclustered |
DUID |
| IX_GDINSTRUCT_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_GDINSTRUCT_TARGETTIME |
nonclustered |
TARGETTIME |
| PK_GDINSTRUCT |
clustered, unique, primary key |
ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GDINSTRUCT_LCX |
nonclustered |
LASTCHANGED |
| GDINSTRUCT_NDX2 |
nonclustered |
DUID |
| GDINSTRUCT_NDX3 |
nonclustered |
TARGETTIME |
| PK_GDINSTRUCT |
clustered, unique, primary key |
ID |