Table: VOLTAGE_INSTRUCTION_TRK

VOLTAGE_INSTRUCTION_TRK

Name

VOLTAGE_INSTRUCTION_TRK

Comment

Parent record for Voltage Instructions (MVAr Dispatch). 'SIGNAL' records will have no children; 'INSTRUCTION' records will have children


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

RUN_DATETIME

VERSION_DATETIME


Index Columns

Name

RUN_DATETIME

VERSION_DATETIME


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

date

X

MVAr Interval - a timestamp of when instructions issued

FILE_TYPE

varchar2(20)

 

Either 'SIGNAL' (childless) or 'INSTRUCTION'

VERSION_DATETIME

DATE

X

Datetime the file was published by VDS - Versions differ from Run_DateTime only for Supplemental runs

SE_DATETIME

DATE

 

State Estimator start time, when a snapshot is taken of SCADA values

SOLUTION_CATEGORY

varchar2(60)

 

VDS solver solution category. Valid values: SUCCESS, WARNING, FAILURE

SOLUTION_STATUS

varchar2(60)

 

VDS solver solution status. Valid values: NOACTCNV [Solved with no instructions], NOVIOACT, CONVERGE, UNMANAGE, UNMANCTG, CTGDIV, SENHDIV [Failed with too many violations], BCDIV

OPERATING_MODE

varchar2(60)

 

The current VDS operating mode. Valid values: AUTO, AUTO-VERFIED, MANUAL

OPERATING_STATUS

varchar2(100)

 

Unstructured code and message from AEMO

EST_EXPIRY

DATE

 

Estimated expiry time of current Instruction set

EST_NEXT_INSTRUCTION

DATE

 

Estimated issue time of next Instruction set