Table: SET_ENERGY_REGION_SUMMARY

SET_ENERGY_REGION_SUMMARY

Name

SET_ENERGY_REGION_SUMMARY

Comment

The Settlement Energy Region Summary report contains the Energy Transactions Summary for all the NEM regions. This report is produced only for Settlement Date post the IESS rule effective date.


Primary Key Columns

Name

PERIODID

REGIONID

SETTLEMENTDATE

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

The Settlement Date of the Billing Week

VERSIONNO

NUMBER(3,0)

X

The Settlement Run No

PERIODID

NUMBER(3,0)

X

The Period ID Identifier

REGIONID

VARCHAR2(20)

X

The NEM Region Id Identifier

CE_MWH

NUMBER(18,8)

 

The Consumed Energy summary for the Region Id

UFEA_MWH

NUMBER(18,8)

 

The UFEA Energy summary for the Region Id

ACE_MWH

NUMBER(18,8)

 

The Adjusted Consumed Energy summary for the Region Id

ASOE_MWH

NUMBER(18,8)

 

The Adjusted Sent Out Energy summary for the Region Id

ACE_AMOUNT

NUMBER(18,8)

 

The Adjusted Consumed Energy Amount for the Region Id

ASOE_AMOUNT

NUMBER(18,8)

 

The Adjusted Sent Out Energy Amount for the Region Id

TOTAL_MWH

NUMBER(18,8)

 

The Total Energy summary for the Region Id

TOTAL_AMOUNT

NUMBER(18,8)

 

The Total Dollar Amount summary for the Region Id

LASTCHANGED

DATE

 

The Last changed Date time of the record