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 Bank Guarantees subreport provides a list of all bank guarantees used in the prudential run. |
Name |
BANK_GUARANTEE_NO |
ORGANISATION_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 |
BANK_GUARANTEE_NO |
VARCHAR2(20) |
X |
The reference number for the bank guarantee included in the prudential run |
ORGANISATION_NAME |
VARCHAR2(80) |
|
The name of the organisation |
EFFECTIVE_FROM_DATE |
DATE |
|
The start date of the bank guarantee |
EXPIRY_DATE |
DATE |
|
Expiry date for the bank guarantee |
PRUDENTIAL_EXPIRY_DATE |
DATE |
|
The prudential expiry date of the guarantee |
AMOUNT |
NUMBER(18,8) |
|
The dollar amount of the guarantee applicable to the prudential run |
BANK_GUARANTEE_ALERT |
VARCHAR2(255) |
|
The field will show the warning “Renew Bank Guarantee Warning” if the prudential expiry date of the bank guarantee is within the next 30 days (PRUDENTIAL_EXPIRY_DATE is less than or equal to PRUDENTIAL_DATETIME + 30 days), otherwise it will have no value |
|
|
|