Table: GSH_PRD_BANK_GUARANTEES

GSH_PRD_BANK_GUARANTEES

Name

GSH_PRD_BANK_GUARANTEES

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.


Primary Key Columns

Name

BANK_GUARANTEE_NO

ORGANISATION_CODE

PRUDENTIAL_DATETIME

PRUDENTIAL_RUN_ID


Content

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