Skip to content

SRA_FINANCIAL_AUC_MARGIN

Records the amount of Cash Security required to be held by an Auction Participant after settlement.

Package

IRAUCTION

Visibility

Private

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
SRA_YEAR numeric(4, 0) 🔑 smallint 🔑 Year of the Tranche
SRA_QUARTER numeric(3, 0) 🔑 smallint 🔑 Relevant Quarter of the Tranche
SRA_RUNNO numeric(3, 0) 🔑 smallint 🔑 SRA Run Number
PARTICIPANTID varchar(10) 🔑 varchar(10) 🔑 Unique participant identifier.
TOTAL_CASH_SECURITY numeric(18, 8) numeric(18, 8) Total cash security held by the participant.
REQUIRED_MARGIN numeric(18, 8) numeric(18, 8) The amount of trading cash security required to be held by the participant after settlement.
RETURNED_MARGIN numeric(18, 8) numeric(18, 8) The amount of cash security returned to the participant.
RETURNED_MARGIN_INTEREST numeric(18, 8) numeric(18, 8) The amount of interest applicable to returned cash security amounts.

Official MMS data model indexes

Index name Index type Index columns (in order)
SRA_FINANCIAL_AUC_MARGIN_PK clustered, unique, primary key SRA_YEAR, SRA_QUARTER, SRA_RUNNO, PARTICIPANTID

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_SRA_FINANCIAL_AUC_MARGIN clustered, unique, primary key SRA_YEAR, SRA_QUARTER, SRA_RUNNO, PARTICIPANTID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
SRA_FINANCIAL_AUC_MARGIN_PK clustered, unique, primary key SRA_YEAR, SRA_QUARTER, SRA_RUNNO, PARTICIPANTID