SRA_PRUDENTIAL_CASH_SECURITY
Records the Cash Security details provided by an SRA Auction Participant as collateral to cover their Trading Position in the SRA market.
Package
IRAUCTION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PRUDENTIAL_DATE |
datetime(3)  |
datetime2(0) |
The prudential date of the run. |
| PRUDENTIAL_RUNNO |
numeric(8, 0) |
int |
The run number for the prudential date |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Unique participant identifier for the Auction Participant lodging the Cash Security |
| CASH_SECURITY_ID |
varchar(36) |
varchar(36) |
Unique identifier for the cash security. |
| CASH_SECURITY_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Remaining Cash Security deposit available |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_PRUDENTIAL_CASH_SEC_PK |
clustered, unique, primary key |
PRUDENTIAL_DATE, PRUDENTIAL_RUNNO, PARTICIPANTID, CASH_SECURITY_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SRA_PRUDENTIAL_CASH_SECURITY |
clustered, unique, primary key |
PRUDENTIAL_DATE, PRUDENTIAL_RUNNO, PARTICIPANTID, CASH_SECURITY_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_PRUDENTIAL_CASH_SEC_PK |
clustered, unique, primary key |
PRUDENTIAL_DATE, PRUDENTIAL_RUNNO, PARTICIPANTID, CASH_SECURITY_ID |