SRA_PRUDENTIAL_COMP_POSITION
The prudential position of each company at the date and time of a specific prudential run.
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 |
| TRADING_LIMIT |
numeric(18, 8) |
numeric(18, 8) |
The Trading Limit of the company at the time of the prudential run |
| PRUDENTIAL_EXPOSURE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Current Prudential Exposure of the Auction Participant including Offers |
| TRADING_MARGIN |
numeric(18, 8) |
numeric(18, 8) |
The amount of Trading Margin available to the Auction Participant to trade (including Offered Units and Cancelled Units). Equal to TRADING_LIMIT minus PRUDENTIAL_EXPOSURE_AMOUNT. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_PRUDENTIAL_COMP_PK |
clustered, unique, primary key |
PRUDENTIAL_DATE, PRUDENTIAL_RUNNO, PARTICIPANTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SRA_PRUDENTIAL_COMP_POSITION |
clustered, unique, primary key |
PRUDENTIAL_DATE, PRUDENTIAL_RUNNO, PARTICIPANTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_PRUDENTIAL_COMP_PK |
clustered, unique, primary key |
PRUDENTIAL_DATE, PRUDENTIAL_RUNNO, PARTICIPANTID |