Name |
|
Comment |
The purpose of the Prudential Exposure report is to provide organisations with daily estimates of their market exposure. The report also contains details of their bank guarantees and security deposits as well as their outstanding amounts for all settlement runs included in the prudential run. The Settlement Amounts subreport provides a breakdown of all settlement amounts at the participant level for all settlement runs included in the prudential run |
Name |
BILLING_PERIOD |
ORGANISATION_CODE |
PARTICIPANT_CODE |
PRUDENTIAL_DATETIME |
PRUDENTIAL_RUN_ID |
Name |
Data Type |
Mandatory |
Comment |
ORGANISATION_CODE |
VARCHAR2(20) |
X |
The unique code for the organisation |
PRUDENTIAL_RUN_ID |
NUMBER(4,0) |
X |
The run number of the prudential run. |
PRUDENTIAL_DATETIME |
DATE |
X |
The date and time of the prudential run |
PARTICIPANT_CODE |
VARCHAR2(20) |
X |
The participant code for the participant which the outstanding amount belongs to |
BILLING_PERIOD |
VARCHAR2(20) |
X |
The billing period |
ORGANISATION_NAME |
VARCHAR2(80) |
|
The name of the organisation |
SETTLEMENT_TYPE |
VARCHAR2(20) |
|
The run type of the settlement run (i.e. Final, Revision, etc) |
SETTLEMENT_VERSION_ID |
NUMBER(18,0) |
|
The version number of the settlement run used in this billing period |
SETTLEMENT_EXPOSURE_AMOUNT |
NUMBER(18,8) |
|
The outstanding amount for the participant as per the settlement run |
PUBLICATION_DATE |
DATE |
|
The publication date of the settlement |
PAYMENT_DUE_DATE |
DATE |
|
The due date of the payment for the outstanding amount |
|
|
|