|
Name |
|
|
Comment |
CONNECTIONPOINTDETAILS is obsolete, since it was never populated by Participants accessing AEMO's Oracle Interface. |
|
CONNECTIONPOINTDETAILS data is confidential to each participant included in details. Source CONNECTIONPOINTDETAILS updates periodically, such as for Transmission Loss Factor (TLF) changes |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
CONNECTIONPOINTID |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
METERDATAPROVIDER |
|
NETWORKSERVICEPROVIDER |
|
FINRESPORGAN |
|
Name |
|
CONNECTIONPOINTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of record |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no of record for given effective date |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Connection point identifier |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
TRANSMISSIONCPTID |
VARCHAR2(10) |
|
Associated transmission connection point id for a distribution connection point |
|
METERDATAPROVIDER |
VARCHAR2(10) |
|
The MDA providing meter data for this connection point |
|
TRANSMISSIONLOSSFACTOR |
NUMBER(7,5) |
|
The transmission level loss factor for this connection point |
|
DISTRIBUTIONLOSSFACTOR |
NUMBER(7,5) |
|
The distribution level loss factor for a distribution connection point |
|
NETWORKSERVICEPROVIDER |
VARCHAR2(10) |
|
The Network Service Provider |
|
FINRESPORGAN |
VARCHAR2(10) |
|
Financially responsible organisation |
|
NATIONALMETERINSTALLID |
NUMBER(7,5) |
|
National Meter Id |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
|
AUTHORISEDDATE |
DATE |
|
Date record authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
INUSE |
VARCHAR2(1) |
|
Status flag. |
|
LNSP |
VARCHAR2(10) |
|
Local Electricity Network Service Provider |
|
MDA |
VARCHAR2(10) |
|
Metering Data Agent for connection point. |
|
ROLR |
VARCHAR2(10) |
|
Retailer of last resort. |
|
RP |
VARCHAR2(10) |
|
Responsible party. |
|
AGGREGATEDDATA |
VARCHAR2(1) |
|
Aggregate flag. |
|
VALID_TODATE |
DATE |
|
Date of validity. |
|
LR |
VARCHAR2(10) |
|
Local Retailer |
|
|
|