Table: MAS_CP_CHANGE

MAS_CP_CHANGE

Name

MAS_CP_CHANGE

Comment

MAS_CP_CHANGE records pending changes to the current MAS configuration.


Description

Obsolete; Replaced by MSATS

Source

MAS_CP_CHANGE updates daily with each MAS export.

Note

Expiry date: When the Expiry date on a change record is reached, the change record is deleted.

Meter Read Date: only used in specific circumstances. For more details, refer to MAS documentation. The meter read date is not cleared if it becomes unusable (e.g. due to change of Metering Type or the passage of time).


Primary Key Columns

Name

NMI


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

NMI

VARCHAR2(10)

X

National Metering Identifier

STATUS_FLAG

VARCHAR2(1)

 

Active/Inactive flag

CP_OLD_SECURITY_CODE

VARCHAR2(4)

 

Old Security Code

CP_NEW_SECURITY_CODE

VARCHAR2(4)

 

New Security Code

OLD_LOCAL_NETWORK_PROVIDER

VARCHAR2(10)

 

Old Local Network Provider

OLD_LOCAL_RETAILER

VARCHAR2(10)

 

Old Local Retailer

OLD_FINANCIAL_PARTICIPANT

VARCHAR2(10)

 

Old FRMP

OLD_METERING_DATA_AGENT

VARCHAR2(10)

 

Old Metering Data Agent

OLD_RETAILER_OF_LAST_RESORT

VARCHAR2(10)

 

Old Retailer of Last Resort

OLD_RESPONSIBLE_PERSON

VARCHAR2(10)

 

Old Responsible Person

NEW_LOCAL_NETWORK_PROVIDER

VARCHAR2(10)

 

New Local Network Provider

NEW_LOCAL_RETAILER

VARCHAR2(10)

 

New Local Retailer

NEW_FINANCIAL_PARTICIPANT

VARCHAR2(10)

 

New FRMP

NEW_METERING_DATA_AGENT

VARCHAR2(10)

 

New Metering Data Agent

NEW_RETAILER_OF_LAST_RESORT

VARCHAR2(10)

 

New Retailer of Last Resort

NEW_RESPONSIBLE_PERSON

VARCHAR2(10)

 

New Responsible Person

OLD_LNSP_OK

VARCHAR2(1)

 

Old LNSP approval flag

OLD_LR_OK

VARCHAR2(1)

 

Old LR approval flag

OLD_FRMP_OK

VARCHAR2(1)

 

Old FRMP approval flag

OLD_MDA_OK

VARCHAR2(1)

 

Old MDA approval flag

OLD_ROLR_OK

VARCHAR2(1)

 

Old ROLR approval flag

OLD_RP_OK

VARCHAR2(1)

 

Old RP approval flag

NEW_LNSP_OK

VARCHAR2(1)

 

New LNSP approval flag

NEW_LR_OK

VARCHAR2(1)

 

New LR approval flag

NEW_FRMP_OK

VARCHAR2(1)

 

New FRMP approval flag

NEW_MDA_OK

VARCHAR2(1)

 

New MDA approval flag

NEW_ROLR_OK

VARCHAR2(1)

 

New ROLR approval flag

NEW_RP_OK

VARCHAR2(1)

 

New RP approval flag

PRUDENTIAL_OK

VARCHAR2(1)

 

Prudential check flag

INITIAL_CHANGE_DATE

DATE

 

Initial change date

CURRENT_CHANGE_DATE

DATE

 

Current change date

CP_NAME

VARCHAR2(30)

 

Connection point name

CP_DETAIL_1

VARCHAR2(30)

 

Connection point detail 1

CP_DETAIL_2

VARCHAR2(30)

 

Connection point detail 2

CITY_SUBURB

VARCHAR2(30)

 

Connection point City/Suburb

STATE

VARCHAR2(3)

 

State of Australia

POST_CODE

VARCHAR2(4)

 

Connection point postcode

TX_NODE

VARCHAR2(4)

 

Connection point TNI

AGGREGATE_DATA

VARCHAR2(1)

 

Aggregate data Flag (YIN)

AVERAGE_DAILY_LOAD_KWH

NUMBER(8,0)

 

Average Daily load in KWh

DISTRIBUTION_LOSS

NUMBER(5,4)

 

Distribution loss factors

OLD_LSNP_TEXT

VARCHAR2(30)

 

Old LNSP text field (LNSP misspelt in name)

OLD_LR_TEXT

VARCHAR2(30)

 

Old LR text field

OLD_FRMP_TEXT

VARCHAR2(30)

 

Old FRMP text field

OLD_MDA_TEXT

VARCHAR2(30)

 

Old MDA text field

OLD_ROLR_TEXT

VARCHAR2(30)

 

Old ROLR text field

OLD_RP_TEXT

VARCHAR2(30)

 

Old RP text field

NEW_LSNP_TEXT

VARCHAR2(30)

 

New LNSP text field (LNSP misspelt in name)

NEW_LR_TEXT

VARCHAR2(30)

 

New LR text field

NEW_FRMP_TEXT

VARCHAR2(30)

 

New FRMP text field


2