|
Name |
Data Type |
Mandatory |
Comment |
|
NEW_MDA_TEXT |
VARCHAR2(30) |
|
New MDA text field |
|
NEW_ROLR_TEXT |
VARCHAR2(30) |
|
New ROLR text field |
|
NEW_RP_TEXT |
VARCHAR2(30) |
|
New RP text field |
|
LASTCHANGED |
DATE |
|
Last changed date. |
|
NMI_CLASS |
VARCHAR2(9) |
|
Class of National Metering Identifier to allow for different business rules to apply |
|
METERING_TYPE |
VARCHAR2(9) |
|
Type of metering installation (e.g. BASIC, MRIM, COMMS) |
|
JURISDICTION |
VARCHAR2(3) |
|
Area; for application of rules |
|
CREATE_DATE |
DATE |
|
Set by the system with today's date when the change record is created. |
|
EXPIRY_DATE |
DATE |
|
Set by the system (and cannot be changed). |
|
METER_READ_DATE |
DATE |
|
Date of meter reading |
|
|
|