CATS Standing Data

Phase 2 updates to CATS Standing Data The data held in the following database tables: • CATS_NMI_Data_Stream • CATS_NMI_Data • CATS_Meter_Register • CATS_NMI_Participants_Relationships • CATS_Register_Identifier NMI Standing Data is a sub-set of the CATS Standing Data., supporting the Standing Data items identified in the MSDR industry consultation.

Removed standing data

Field	Category
Additional Site Information	General Metering Installation Information
Asset Management Plan	General Metering Installation Information
Calibration Tables	General Metering Installation Information
Communication Protocol	Meter Communications Information
Communications Equipment Type	Meter Communications Information
Data Conversion	Meter Communications Information
Data Validations	Meter Read Estimation Information
Demand 1	Register Identifier
Demand 2	Register Identifier
Estimation Instructions	Meter Read Estimation Information
Measurement Type	Meter Read Estimation Information
Meter Constant	General Metering Installation Information
Meter Point	General Metering Installation Information
Meter Program	General Metering Installation Information
Meter Route	General Metering Installation Information
Meter Test & Calibration Program	General Metering Installation Information
Meter Test Result Notes	General Metering Installation Information
Next Test Date	General Metering Installation Information
Passwords	Meter Communications Information
Remote Phone Number	Meter Communications Information
Test Performed By	General Metering Installation Information
Test Result Accuracy
Transformer Location	Transformer Information
Transformer Ratio	Transformer Information
Transformer Type	Transformer Information
User Access Rights	Meter Communications Information

New standing data

For these new Standing Data items, a value supplied in a completed (COM) 2XXX and 5XXX series CR is stored:

ConnectionConfiguration
DPNumber
GNAFPID
HouseNumberTo
SectionNumber

New meter register data

For these new Meter Register Data items, a value supplied in a completed (COM) 2XXX, 3XXX and 5XXX series CR is stored:

CurrentTransformerAccuracyClass
GPSCoordinatesLong
CurrentTransformerLocation
TestResult
CurrentTransformerRatioAvailable
VoltageTransformerAccuracyClass
CurrentTransformerRatioConnected
VoltageTransformerLocation
CurrentTransformerTest
VoltageTransformerRatio
CurrentTransformerTestDate
VoltageTransformerTest
CurrentTransformerType
VoltageTransformerTestDate
GPSCoordinatesLat
VoltageTransformerType

Standing data update details

Field	Type	Status	Update by	CATS table	DB data type	aseXML data type	aseXML path	Provider	Transition end
Building or Property Name	A	R	CR BUT	NMI_DATA	VARCHAR2(30)	xsd:string maxLen = 30	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ AustralianBuildingOrPropertyName	LNSP	30 Jun 23
Connection Configuration	N	M	CR BUT	NMI_DATA	VARCHAR2(2)	xsd:string maxLen = 2	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ ConnectionConfiguration	LNSP	7 Nov 23
Controlled Load	A	M	CR SU	REGISTER _IDENTIFIER	VARCHAR2(100)	xsd:string maxLen = 100	Electricity_r42.xsd ElectricityMeterRegisterDetail/	MP AEMO	30 Jun 23
Current Transformer Accuracy Class	N	R	CR BUT	METER _REGISTER	VARCHAR(50)	xsd:string maxLen = 50	Electricity_r42 ElectricityMeter/ CurrentTransformerAccuracyClass	MP	7 Nov 23
Current Transformer Location	N	R	CR BUT	METER _REGISTER	VARCHAR(50)	xsd:string maxLen = 50	Electricity_r42 ElectricityMeter/ CurrentTransformerLocation	MP	7 Nov 23
Current Transformer Ratio Available	N	R	CR BUT	METER _REGISTER	VARCHAR(50)	xsd:string maxLen = 50	Electricity_r42 ElectricityMeter/ CurrentTransformerRatioAvailable	MP	7 Nov 23
Current Transformer Ratio Connected	N	R	CR BUT	METER _REGISTER	VARCHAR(20)	xsd:string maxLen = 50	Electricity_r42 ElectricityMeter/ CurrentTransformerRatioConnected	MP	7 Nov 23
Current Transformer Test	N	R	CR BUT	METER _REGISTER	VARCHAR(20)	xsd:string maxLen = 20	Electricity_r42 ElectricityMeter/ CurrentTransformerTest	MP	7 Nov 23
Current Transformer Test Date	N	R	CR BUT	METER _REGISTER	DATE	xsd:date	Electricity_r42 ElectricityMeter/ CurrentTransformerTestDate	MP	7 Nov 23
Current Transformer Type	N	R	CR BUT	METER _REGISTER	VARCHAR(20)	xsd:string maxLen = 20	Electricity_r42 ElectricityMeter/ CurrentTransformerType	MP	7 Nov 23
Delivery Point Identifier	A	R	CR	NMI_DATA	Non-negative integer	Min: 10000000 Max: 99999999	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ DeliveryPointIdentifier	AEMO only	30 Jun 23
DPNumber	N	R: NSW/ACT	CR BUT	NMI_DATA	Varchar2(20)	xsd:string maxLen = 20	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ DPNumber	LNSP	7 Nov 23
Feeder Class	A	R	CR BUT	NMI_DATA	Varchar2(20)	xsd:string maxLen = 20	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ FeederClass	LNSP	7 Nov 23
Flat Or Unit Number	A	R	CR BUT	NMI_DATA	Varchar2(7)	xsd:string maxLen = 7	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ FlatOrUnitNumber	LNSP	30 Jun 23
Flat Or Unit Type	A	R	CR BUT	NMI_DATA	Varchar2(4)	xsd:string maxLen = 4	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ FlatOrUnitType	LNSP	30 Jun 23
Floor Or Level Number	A	R	CR BUT	NMI_DATA	Varchar2(5)	xsd:string maxLen = 4	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ FloorOrLevelNumber	LNSP	30 Jun 23
Floor Or Level Type	A	R	CR BUT	NMI_DATA	Varchar2(2)	xsd:string maxLen = 2	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ FloorOrLevelType	LNSP	30 Jun 23
GNAFPID	N	R	CR	NMI_DATA	Varchar2(20)	xsd:string maxLen = 20	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ GNAFPID	AEMO only	30 Jun 23
GPS Coordinates Lat	N	C	CR BUT	METER _REGISTER	NUMERIC (s2.7)	xsd:decimal minIncl = 0 maxIncl = 99.9999999 totdig = 2 fracdig = 7	Electricity_r42 ElectricityMeter/ GPSCoordinates	MP	7 Nov 25
GPS Coordinates Long	N	C	CR BUT	METER _REGISTER	NUMERIC (s3.7)	xsd:decimal minIncl = 0 maxIncl = 99.9999999 totdig = 3 fracdig = 7	Electricity_r42 ElectricityMeter/ GPSCoordinates	MP	11 Jul 25
Hazard	A	R	CR	METER _REGISTER	VARCHAR2(12)	maxLength = 100	Electricity_r42 ElectricityMeter Hazard	MP	7 Nov 23
House Number	A	R	CR BUT	NMI_DATA	NUMBER(99999)	xsd:nonNegativeInteger maxIncl = 99999	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ HouseNumber	LNSP	30 Jun 23
House Number Suffix	A	R	CR BUT	NMI_DATA	VARCHAR2(1)	xsd:string maxLen = 1	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ HouseNumberSuffix	LNSP	30 Jun 23
House Number To	A	R	CR BUT	NMI_DATA	NUMBER(99999)	xsd:nonNegativeInteger maxIncl = 99999	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ HouseNumberTo	LNSP	30 Jun 23
Last Test Date	A	R	CR	METER _REGISTER	DATE	xsd:date	Electricity_r42 ElectricityMeter/LastTestDate	MP	7 Nov 23
Location	A	R	CR	METER _REGISTER	VARCHAR2(50)	maxLength = 200	Electricity_r42 ElectricityMeter/ Location	MP	7 Nov 23
Location Descriptor	A	R	CR BUT	NMI_DATA	VARCHAR2(200)	xsd:string maxLen = 200	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ LocationDescriptor	LNSP	30 Jun 23
Lot Number	A	R	CR BUT	NMI_DATA	VARCHAR2(6)	xsd:string maxLen = 6	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ LotNumber	LNSP	30 Jun 23
Manufacturer	A	M	CR BUT	METER _REGISTER	VARCHAR2(15)	xsd:string maxLen = 15	Electricity_r42 ElectricityMeter/ Manufacturer	MP	7 Nov 23
Model	A	M	CR BUT	METER _REGISTER	VARCHAR2(12)	xsd:string maxLen = 12	Electricity_r42 ElectricityMeter/ Model	MP	7 Nov 23
Meter Malfunction Exemption Expiry Date	N	R	CR	NMI_DATA	DATE	xsd:date	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ MeterMalfunctionExemptionExpiryDate	AEMO only	30 Jun 23
Meter Malfunction Exemption Number	N	R	CR	NMI_DATA	n/a	MeterMalfunctionExemptionNumber	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ MeterMalfunctionExemptionNumber	AEMO only	30 Jun 23
Additional Site Information	A	R	CR	REGISTER _IDENTIFIER	Varchar2(100)	xsd:AdditionalSiteInformation	ElectricityMeter/ AdditionalSiteInformati on	MP	7 Nov 23
Next Scheduled Read Date	A	M: manually read R: Type 7	CR	METER _REGISTER	DATE	xsd:date	Electricity_r42 ElectricityMeter/ NextScheduledReadDate	MP	30 Jun 23
Section Number	N	R: NSW/ACT	CR BUT	NMI_DATA	Varchar2(20)	xsd:string maxLen = 20	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ SectionNumber	LNSP	7 Nov 23
Shared Isolation Point Flag	N	R	CR BUT	NMI_DATA	Varchar2(1)	xsd:string maxLen = 1	ElectricityMasterStandingData_r42 SharedIsolationPointFlag	LNSP	1 May 2023
Street Name	A	R	CR BUT	NMI_DATA	Varchar2(30)	xsd:string maxLen = 20	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ StreetName	LNSP	30 Jun 23
Street Suffix	A	R	CR BUT	NMI_DATA	Varchar2(2)	xsd:string maxLen = 2	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ StreetSuffix	LNSP	30 Jun 23
Street Type	A	R	CR BUT	NMI_DATA	Varchar2(4)	xsd:string maxLen = 4	ElectricityMasterStandingData_r42 ElectricityNMIMasterGroup/ StreetType	LNSP	30 Jun 23
Test Result	A	R	CR	METER _REGISTER	VARCHAR2(4)	xsd:string maxLen = 4	Electricity_r42 ElectricityMeter/ TestResult	MP	7 Nov 23
Time Of Day	A	M	CR SU	REGISTER _IDENTIFIER	VARCHAR2(10)	xsd:string maxLen = 10	CATSTableReplication_r42 ElectricityNMIMeterRegisterGroup	MP AEMO	30 Jun 23
Use	A	M	CR BUT	METER _REGISTER	VARCHAR2(10)	xsd:string maxLen = 10	Electricity_r42 ElectricityMeter/ Use	MP	30 Jun 23
Voltage Transformer Accuracy Class	N	R	CR BUT	METER _REGISTER	VARCHAR(20)	xsd:string maxLen = 20	Electricity_r42 ElectricityMeter/ VoltageTransformerAccuracyClass	MP	7 Nov 23
Voltage Transformer Location	N	R	CR BUT	METER _REGISTER	VARCHAR(50)	xsd:string maxLen = 50	Electricity_r42 ElectricityMeter/ VoltageTransformerLocation	MP	7 Nov 23
Voltage Transformer Ratio	N	R	CR BUT	METER _REGISTER	VARCHAR(50)	xsd:string maxLen = 50	Electricity_r42 ElectricityMeter/ VoltageTransformerRatio	MP	7 Nov 23
Voltage Transformer Test	N	R	CR BUT	METER _REGISTER	VARCHAR(20)	xsd:string maxLen = 20	Electricity_r42 ElectricityMeter/ VoltageTransformerTest	MP	7 Nov 23
Voltage Transformer Test Date	N	R	CR BUT	METER _REGISTER	DATE	xsd:date	Electricity_r42 ElectricityMeter/ VoltageTransformerTestDate	MP	7 Nov 23
Voltage Transformer Type	N	R	CR BUT	METER _REGISTER	VARCHAR(50)	xsd:string maxLen = 50	Electricity_r42 ElectricityMeter/ Voltage Transformer Type	MP	7 Nov 23

BUT update field details

This table describes the BUT Blind Update Tool updatable fields and details.

NEW NOT NULL: Submitted value cannot be NULL
BUT ONCE: Field can only be updated once
CURRENT IS NULL: Will update where the current value is NULL or not NULL

BUT Field ID	Field	CATS table	Group	BUT ONCE	CURRENT IS NULL	NEW NOT NULL
BUILDING_NAME	Building Or Property Name	NMI_DATA	Address	✓	✖	✖
CONNECTION_CONFIGURATION	Connection Configuration	NMI_DATA	NMI Site	✓	✖	✓
CT_ACCURACY_CLASS	Current Transformer Accuracy Class	METER_REGISTER	CT Group	✓	✖	✓
CT_LOCATION	Current Transformer Location	METER_REGISTER	CT Group	✓	✖	✓
CT_RATIO_AVAILABLE	Current Transformer Ratio Available	METER_REGISTER	CT Group	✓	✖	✓
CT_RATIO_CONNECTED	Current Transformer Ratio Connected	METER_REGISTER	CT Group	✓	✖	✓
CT_TEST	Current Transformer Test	METER_REGISTER	CT Group	✓	✖	✓
CT_TEST_DATE	Current Transformer Test Date	METER_REGISTER	CT Group	✓	✖	✓
CT_TYPE	Current Transformer Type	METER_REGISTER	CT Group	✓	✖	✓
DP_NUMBER	DPNumber	NMI_DATA	NMI Allocate	✓	✖	✓
FEEDER_CLASS	Feeder Class	NMI_DATA	NMI Location	✓	✖	✓
FLAT_NUMBER	Flat Or Unit Number	NMI_DATA	Address	✓	✖	✖
FLAT_TYPE	Flat Or Unit Type	NMI_DATA	Address	✓	✖	✖
FLOOR_NUMBER	Floor Or Level Number	NMI_DATA	Address	✓	✖	✖
FLOOR_TYPE	Floor Or Level Type	NMI_DATA	Address	✓	✖	✖
LATITUDE	GPS Coordinates Lat	METER_REGISTER	NMI Location	✓	✓	✓
LONGITUDE	GPS Coordinates Long	METER_REGISTER	NMI Location	✓	✓	✓
HOUSE_NUMBER	House Number	NMI_DATA	Address	✓	✖	✖
HOUSE_NUMBER_SUFFIX	House Number Suffix	NMI_DATA	Address	✓	✖	✖
HOUSE_NUMBER_TO	House Number To	NMI_DATA	Address	✓	✖	✖
LOCATION_DESCRIPTOR	Location Descriptor	NMI_DATA	Address	✓	✖	✖
LOT_NUMBER	Lot Number	NMI_DATA	Address	✓	✖	✖
METER_MANUFACTURER	Manufacturer	METER_REGISTER	Meter	✓	✖	✓
METER_USE	Use	METER_REGISTER	Meter	✓	✖	✓
	Model	METER_REGISTER	Meter	✓	✖	✓
SECTION_NUMBER	Section Number	NMI_DATA	NMI Site	✓	✖	✓
SHARED_ISOLATION_POINT_FLAG	Shared Isolation Point Flag	NMI_DATA	Meter	✓	✖	✓
STREET_NAME	Street Name	NMI_DATA	Address	✓	✖	✓
STREET_SUFFIX	Street Suffix	NMI_DATA	Address	✓	✖	✖
STREET_TYPE	Street Type	NMI_DATA	Address	✓	✖	✖
VT_ACCURACY_CLASS	Voltage Transformer Accuracy Class	METER_REGISTER	VT Group	✓	✖	✓
VT_LOCATION	Voltage Transformer Location	METER_REGISTER	VT Group	✓	✖	✓
VT_RATIO	Voltage Transformer Ratio	METER_REGISTER	VT Group	✓	✖	✓
VT_TEST	Voltage Transformer Test	METER_REGISTER	VT Group	✓	✖	✓
VT_TEST_DATE	Voltage Transformer Test Date	METER_REGISTER	VT Group	✓	✖	✓
VT_TYPE	Voltage Transformer Type	METER_REGISTER	VT Group	✓	✖	✓