MAS_CP_CHANGE (Historical table)
MAS_CP_CHANGE records pending changes to 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 |
| STATUS_FLAG |
varchar(1) |
varchar(1) |
Active/Inactive flag |
| CP_OLD_SECURITY_CODE |
varchar(4) |
varchar(4) |
Old Security Code |
| CP_NEW_SECURITY_CODE |
varchar(4) |
varchar(4) |
New Security Code |
| OLD_LOCAL_NETWORK_PROVIDER |
varchar(10) |
varchar(10) |
Old Local Network Provider |
| OLD_LOCAL_RETAILER |
varchar(10) |
varchar(10) |
Old Local Retailer |
| OLD_FINANCIAL_PARTICIPANT |
varchar(10) |
varchar(10) |
Old FRMP |
| OLD_METERING_DATA_AGENT |
varchar(10) |
varchar(10) |
Old Metering Data Agent |
| OLD_RETAILER_OF_LAST_RESORT |
varchar(10) |
varchar(10) |
Old Retailer of Last Resort |
| OLD_RESPONSIBLE_PERSON |
varchar(10) |
varchar(10) |
Old Responsible Person |
| NEW_LOCAL_NETWORK_PROVIDER |
varchar(10) |
varchar(10) |
New Local Network Provider |
| NEW_LOCAL_RETAILER |
varchar(10) |
varchar(10) |
New Local Retailer |
| NEW_FINANCIAL_PARTICIPANT |
varchar(10) |
varchar(10) |
New FRMP |
| NEW_METERING_DATA_AGENT |
varchar(10) |
varchar(10) |
New Metering Data Agent |
| NEW_RETAILER_OF_LAST_RESORT |
varchar(10) |
varchar(10) |
New Retailer of Last Resort |
| NEW_RESPONSIBLE_PERSON |
varchar(10) |
varchar(10) |
New Responsible Person |
| OLD_LNSP_OK |
varchar(1) |
varchar(1) |
Old LNSP approval flag |
| OLD_LR_OK |
varchar(1) |
varchar(1) |
Old LR approval flag |
| OLD_FRMP_OK |
varchar(1) |
varchar(1) |
Old FRMP approval flag |
| OLD_MDA_OK |
varchar(1) |
varchar(1) |
Old MDA approval flag |
| OLD_ROLR_OK |
varchar(1) |
varchar(1) |
Old ROLR approval flag |
| OLD_RP_OK |
varchar(1) |
varchar(1) |
Old RP approval flag |
| NEW_LNSP_OK |
varchar(1) |
varchar(1) |
New LNSP approval flag |
| NEW_LR_OK |
varchar(1) |
varchar(1) |
New LR approval flag |
| NEW_FRMP_OK |
varchar(1) |
varchar(1) |
New FRMP approval flag |
| NEW_MDA_OK |
varchar(1) |
varchar(1) |
New MDA approval flag |
| NEW_ROLR_OK |
varchar(1) |
varchar(1) |
New ROLR approval flag |
| NEW_RP_OK |
varchar(1) |
varchar(1) |
New RP approval flag |
| PRUDENTIAL_OK |
varchar(1) |
varchar(1) |
Prudential check flag |
| INITIAL_CHANGE_DATE |
datetime(3) |
datetime2(0) |
Initial change date |
| CURRENT_CHANGE_DATE |
datetime(3) |
datetime2(0) |
Current change date |
| 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 factors |
| OLD_LSNP_TEXT |
varchar(30) |
varchar(30) |
Old LNSP text field (LNSP misspelt in name) |
| OLD_LR_TEXT |
varchar(30) |
varchar(30) |
Old LR text field |
| OLD_FRMP_TEXT |
varchar(30) |
varchar(30) |
Old FRMP text field |
| OLD_MDA_TEXT |
varchar(30) |
varchar(30) |
Old MDA text field |
| OLD_ROLR_TEXT |
varchar(30) |
varchar(30) |
Old ROLR text field |
| OLD_RP_TEXT |
varchar(30) |
varchar(30) |
Old RP text field |
| NEW_LSNP_TEXT |
varchar(30) |
varchar(30) |
New LNSP text field (LNSP misspelt in name) |
| NEW_LR_TEXT |
varchar(30) |
varchar(30) |
New LR text field |
| NEW_FRMP_TEXT |
varchar(30) |
varchar(30) |
New FRMP text field |
| NEW_MDA_TEXT |
varchar(30) |
varchar(30) |
New MDA text field |
| NEW_ROLR_TEXT |
varchar(30) |
varchar(30) |
New ROLR text field |
| NEW_RP_TEXT |
varchar(30) |
varchar(30) |
New RP text field |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed date. |
| NMI_CLASS |
varchar(9) |
varchar(9) |
Class of National Metering Identifier to allow for different business rules to apply |
| METERING_TYPE |
varchar(9) |
varchar(9) |
Type of metering installation (e.g. BASIC, MRIM, COMMS) |
| JURISDICTION |
varchar(3) |
varchar(3) |
Area; for application of rules |
| CREATE_DATE |
datetime(3) |
datetime2(0) |
Set by the system with today''s date when the change record is created. |
| EXPIRY_DATE |
datetime(3) |
datetime2(0) |
Set by the system (and cannot be changed). |
| METER_READ_DATE |
datetime(3) |
datetime2(0) |
Date of meter reading |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MAS_CP_CHANGE_LCX |
nonclustered |
LASTCHANGED |
| PK_MAS_CP_CHANGE |
clustered, unique, primary key |
NMI |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MAS_CP_CHANGE_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MAS_CP_CHANGE |
clustered, unique, primary key |
NMI |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MAS_CP_CHANGE_LCX |
nonclustered |
LASTCHANGED |
| PK_MAS_CP_CHANGE |
clustered, unique, primary key |
NMI |