Name |
|
Comment |
MAS_CP_MASTER shows the current MAS configuration. |
Obsolete; Replaced by MSATS Source MAS_CP_MASTER updates daily with each MAS export. Note
|
Name |
NMI |
VALID_FROM_DATE |
Name |
NMI |
VALID_TO_DATE |
Name |
LASTCHANGED |
Name |
Data Type |
Mandatory |
Comment |
NMI |
VARCHAR2(10) |
X |
National Metering Identifier |
CP_SECURITY_CODE |
VARCHAR2(4) |
|
Security Code |
IN_USE |
VARCHAR2(1) |
|
Active/Inactive Status flag (NEW/N/Y/X) |
VALID_FROM_DATE |
DATE |
X |
Record valid from date |
VALID_TO_DATE |
DATE |
X |
Record valid to date |
LOCAL_NETWORK_PROVIDER |
VARCHAR2(10) |
|
LNSP |
LOCAL_RETAILER |
VARCHAR2(10) |
|
Local Retailer |
FINANCIAL_PARTICIPANT |
VARCHAR2(10) |
|
FRMP |
METERING_DATA_AGENT |
VARCHAR2(10) |
|
MDA |
RETAILER_OF_LAST_RESORT |
VARCHAR2(10) |
|
ROLR |
RESPONSIBLE_PERSON |
VARCHAR2(10) |
|
Responsible Person |
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 factor |
LSNP_TEXT |
VARCHAR2(30) |
|
LNSP text field (name has misspelt LNSP) |
LR_TEXT |
VARCHAR2(30) |
|
LR text field |
FRMP_TEXT |
VARCHAR2(30) |
|
FRMP text field |
MDA_TEXT |
VARCHAR2(30) |
|
MDA text field |
ROLR_TEXT |
VARCHAR2(30) |
|
ROLR text field |
RP_TEXT |
VARCHAR2(30) |
|
RP text field |
LASTCHANGED |
DATE |
|
Last changed date |
NMI_CLASS |
VARCHAR2(9) |
|
|
METERING_TYPE |
VARCHAR2(9) |
|
|
JURISDICTION |
VARCHAR2(3) |
|
|
|
|
|