Table: SET_WDR_TRANSACT

SET_WDR_TRANSACT

Name

SET_WDR_TRANSACT

Comment

Settlements WDR transactions summary


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

COUNTERPARTYPARTICIPANTID

PARTICIPANTID

PARTICIPANTROLEID

PERIODID

REGIONID

SETTLEMENTDATE

SETTLEMENTRUNNO


Content

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