Table: CONTRACTRESTARTSERVICES

CONTRACTRESTARTSERVICES

Name

CONTRACTRESTARTSERVICES

Comment

CONTRACTRESTARTSERVICES shows Restart Services contract details used in the settlement and dispatch of this service.


Description

CONTRACTRESTARTSERVICES data is confidential to the participant holding the contract.

Source

CONTRACTRESTARTSERVICES updates only where there is a contract variation.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

CONTRACTID

VERSIONNO


Index Columns

Name

PARTICIPANTID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(10)

X

Contract Identifier

VERSIONNO

NUMBER(3,0)

X

Contract Version No.

STARTDATE

DATE

 

Starting Date of Contract

ENDDATE

DATE

 

Termination Date of Contract

PARTICIPANTID

VARCHAR2(10)

 

Unique participant identifier

RESTARTTYPE

NUMBER(1,0)

 

Restart Type - 0 = BlackStart, 1 = Combination, 2 = Trip To House

RCPRICE

NUMBER(6,2)

 

Availability Price

TRIPTOHOUSELEVEL

NUMBER(5,0)

 

Trip To House Level

AUTHORISEDBY

VARCHAR2(15)

 

User Name

AUTHORISEDDATE

DATE

 

Date Contract was Authorised

LASTCHANGED

DATE

 

Last date and time record changed

DEFAULT_TESTINGPAYMENT_AMOUNT

NUMBER(18,8)

 

The NMAS default payment amount

SERVICE_START_DATE

DATE

 

The NMAS Testing Service Start Date