ADDRESSTYPE

The AddressType table stores information about the type of address associated with a premise. Address types are user-defined. Use this table to group like-addresses together, for example, residential district 5.

Table 40 ADDRESSTYPE

Column name

Column data type

Character length

Description

ACCOUNTID

VARCHAR2

400

A unique identifier for the account; an externally used value

ACCOUNTKEY

RAW

16

A unique primary key for the entity, an internal value

ACCOUNTNUMBER

VARCHAR2

400

The number used in the billing system to represent the account; usually the same as account ID, but may not be unique if two billing systems have accounts with the same number

ACCOUNTPROGRAMKEY

RAW

16

Foreign key to the AccountProgram table from which the Account row was derived

ACCOUNTTYPEKEY

RAW

16

Can be used to distinguish generation, transmission, and so on

APPLICATIONCODEKEY

RAW

16

A unique, customer-defined identifier for the application code

DESCRIPTION

VARCHAR2

400

A text description for this entity

EFFECTIVEENDDATE

TIMESTAMP(0)

7

The end date after which this entity is no longer effective

EFFECTIVESTARTDATE

TIMESTAMP(0)

7

The start date from which this entity is effective

ENTITYSTATUSKEY

RAW

16

A primary key for the entity, an internal value

ISTEMPLATE

NUMBER

22

Used by configuration to differentiate physical objects from configuration template objects

LASTUPDATEDATE

TIMESTAMP(3)

11

The date this entity was last updated

NAICSCODE

VARCHAR2

400

The coding system that replaces the SIC system for classifying industries using the North American Industry Classification System

NODEKEY

RAW

16

A unique key for an object within the IEE database; used internally for linking objects together

REVENUECLASSKEY

RAW

16

The identifier for the revenue class: residential, commercial, and so on

SICCODE

VARCHAR2

400

A
4-digit code to categorize and define business activities using the Standard Industrial Classifications

STRATUM

VARCHAR2

400

An optional classification of accounts; often used in load research

Column name

Column data type

Character length

Description

ADDRESSTYPEID

VARCHAR2

400

A unique identifier for an address type

ADDRESSTYPEKEY

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

A text description for this entity.

ISSYSTEM

NUMBER

22

Indicates if this is a system value delivered with the database

The ADDRESSTYPE table references the following tables:

and is referenced by:

ADDRESS(ADDRESSTYPEKEY) -> (ADDRESSTYPEKEY)