Table: GSH_PRD_SECURITY_DEPOSITS

GSH_PRD_SECURITY_DEPOSITS

Name

GSH_PRD_SECURITY_DEPOSITS

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).


Primary Key Columns

Name

ORGANISATION_CODE

PARTICIPANT_CODE

PRUDENTIAL_DATETIME

PRUDENTIAL_RUN_ID

SECURITY_DEPOSIT_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

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