|
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) |
|
|
|
|
|