SRA_FINANCIAL_RUNTRK
Records details of the settlement process for the cancellation and purchase of SRA Auction Units.
Package
IRAUCTION
Visibility
Public
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 |
| RUNTYPE |
varchar(20) |
varchar(20) |
The type of SRA run |
| RUNDATE |
datetime(3) |
datetime2(0) |
The date and time the run was triggered |
| POSTEDDATE |
datetime(3) |
datetime2(0) |
The date/time the run was posted |
| INTEREST_VERSIONNO |
numeric(3, 0) |
smallint |
Version number of the interest component used in the payments run |
| MAKEUP_VERSIONNO |
numeric(3, 0) |
smallint |
Version number of the makeup component used in the makeup run |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The date and time this record was last modified |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_FINANCIAL_RUNTRK_PK |
clustered, unique, primary key |
SRA_YEAR, SRA_QUARTER, SRA_RUNNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SRA_FINANCIAL_RUNTRK |
clustered, unique, primary key |
SRA_YEAR, SRA_QUARTER, SRA_RUNNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_FINANCIAL_RUNTRK_PK |
clustered, unique, primary key |
SRA_YEAR, SRA_QUARTER, SRA_RUNNO |