SRA_FINANCIAL_AUC_MARDETAIL
This table stores details of the margins returned to the participants.
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) |
The participant identifier. |
| CASH_SECURITY_ID |
varchar(36) |
varchar(36) |
Unique identifier for the cash security. |
| RETURNED_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The amount returned to the Auction participant from this cash security. |
| RETURNED_INTEREST |
numeric(18, 8) |
numeric(18, 8) |
The amount of interest applicable to the returned amount. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_FINANCIAL_AUC_MARDETAIL_PK |
clustered, unique, primary key |
SRA_YEAR, SRA_QUARTER, SRA_RUNNO, PARTICIPANTID, CASH_SECURITY_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SRA_FINANCIAL_AUC_MARDETAIL |
clustered, unique, primary key |
SRA_YEAR, SRA_QUARTER, SRA_RUNNO, PARTICIPANTID, CASH_SECURITY_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_FINANCIAL_AUC_MARDETAIL_PK |
clustered, unique, primary key |
SRA_YEAR, SRA_QUARTER, SRA_RUNNO, PARTICIPANTID, CASH_SECURITY_ID |