Table: SSM_CONTRACT_UNIT_AVAIL

SSM_CONTRACT_UNIT_AVAIL

Name

SSM_CONTRACT_UNIT_AVAIL

Comment

The variable parameters associated to the Unit within an SSM Contract, allowing changes to the base contract values due to unit availabilities (e.g Maintenance, Outages).


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

CONTRACT_ID

DUID

INTERVAL_DATETIME

VERSION_DATETIME


Content

Name

Data Type

Mandatory

Comment

CONTRACT_ID

VARCHAR2(20)

X

Unique Contract Identifier

DUID

VARCHAR2(20)

X

Dispatchable Unit Identifier

INTERVAL_DATETIME

DATE

X

The starting Dispatch Interval for the availability change. This will be the active availability until the next INTERVAL_DATETIME record for this Contract and DUID.

VERSION_DATETIME

DATE

X

Effective Date and Time of this record.

AVAILABLE

NUMBER(1,0)

 

Indicates if DUID is available for the INTERVAL_DATETIME (1 = True, 0 = False).

UNIT_COUNT

NUMBER(4,0)

 

Number of sub-units within a DUID that are available for enablement.

ACTIVATION_LEAD_TIME

NUMBER(6,0)

 

The expected maximum lead time for the system security service to be enabled from a non-operational state in minutes.

MIN_DISPATCH_MW

NUMBER(18,8)

 

Minimum Dispatch Target required for DUID to enable the contract.

MIN_ENABLEMENT_DURATION

NUMBER(6,0)

 

Minimum duration a unit must be active to enable the contract in minutes.

LASTCHANGED

DATE

 

Last time record was changed


Table: SSM_ENABLEMENT_COSTS

SSM_ENABLEMENT_COSTS

Name

SSM_ENABLEMENT_COSTS

Comment

SSM Contract Enablement Costs for NEM


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

ENABLEMENT_REASON

END_TRADINGDATE


Content

Name

Data Type

Mandatory

Comment

END_TRADINGDATE

DATE

X

Trading Date of the end of the enablement

ENABLEMENT_REASON

VARCHAR2(40)

X

Primary Service type associated.

ESTIMATED_COSTS

NUMBER(18,8)

 

Cost estimation for the service type.

LASTCHANGED

DATE

 

Last time record was changed.


Table: SSM_ENABLEMENT_PERIOD

SSM_ENABLEMENT_PERIOD

Name

SSM_ENABLEMENT_PERIOD

Comment

SSM Contract Enablement Periods


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

DUID

ENABLEMENT_START_INTERVAL

INSTRUCTION_ID


Content

Name

Data Type

Mandatory

Comment

INSTRUCTION_ID

VARCHAR2(20)

X

Unique Instruction Identifier

DUID

VARCHAR2(20)

X

Dispatchable Unit Identifier

ENABLEMENT_START_INTERVAL

DATE

X

The first Dispatch Interval the unit is enabled for SSM Services.

ENABLEMENT_END_INTERVAL

DATE

 

The last Dispatch Interval the unit is enabled for SSM Services.

ENABLEMENT_REASON

VARCHAR2(40)

 

Reason for the enablement.

LASTCHANGED

DATE

 

Last time record was changed.


Table: SSM_INSTRUCTION

SSM_INSTRUCTION

Name

SSM_INSTRUCTION

Comment

An enablement of an SSM Contract that instructs a Dispatchable Unit is to provide a System Security Service.


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

INSTRUCTION_ID

VERSION_DATETIME


Content

Name

Data Type

Mandatory

Comment

INSTRUCTION_ID

VARCHAR2(20)

X

Unique Instruction Identifier.

VERSION_DATETIME

DATE

X

Effective Date and Time of this record.

INITIAL_INSTRUCTION_ID

VARCHAR2(20)

 

Unique transaction identifier of initiating transaction if instruction related to an amendment or cancellation.

DUID_PARTICIPANTID

VARCHAR2(10)

 

Primary recipient (SSM Service Provider) of enablement instruction.

CONTRACT_ID

VARCHAR2(20)

 

Unique Contract Identifier used to create enablement.

TNSP_PARTICIPANTID

VARCHAR2(10)

 

Participant ID of TNSP if contract procurer is TNSP.

DUID

VARCHAR2(20)

 

Dispatchable Unit Identifier

UNIT_COUNT

NUMBER(4,0)

 

Number of sub-units within a DUID that are required for enablement. Value of zero means cancellation of instruction.

EQUIPMENT_TYPE

VARCHAR2(40)

 

Dispatchable Unit resource (for example, GENERATOR, LOAD, BIDIRECTIONAL, SYNCHRONOUS CONDENSER).

SERVICE_TYPE

VARCHAR2(40)

 

Requested Service to provide(System strength-combination,System strength-coefficient,NSCAS-voltage control,NSCAS,Inertia,Transitional service-type 1 MSL,Transitional service-type 1,Transitional service-type 2).

MIN_DISPATCH_MW

NUMBER(18,8)

 

Minimum Dispatch Target required for DUID to enable the contract. Value of zero means cancellation of instruction.

START_INTERVAL_DATETIME

DATE

 

The first Dispatch Interval of the enablement.

END_INTERVAL_DATETIME

DATE

 

The last Dispatch Interval of the enablement.

LASTCHANGED

DATE

 

Last time record was changed.


Table: SSM_SCHEDULE

SSM_SCHEDULE

Name

SSM_SCHEDULE

Comment

Scheduled SSM contract enablements.


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

INSTRUCTION_ID


Content

Name

Data Type

Mandatory

Comment

INSTRUCTION_ID

VARCHAR2(20)

X

Unique Instruction Identifier

CONTRACT_ID

VARCHAR2(20)

 

Unique Contract Identifier used to create enablement.

DUID_PARTICIPANTID

VARCHAR2(10)

 

Primary recipient (SSM Service Provider)

TNSP_PARTICIPANTID

VARCHAR2(10)

 

Participant ID of TNSP if contract procurer is TNSP.

DUID

VARCHAR2(20)

 

Dispatchable Unit Identifier

UNIT_COUNT

NUMBER(4,0)

 

Number of sub-units within a DUID that are required for enablement.

EQUIPMENT_TYPE

VARCHAR2(40)

 

Dispatchable Unit resource (for example, GENERATOR, LOAD, BIDIRECTIONAL, SYNCHRONOUS CONDENSER).

SERVICE_TYPE

VARCHAR2(40)

 

Requested Service to provide(System strength-combination,System strength-coefficient,NSCAS-voltage control,NSCAS,Inertia,Transitional service-type 1 MSL,Transitional service-type 1,Transitional service-type 2).

MIN_DISPATCH_MW

NUMBER(18,8)

 

Minimum Dispatch Target required for DUID to enable the contract.

START_INTERVAL_DATETIME

DATE

 

The first Dispatch Interval of the enablement.

END_INTERVAL_DATETIME

DATE

 

The last Dispatch Interval of the enablement.

LASTCHANGED

DATE

 

Last time record was changed.


Table: SSM_SCHEDULED_AVAILABILITY

SSM_SCHEDULED_AVAILABILITY

Name

SSM_SCHEDULED_AVAILABILITY

Comment

Scheduled SSM availability


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

AVAILABLE_START_INTERVAL

CONTRACT_ID

DUID


Content

Name

Data Type

Mandatory

Comment

CONTRACT_ID

VARCHAR2(20)

X

Unique Contract Identifier

DUID

VARCHAR2(20)

X

Dispatchable Unit Identifier

AVAILABLE_START_INTERVAL

DATE

X

The first Dispatch Interval the unit is available.

AVAILABLE_END_INTERVAL

DATE

 

The last Dispatch Interval the unit is available.

TNSP_PARTICIPANTID

VARCHAR2(10)

 

TNSP Participant ID

LASTCHANGED

DATE

 

Last time record was changed.