RESIDUE_FUNDS_BID
RESIDUE_FUNDS_BID supports the Settlement Residue Auction, by showing the fund details for each SRA bid by each Participant.
Package
IRAUCTION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTID |
varchar(30)  |
varchar(30) |
SRA Contract identifier |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant identifier |
| LOADDATE |
datetime(3) |
datetime2(0) |
Date and time the batcher loaded the SRA offer |
| OPTIONID |
numeric(3, 0) |
smallint |
Unique option identifier (1..20) |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Interconnector Identifier |
| FROMREGIONID |
varchar(10) |
varchar(10) |
Nominated source region for Interconnector |
| UNITS |
numeric(5, 0) |
smallint |
Quantity of units bid for |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_FUNDS_BID_LCX |
nonclustered |
LASTCHANGED |
| RESIDUE_FUNDS_BID_PK |
clustered, unique, primary key |
CONTRACTID, PARTICIPANTID, LOADDATE, OPTIONID, INTERCONNECTORID, FROMREGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_RESIDUE_FUNDS_BID_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_RESIDUE_FUNDS_BID |
clustered, unique, primary key |
CONTRACTID, PARTICIPANTID, LOADDATE, OPTIONID, INTERCONNECTORID, FROMREGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_FUNDS_BID_LCX |
nonclustered |
LASTCHANGED |
| RESIDUE_FUNDS_BID_PK |
clustered, unique, primary key |
CONTRACTID, PARTICIPANTID, LOADDATE, OPTIONID, INTERCONNECTORID, FROMREGIONID |