Table: PMS_GROUPNMI

PMS_GROUPNMI

Name

PMS_GROUPNMI

Comment

Describe the NMIs that a group uses to provide its service


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

GROUPNMIID


Index Columns

Name

GROUPID

NMI


Content

Name

Data Type

Mandatory

Comment

GROUPNMIID

NUMBER(20,0)

X

Record Identifier of the NMI within a Group. When data is updated, existing record identifier is terminated, and new record identifier(s) are allocated.

GROUPID

NUMBER(20,0)

 

Group id of the Group which the NMI belongs in.

VERSIONFROM

TIMESTAMP(3)

 

Date for which this version is effective from

VERSIONTO

TIMESTAMP(3)

 

Date for which this version is effective to. Will be set to current day plus one if it is the current active record or past date if the record has been superseded/ended.

STARTDATE

TIMESTAMP(3)

 

Effective date of when this service started operation

ENDDATE

TIMESTAMP(3)

 

Date for which this version is effective to. Will be set to current day plus one if it is the current active record or past date if the record has been superseded/ended.

NMI

VARCHAR2(20)

 

National Meter Identifier linked to the group.

SITENAME

VARCHAR2(50)

 

Site name

NERRGROUPPREMISES

NUMBER(1,0)

 

Specifies whether NMI is in a NERR aggregated premises (TRUE = 1/FALSE = 0)

BASELINEMETHODOLOGYID

VARCHAR2(50)

 

Baseline methodology to be used for the PoL and Baseline assessment of the NMI

MRC

NUMBER(10,3)

 

Maximum responsive component for the NMI

MRCREASON

VARCHAR2(500)

 

Reason for the MRC

RETAILCUSTOMER

VARCHAR2(50)

 

Retail customer of the NMI

SUSPENDED

NUMBER(1,0)

 

Indicates whether the NMI has been suspended from use. (TRUE = 1/FALSE = 0)

UNAVAILABLE

NUMBER(1,0)

 

Indicates whether the NMI is unavailable for use. (TRUE = 1/FALSE = 0)

APPROVEDDATE

TIMESTAMP(3)

 

Date which this record was approved

LASTCHANGED

TIMESTAMP(3)

 

Date time which record was last changed