SET_WDR_TRANSACT
Settlements WDR transactions summary.
Package
SETTLEMENT_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement date |
| SETTLEMENTRUNNO |
numeric(3, 0) |
smallint |
Settlement run number |
| PERIODID |
numeric(3, 0) |
smallint |
Trading interval identifier with Period 1 being the first TI for the calendar day, that is the interval ending 00:05 |
| REGIONID |
varchar(20) |
varchar(20) |
Unique identifier for the region to which the TNI belongs on the settlement date |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
Unique identifier for a participant |
| PARTICIPANTROLEID |
varchar(20) |
varchar(20) |
Participant role identifier - FRMP or DRSP |
| COUNTERPARTYPARTICIPANTID |
varchar(20) |
varchar(20) |
Unique identifier for the counter participant id. |
| TRANSACTIONAMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Aggregate WDR transaction amount for the participant and counterparty in the settlement interval |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_WDR_TRANSACT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, SETTLEMENTRUNNO, PERIODID, REGIONID, PARTICIPANTID, PARTICIPANTROLEID, COUNTERPARTYPARTICIPANTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_WDR_TRANSACT |
clustered, unique, primary key |
SETTLEMENTDATE, SETTLEMENTRUNNO, PERIODID, REGIONID, PARTICIPANTID, PARTICIPANTROLEID, COUNTERPARTYPARTICIPANTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_WDR_TRANSACT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, SETTLEMENTRUNNO, PERIODID, REGIONID, PARTICIPANTID, PARTICIPANTROLEID, COUNTERPARTYPARTICIPANTID |