Table: MTPASA_DUIDAVAILABILITY

MTPASA_DUIDAVAILABILITY

Name

MTPASA_DUIDAVAILABILITY

Comment

Offered PASA Availability of the scheduled generator DUID for each day over the Medium Term PASA period. The data in this table is input data to the MT PASA process it is not part of the MTPASA solution. The availability does not reflect any energy limitations in the MT PASA offers


Primary Key Columns

Name

DAY

DUID

PUBLISH_DATETIME

REGIONID


Content

Name

Data Type

Mandatory

Comment

PUBLISH_DATETIME

DATE

X

Date Time the report was published.

DAY

DATE

X

Date on which the PASA availability of DUID applies.

REGIONID

VARCHAR2(20)

X

NEM Region.

DUID

VARCHAR2(20)

X

NEM DUID.

PASAAVAILABILITY

NUMBER(12,0)

 

Offered PASA Availability of Scheduled generator DUID for the day.

LATEST_OFFER_DATETIME

DATE

 

Date Time of the latest offer used for DUID for this date.

LASTCHANGED

DATE

 

Last date and time record changed

CARRYOVERSTATUS

NUMBER(1,0)

 

Status of a reported capacity value (e.g. 1 for Yes, 0 for No)

PASAUNITSTATE

VARCHAR2(20)

 

The unit state value

PASARECALLTIME

NUMBER(4)

 

The recall time value