RESIDUE_CON_DATA
RESIDUE_CON_DATA supports the Settlement Residue Auction, by holding for each participant the confidential data from the auction. RESIDUE_CON_DATA joins to RESIDUE_PUBLIC_DATA and RESIDUE_TRK.
Package
IRAUCTION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTID |
varchar(30)  |
varchar(30) |
SRA Contract unique identifier |
| VERSIONNO |
numeric(3, 0) |
smallint |
Contract run version |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Identifier of Contracted Participant |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Identifier of Contracted Interconnector |
| FROMREGIONID |
varchar(10) |
varchar(10) |
Nominated source region for Interconnector |
| UNITSPURCHASED |
numeric(17, 5) |
numeric(17, 5) |
Units purchased on the directional interconnector (i.e. Contracted quantity) |
| LINKPAYMENT |
numeric(17, 5) |
numeric(17, 5) |
Payment due (i.e. total purchase price) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| SECONDARY_UNITS_SOLD |
numeric(18, 8) |
numeric(18, 8) |
The number of cancelled Units for all Auction Participants. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_CON_DATA_LCX |
nonclustered |
LASTCHANGED |
| RESIDUE_CON_DATA_PK |
clustered, unique, primary key |
CONTRACTID, VERSIONNO, PARTICIPANTID, INTERCONNECTORID, FROMREGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_RESIDUE_CON_DATA_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_RESIDUE_CON_DATA |
clustered, unique, primary key |
CONTRACTID, VERSIONNO, PARTICIPANTID, INTERCONNECTORID, FROMREGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_CON_DATA_LCX |
nonclustered |
LASTCHANGED |
| RESIDUE_CON_DATA_PK |
clustered, unique, primary key |
CONTRACTID, VERSIONNO, PARTICIPANTID, INTERCONNECTORID, FROMREGIONID |