Table: ROOFTOP_PV_ACTUAL

ROOFTOP_PV_ACTUAL

Name

ROOFTOP_PV_ACTUAL

Comment

Estimate of regional Rooftop Solar actual generation for each half-hour interval in a day


Primary Key Columns

Name

INTERVAL_DATETIME

REGIONID

TYPE


Index Columns

Name

INTERVAL_DATETIME

TYPE

REGIONID


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

The forecast half-hour interval (time ending)

TYPE

VARCHAR2(20)

X

One of DAILY, MEASUREMENT or SATELLITE. DAILY- best quality estimated actuals, available day after. MEASUREMENT- best quality estimated actuals on day, delayed by 1 half hour. SATELLITE- estimated actuals using satellite imagery, delayed by 1 half hour.

REGIONID

VARCHAR2(20)

X

Region identifier

POWER

NUMBER(12,3)

 

Estimated generation in MW at the interval end

QI

NUMBER(2,1)

 

Quality indicator. Represents the quality of the estimate.

LASTCHANGED

DATE

 

Last date and time record changed