User Manual

6
1.1
3.1 Supported Databases
For the purposes of this specification, the databases in the system
are classified into internal and external databases. Internal databases
are those that will be built into a stand alone Innovatec system. External
(or legacy) databases are those that are supplied by a particular
Innovatec customer or a particular 3
rd
party application. An interface to
an external database may be supplied as part of the customization for a
particular customer, but the information contained in these databases is
not required to run the Innovatec system.
Internal databases are specified in section 4.2.1.
3.1.1 External databases
While it is possible for the set of external databases to be
composed, in principle, of anything or nothing, we anticipate that the
external databases will typically consist of the following for each utility.
Database Record Type Item Comment
Billing Basic
account
information
• Account number
• Customer name
• Customer address
Meter
information
for a
customer
• Account number
• Meter type
• Meter name
May be
multiple
records for
each
customer
Physical Assets Data for each
meter
• Account number
• Meter name
• Meter type
• Meter Model
• Factory number
• Meter brand
• Meter size
• Zone
• Installation date
• Installer
• Installation time
• Location
information
3.2 Multiple database set support
One of the uses of the utility server software will be Innovatec
acting as a service bureau. In order to support this type of operation, the