Table: GSH_PRD_SETTLEMENT_AMOUNTS

GSH_PRD_SETTLEMENT_AMOUNTS

Name

GSH_PRD_SETTLEMENT_AMOUNTS

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


Primary Key Columns

Name

BILLING_PERIOD

ORGANISATION_CODE

PARTICIPANT_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

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