Table: MAS_CP_MASTER

MAS_CP_MASTER

Name

MAS_CP_MASTER

Comment

MAS_CP_MASTER shows the current MAS configuration.


Description

Obsolete; Replaced by MSATS

Source

MAS_CP_MASTER updates daily with each MAS export.

Note

In_Use Value

Meaning

Y

ACTIVE

N

CLOSED

X

EXTINCT


Primary Key Columns

Name

NMI

VALID_FROM_DATE


Primary Key Columns

Name

NMI

VALID_TO_DATE


Index Columns

Name

LASTCHANGED


Content

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)