Table: CONNECTIONPOINT

CONNECTIONPOINT

Name

CONNECTIONPOINT

Comment

CONNECTIONPOINT shows all valid connection points and their type. Transmission loss factors are available for all connection points in TRANSMISSIONLOSSFACTOR.


Description

CONNECTIONPOINT data is confidential to each relevant participant

Source

CONNECTIONPOINT updates for new connection points as required.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

CONNECTIONPOINTID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONNECTIONPOINTID

VARCHAR2(10)

X

Connection Point Identifier

CONNECTIONPOINTNAME

VARCHAR2(80)

 

Connection point full description

CONNECTIONPOINTTYPE

VARCHAR2(20)

 

Connection point type. transmission, distribution, station, genunit, or interconnector

ADDRESS1

VARCHAR2(80)

 

Connection point location

ADDRESS2

VARCHAR2(80)

 

Connection point location

ADDRESS3

VARCHAR2(80)

 

Connection point location

ADDRESS4

VARCHAR2(80)

 

Not Used

CITY

VARCHAR2(40)

 

City

STATE

VARCHAR2(10)

 

State of Australia

POSTCODE

VARCHAR2(10)

 

Post Code

LASTCHANGED

DATE

 

Last date and time record changed