CONFIGGROUP

The ConfigGroup table defines a static or dynamic configuration group to support the IEE advanced groups functionality.

Table 110 CONFIGGROUP

Column name

Column data type

Character length

Description

CONFIGGROUPID

VARCHAR2

400

A text ID entered by the user

CONFIGGROUPKEY

RAW

16

A unique primary key for the entity, an internal value

DATASOURCE

NUMBER

22

0 = User data. Data created by IEE users. User data is not modified during an upgrade
1 = Static data. Data installed with IEE that cannot be overwritten. This data is crucial to the correct operation of IEE. Update, insert, or delete static data during an upgrade
2 = Default data. Data installed with IEE that can be overwritten. Default data is not updated or deleted during an upgrade. However, you can add new default data during an upgrade

DESCRIPTION

VARCHAR2

400

An optional, extended user-defined description

EFFECTIVEDATE

TIMESTAMP(0)

7

Records the date and time this group was created

GROUPTYPE

NUMBER

22

Indicates whether it is a Report or a Filter group. Report groups are used in reports, exports, and so forth. Filter groups are used in CommonFilter control. GroupType - 0 (Report group) GroupType - 1 (Filter group)

ISDEFAULT

NUMBER

22

Indicates default group. In CommonFilter control, the default group is initially selected when the control is loaded. The valid values are as follows:
0 - false
1 - true

ISSHARED

NUMBER

22

Indicates shared group. In CommonFilter control, if a group is shared, it is visible and can be used by all users. Otherwise it is only visible to the user that created it. The valid values are as follows:
0 - false
1 - true

ISSTATIC

NUMBER

22

Identifies this group as static or dynamic. A static group is a fixed list of entities of a given type that the user chooses at the time the group is defined. A dynamic group is based on criteria that may affect group membership over time. Static - 1 Dynamic - 0

ITRONIDENTITYKEY

RAW

16

Identifies the owner of this group

LASTCOUNT

NUMBER

22

Estimates the size of the group when last counted

NODEKEY

RAW

16

The NodeKey corresponding to the configuration group

NODETYPEKEY

RAW

16

The type of node that this group collects; may be a service point, meter, customer or account

The CONFIGGROUP table references the following tables:

ITRONIDENTITYKEY -> ITRONIDENTITY(ITRONIDENTITYKEY)

NODEKEY -> NODE(NODEKEY)

NODETYPEKEY -> NODETYPE(NODETYPEKEY)

and is referenced by:

ADEREQUEST(CONFIGGROUPKEY) -> (CONFIGGROUPKEY)

CONFIGGROUPPARAMETER(CONFIGGROUPKEY) -> (CONFIGGROUPKEY)