Table: CONNECTIONPOINTOPERATINGSTA

CONNECTIONPOINTOPERATINGSTA

Name

CONNECTIONPOINTOPERATINGSTA

Comment

CONNECTIONPOINTOPERATINGSTA shows whether a connection point is active or not.


Description

CONNECTIONPOINTOPERATINGSTA data is confidential to each relevant participant.

Source

CONNECTIONPOINTOPERATINGSTA updates periodically with changes in connection point status, such as for Transmission Loss Factor (TLF) changes.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

CONNECTIONPOINTID

EFFECTIVEDATE

VERSIONNO


Index Columns

Name

CONNECTIONPOINTID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

EFFECTIVEDATE

DATE

X

Effective date of record

VERSIONNO

NUMBER(3,0)

X

 

CONNECTIONPOINTID

VARCHAR2(10)

X

Connection point identifier

OPERATINGSTATUS

VARCHAR2(16)

 

Active or inactive indicator

AUTHORISEDDATE

DATE

 

Date record authorised

AUTHORISEDBY

VARCHAR2(15)

 

User authorising record

LASTCHANGED

DATE

 

Last date and time record changed