Table: INTCONTRACTAMOUNTTRK

INTCONTRACTAMOUNTTRK

Name

INTCONTRACTAMOUNTTRK

Comment

INTCONTRACTAMOUNTTRK shows the latest valid version of each intervention contract.


Description

INTCONTRACTAMOUNTTRK became unused when Ancillary Services Review was implemented in 2001.

INTCONTRACTAMOUNTTRK is confidential to relevant participant

Source

INTCONTRACTAMOUNTTRK is unused; was updated for contract changes / creation only.


Primary Key Columns

Name

CONTRACTID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(10)

X

Intervention Contract Identifier

VERSIONNO

NUMBER(3,0)

X

Intervention Contract Version

AUTHORISEDBY

VARCHAR2(15)

 

User name

AUTHORISEDDATE

DATE

 

Date contract was authorised

LASTCHANGED

DATE

 

Last date and time record changed