SRA_PRUDENTIAL_RUN

Records the prudential run details for each prudential date.

Package

IRAUCTION

Visibility

Public

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 prudential run number for the run

Official MMS data model indexes

Index name	Index type	Index columns (in order)
SRA_PRUDENTIAL_RUN_PK	clustered, unique, primary key	PRUDENTIAL_DATE, PRUDENTIAL_RUNNO

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
PK_SRA_PRUDENTIAL_RUN	clustered, unique, primary key	PRUDENTIAL_DATE, PRUDENTIAL_RUNNO

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
SRA_PRUDENTIAL_RUN_PK	clustered, unique, primary key	PRUDENTIAL_DATE, PRUDENTIAL_RUNNO