Table: PRUDENTIALRUNTRK

PRUDENTIALRUNTRK

Name

PRUDENTIALRUNTRK

Comment

Records the prudential run accepted by Settlements staff for each prudential date


Primary Key Columns

Name

PRUDENTIAL_DATE

RUNNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

PRUDENTIAL_DATE

DATE

X

The prudential date

RUNNO

NUMBER(3)

X

The run number for the prudential date

AUTHORISEDBY

VARCHAR(15)

 

The user that authorised the prudential run

AUTHORISEDDATE

DATE

 

The datetime that the prudential run was authorised

LASTCHANGED

DATE

 

The datetime that the record was last changed