|
Name |
|
|
Comment |
CONNECTIONPOINT shows all valid connection points and their type. Transmission loss factors are available for all connection points in TRANSMISSIONLOSSFACTOR. |
|
CONNECTIONPOINT data is confidential to each relevant participant Source CONNECTIONPOINT updates for new connection points as required. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
CONNECTIONPOINTID |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|