|
Name |
|
|
Comment |
Settlements WDR transactions summary |
|
Name |
|
COUNTERPARTYPARTICIPANTID |
|
PARTICIPANTID |
|
PARTICIPANTROLEID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
SETTLEMENTRUNNO |
NUMBER(3,0) |
X |
Settlement run number |
|
PERIODID |
NUMBER(3,0) |
X |
Trading interval identifier with Period 1 being the first TI for the calendar day, that is the interval ending 00:05 |
|
REGIONID |
VARCHAR2(20) |
X |
Unique identifier for the region to which the TNI belongs on the settlement date |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Unique identifier for a participant |
|
PARTICIPANTROLEID |
VARCHAR2(20) |
X |
Participant role identifier - FRMP or DRSP |
|
COUNTERPARTYPARTICIPANTID |
VARCHAR2(20) |
X |
Unique identifier for the counter participant id. |
|
TRANSACTIONAMOUNT |
NUMBER(18,8) |
|
Aggregate WDR transaction amount for the participant and counterparty in the settlement interval |
|
|
|