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 Security Deposits subreport provides a list of all security deposits used in the prudential run (Note: only security deposits that are maturing on a day later than the prudential date time are included in this report). |
Name |
ORGANISATION_CODE |
PARTICIPANT_CODE |
PRUDENTIAL_DATETIME |
PRUDENTIAL_RUN_ID |
SECURITY_DEPOSIT_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 who lodged the security deposit |
SECURITY_DEPOSIT_ID |
VARCHAR2(20) |
X |
The unique identifier for a security deposit which is included in the prudential run (Note: only security deposits that are maturing on a day later than the prudential date time are included in this report) |
ORGANISATION_NAME |
VARCHAR2(80) |
|
The name of the organisation |
EFFECTIVE_FROM_DATE |
DATE |
|
The start date of the security deposit |
MATURITY_DATE |
DATE |
|
The maturity date of the security deposit |
TOTAL_SECURITY_DEPOSIT_AMOUNT |
NUMBER(18,8) |
|
All cash being held and not yet paid back via settlement |
NON_APPLIED_SEC_DEPOSIT_AMT |
NUMBER(18,8) |
|
All cash that is used to directly reduce outstandings (not in a settlement run) |
INTEREST_ACCT_ID |
VARCHAR2(20) |
|
The Interest Account Id for calculating the Interest Payment. This is NULL if the INTEREST_CALC_TYPE = FIXED |
INTEREST_CALC_TYPE |
VARCHAR2(20) |
|
Fixed or daily |
|
|
|