MAS_CP_MASTER (Historical table)
MAS_CP_MASTER shows the current MAS configuration.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| NMI |
varchar(10)  |
varchar(10) |
National Metering Identifier |
| VALID_FROM_DATE |
datetime(3) |
datetime2(0) |
Record valid from date |
| CP_SECURITY_CODE |
varchar(4) |
varchar(4) |
Security Code |
| IN_USE |
varchar(1) |
varchar(1) |
Active/Inactive Status flag (NEW/N/Y/X) |
| VALID_TO_DATE |
datetime(3) (not nullable) |
datetime2(0) (not nullable) |
Record valid to date |
| LOCAL_NETWORK_PROVIDER |
varchar(10) |
varchar(10) |
LNSP |
| LOCAL_RETAILER |
varchar(10) |
varchar(10) |
Local Retailer |
| FINANCIAL_PARTICIPANT |
varchar(10) |
varchar(10) |
FRMP |
| METERING_DATA_AGENT |
varchar(10) |
varchar(10) |
MDA |
| RETAILER_OF_LAST_RESORT |
varchar(10) |
varchar(10) |
ROLR |
| RESPONSIBLE_PERSON |
varchar(10) |
varchar(10) |
Responsible Person |
| CP_NAME |
varchar(30) |
varchar(30) |
Connection point name |
| CP_DETAIL_1 |
varchar(30) |
varchar(30) |
Connection point detail 1 |
| CP_DETAIL_2 |
varchar(30) |
varchar(30) |
Connection point detail 2 |
| CITY_SUBURB |
varchar(30) |
varchar(30) |
Connection point city/suburb |
| STATE |
varchar(3) |
varchar(3) |
State of Australia |
| POST_CODE |
varchar(4) |
varchar(4) |
Connection point postcode |
| TX_NODE |
varchar(4) |
varchar(4) |
Connection point TNI |
| AGGREGATE_DATA |
varchar(1) |
varchar(1) |
Aggregate data flag (YIN) |
| AVERAGE_DAILY_LOAD_KWH |
numeric(8, 0) |
int |
Average daily load in KWh |
| DISTRIBUTION_LOSS |
numeric(5, 4) |
numeric(5, 4) |
Distribution loss factor |
| LSNP_TEXT |
varchar(30) |
varchar(30) |
LNSP text field (name has misspelt LNSP) |
| LR_TEXT |
varchar(30) |
varchar(30) |
LR text field |
| FRMP_TEXT |
varchar(30) |
varchar(30) |
FRMP text field |
| MDA_TEXT |
varchar(30) |
varchar(30) |
MDA text field |
| ROLR_TEXT |
varchar(30) |
varchar(30) |
ROLR text field |
| RP_TEXT |
varchar(30) |
varchar(30) |
RP text field |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed date |
| NMI_CLASS |
varchar(9) |
varchar(9) |
- |
| METERING_TYPE |
varchar(9) |
varchar(9) |
- |
| JURISDICTION |
varchar(3) |
varchar(3) |
- |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MAS_CP_MASTER_LCX |
nonclustered |
LASTCHANGED |
| PK_MAS_CP_MASTER |
clustered, unique, primary key |
NMI, VALID_FROM_DATE |
| UC_MAS_CP_MASTER |
nonclustered, unique, unique key |
NMI, VALID_TO_DATE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MAS_CP_MASTER_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_MAS_CP_MASTER_NMI_VALID_TO_DATE |
nonclustered, unique |
NMI, VALID_TO_DATE |
| PK_MAS_CP_MASTER |
clustered, unique, primary key |
NMI, VALID_FROM_DATE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MAS_CP_MASTER_LCX |
nonclustered |
LASTCHANGED |
| PK_MAS_CP_MASTER |
clustered, unique, primary key |
NMI, VALID_FROM_DATE |
| UC_MAS_CP_MASTER |
nonclustered, unique, unique key |
NMI, VALID_TO_DATE |