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.
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 |
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 |
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)