Table: GDINSTRUCT

GDINSTRUCT

Name

GDINSTRUCT

Comment

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.


Description

Source

GDINSTRUCT updates on issue of an instruction by AEMO, with visibility restricted on the day of issue to the relevant participant. All participants have previous days' data available.


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

ID


Index Columns

Name

LASTCHANGED


Index Columns

Name

DUID


Index Columns

Name

TARGETTIME


Content

Name

Data Type

Mandatory

Comment

DUID

VARCHAR2(10)

 

Dispatchable unit identifier

STATIONID

VARCHAR2(10)

 

Station Identifier

REGIONID

VARCHAR2(10)

 

Region Identifier

ID

NUMBER(22,0)

X

Instruction ID (sequential number)

INSTRUCTIONTYPEID

VARCHAR2(10)

 

Instruction type

INSTRUCTIONSUBTYPEID

VARCHAR2(10)

 

Instruction sub type

INSTRUCTIONCLASSID

VARCHAR2(10)

 

Instruction class

REASON

VARCHAR2(64)

 

Reason

INSTLEVEL

NUMBER(6,0)

 

Instruction target level

AUTHORISEDDATE

DATE

 

Authorised date

AUTHORISEDBY

VARCHAR2(15)

 

User authorised by

PARTICIPANTID

VARCHAR2(10)

 

Unique participant identifier

ISSUEDTIME

DATE

 

Date / time issued

TARGETTIME

DATE

 

Date / time instruction to apply

LASTCHANGED

DATE

 

Last date and time record changed


Table: INSTRUCTIONSUBTYPE

INSTRUCTIONSUBTYPE

Name

INSTRUCTIONSUBTYPE

Comment

Each Dispatch instruction (GD instruct) has a type and subtype. INSTRUCTIONSUBTYPE, together with INSTRUCTIONTYPE, sets out valid instruction types.


Description

INSTRUCTIONSUBTYPE is public data, and is available to all participants.

Source

INSTRUCTIONSUBTYPE shows ad hoc updates to market configuration.


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

INSTRUCTIONSUBTYPEID

INSTRUCTIONTYPEID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

INSTRUCTIONTYPEID

VARCHAR2(10)

X

Instruction type

INSTRUCTIONSUBTYPEID

VARCHAR2(10)

X

Subtype for each dispatch instruction type, for example governor off.

DESCRIPTION

VARCHAR2(64)

 

Description of instruction subtype

LASTCHANGED

DATE

 

Last date and time record changed


Table: INSTRUCTIONTYPE

INSTRUCTIONTYPE

Name

INSTRUCTIONTYPE

Comment

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


Description

INSTRUCTIONTYPE data is public to all participants.

Source

INSTRUCTIONTYPE shows ad hoc updates to market configuration.


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

INSTRUCTIONTYPEID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

INSTRUCTIONTYPEID

VARCHAR2(10)

X

Dispatch instruction type for example FCAS service.

DESCRIPTION

VARCHAR2(64)

 

Description of instruction type

REGIONID

VARCHAR2(10)

 

Region id if regional instruction only.

LASTCHANGED

DATE

 

Last date and time record changed