SETINTRAREGIONRESIDUES
The Settlement Intra Region Residues Result.
Package
SETTLEMENT_DATA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement Date |
| RUNNO |
numeric(3, 0) |
smallint |
Settlement run number |
| PERIODID |
numeric(3, 0) |
smallint |
Settlements Trading Interval. |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| EP |
numeric(15, 5) |
numeric(15, 5) |
Energy payments to generators. NULL for Settlement dates post the IESS rule effective date |
| EC |
numeric(15, 5) |
numeric(15, 5) |
Energy purchased by customers. NULL for Settlement dates post the IESS rule effective date |
| RRP |
numeric(15, 5) |
numeric(15, 5) |
Regional price |
| EXP |
numeric(15, 5) |
numeric(15, 5) |
Net import in MWh into the region calculated at the regional reference node (export is negative) |
| IRSS |
numeric(15, 5) |
numeric(15, 5) |
Intra-regional surplus (a negative sign indicates surplus, and a positive sign indicates a deficiency) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| ACE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Consumed Energy Dollar Amount for the Region used in the calculation of IRSS (Intra Residue Amount). NULL for Settlement dates prior to the IESS rule effective date |
| ASOE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Sent Out Energy Dollar Amount for the Region used in the calculation of IRSS (Intra Residue Amount). NULL for Settlement dates prior to the IESS rule effective date |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SETINTRAREGIONRESIDUES |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, PERIODID, REGIONID |
| SETINTRAREGIONRESIDUES_LCX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_SETINTRAREGIONRESIDUES_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_SETINTRAREGIONRESIDUES |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, PERIODID, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SETINTRAREGIONRESIDUES |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, PERIODID, REGIONID |
| SETINTRAREGIONRESIDUES_LCX |
nonclustered |
LASTCHANGED |