|
Name |
|
|
Comment |
MAS_CP_CHANGE records pending changes to the current MAS configuration. |
|
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). |
|
Name |
|
NMI |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|