CONNECTIONPOINTDETAILS (Historical table)
CONNECTIONPOINTDETAILS is obsolete, since it was never populated by Participants accessing AEMO''s Oracle Interface. CONNECTIONPOINTDETAILS was designed to show relevant details for each connection point including the responsible party, loss factor and relevant MDAs.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| EFFECTIVEDATE |
datetime(3)  |
datetime2(0) |
Effective date of record |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version no of record for given effective date |
| CONNECTIONPOINTID |
varchar(10) |
varchar(10) |
Connection point identifier |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| TRANSMISSIONCPTID |
varchar(10) |
varchar(10) |
Associated transmission connection point id for a distribution connection point |
| METERDATAPROVIDER |
varchar(10) |
varchar(10) |
The MDA providing meter data for this connection point |
| TRANSMISSIONLOSSFACTOR |
numeric(7, 5) |
numeric(7, 5) |
The transmission level loss factor for this connection point |
| DISTRIBUTIONLOSSFACTOR |
numeric(7, 5) |
numeric(7, 5) |
The distribution level loss factor for a distribution connection point |
| NETWORKSERVICEPROVIDER |
varchar(10) |
varchar(10) |
The Network Service Provider |
| FINRESPORGAN |
varchar(10) |
varchar(10) |
Financially responsible organisation |
| NATIONALMETERINSTALLID |
numeric(7, 5) |
numeric(7, 5) |
National Meter Id |
| AUTHORISEDBY |
varchar(15) |
varchar(15) |
User authorising record |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Date record authorised |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| INUSE |
varchar(1) |
varchar(1) |
Status flag. |
| LNSP |
varchar(10) |
varchar(10) |
Local Electricity Network Service Provider |
| MDA |
varchar(10) |
varchar(10) |
Metering Data Agent for connection point. |
| ROLR |
varchar(10) |
varchar(10) |
Retailer of last resort. |
| RP |
varchar(10) |
varchar(10) |
Responsible party. |
| AGGREGATEDDATA |
varchar(1) |
varchar(1) |
Aggregate flag. |
| VALID_TODATE |
datetime(3) |
datetime2(0) |
Date of validity. |
| LR |
varchar(10) |
varchar(10) |
Local Retailer |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| CONNECTIONPOINTDETAI_NDX2 |
nonclustered |
METERDATAPROVIDER, NETWORKSERVICEPROVIDER, FINRESPORGAN |
| CONNECTIONPOINTDETAI_NDX3 |
nonclustered |
CONNECTIONPOINTID |
| CONNECTIONPOINTDETAILS_LCX |
nonclustered |
LASTCHANGED |
| CONNECTIONPOINTDETAILS_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, CONNECTIONPOINTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_CONNECTIONPOINTDETAILS_CONNECTIONPOINTID |
nonclustered |
CONNECTIONPOINTID |
| IX_CONNECTIONPOINTDETAILS_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_CONNECTIONPOINTDETAILS_METERDATAPROVIDER_NETWORKSERVICEPROVIDER_FINRESPORGAN |
nonclustered |
METERDATAPROVIDER, NETWORKSERVICEPROVIDER, FINRESPORGAN |
| PK_CONNECTIONPOINTDETAILS |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, CONNECTIONPOINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| CONNECTIONPOINTDETAI_NDX2 |
nonclustered |
METERDATAPROVIDER, NETWORKSERVICEPROVIDER, FINRESPORGAN |
| CONNECTIONPOINTDETAI_NDX3 |
nonclustered |
CONNECTIONPOINTID |
| CONNECTIONPOINTDETAILS_LCX |
nonclustered |
LASTCHANGED |
| CONNECTIONPOINTDETAILS_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, CONNECTIONPOINTID |