3 Logical Data Model Dimensions

This chapter describes the logical dimensions and hierarchies of the data model, as shown in Table 3-1. The IETL use dimensions are shown in Table 3-2.

Logical Data Model Dimensions

This sections lists the logical data model dimensions.

Account

Description: Account

Account Hierarchy

Standard Account Hierarchy

Description of dim_account.png follows
Description of the illustration dim_account.png

Account Levels

Table 3-3 shows Account Total: All ACCOUNT is the most aggregate level of the dimension.

Table 3-3 Account Total

Sr. Number Attribute Description

1.

ALL ACCOUNT CODE

Identification for the top level value.


Table 3-4 shows Account Detail: The account tracks the financial interactions of a customer with the utility. It is normally generated by a contract between the utility and customer. One customer may have multiple accounts.

Table 3-4 Account Detail

Sr. Number Attribute Description Sample Value

1.

Account Code

 

2006012514

2.

Account Code1

   

3.

Organization Business Unit Code

   

4.

Account Segment Code

   

5.

Account Type Code

 

Electricity

6.

Accounting Cycle Code

   

7.

Billing Cycle Code

   

8.

Billing Period Code

   

9.

Currency Code

 

USD

10.

Credit Category Code

Code for credit category.

 

11.

Party Code

A code for any person or business that is of interest to the utility.

 

12.

Source System Code

   

13.

Payment Method Type Code

   

14.

Billing Frequency Code

   

15.

Account Role Type Code

 

PRPD

16.

Account Status Type Code

   

17.

Account Status Reason Code

   

18.

Customer Visible Code

The account number visible to the customer.

 

19.

Secondary Currency Code

Secondary currency for this bill info. A/R can be viewed and payments/disputes/adjustments made in the secondary currency, but all impacts are translated to the primary currency for actual A/R tracking. Only euro and EMU currencies are supported as secondary.

 

20.

Billing Status Code

Used to track the billing status of a bill info. Legal values are BILL_ACTIVE - indicates that billing should be provided for the account in a standard (regular) way. This is a default value. BILL_INACTIVE.

 

21.

Billing Status Reason Code

Indicates a reason for changing of BILLING_STATUS.

 

22.

Create Staff

The employee who created the account.

 

23.

Advertising Status

The account setting regarding advertisement, for example, allow SMS marketing, forbid SMS marketing.

 

24.

Account Charge Type

The charge type of the account.

For example: Prepaid, or Postpaid.

25.

Source System Identifier

The identifier in the source system, as specified by source system key (code).

 

26.

Payment Comment

The textual note attached to the payment.

 

27.

Account Description

   

28.

Create Date

 

22-JAN-08

29.

Termination Date

 

21-SEP-08

30.

Account Effective Date

Effective time of modification of this account on an external system. For example, if this account is created by billing system, this date may refer to when this account is activated in CRM system.

 

31.

Initial Activation Date

The date when the account was activated.

 

32.

Last Activate Date

The last time this account is activated.

 

33.

Last Suspend Date

   

34.

Last Reopen Date

   

35.

Group Plan Indicator

   

36.

Multiple Customer Indicator

To indicate this account is used by multiple customers.

 

37.

Payment Days

The default payment due days for invoices.

 

38.

Close Grace Period

Number of days (months) before the account is suspended if the balance is below zero. During this period account may be functional with limitations, like no outgoing calls.

 

39.

Balance Expire Period

Number of days (months) before the account balance expires.

 

40.

Close Period

Number of days (months) before the account is closed (or suspended), if the balance is below zero. Accounts in this state maybe recovered.

 

41.

Close Purge Period

Number of days (months) before the account is closed and purged if the balance is below zero.

 

42.

Warning Balance Level

The balance level bar for warning period. For example, if customer balance is < $5, then customer receive warning messages.

 

43.

Close Balance Level

The balance level below which the customer account may be closed after a period.

 

44.

Effective From Date

   

45.

Effective To Date

   

46.

Status Code

 

A

47.

Account Name

   

48.

In Platform Code

Id for IN platform.

 

Customer

Description: Customer

Customer Hierarchy

Standard Customer Hierarchy Description of dim_customer.png follows
Description of the illustration dim_customer.png

Customer Levels

Table 3-5 shows Customer Total: All CUSTOMER is the most aggregate level of the dimension.

Table 3-5 Customer Total

Sr. Number Attribute Description

1.

ALL CUSTOMER CODE

Identification for the top level value.


Table 3-6 shows Customer Detail: All the customers, including individual and organization customers. A customer is generally defined as a party using one or more services from the operator.

Table 3-6 Customer Detail

Sr. Number Attribute Description Sample Value

1.

Customer Code

 

CUST-10561

2.

Customer Kind Code

Kind of customer.

 

3.

Customer Score Code

   

4.

Customer Segment Code

   

5.

Customer Source Code

   

6.

Customer Type Code

 

Commercial

7.

External Organization Type Code

   

8.

Language Code

   

9.

Prospect Code

   

10.

Status Code

   

11.

Planned Outage Code

   

12.

Address Location Code

   

13.

Job Code

Code for job of subscriber.

 

14.

Household Code

   

15.

Customer Revenue Band Code

   

16.

Nationality Code

Code for nationality of subscriber.

 

17.

Education Code

Code for educational qualification of subscriber.

 

18.

Other Individual Code

   

19.

SOC Job Code

   

20.

Marital Status Code

Code for marital status of subscriber.

 

21.

Gender Code

Code for gender.

 

22.

Billing Address Location Code

The address where the billing is sent to.

 

23.

Chairman Code

   

24.

Party Organization Type Code

   

25.

Death Certificate Code

   

26.

Manager Code

   

27.

Campaign Partner Code

The campaign partner code if this customer at the same time is also a campaign partner.

 

28.

Sales Volume Code

   

29.

Contact Code

   

30.

Referral Customer Code

Some commission or loyalty program depends on this information to calculate the bonus.

 

31.

Company Registry Number

   

32.

Driver License Number

   

33.

DUNS Number

The data universal numbering system code, as from D&B.

 

34.

Employer Tax Number

The tax number of the employer from tax authority.

 

35.

Prev Employer Tax Number

   

36.

Social Security Number

Social security number for individual customer.

 

37.

Job Contract Type

   

38.

Tax Exempt Status

   

39.

Tax Number

Tax number of the party, for both individual and organizational.

 

40.

Initiative Number

The initiative code as defined in initiative entity. For example, when a person register himself on the operator`s website, he becomes an initiative. Later on, once he places the order, he becomes the customer. In the customer table, imitative number track.

 

41.

Primary Occasion Name

Default customer occasion type name. For example, the marriage anniversary.

 

42.

Primary Status Code

Unique identifier for the primary Status.

 

43.

Primary Status Name

Default Status Name.

 

44.

Primary Status Reason Code

Unique identifier for the primary Status Reason.

 

45.

Primary Status Reason Name

Name of the primary status reason.

 

46.

Seal Image

The image files of customer signature, or stamp.

 

47.

Manager Name

   

48.

Contact Name

   

49.

Stock Exchange Name

   

50.

Name Prefix

   

51.

Name Suffix

   

52.

First Name

 

Sydney

53.

Last Name

 

Kerry

54.

Middle Name

   

55.

Family Name In Maiden

   

56.

Given Name In Maiden

   

57.

Name Of Workplace

   

58.

Place Of Birth

   

59.

Job Position

 

Financial Analyst

60.

Legal Title To Housing

   

61.

Ethnic Background

   

62.

Number Of Children

   

63.

Number Of Dependents

   

64.

Dwelling Tenure

 

28

65.

Dwelling Size

 

33290

66.

Ethnicity

   

67.

Form Of Employment

   

68.

Dwelling Type

 

LEASED

69.

Dwelling Status

   

70.

Office Tel No

This is the office number, and more contact information can be found in _party contact information_.

 

71.

Cell Phone No

The cell phone number, and more contact information can be found in _party contact information_.

9985010563

72.

Personal Identification Number

   

73.

Source Of Income

 

BUSINESS INCOME

74.

Payment Account Number

Account number for payments. Deprecated: This one is only used for backward compatibility.

 

75.

PUC Number

(if applicable) Public utility commission (PUC) identification number.

 

76.

Special Need

True if customer organization has special service needs such as life support, hospitals, and so on.

 

77.

Living At Current Address Since

   

78.

End Of Job Contract

   

79.

Start Of Employment

   

80.

Prev Employment Start Date

   

81.

Prev Employment End Date

   

82.

Final Settlement Start Date

The start date of the period when this customer lives in the last known area.

 

83.

Final Settlement End Date

The end date of the period when this customer lives in the last known area.

 

84.

Date Of Birth

The birthday of the customer, for individual customers.

13-MAR-87

85.

Establishment Date

Time of establish for organizational customer.

 

86.

Termination Date

The natural termination date of organizational and individual customer.

 

87.

Validation Start Date

The business license validation period start date.

 

88.

Validation End Date

The business license validation period end date.

 

89.

Liquidation Start Date

The start date of liquidation process.

 

90.

Liquidation End Date

The end date of liquidation process.

 

91.

Contact Address Effective Date

Date on which the contact address referenced in the billing_address_id column became active. This facilitates queries such as ``find customers who changed address in the last 3 months``.

 

92.

Billing Address Effective Date

Date on which the billing address referenced in the billing_address_id column became active. This facilitates queries such as ``find customers who changed address in the last 3 months``.

 

93.

Payment Account Open Date

Opening date of the first account with valid payment information. Deprecated: This one is only used for backward compatibility.

 

94.

Payment Account Close Date

Closing date of the first account with valid payment information. Deprecated: This one is only used for backward compatibility.

 

95.

Create Date

The date when this customer record is created. This can be same as first account create date, or first contract setup date.

 

96.

Economically Active Indicator

 

N

97.

Public Indicator

To indicate this is public listed company (listed and traded in stock exchange market).

 

98.

Domestic Indicator

To indicate this is a domestic company (compared with overseas, or those from other country).

N

99.

Campaign Partner Indicator

To indicate this is a campaign partner.

 

100.

Mail Allowed Indicator

Indicates if marketing information can be sent to the customer.

Y

101.

Third Party Marketing Allowed Indicator

Specifies whether to allow third party to do marketing to the customer.

N

102.

Customer Payment Responsible Indicator

Indicate if this customer is responsible for payment of a customer organization or household.

 

103.

VIP

True if this is an important customer. Importance is for matters different than those in `SpecialNeed` attribute.

 

104.

Employee Count

   

105.

Annual Revenue

 

139146011

106.

Annual Revenue Local

   

107.

Annual Revenue Reporting

   

108.

Annual Sales

 

246140617

109.

Annual Sales Local

   

110.

Annual Sales Reporting

   

111.

Equity Amount

 

659037373

112.

Equity Amount Local

   

113.

Equity Amount Reporting

   

114.

Effective From Date

   

115.

Effective To Date

   

116.

ARPU Band Code

   

117.

Churn Date

In porting in/out case, customer churn can be detected in real time. In some prepaid business, operator may only know customer churn after 6 months or even longer. In the later one, the churn date will be different with customer effective to date.

 

118.

Customer Importance Rank

Integer that gives the relative importance of this customer with respect to others.

 

119.

Party Role Code

   

120.

Number Of Lines

Number of phone lines belonging to this customer.

 

121.

Primary Line Number

Default fixed line number.

 

122.

Primary MSISDN Number

Default subscriber number.

 

123.

Religious Affiliation Code

   

124.

Demand Response Program Code

   

Feeder

Description: Feeder

Feeder Hierarchy

Standard Feeder Hierarchy

Description of dim_feeder.png follows
Description of the illustration dim_feeder.png

Feeder Levels

Table 3-7 shows Feeder Total: All FEEDER is the most aggregate level of the dimension.

Table 3-7 Feeder Total

Sr. Number Attribute Description

1.

ALL FEEDER CODE

Identification for the top level value.


Table 3-8 shows Feeder Detail: Shows Feeder Detail: Substation feeder.

Table 3-8 Feeder Detail

Sr. Number Attribute Description Sample Value

1.

Feeder Code

 

FDR-0001

2.

Feeder Name

 

FDR-0001

3.

Feeder Description

 

FDR-0001


Geography Zone

Description: Geography Entity

Geography Zone Hierarchy

Standard Geography Zone Hierarchy

Description of dim_geo_zone.png follows
Description of the illustration dim_geo_zone.png

Geography Zone Levels

Table 3-9 shows Geography Zone All States: All States Geography Zone is the most aggregate level of the dimension.

Table 3-9 Geography Zone All States

Sr. Number Attribute Description

1.

All States

 

Table 3-10 shows State: State level in Geography hierarchy.

Table 3-10 Geography Zone: State

Sr. Number Attribute Description Sample Value

1.

Geography State Code

 

NJ

2.

Geography Country Code

   

3.

Geography State Name

 

New Jersey

4.

Geography State Description

   

5.

Effective From Date

   

6.

Effective To Date

   

7.

Status Code

   

Table 3-11 shows City: City level in Geography hierarchy.

Table 3-11 Geography Zone: City

Sr. Number Attribute Description Sample Value

1.

Geography City Code

 

San Francisco

2.

Geography State Code

   

3.

Geography City Name

 

San Francisco

4.

Geography City Description

 

San Francisco

5.

Effective From Date

   

6.

Effective To Date

   

7.

Status Code

   

Table 3-12 shows Usage Point: Logical or physical point in the network to which readings or events may be attributed. Used at the place where a physical or virtual meter may be located; however, it is not required that a meter be present.

Table 3-12 Geography Zone Usage Point

Sr. Number Attribute Description Sample Value

1.

Usage Point Code

 

UP-1240

2.

Phase Code

Phases carried, if applicable.

A

3.

AMI Billing Ready Kind Code

Tracks the lifecycle of the metering installation at a usage point with respect to readiness for billing through advanced metering infrastructure reads.

2

4.

Usage Point Connected Kind Code

State of the usage point with respect to connection to the network.

connected

5.

Account Code

   

6.

Usage Point Location Code

   

7.

Service Category Code

   

8.

Service Location Code

   

9.

Minimal Usage Expected

If true, minimal or zero usage is expected at this usage point for situations such as premise vacancy, logical or physical disconnect. It is used for readings validation and estimation.

 

10.

Is SDP

If true, this usage point is a service delivery point, that is, a usage point where the ownership of the service changes hands.

 

11.

Is Virtual

If true, this usage point is virtual, that is, no physical location exists in the network where a meter could be located to collect the meter readings. For example, one may define a virtual usage point to serve as an aggregation of usage for all of a company.

 

12.

Grounded

True if grounded.

 

13.

Check Billing

True if as a result of an inspection or otherwise, there is a reason to suspect that a previous billing may have been performed with erroneous data. Value should be reset once this potential discrepancy has been resolved.

 

14.

Service Priority

Priority of service for this usage point. Note that usage points at the same service location can have different priorities.

MEDIUM

15.

Service Delivery Remark

Remarks about this usage point, for example the reason for it being rated with a non-nominal priority.

 

16.

Outage Region

Outage region in which this usage point is located.

 

17.

Facility Level

 

XFM-A148

18.

Estimated Load KW

Estimated load.

9

19.

Rated Current

The maximum continuous current carrying capacity in amps governed by the device material and construction.

220

20.

Nominal Service Voltage

Nominal service voltage.

120

21.

Rated Power KVA

Active power that this usage point is configured to deliver.

26

22.

Rated Power

Active power that this usage point is configured to deliver.

23.76


Hour

Description: Hour

Hour Hierarchy

Standard Hour Hierarchy

Description of dim_hour.png follows
Description of the illustration dim_hour.png

Hour Levels

Table 3-13 shows Hour Total: Total Hours.

Table 3-13 Hour Total

Sr. Number Attribute Description

1.

Total Hours

 

Table 3-14 shows Hour: This table contains information at the hour level.

Table 3-14 Hour Detail

Sr. Number Attribute Description Sample Value

1.

Hour Code

 

1

2.

Hour Number

 

1

3.

Hour Description

 

01:00 - 01:59 AM


Household

Description: Household

Household Hierarchy

Standard Household Hierarchy

Description of dim_houshold.png follows
Description of the illustration dim_houshold.png

Household Levels

Table 3-15 shows Household Total: All HOUSEHOLD is the most aggregate level of the dimension.

Table 3-15 Household Total

Sr. Number Attribute Description

1.

ALL HOUSEHOLD CODE

Identification for the top level value.


Table 3-16 shows Household Detail: Captures household information which the individual customer may belong to. Operator may recognize household by customer's shared address and then generate this data according to the customer's demographic value.

Table 3-16 Household Detail

Sr. Number Attribute Description Sample Value

1.

Household Code

Unique identifier for house hold.

HH1

2.

Dwelling Type

Type of dwelling.

 

3.

Composition Group

Composition of the group.

 

4.

Income Group

Income of the group.

BELOWMIDDLECLASS

5.

Dwelling Status

Status of dwelling.

 

6.

Household Size

Size of a house hold.

 

7.

Dwelling Size

Size of the dwelling.

 

8.

Dwelling Tenure

Length of stay at present location.

 

9.

Number Of Children

Number of children in house.

3

10.

Number Of Teens

Number of teens in house.

3

11.

Number Of Adults

Number of adults in house.

2

12.

Number Of Seniors

Number of seniors in house.

1

13.

Number Of Persons

Number of persons sharing the customer`s household.

9

14.

Number Of Earners

Number of wage earners in the household.

1


Manufacturer

Description: Manufacturer

Manufacturer Hierarchy

Standard Manufacturer Hierarchy

Description of dim_manufacturer.png follows
Description of the illustration dim_manufacturer.png

Manufacturer Levels

Table 3-17 shows Manufacturer Total: All MANUFACTURER is the most aggregate level of the dimension.

Table 3-17 Manufacturer Total

Sr. Number Attribute Description

1.

ALL MANUFACTURER CODE

Identification for the top level value.


Table 3-18 shows Manufacturer Detail: Organization that manufactures asset products.

Table 3-18 Manufacturer Detail

Sr. Number Attribute Description Sample Value

1.

Manufacturer Code

 

MNFCTR1


Meter

Description: Meter

Meter Hierarchy

Standard Meter Hierarchy

Description of dim_meter.png follows
Description of the illustration dim_meter.png

Meter Levels

Table 3-19 shows Meter Total: All METER is the most aggregate level of the dimension.

Table 3-19 Meter Total

Sr. Number Attribute Description

1.

ALL METER CODE

Identification for the top level value.


Table 3-20 shows Meter Detail: Physical asset that performs the metering role of the usage point. Used for measuring consumption and detection of events.

Table 3-20 Meter Detail

Sr. Number Attribute Description Sample Value

1.

Meter Code

 

M-220-2153

2.

Form Number

Meter form designation per ANSI C12.10 or other applicable standard. An alphanumeric designation denoting the circuit arrangement for which the meter is applicable and its specific terminal arrangement.

 

Operational

Description: Operational

Operational Hierarchy

Standard Operational Hierarchy

Description of dim_operational.png follows
Description of the illustration dim_operational.png

Operational Levels

Table 3-21 shows Total: aggregate level of the dimension.

Table 3-21 Operational Total

Sr. Number Attribute Description

1.

Total

Code for All Access Method


Table 3-22 shows Operational Substation: A collection of equipment for purposes other than generation or utilization, through which electric energy in bulk is passed for the purposes of switching or modifying its characteristics.

Table 3-22 Operational Substation

Sr. Number Attribute Description Sample Value

1.

Substation Code

 

SUB-001


Table 3-23 shows Operational Feeder: Feeder level of the dimension. Stores the Operational Information.

Table 3-23 Operational Feeder

Sr. Number Attribute Description Sample Value

1.

Feeder Code

 

FDR-0001

2.

Feeder Name

 

FDR-0001

3.

Feeder Description

 

FDR-0001


Table 3-23 shows Operational Transformer Tank: An assembly of two or more coupled windings that transform electrical power between voltage levels. These windings are bound on a common core and place in the same tank. Transformer tank can be used to model both single-phase and 3-phase transformers.

Table 3-24 Operational Transformer Tank

Sr. Number Attribute Description Sample Value

1.

Transformer Tank Code

 

XFM-001

2.

Power Transformer Code

   

Table 3-23 shows Operational Usage Point: Logical or physical point in the network to which readings or events may be attributed. Used at the place where a physical or virtual meter may be located; however, it is not required that a meter be present.

Table 3-25 Operational Usage Point

Sr. Number Attribute Description Sample Value

1.

Usage Point Code

UP-1240

 

2.

Phase Code

Phases carried, if applicable.

A

3.

AMI Billing Ready Kind Code

Tracks the lifecycle of the metering installation at a usage point with respect to readiness for billing through advanced metering infrastructure reads.

2

4.

Usage Point Connected Kind Code

State of the usage point with respect to connection to the network.

connected

5.

Account Code

   

6.

Usage Point Location Code

   

7.

Service Category Code

   

8.

Service Location Code

   

9.

Minimal Usage Expected

If true, minimal or zero usage is expected at this usage point for situations such as premise vacancy, logical or physical disconnect. It is used for readings validation and estimation.

 

10.

Is SDP

If true, this usage point is a service delivery point, that is, a usage point where the ownership of the service changes hands.

 

11.

Is Virtual

If true, this usage point is virtual, that is, no physical location exists in the network where a meter could be located to collect the meter readings. For example, one may define a virtual usage point to serve as an aggregation of usage for all of a company.

 

12.

Grounded

True if grounded.

 

13.

Check Billing

True if as a result of an inspection or otherwise, there is a reason to suspect that a previous billing may have been performed with erroneous data. Value should be reset once this potential discrepancy has been resolved.

 

14.

Service Priority

Priority of service for this usage point. Note that usage points at the same service location can have different priorities.

MEDIUM

15.

Service Delivery Remark

Remarks about this usage point, for example the reason for it being rated with a non-nominal priority.

 

16.

Outage Region

Outage region in which this usage point is located.

 

17.

Facility Level

XFM-A148

 

18.

Estimated Load KW

Estimated load.

9

19.

Rated Current

The maximum continuous current carrying capacity in amps governed by the device material and construction.

220

20.

Nominal Service Voltage

Nominal service voltage.

120

21.

Rated Power KVA

Active power that this usage point is configured to deliver.

26

22.

Rated Power

Active power that this usage point is configured to deliver.

23.76


Organization

Description: Organization Business Entity

Organization Hierarchy

Standard Organization Hierarchy

Description of dim_organizational.png follows
Description of the illustration dim_organizational.png

Organization Levels

Table 3-26 shows Organization Total: All Organization is the most aggregate level of the dimension.

Table 3-26 Organization Total

Sr. Number Attribute Description

1.

ALL ORGANIZATION CODE

Identification for the top level value.


Table 3-27 shows Organization Detail: A business unit of the organization that delivers a limited range of specific services through any sales channel. Examples could be retail or distribution.

Table 3-27 Organization Business Unit Detail

Sr. Number Attribute Description Sample Value

1.

Organization Business Unit Code

Unique identifier for business unit. To identify whether the site is a store, distribution center or warehouse.

SUD1BU1

2.

Organization Business Unit Type Code

   

3.

Address Location Code

   

4.

Organization District Code

   

5.

Organization Banner Code

   

6.

Organization Business Entity Code

   

7.

Organization Role Code

   

8.

Channel Type Code

   

9.

Organizational Demography Value Code

   

10.

Chairman Code

   

11.

Address Type Code

Unique identifier of the address type.

 

12.

Postcode

Postal codes of interest to the retail organization.

 

13.

Postal Plus Code

Four digit extension to the United States postal zip code.

 

14.

Location Type Code

Unique identifier for location type.

 

15.

Primary Trade Area Code

Primary trade area code, under which the business unit falls.

 

16.

Contact Type Code

This is the general method to use to contact a site.

For example: Phone, Fax, Telex, and so on.

17.

Primary Market Area Code

Market area code under which the business unit falls.

 

18.

Account Clerk Code

Person managing the accounts of the cost center. This field is client specific. The definition and use of this field is customizable for each client.

 

19.

Organization Code

The unique identifier of the organization.

 

20.

Primary Currency ISO Code

The unique ISO standard identifier of the currency.

 

21.

Primary Business Unit Calendar Code

Default Site calendar code.

 

22.

Organization Division Code

   

23.

Judicial Distraint Code

Case identifier of the judicial distraint.

 

24.

Contact Code

The identifier of the contact person.

 

25.

Court Code

Code of the law of court.

 

26.

Manager Code

Identifier of manager, as one individual party.

 

27.

Company Registry Number

The registration number, according to the local authority.

 

28.

DUNS Number

   

29.

Manager Employee Number

Unique key denoting the employee number of the employee`s manager.

 

30.

Payment Account Number

   

31.

Contact Number

This is the number for the method specified to contact this site. There can be more than one number of each type for each site.

 

32.

Time Zone

It denotes which time zone the site is in.

 

33.

Shopping Center Type

Shopping center is group of retail and other commercial establishments that is planned, developed, owned, and managed as a single property.

- Strip Center (Neighborhood, Community)

- Mall (Power, Super Regional, Regional, Fashion/Sp

 

34.

Short Description

The 3 character abbreviation of the store name.

Business Unit 1

35.

Long Description

The 10 character abbreviation of the store name.

Business Unit 1

36.

Secondary Description

The secondary description or name of the store or warehouse.

 

37.

Address Line1

Line one of the detail postal addresses.

 

38.

Address Line2

Line 2 of the detailed postal address.

 

39.

Address Line3

Line 3 of the detailed postal address.

 

40.

Address Usage

Describes how the address is used.

 

41.

Primary Address Telephone

Default addresses telephone number.

 

42.

Primary Email Address

Default Email Address.

 

43.

Construction Status

Identifies the status of the site such as `Under Construction`, `New`, and so on.

 

44.

Tax Exempt Status

   

45.

Contact Name

   

46.

External Name

Name/Number assigned to site for electronic communication.

For example: EDI transactions;

47.

Manager Name

   

48.

Stock Exchange Name

   

49.

Business Unit Concept

Possible values include,

Convenience, General Merchandise, Category dominant anchors with few small tenants, Fashion, Higher-end (Upscale), Fashion oriented, Manufacturer`s Outlet, Leisure, Tourist oriented and Discount.

 

50.

Total Linear Distance

The total linear selling space of the location.

 

51.

Vat Region

The number of the value added tax region in which this store or warehouse is contained.

 

52.

Seal Image

   

53.

Liquidation Start Date

   

54.

Termination Date

Termination date of the company in case of company was founded with termination date.

 

55.

Liquidation End Date

   

56.

Bankruptcy Start Date

   

57.

Bankruptcy End Date

   

58.

Final Settlement Start Date

   

59.

Final Settlement End Date

   

60.

Payment Account Open Date

Opening date of the account for payments.

 

61.

Payment Account Close Date

Closing date of the account for payments.

 

62.

Judicial Distraint Date

Date of the judicial distraint.

 

63.

Validation Start Date

Date of the registration of the company` record deletion from the company register.

 

64.

Validation End Date

Effective date of the deletion of the company`s record from the company register.

 

65.

Vat Include Indicator

Indicates whether value added tax will be included in the retail prices for the store.

Valid values are `Y` or `N`.

66.

Domestic Indicator

Whether this organization is operated in a foreign country.

 

67.

Employee Count

   

68.

Equity Amount

   

69.

Equity Amount Local

   

70.

Equity Amount Reporting

   

71.

Annual Revenue

   

72.

Annual Revenue Local

   

73.

Annual Revenue Reporting

   

74.

Annual Sales

   

75.

Annual Sales Local

   

76.

Annual Sales Reporting

   

77.

Organization Name

Name of the organization.

 

78.

Party Type Code

   

Outage Record

Description: Outage Record

Outage Record Hierarchy

Standard Outage Record Hierarchy

Description of dim_outagerecord.png follows
Description of the illustration dim_outagerecord.png

Outage Record Levels

Table 3-28 shows Outage Record Total: All Outage Record is the most aggregate level of the dimension.

Table 3-28 Outage Record Total

Sr. Number Attribute Description

1.

ALL OUTAGE RECORD CODE

Identification for the top level value.


Table 3-29 shows Outage Record Detail: Document describing details of an outage in part of the electrical network, typically produced by a SCADA system following a breaker trip, or within a trouble call system by grouping customer calls. It has an associated outage step for each supply point. Primary cause of the outage is captured in 'type'. In some countries all outage restoration is performed using a switching schedule which complements the outage record and records the crew and any planned work. In other systems, it may be acceptable to manage outages including new work tasks without switching schedules. Note: The relationship between Outage Record and Erp Person and Crew is inherited as each is a type of Document.

Table 3-29 Outage Record Detail

Sr. Number Attribute Description Sample Value

1.

Outage Record Code

 

19901

2.

Outage Report Code

   

3.

Damage Code

The damage code relative to the associated power system resource(s).

Examples include broken, burnout, failure, flashed (burned), manually operated, wire down, no damage - rolling blackout, none.

4.

Action Taken

Overall action taken to resolve outage (details are in work tasks).

 

5.

Mode

Value of Erporganization.mode at the time of `startDateTime`.

 

Postcode

Description: Postcode

Postcode Hierarchy

Standard Postcode Hierarchy

Description of dim_postcode.png follows
Description of the illustration dim_postcode.png

Postcode Levels

Table 3-30 shows Postcode Total: All Postcode is the most aggregate level of the dimension.

Table 3-30 Postcode Total

Sr. Number Attribute Description

1.

ALL POSTCODE CODE

Identification for the top level value.


Table 3-31 shows Postcode Detail: Postal Code, Zip Code, or similar geographical designation.

Table 3-31 Postcode Detail

Sr. Number Attribute Description Sample Value

1.

Postcode Code

 

PC1

2.

Address Location Code

   

3.

ISO Country Code

   

4.

Postcode Value

 

PC1

5.

Postcode Description

   

6.

Disease Hazard Indicator

   

7.

Earthquake Hazard Indicator

   

8.

Environmental Hazard Indicator

   

9.

Flood Hazard Indicator

   

10.

Hazardous Weather Area Indicator

   

11.

Hurricane Hazard Indicator

   

12.

Other Hazard Indicator

   

13.

Radon Hazard Indicator

   

14.

Storm Hazard Indicator

   

15.

Tornado Hazard Indicator

   

16.

Effective From Date

   

17.

Effective To Date

   

18.

Status Code

   

Product Asset Model

Description: Product Asset Model

Product Asset Model Hierarchy

Standard Product Asset Model Hierarchy

Description of dim_productassetmodel.png follows
Description of the illustration dim_productassetmodel.png

Product Asset Model Levels

Table 3-32 shows Product Asset Model Total: All Product Asset Model is the most aggregate level of the dimension.

Table 3-32 Product Asset Model Total

Sr. Number Attribute Description

1.

ALL PRODUCT ASSET MODEL

Identification for the top level value.


Table 3-33 shows Product Asset Model Detail: Asset model by a specific manufacturer.

Table 3-33 Product Asset Model Detail

Sr. Number Attribute Description Sample Value

1.

Product Asset Model Code

 

PROD1

2.

Unit Symbol Code

   

3.

Unit Multiplier Code

   

4.

Corporate Standard Kind Code

Kind of corporate standard for this asset model.

 

5.

Asset Model Usage Kind Code

Intended usage for this asset model.

 

6.

Manufacturer Code

   

7.

Model Number

Version number for product model, which indicates vintage of the product.

 

8.

Model Version

   

9.

Weight Total Weight Value

The value to supervise.

 

Region

Description: Geography Region

Region Hierarchy

Standard Region Hierarchy

Description of dim_region.png follows
Description of the illustration dim_region.png

Region Levels

Table 3-34 shows Region All Regions:

Table 3-34 Region All Regions

Sr. Number Attribute Description

1.

All Regions

 

Table 3-35 shows Region. Region level in Geography hierarchy.

Table 3-35 Region Region

Sr. Number Attribute Description Sample Value

1.

Geography Region Code

 

1

2.

Geography World Code

   

3.

Geography Region Name

 

RGN-1

4.

Geography Region Description

 

RGN-1

5.

Effective From Date

   

6.

Effective To Date

   

7.

Status Code

   

Table 3-36 shows Region Sub Region: Sub region level in Geography hierarchy.

Table 3-36 Region Sub Region

Sr. Number Attribute Description Sample Value

1.

Geography Sub Region Code

 

1

2.

Geography Region Code

   

3.

Geography Sub Region Name

 

SB-RGN-1

4.

Geography Sub Region Description

 

SB-RGN-1

5.

Effective From Date

   

6.

Effective To Date

   

7.

Status Code

   

Table 3-36 shows Usage Point: Logical or physical point in the network to which readings or events may be attributed. Used at the place where a physical or virtual meter may be located; however, it is not required that a meter be present.

Table 3-37 Region Usage Point

Sr. Number Attribute Description Sample Value

1.

Usage Point Code

 

UP-1240

2.

Phase Code

Phases carried, if applicable.

A

3.

AMI Billing Ready Kind Code

Tracks the lifecycle of the metering installation at a usage point with respect to readiness for billing through advanced metering infrastructure reads.

2

4.

Usage Point Connected Kind Code

State of the usage point with respect to connection to the network.

connected

5.

Account Code

   

6.

Usage Point Location Code

   

7.

Service Category Code

   

8.

Service Location Code

   

9.

Minimal Usage Expected

If true, minimal or zero usage is expected at this usage point for situations such as premise vacancy, logical or physical disconnect. It is used for readings validation and estimation.

 

10.

Is SDP

If true, this usage point is a service delivery point, that is, a usage point where the ownership of the service changes hands.

 

11.

Is Virtual

If true, this usage point is virtual, that is, no physical location exists in the network where a meter could be located to collect the meter readings. For example, one may define a virtual usage point to serve as an aggregation of usage for all of a company.

 

12.

Grounded

True if grounded.

 

13.

Check Billing

True if as a result of an inspection or otherwise, there is a reason to suspect that a previous billing may have been performed with erroneous data. Value should be reset once this potential discrepancy has been resolved.

 

14.

Service Priority

Priority of service for this usage point. Note that usage points at the same service location can have different priorities.

MEDIUM

15.

Service Delivery Remark

Remarks about this usage point, for example the reason for it being rated with a non-nominal priority.

 

16.

Outage Region

Outage region in which this usage point is located.

 

17.

Facility Level

 

XFM-A148

18.

Estimated Load KW

Estimated load.

9

19.

Rated Current

The maximum continuous current carrying capacity in amps governed by the device material and construction.

220

20.

Nominal Service Voltage

Nominal service voltage.

120

21.

Rated Power KVA

Active power that this usage point is configured to deliver.

26

22.

Rated Power

Active power that this usage point is configured to deliver.

23.76


Service Location

Description: Service Location

Service Location Hierarchy

Standard Service Location Hierarchy

Description of dim_servicel.png follows
Description of the illustration dim_servicel.png

Service Location Levels

Table 3-38 shows Service Location Total: All Service Location is the most aggregate level of the dimension.

Table 3-38 Service Location Total

Sr. Number Attribute Description

1.

ALL SERVICE LOCATION

Identification for the top level value.


Table 3-39 shows Service Location Detail: A real estate location commonly referred to as premise.

Table 3-39 Service Location Detail

Sr. Number Attribute Description Sample Value

1.

Service Location Code

 

SLC-2001434

2.

Access Method

Method for the service person to access this usage point location. For example, a description of where to obtain a key if the facility is unmanned and secured.

 

3.

Site Access Problem

Problems previously encountered when visiting or performing work on this location.

Examples include: bad dog, violent customer, verbally abusive occupant, obstructions, safety hazards, and so on.

4.

Needs Inspection

True if inspection is needed of facilities at this service location. This could be requested by a customer, due to suspected tampering, environmental concerns (for example: a fire in the vicinity), or to correct incompatible data.

 

Substation

Description: Substation

Substation Hierarchy

Standard Substation Hierarchy

Description of dim_substation.png follows
Description of the illustration dim_substation.png

Substation Levels

Table 3-40 shows Substation Total: All Substation is the most aggregate level of the dimension.

Table 3-40 Substation Total

Sr. Number Attribute Description

1.

ALL SUBSTATION

Identification for the top level value.


Table 3-41 shows Substation Detail: A collection of equipment for purposes other than generation or utilization, through which electric energy in bulk is passed for the purposes of switching or modifying its characteristics.

Table 3-41 Substation Detail

Sr. Number Attribute Description Sample Value

1.

Substation Code

 

SUB-001


Time

Description: Time

Time Hierarchy

Standard Time Hierarchy

Description of dim_ttime.png follows
Description of the illustration dim_ttime.png

Time Levels

Table 3-42 shows Time Total: .

Table 3-42 Time TTime

Sr. Number Attribute Description

1.

TTime

 

Table 3-43 shows Year: It captures information relating to a year in a Normal Calendar.

Table 3-43 Time Year

Sr. Number Attribute Description Sample Value

1.

Calendar Year Code

 

20000101

2.

Calendar Name

 

CALENDAR

3.

Calendar Year Description

 

CY 2000

4.

Calendar Year End Date

 

31-DEC-00

5.

Calendar Year Number

 

1

6.

Calendar Year Start Date

 

01-JAN-00

7.

Calendar Year Timespan

 

366


Table 3-44 shows Quarter: Captures information relating to a quarter in a Normal Calendar.

Table 3-44 Time Quarter

Sr. Number Attribute Description Sample Value

1.

Calendar Quarter Code

 

20000101

2.

Calendar Half Year Start Day Code

   

3.

Calendar Quarter Description

 

CY 2000 Q1

4.

Calendar Quarter End Date

 

31-MAR-00

5.

Calendar Quarter Number

 

1

6.

Calendar Quarter Start Date

 

01-JAN-00

7.

Calendar Quarter Timespan

 

91

8.

Calendar Year Start Day Code

   

Table 3-44 shows Month: Captures information relating to a month in a Normal Calendar.

Table 3-45 Time Month

Sr. Number Attribute Description Sample Value

1.

Calendar Month Code

Unique warehouse key of the month, in the calendar.

20000101

2.

Calendar Quarter Code

 

20000101

3.

Calendar Year Start Day Code

   

4.

Calendar Half Year Start Day Code

   

5.

Calendar Quarter Start Day Code

   

6.

Calendar Month Number

A numeric representation of the month number in the calendar. It ranges from 1 to 12.

1

7.

Calendar Month Description

 

Jan 2000

8.

Calendar Month Timespan

The length, in terms of days, of this month in the calendar.

31

9.

Calendar Month Start Date

 

01-JAN-00

10.

Calendar Month End Date

 

31-JAN-00


Table 3-44 shows Day: Calendar day in the day dimension.

Table 3-46 Time Day

Sr. Number Attribute Description Sample Value

1.

Day Code

The unique identifier for a calendar date.

 

2.

Calendar Week Day Code

   

3.

Calendar Week Day

 

SAT

4.

Calendar Week Day Description

 

SATURDAY

5.

Calendar Julian Day

 

2451825

6.

Calendar Day Timespan

 

1

7.

Calendar Day Of Year

 

281

8.

Calendar Working Day Indicator

 

N

9.

Calendar Holiday Indicator

 

Y

10.

Calendar Weekend Indicator

 

Y

11.

Calendar Date

Represents a calendar date.

07-OCT-00

12.

Calendar Date Description

A description of the calendar date.

20001007

13.

Calendar Start Date

Start date of calendar.

07-OCT-00

14.

Calendar End Date

End date of calendar.

07-OCT-00

15.

Calendar Load Date

 

28-JUN-13

16.

Calendar Last Update Date

 

28-JUN-13

17.

Calendar Last Update By

 

OUDM_UPD

18.

Calendar Current Indicator

 

Y

19.

Calendar Week Number

 

40

20.

Calendar Week Description

 

CY 2000 W40

21.

Calendar Week Start Date

 

02-OCT-00

22.

Calendar Week End Date

 

08-OCT-00

23.

Calendar Week Timespan

 

7

24.

Calendar Half Month Number

 

19

25.

Calendar Half Month Description

 

Oct 2000 HM1

26.

Calendar Half Month Start Date

 

01-OCT-00

27.

Calendar Half Month End Date

 

15-OCT-00

28.

Calendar Half Month Timespan

 

15

29.

Calendar Month Number

 

10

30.

Calendar Month Description

 

Oct 2000

31.

Calendar Month Start Date

 

01-OCT-00

32.

Calendar Month End Date

 

31-OCT-00

33.

Calendar Month Timespan

 

31

34.

Calendar Quarter Code

 

20001001

35.

Calendar Quarter Number

 

4

36.

Calendar Quarter Description

 

CY 2000 Q4

37.

Calendar Quarter Start Date

 

01-OCT-00

38.

Calendar Quarter End Date

 

31-DEC-00

39.

Calendar Quarter Timespan

 

92

40.

Calendar Half Year Code

 

20000701

41.

Calendar Half Year Number

 

2

42.

Calendar Half Year Description

 

CY 2000 HY2

43.

Calendar Half Year Start Date

 

01-JUL-00

44.

Calendar Half Year End Date

 

31-DEC-00

45.

Calendar Half Year Timespan

 

184

46.

Calendar Year Code

 

20000101

47.

Calendar Year Number

 

1

48.

Calendar Year Description

 

CY 2000

49.

Calendar Year Start Date

 

01-JAN-00

50.

Calendar Year End Date

 

31-DEC-00

51.

Calendar Year Timespan

 

366

52.

Calendar Month Start Day Code

   

53.

Calendar Quarter Start Day Code

   

54.

Calendar Year Start Day Code

   

55.

Calendar Week Start Day Code

   

56.

Calendar Half Month Start Day Code

   

57.

Calendar Half Year Start Day Code

   

58.

Business Day Code

   

59.

Business Week Day Code

   

60.

Business Week Day

   

61.

Business Week Day Description

   

62.

Business Julian Day

   

63.

Business Day Timespan

   

64.

Business Day Of Year

   

65.

Business Working Day Indicator

   

66.

Business Holiday Indicator

   

67.

Business Weekend Indicator

   

68.

Business Date

   

69.

Business Date Description

   

70.

Business Start Date

   

71.

Business End Date

   

72.

Business Load Date

   

73.

Business Last Update Date

   

74.

Business Last Update By

   

75.

Business Current Indicator

   

76.

Business Week Number

   

77.

Business Week Description

   

78.

Business Week Start Date

   

79.

Business Week End Date

   

80.

Business Week Timespan

   

81.

Business Half Month Code

   

82.

Business Half Month Number

   

83.

Business Half Month Description

   

84.

Business Half Month Start Date

   

85.

Business Half Month End Date

   

86.

Business Half Month Timespan

   

87.

Business Month Code

   

88.

Business Month Number

   

89.

Business Month Description

   

90.

Business Month Start Date

   

91.

Business Month End Date

   

92.

Business Month Timespan

   

93.

Business Quarter Code

   

94.

Business Quarter Number

   

95.

Business Quarter Description

   

96.

Business Quarter Start Date

   

97.

Business Quarter End Date

   

98.

Business Quarter Timespan

   

99.

Business Half Year Code

   

100.

Business Half Year Number

   

101.

Business Half Year Description

   

102.

Business Half Year Start Date

   

103.

Business Half Year End Date

   

104.

Business Half Year Timespan

   

105.

Business Year Code

   

106.

Business Year Number

   

107.

Business Year Description

   

108.

Business Year Start Date

   

109.

Business Year End Date

   

110.

Business Year Timespan

   

111.

Business Month Start Day Code

   

112.

Business Quarter Start Day Code

   

113.

Business Year Start Day Code

   

114.

Business Week Start Day Code

   

115.

Business Half Month Start Day Code

   

116.

Business Half Year Start Day Code

   

117.

Business Week Code

   

118.

Calendar Week Code

 

20001002

119.

Calendar Month Code

 

20001001


Time Month Day Hour

Description: Calendar Year

Time Month Hour Hierarchy

Standard Time Month Hour Hierarchy

Description of dim_time_mdh.png follows
Description of the illustration dim_time_mdh.png

Time Month Hour Levels

Table 3-47 shows Time Month Hour Time.

Table 3-47 Time Month Hour Time

Sr. Number Attribute Description

1.

Time

 

Table 3-48 shows Time Month Hour Year: It captures information relating to a year in a Normal Calendar.

Table 3-48 Time Month Hour Year

Sr. Number Attribute Description Sample Value

1.

Calendar Year Code

 

20000101

2.

Calendar Name

 

CALENDAR

3.

Calendar Year Description

 

CY 2000

4.

Calendar Year End Date

 

31-DEC-00

5.

Calendar Year Number

 

1

6.

Calendar Year Start Date

 

01-JAN-00

7.

Calendar Year Timespan

 

366


Table 3-49 shows Time Month Hour Month: Detail level of the dimension. Stores the Time Month Hour Information.

Table 3-49 Time Month Hour Month

Sr. Number Attribute Description Sample Value

1.

Calendar Month Code

Unique warehouse key of the month, in the calendar.

20000101

2.

Calendar Quarter Code

 

20000101

3.

Calendar Year Start Day Code

   

4.

Calendar Half Year Start Day Code

   

5.

Calendar Quarter Start Day Code

   

6.

Calendar Month Number

A numeric representation of the month number in the calendar. It ranges from 1 to 12.

1

7.

Calendar Month Description

Jan 2000

 

8.

Calendar Month Timespan

The length, in terms of days, of this month in the calendar. For example: 30 days

31

9.

Calendar Month Start Date

 

01-JAN-00

10.

Calendar Month End Date

 

31-JAN-00


Table 3-50 shows Time Month Hour Day: Calendar day in the day dimension.

Table 3-50 Time Month Hour Day

Sr. Number Attribute Description Sample Value

1.

Day Code

The unique identifier for a calendar date.

 

2.

Calendar Week Day Code

   

3.

Calendar Week Day

 

SAT

4.

Calendar Week Day Description

 

SATURDAY

5.

Calendar Julian Day

 

2451825

6.

Calendar Day Timespan

 

1

7.

Calendar Day Of Year

 

281

8.

Calendar Working Day Indicator

 

N

9.

Calendar Holiday Indicator

 

Y

10.

Calendar Weekend Indicator

 

Y

11.

Calendar Date

Represents a calendar date.

07-OCT-00

12.

Calendar Date Description

A description of the calendar date.

20001007

13.

Calendar Start Date

Start date of calendar.

07-OCT-00

14.

Calendar End Date

End date of calendar.

07-OCT-00

15.

Calendar Load Date

 

28-JUN-13

16.

Calendar Last Update Date

 

28-JUN-13

17.

Calendar Last Update By

 

OUDM_UPD

18.

Calendar Current Indicator

 

Y

19.

Calendar Week Number

 

40

20.

Calendar Week Description

 

CY 2000 W40

21.

Calendar Week Start Date

 

02-OCT-00

22.

Calendar Week End Date

 

08-OCT-00

23.

Calendar Week Timespan

 

7

24.

Calendar Half Month Number

 

19

25.

Calendar Half Month Description

 

Oct 2000 HM1

26.

Calendar Half Month Start Date

 

01-OCT-00

27.

Calendar Half Month End Date

 

15-OCT-00

28.

Calendar Half Month Timespan

 

15

29.

Calendar Month Number

 

10

30.

Calendar Month Description

 

Oct 2000

31.

Calendar Month Start Date

 

01-OCT-00

32.

Calendar Month End Date

 

31-OCT-00

33.

Calendar Month Timespan

 

31

34.

Calendar Quarter Code

 

20001001

35.

Calendar Quarter Number

 

4

36.

Calendar Quarter Description

 

CY 2000 Q4

37.

Calendar Quarter Start Date

 

01-OCT-00

38.

Calendar Quarter End Date

 

31-DEC-00

39.

Calendar Quarter Timespan

 

92

40.

Calendar Half Year Code

 

20000701

41.

Calendar Half Year Number

 

2

42.

Calendar Half Year Description

 

CY 2000 HY2

43.

Calendar Half Year Start Date

 

01-JUL-00

44.

Calendar Half Year End Date

 

31-DEC-00

45.

Calendar Half Year Timespan

 

184

46.

Calendar Year Code

 

20000101

47.

Calendar Year Number

 

1

48.

Calendar Year Description

 

CY 2000

49.

Calendar Year Start Date

 

01-JAN-00

50.

Calendar Year End Date

 

31-DEC-00

51.

Calendar Year Timespan

 

366

52.

Calendar Month Start Day Code

   

53.

Calendar Quarter Start Day Code

   

54.

Calendar Year Start Day Code

   

55.

Calendar Week Start Day Code

   

56.

Calendar Half Month Start Day Code

   

57.

Calendar Half Year Start Day Code

   

58.

Business Day Code

   

59.

Business Week Day Code

   

60.

Business Week Day

   

61.

Business Week Day Description

   

62.

Business Julian Day

   

63.

Business Day Timespan

   

64.

Business Day Of Year

   

65.

Business Working Day Indicator

   

66.

Business Holiday Indicator

   

67.

Business Weekend Indicator

   

68.

Business Date

   

69.

Business Date Description

   

70.

Business Start Date

   

71.

Business End Date

   

72.

Business Load Date

   

73.

Business Last Update Date

   

74.

Business Last Update By

   

75.

Business Current Indicator

   

76.

Business Week Number

   

77.

Business Week Description

   

78.

Business Week Start Date

   

79.

Business Week End Date

   

80.

Business Week Timespan

   

81.

Business Half Month Code

   

82.

Business Half Month Number

   

83.

Business Half Month Description

   

84.

Business Half Month Start Date

   

85.

Business Half Month End Date

   

86.

Business Half Month Timespan

   

87.

Business Month Code

   

88.

Business Month Number

   

89.

Business Month Description

   

90.

Business Month Start Date

   

91.

Business Month End Date

   

92.

Business Month Timespan

   

93.

Business Quarter Code

   

94.

Business Quarter Number

   

95.

Business Quarter Description

   

96.

Business Quarter Start Date

   

97.

Business Quarter End Date

   

98.

Business Quarter Timespan

   

99.

Business Half Year Code

   

100.

Business Half Year Number

   

101.

Business Half Year Description

   

102.

Business Half Year Start Date

   

103.

Business Half Year End Date

   

104.

Business Half Year Timespan

   

105.

Business Year Code

   

106.

Business Year Number

   

107.

Business Year Description

   

108.

Business Year Start Date

   

109.

Business Year End Date

   

110.

Business Year Timespan

   

111.

Business Month Start Day Code

   

112.

Business Quarter Start Day Code

   

113.

Business Year Start Day Code

   

114.

Business Week Start Day Code

   

115.

Business Half Month Start Day Code

   

116.

Business Half Year Start Day Code

   

117.

Business Week Code

   

118.

Calendar Week Code

 

20001002

119.

Calendar Month Code

 

20001001


Time Month

Description: Calendar Year

Time Month Hierarchy

Standard Time Month Hierarchy

Description of dim_time_m.png follows
Description of the illustration dim_time_m.png

Time Month Levels

Table 3-51 shows Time Month Total Time.

Table 3-51 Time Month Total Time

Sr. Number Attribute Description

1.

Total Time

 

Table 3-52 shows Time Month TM-Year: It captures information relating to a year in a Normal Calendar.

Table 3-52 Time Month TM Year

Sr. Number Attribute Description Sample Value

1.

Calendar Year Code

 

20000101

2.

Calendar Name

 

CALENDAR

3.

Calendar Year Description

 

CY 2000

4.

Calendar Year End Date

 

31-DEC-00

5.

Calendar Year Number

 

1

6.

Calendar Year Start Date

 

01-JAN-00

7.

Calendar Year Timespan

 

366


Table 3-53 shows Time Month Month. Captures information relating to a month in a Normal Calendar.

Table 3-53 Time Month TM-Month

Sr. Number Attribute Description Sample Value

1.

Calendar Month Code

Unique warehouse key of the month, in the calendar.

20000101

2.

Calendar Quarter Code

 

20000101

3.

Calendar Year Start Day Code

   

4.

Calendar Half Year Start Day Code

   

5.

Calendar Quarter Start Day Code

   

6.

Calendar Month Number

A numeric representation of the month number in the calendar. It ranges from 1 to 12.

1

7.

Calendar Month Description

 

Jan 2000

8.

Calendar Month Timespan

The length, in terms of days, of this month in the calendar. For example: 30 days

31

9.

Calendar Month Start Date

 

01-JAN-00

10.

Calendar Month End Date

 

31-JAN-00


Time Month Hour

Description: Calendar Year

Time Month Hour Hierarchy

Standard Time Month Hour Hierarchy

Description of dim_time_mh.png follows
Description of the illustration dim_time_mh.png

Time Month Hour Levels

Table 3-54 shows Time Month Hour Total Time Hour.

Table 3-54 Time Month Hour Total Time Hour

Sr. Number Attribute Description

1.

Total Time Hour

 

Table 3-55 shows Time Month Hour TMH-Year: It captures information relating to a year in a Normal Calendar.

Table 3-55 Time Month Hour TMH-Year

Sr. Number Attribute Description Sample Value

1.

Calendar Year Code

 

20000101

2.

Calendar Name

 

CALENDAR

3.

Calendar Year Description

 

CY 2000

4.

Calendar Year End Date

 

31-DEC-00

5.

Calendar Year Number

 

1

6.

Calendar Year Start Date

 

01-JAN-00

7.

Calendar Year Timespan

 

366


Table 3-56 shows Time Month Hour TMH-Month: Captures information relating to a month in a Normal Calendar.

Table 3-56 Time Month Hour TMH-Month

Sr. Number Attribute Description Sample Value

1.

Calendar Month Code

Unique warehouse key of the month, in the calendar.

20000101

2.

Calendar Quarter Code

 

20000101

3.

Calendar Year Start Day Code

   

4.

Calendar Half Year Start Day Code

   

5.

Calendar Quarter Start Day Code

   

6.

Calendar Month Number

A numeric representation of the month number in the calendar. It ranges from 1 to 12.

1

7.

Calendar Month Description

 

Jan 2000

8.

Calendar Month Timespan

The length, in terms of days, of this month in the calendar. For example: 30 days

31

9.

Calendar Month Start Date

 

01-JAN-00

10.

Calendar Month End Date

 

31-JAN-00


TOU

Description: Time Of Use

Time Of Use Hierarchy

Standard Time Of Use Hierarchy

Description of dim_tou.png follows
Description of the illustration dim_tou.png

Time Of Use Levels

Table 3-57 shows TOU: Time of Use.

Table 3-57 Time Of Use Total Time

Sr. Number Attribute Description

1.

Total

 

Table 3-58 shows Time Of Use.

Table 3-58 Time Of Use

Sr. Number Attribute Description Sample Value

1.

Time Of Use Code

 

1

2.

Code

 

1

3.

Value

 

OnPeak

4.

Description

 

On peak time of use

5.

Comment

 

On peak


TOU Time

Description: TOU Time

TOU Time Hierarchy

Standard TOU Time Hierarchy

Description of dim_tou_time.png follows
Description of the illustration dim_tou_time.png

TOU Time Levels

Table 3-59 shows TOU Time Total.

Table 3-59 TOU Time Total

Sr. Number Attribute Description

1.

Total

 

Table 3-60 shows TOU-Year: It captures information relating to a year in a Normal Calendar.

Table 3-60 TOU Time TOU-Year

Sr. Number Attribute Description Sample Value

1.

Calendar Year Code

 

20000101

2.

Calendar Name

 

CALENDAR

3.

Calendar Year Description

 

CY 2000

4.

Calendar Year End Date

 

31-DEC-00

5.

Calendar Year Number

 

1

6.

Calendar Year Start Date

 

01-JAN-00

7.

Calendar Year Timespan

 

366


Table 3-61 shows TOU-Quarter: Captures information relating to a quarter in a Normal Calendar.

Table 3-61 TOU Time TOU-Quarter

Sr. Number Attribute Description Sample Value

1.

Calendar Quarter Code

 

20000101

2.

Calendar Half Year Start Day Code

   

3.

Calendar Quarter Description

 

CY 2000 Q1

4.

Calendar Quarter End Date

 

31-MAR-00

5.

Calendar Quarter Number

 

1

6.

Calendar Quarter Start Date

 

01-JAN-00

7.

Calendar Quarter Timespan

 

91

8.

Calendar Year Start Day Code

 

20000101


Table 3-62 shows TOU-Month: Captures information relating to a month in a Normal Calendar.

Table 3-62 TOU Time TOU-Month

Sr. Number Attribute Description Sample Value

1.

Calendar Month Code

Unique warehouse key of the month, in the calendar.

20000101

2.

Calendar Quarter Code

 

20000101

3.

Calendar Year Start Day Code

   

4.

Calendar Half Year Start Day Code

   

5.

Calendar Quarter Start Day Code

   

6.

Calendar Month Number

A numeric representation of the month number in the calendar. It ranges from 1 to 12.

1

7.

Calendar Month Description

 

Jan 2000

8.

Calendar Month Timespan

The length, in terms of days, of this month in the calendar.

31

9.

Calendar Month Start Date

 

01-JAN-00

10.

Calendar Month End Date

 

31-JAN-00


Table 3-63 shows TOU-Day: Calendar day in the day dimension.

Table 3-63 TOU Time TOU-Day

Sr. Number Attribute Description Sample Value

1.

Day Code

The unique identifier for a calendar date.

 

2.

Calendar Week Day Code

   

3.

Calendar Week Day

 

SAT

4.

Calendar Week Day Description

 

SATURDAY

5.

Calendar Julian Day

 

2451825

6.

Calendar Day Timespan

 

1

7.

Calendar Day Of Year

 

281

8.

Calendar Working Day Indicator

 

N

9.

Calendar Holiday Indicator

 

Y

10.

Calendar Weekend Indicator

 

Y

11.

Calendar Date

Represents a calendar date.

07-OCT-00

12.

Calendar Date Description

A description of the calendar date.

20001007

13.

Calendar Start Date

Start date of calendar.

07-OCT-00

14.

Calendar End Date

End date of calendar.

07-OCT-00

15.

Calendar Load Date

 

28-JUN-13

16.

Calendar Last Update Date

 

28-JUN-13

17.

Calendar Last Update By

 

OUDM_UPD

18.

Calendar Current Indicator

 

Y

19.

Calendar Week Number

 

40

20.

Calendar Week Description

 

CY 2000 W40

21.

Calendar Week Start Date

 

02-OCT-00

22.

Calendar Week End Date

 

08-OCT-00

23.

Calendar Week Timespan

 

7

24.

Calendar Half Month Number

 

19

25.

Calendar Half Month Description

 

Oct 2000 HM1

26.

Calendar Half Month Start Date

 

01-OCT-00

27.

Calendar Half Month End Date

 

15-OCT-00

28.

Calendar Half Month Timespan

 

15

29.

Calendar Month Number

 

10

30.

Calendar Month Description

 

Oct 2000

31.

Calendar Month Start Date

 

01-OCT-00

32.

Calendar Month End Date

 

31-OCT-00

33.

Calendar Month Timespan

 

31

34.

Calendar Quarter Code

 

20001001

35.

Calendar Quarter Number

 

4

36.

Calendar Quarter Description

 

CY 2000 Q4

37.

Calendar Quarter Start Date

 

01-OCT-00

38.

Calendar Quarter End Date

 

31-DEC-00

39.

Calendar Quarter Timespan

 

92

40.

Calendar Half Year Code

 

20000701

41.

Calendar Half Year Number

 

2

42.

Calendar Half Year Description

 

CY 2000 HY2

43.

Calendar Half Year Start Date

 

01-JUL-00

44.

Calendar Half Year End Date

 

31-DEC-00

45.

Calendar Half Year Timespan

 

184

46.

Calendar Year Code

 

20000101

47.

Calendar Year Number

 

1

48.

Calendar Year Description

 

CY 2000

49.

Calendar Year Start Date

 

01-JAN-00

50.

Calendar Year End Date

 

31-DEC-00

51.

Calendar Year Timespan

 

366

52.

Calendar Month Start Day Code

   

53.

Calendar Quarter Start Day Code

   

54.

Calendar Year Start Day Code

   

55.

Calendar Week Start Day Code

   

56.

Calendar Half Month Start Day Code

   

57.

Calendar Half Year Start Day Code

   

58.

Business Day Code

   

59.

Business Week Day Code

   

60.

Business Week Day

   

61.

Business Week Day Description

   

62.

Business Julian Day

   

63.

Business Day Timespan

   

64.

Business Day Of Year

   

65.

Business Working Day Indicator

   

66.

Business Holiday Indicator

   

67.

Business Weekend Indicator

   

68.

Business Date

   

69.

Business Date Description

   

70.

Business Start Date

   

71.

Business End Date

   

72.

Business Load Date

   

73.

Business Last Update Date

   

74.

Business Last Update By

   

75.

Business Current Indicator

   

76.

Business Week Number

   

77.

Business Week Description

   

78.

Business Week Start Date

   

79.

Business Week End Date

   

80.

Business Week Timespan

   

81.

Business Half Month Code

   

82.

Business Half Month Number

   

83.

Business Half Month Description

   

84.

Business Half Month Start Date

   

85.

Business Half Month End Date

   

86.

Business Half Month Timespan

   

87.

Business Month Code

   

88.

Business Month Number

   

89.

Business Month Description

   

90.

Business Month Start Date

   

91.

Business Month End Date

   

92.

Business Month Timespan

   

93.

Business Quarter Code

   

94.

Business Quarter Number

   

95.

Business Quarter Description

   

96.

Business Quarter Start Date

   

97.

Business Quarter End Date

   

98.

Business Quarter Timespan

   

99.

Business Half Year Code

   

100.

Business Half Year Number

   

101.

Business Half Year Description

   

102.

Business Half Year Start Date

   

103.

Business Half Year End Date

   

104.

Business Half Year Timespan

   

105.

Business Year Code

   

106.

Business Year Number

   

107.

Business Year Description

   

108.

Business Year Start Date

   

109.

Business Year End Date

   

110.

Business Year Timespan

   

111.

Business Month Start Day Code

   

112.

Business Quarter Start Day Code

   

113.

Business Year Start Day Code

   

114.

Business Week Start Day Code

   

115.

Business Half Month Start Day Code

   

116.

Business Half Year Start Day Code

   

117.

Business Week Code

   

118.

Calendar Week Code

 

20001002

119.

Calendar Month Code

 

20001001


Time Season Month

Description: Time Season Month

Time Season Month Hierarchy

Standard Time Season Month Hierarchy

Description of dim_time_tsm.png follows
Description of the illustration dim_time_tsm.png

Time Season Month Levels

Table 3-64 shows Time Season Month Total.

Table 3-64 Time Season Month Total

Sr. Number Attribute Description

1.

Total

 

Table 3-65 shows Time Season Month TSM-Year: It captures information relating to a year in a Normal Calendar.

Table 3-65 Time Season Month TSM-Year

Sr. Number Attribute Description Sample Value

1.

Calendar Year Code

 

20000101

2.

Calendar Name

 

CALENDAR

3.

Calendar Year Description

 

CY 2000

4.

Calendar Year End Date

 

31-DEC-00

5.

Calendar Year Number

 

1

6.

Calendar Year Start Date

 

01-JAN-00

7.

Calendar Year Timespan

 

366


Table 3-66 shows Time Season Month TSM-Quarter: Captures information relating to a quarter in a Normal Calendar.

Table 3-66 Time Season Month TSM-Quarter

Sr. Number Attribute Description Sample Value

1.

Calendar Quarter Code

 

20000101

2.

Calendar Half Year Start Day Code

   

3.

Calendar Quarter Description

 

CY 2000 Q1

4.

Calendar Quarter End Date

 

31-MAR-00

5.

Calendar Quarter Number

 

1

6.

Calendar Quarter Start Date

 

01-JAN-00

7.

Calendar Quarter Timespan

 

91

8.

Calendar Year Start Day Code

 

20000101


Table 3-67 shows Time Season Month TSM-Month: Captures information relating to a month in a Normal Calendar.

Table 3-67 Time Season Month TSM-Month

Sr. Number Attribute Description Sample Value

1.

Calendar Month Code

Unique warehouse key of the month, in the calendar.

20000101

2.

Calendar Quarter Code

 

20000101

3.

Calendar Year Start Day Code

   

4.

Calendar Half Year Start Day Code

   

5.

Calendar Quarter Start Day Code

   

6.

Calendar Month Number

A numeric representation of the month number in the calendar. It ranges from 1 to 12.

1

7.

Calendar Month Description

 

Jan 2000

8.

Calendar Month Timespan

The length, in terms of days, of this month in the calendar.

31

9.

Calendar Month Start Date

 

01-JAN-00

10.

Calendar Month End Date

 

31-JAN-00


Time Season Month Hour

Description: Time Season Month Hour

Time Season Month Hour Hierarchy

Standard Time Season Month Hour Hierarchy

Description of dim_time_smh.png follows
Description of the illustration dim_time_smh.png

Time Season Month Hour Levels

Table 3-68 shows Time Season Month Hour TSMH.

Table 3-68 Time Season Month Hour TSMH

Sr. Number Attribute Description

1.

TSMH

 

Table 3-69 shows Time Season Month Hour TSMH-Year: It captures information relating to a year in a Normal Calendar.

Table 3-69 Time Season Month Hour TSMH-Year

Sr. Number Attribute Description Sample Value

1.

Calendar Year Code

 

20000101

2.

Calendar Name

 

CALENDAR

3.

Calendar Year Description

 

CY 2000

4.

Calendar Year End Date

 

31-DEC-00

5.

Calendar Year Number

 

1

6.

Calendar Year Start Date

 

01-JAN-00

7.

Calendar Year Timespan

 

366


Table 3-70 shows Time Season Month Hour TSMH-Quarter: Captures information relating to a quarter in a Normal Calendar.

Table 3-70 Time Season Month Hour TSMH-Quarter

Sr. Number Attribute Description Sample Value

1.

Calendar Quarter Code

 

20000101

2.

Calendar Half Year Start Day Code

   

3.

Calendar Quarter Description

 

CY 2000 Q1

4.

Calendar Quarter End Date

 

31-MAR-00

5.

Calendar Quarter Number

 

1

6.

Calendar Quarter Start Date

 

01-JAN-00

7.

Calendar Quarter Timespan

 

91

8.

Calendar Year Start Day Code

 

20000101


Table 3-71 shows Time Season Month Hour TSMH-Month: Captures information relating to a month in a Normal Calendar.

Table 3-71 Time Season Month Hour TSMH-TSMH-Month

Sr. Number Attribute Description Sample Value

1.

Calendar Month Code

Unique warehouse key of the month, in the calendar.

20000101

2.

Calendar Quarter Code

 

20000101

3.

Calendar Year Start Day Code

   

4.

Calendar Half Year Start Day Code

   

5.

Calendar Quarter Start Day Code

   

6.

Calendar Month Number

A numeric representation of the month number in the calendar. It ranges from 1 to 12.

1

7.

Calendar Month Description

 

Jan 2000

8.

Calendar Month Timespan

The length, in terms of days, of this month in the calendar.

31

9.

Calendar Month Start Date

 

01-JAN-00

10.

Calendar Month End Date

 

31-JAN-00


Table 3-72 shows Time Season Month Hour TSMH-Day: Calendar day in the day dimension.

Table 3-72 Time Season Month Hour TSMH-Day

Sr. Number Attribute Description Sample Value

1.

Day Code

The unique identifier for a calendar date.

 

2.

Calendar Week Day Code

   

3.

Calendar Week Day

 

SAT

4.

Calendar Week Day Description

 

SATURDAY

5.

Calendar Julian Day

 

2451825

6.

Calendar Day Timespan

 

1

7.

Calendar Day Of Year

 

281

8.

Calendar Working Day Indicator

 

N

9.

Calendar Holiday Indicator

 

Y

10.

Calendar Weekend Indicator

 

Y

11.

Calendar Date

Represents a calendar date.

07-OCT-00

12.

Calendar Date Description

A description of the calendar date.

20001007

13.

Calendar Start Date

Start date of calendar.

07-OCT-00

14.

Calendar End Date

End date of calendar.

07-OCT-00

15.

Calendar Load Date

 

28-JUN-13

16.

Calendar Last Update Date

 

28-JUN-13

17.

Calendar Last Update By

 

OUDM_UPD

18.

Calendar Current Indicator

 

Y

19.

Calendar Week Number

 

40

20.

Calendar Week Description

 

CY 2000 W40

21.

Calendar Week Start Date

 

02-OCT-00

22.

Calendar Week End Date

 

08-OCT-00

23.

Calendar Week Timespan

 

7

24.

Calendar Half Month Number

 

19

25.

Calendar Half Month Description

 

Oct 2000 HM1

26.

Calendar Half Month Start Date

 

01-OCT-00

27.

Calendar Half Month End Date

 

15-OCT-00

28.

Calendar Half Month Timespan

 

15

29.

Calendar Month Number

 

10

30.

Calendar Month Description

 

Oct 2000

31.

Calendar Month Start Date

 

01-OCT-00

32.

Calendar Month End Date

 

31-OCT-00

33.

Calendar Month Timespan

 

31

34.

Calendar Quarter Code

 

20001001

35.

Calendar Quarter Number

 

4

36.

Calendar Quarter Description

 

CY 2000 Q4

37.

Calendar Quarter Start Date

 

01-OCT-00

38.

Calendar Quarter End Date

 

31-DEC-00

39.

Calendar Quarter Timespan

 

92

40.

Calendar Half Year Code

 

20000701

41.

Calendar Half Year Number

 

2

42.

Calendar Half Year Description

 

CY 2000 HY2

43.

Calendar Half Year Start Date

 

01-JUL-00

44.

Calendar Half Year End Date

 

31-DEC-00

45.

Calendar Half Year Timespan

 

184

46.

Calendar Year Code

 

20000101

47.

Calendar Year Number

 

1

48.

Calendar Year Description

 

CY 2000

49.

Calendar Year Start Date

 

01-JAN-00

50.

Calendar Year End Date

 

31-DEC-00

51.

Calendar Year Timespan

 

366

52.

Calendar Month Start Day Code

   

53.

Calendar Quarter Start Day Code

   

54.

Calendar Year Start Day Code

   

55.

Calendar Week Start Day Code

   

56.

Calendar Half Month Start Day Code

   

57.

Calendar Half Year Start Day Code

   

58.

Business Day Code

   

59.

Business Week Day Code

   

60.

Business Week Day

   

61.

Business Week Day Description

   

62.

Business Julian Day

   

63.

Business Day Timespan

   

64.

Business Day Of Year

   

65.

Business Working Day Indicator

   

66.

Business Holiday Indicator

   

67.

Business Weekend Indicator

   

68.

Business Date

   

69.

Business Date Description

   

70.

Business Start Date

   

71.

Business End Date

   

72.

Business Load Date

   

73.

Business Last Update Date

   

74.

Business Last Update By

   

75.

Business Current Indicator

   

76.

Business Week Number

   

77.

Business Week Description

   

78.

Business Week Start Date

   

79.

Business Week End Date

   

80.

Business Week Timespan

   

81.

Business Half Month Code

   

82.

Business Half Month Number

   

83.

Business Half Month Description

   

84.

Business Half Month Start Date

   

85.

Business Half Month End Date

   

86.

Business Half Month Timespan

   

87.

Business Month Code

   

88.

Business Month Number

   

89.

Business Month Description

   

90.

Business Month Start Date

   

91.

Business Month End Date

   

92.

Business Month Timespan

   

93.

Business Quarter Code

   

94.

Business Quarter Number

   

95.

Business Quarter Description

   

96.

Business Quarter Start Date

   

97.

Business Quarter End Date

   

98.

Business Quarter Timespan

   

99.

Business Half Year Code

   

100.

Business Half Year Number

   

101.

Business Half Year Description

   

102.

Business Half Year Start Date

   

103.

Business Half Year End Date

   

104.

Business Half Year Timespan

   

105.

Business Year Code

   

106.

Business Year Number

   

107.

Business Year Description

   

108.

Business Year Start Date

   

109.

Business Year End Date

   

110.

Business Year Timespan

   

111.

Business Month Start Day Code

   

112.

Business Quarter Start Day Code

   

113.

Business Year Start Day Code

   

114.

Business Week Start Day Code

   

115.

Business Half Month Start Day Code

   

116.

Business Half Year Start Day Code

   

117.

Business Week Code

   

118.

Calendar Week Code

 

20001002

119.

Calendar Month Code

 

20001001


Transformer

Description: Transformer

Transformer Hierarchy

Standard Transformer Hierarchy

Description of dim_transformer.png follows
Description of the illustration dim_transformer.png

Transformer Levels

Table 3-73 shows Transformer Total: All Transformer is the most aggregate level of the dimension.

Table 3-73 Transformer Total

Sr. Number Attribute Description

1.

ALL TRANSFORMER

Identification for the top level value.


Table 3-74 shows Transformer Detail: An assembly of two or more coupled windings that transform electrical power between voltage levels. These windings are bound on a common core and place in the same tank. Transformer tank can be used to model both single-phase and 3-phase transformers.

Table 3-74 Transformer Detail

Sr. Number Attribute Description Sample Value

1.

Transformer Tank Code

 

XFM-001

2.

Power Transformer Code

   

Usage Point

Description: Usage Point

Usage Point Hierarchy

Standard Usage Point Hierarchy

Description of dim_usagepoint.png follows
Description of the illustration dim_usagepoint.png

Usage Point Levels

Table 3-75 shows Usage Point Total: All Usage Point is the most aggregate level of the dimension.

Table 3-75 Usage Point Total

Sr. Number Attribute Description

1.

ALL USAGE POINT

Identification for the top level value.


Table 3-76 shows Usage Point Detail: Logical or physical point in the network to which readings or events may be attributed. Used at the place where a physical or virtual meter may be located; however, it is not required that a meter be present.

Table 3-76 Usage Point Detail

Sr. Number Attribute Description Sample Value

1.

Usage Point Code

 

UP-1240

2.

Phase Code

Phases carried, if applicable.

A

3.

AMI Billing Ready Kind Code

Tracks the lifecycle of the metering installation at a usage point with respect to readiness for billing through advanced metering infrastructure reads.

2

4.

Usage Point Connected Kind Code

State of the usage point with respect to connection to the network.

connected

5.

Account Code

   

6.

Usage Point Location Code

   

7.

Service Category Code

   

8.

Service Location Code

   

9.

Minimal Usage Expected

If true, minimal or zero usage is expected at this usage point for situations such as premise vacancy, logical or physical disconnect. It is used for readings validation and estimation.

 

10.

Is SDP

If true, this usage point is a service delivery point, that is, a usage point where the ownership of the service changes hands.

 

11.

Is Virtual

If true, this usage point is virtual, that is, no physical location exists in the network where a meter could be located to collect the meter readings. For example, one may define a virtual usage point to serve as an aggregation of usage for all of a company.

 

12.

Grounded

True if grounded.

 

13.

Check Billing

True if as a result of an inspection or otherwise, there is a reason to suspect that a previous billing may have been performed with erroneous data. Value should be reset once this potential discrepancy has been resolved.

 

14.

Service Priority

Priority of service for this usage point. Note that usage points at the same service location can have different priorities.

MEDIUM

15.

Service Delivery Remark

Remarks about this usage point, for example the reason for it being rated with a non-nominal priority.

 

16.

Outage Region

Outage region in which this usage point is located.

 

17.

Facility Level

 

XFM-A148

18.

Estimated Load KW

Estimated load.

9

19.

Rated Current

The maximum continuous current carrying capacity in amps governed by the device material and construction.

220

20.

Nominal Service Voltage

Nominal service voltage.

120

21.

Rated Power KVA

Active power that this usage point is configured to deliver.

26

22.

Rated Power

Active power that this usage point is configured to deliver.

23.76


Usage Point Location

Description: Usage Point Location

Usage Point Location Hierarchy

Standard Usage Point Location Hierarchy

Description of dim_usage_pointloc.png follows
Description of the illustration dim_usage_pointloc.png

Usage Point Location Levels

Table 3-77 shows Usage Point Location Total: All Usage Point Location is the most aggregate level of the dimension.

Table 3-77 Usage Point Location Total

Sr. Number Attribute Description

1.

ALL USAGE POINT LOCATION

Identification for the top level value.


Table 3-78 shows Usage Point Location Detail: Location of an individual usage point.

Table 3-78 Usage Point Location Detail

Sr. Number Attribute Description Sample Value

1.

Usage Point Location Code

 

SLC-1266

2.

Access Method

Method for the service person to access this usage point location. For example, a description of where to obtain a key if the facility is unmanned and secured.

 

3.

Site Access Problem

Problems previously encountered when visiting or performing work on this location.

Examples include: bad dog, violent customer, verbally abusive occupant, obstructions, safety hazards, and so on.

4.

Remark

Remarks about this location.

 

IETL Use Dimensions

Address Location

Description: Address Location

Address Location Hierarchy

Standard Address Location Hierarchy

Description of dim_address_locationt.png follows
Description of the illustration dim_address_locationt.png

Address Location Levels

Table 3-79 shows Address Location Total: All ADDRESS LOCATION is the most aggregate level of the dimension.

Table 3-79 Address Location Total

Sr. Number Attribute Description

1.

ALL ADDRESS LOCATION

Identification for the top level value.


Table 3-80 Shows Address Location Detail: Keep all address. It has levels as country, state, city, address and so on.

Table 3-80 Address Location Detail

Sr. Number Attribute Description Sample Value

1.

Address Location Code

Unique identifier for the address.

5170

2.

Address Location Code1

   

3.

Geography Entity Code

   

4.

Postcode Code

   

5.

Tax Authority Code

   

6.

Geography Location Code

Applicable unique geography ID.

 

7.

Postal Plus Code

Four digit extension to the united states postal ZIP code.

 

8.

Elevation UOM Code

   

9.

Post Office Box

PO box if available.

 

10.

Post Office Box Type

   

11.

Address Name

   

12.

Address Description

Address description. Textual description of the address.

 

13.

Address Line1

Address line one of detailed postal address.

Room 2457

14.

Address Line2

Address lines two of detailed postal address.

YIU YAT HOUSE TIN YIU ESTATE

15.

Address Line3

Address lines three of detailed postal address.

TIN SHUI WAI NT

16.

Address Line4

   

17.

Address Style

Address style to specify the format of the address.

For example, USA, australia, japan, and so on.

18.

Address Lines Phonetic

Phonetic or kana representation of the kanji address lines (used in japan, or china).

 

19.

Primary Address Telephone

   

20.

Geography World Code

   

21.

World Name

   

22.

World Description

One value ``All`` shall be populated, which will be used in analytical applications.

 

23.

Geography Region Code

   

24.

Region Name

 

HK

25.

Region Description

 

HK

26.

Geography Sub Region Code

   

27.

Sub region Name

   

28.

Sub region Description

   

29.

Geography State Code

   

30.

State Name

 

Hong Kong

31.

State Description

 

Hong Kong

32.

Geography Country Code

   

33.

Country Name

 

China

34.

Country Description

 

China

35.

Geography County Code

   

36.

County Name

   

37.

County Description

   

38.

Geography City Code

   

39.

City Name

 

Hong Kong

40.

City Description

 

Hong Kong

41.

Geography Street Code

   

42.

Street Name

 

TIN SHUI WAI NT

43.

Street Description

 

TIN SHUI WAI NT

44.

Geography Building Code

   

45.

Building Name

 

YIU YAT HOUSE TIN YIU ESTATE

46.

Building Description

 

YIU YAT HOUSE TIN YIU ESTATE

47.

Flat Room Code

   

48.

Flat Room Name

   

49.

Flat Room Description

   

50.

Floor Code

   

51.

Floor Name

   

52.

Floor Description

   

53.

Elevation

Elevation of the geographic location.

 

54.

Primary Email Address

   

55.

Longitude

The angular distance between a point on any meridian and the prime meridian at Greenwich.

 

56.

Latitude

   

57.

Accuracy

Accuracy of longitude and latitude.

 

58.

Source System Identifier

The identifier in the source system, as specified by source system key (code).

 

59.

Address Longitude Measure

Address longitude measure is the unit of measure of longitude.

 

60.

Address Latitude Measure

The unit of measure of latitude.

 

61.

Effective From Date

   

62.

Effective To Date

   

63.

Status Code

   

64.

Address Type Code

   

65.

Employee Code

   

66.

Source System Code

   

67.

Time Zone Code

   

Asset Info

Description: Asset Info

Asset Info Hierarchy

Standard Asset Info Hierarchy

Description of dim_asset_infot.png follows
Description of the illustration dim_asset_infot.png

Asset Info Levels

Table 3-81 shows Asset Info Total: All ASSET INFO is the most aggregate level of the dimension.

Table 3-81 Asset InfoTotal

Sr. Number Attribute Description

1.

ALL ASSET INFO

Identification for the top level value.


Table 3-82 shows Asset Info Detail: Set of attributes of an asset, representing typical data-sheet information of a physical device that can be instantiated and shared in different data exchange contexts:- as attributes of an asset instance (installed or in stock), as attributes of an asset model (product by a manufacturer), as attributes of a type asset (generic type of an asset as used in designs/extension planning).

Table 3-82 Asset Info Detail

Sr. Number Attribute Description Sample Value

1.

Asset Info Code

 

ASST_INFO1

2.

Asset Model Code

   

Demand Response Program

Description: Demand Response Program

Demand Response Program Hierarchy

Standard Demand Response Program Hierarchy

Description of dim_demandrp.png follows
Description of the illustration dim_demandrp.png

Demand Response Program Levels

Table 3-83 shows Demand Response Program Total: All DEMAND RESPONSE PROGRAM is the most aggregate level of the dimension.

Table 3-83 Demand Response Program Total

Sr. Number Attribute Description

1.

ALL DEMAND RESPONSE PROGRAM

Identification for the top level value.


Table 3-84 shows Demand Response Program Detail

Table 3-84 Demand Response Program Detail

Sr. Number Attribute Description Sample Value

1.

Demand Response Program Code

 

1001

2.

Type

Utility-specific classification of this document, according to their corporate standards, practices, and existing IT systems.

SUMMER SAVING

3.

Start Date

 

01-JUL-07

4.

End Date

 

30-SEP-07


Outage Report

Description: Outage Report

Outage Report Hierarchy

Standard Outage Report Hierarchy

Description of dim_outager.png follows
Description of the illustration dim_outager.png

Outage Report Levels

Table 3-85 shows Outage Report Total: All OUTAGE REPORT is the most aggregate level of the dimension.

Table 3-85 Outage Report Total

Sr. Number Attribute Description

1.

ALL OUTAGE REPORT CODE

Identification for the top level value.


Table 3-86 shows Outage Report Detail: Location of an individual usage point.

Table 3-86 Outage Report Detail

Sr. Number Attribute Description Sample Value

1.

Outage Report Code

 

14803

2.

Customer Count

 

8

3.

Outage Duration

Total outage duration.

166

4.

Average CML

Average customer minutes lost (CML) for this point of supply for this outage.

20.75

5.

Total CML

Total customer minutes lost (CML).

1328


Product Offering

Description: Product Offering

Product Offering Hierarchy

Standard Product Offering Hierarchy

Description of dim_product_offering.png follows
Description of the illustration dim_product_offering.png

Product Offering Level

Table 3-87 Product Offering Detail: Defines how a utility service/product is brought to the market.

Table 3-87 Product Offering Total

Sr. Number Attribute Description

1.

ALL PRODUCT OFFERING

Identification for the top level value.


Table 3-88 shows Product Offering Detail: Defines how a utility service/product is brought to the market.

Table 3-88 Product Offering Detail

Sr. Number Attribute Description Sample Value

1.

Product Offering Code

 

PROD_OFR-1

2.

Primary Product Specification Code

   

3.

Product Offering Price List Code

   

4.

Product Offering Type Code

   

5.

Product Offering Price Code

   

6.

Product Offering Name

   

7.

Product Offering Description

   

8.

Remark

   

9.

Service Time UOM

   

10.

Premium Pay Method

   

11.

New Customer Only Indicator

To indicate this market plan is applicable only to new customers and not for old customers.

 

12.

Joint Program Indicator

To indicate that this product market plan is a joint program with another partner.

 

13.

Loyalty Program Indicator

To indicate that this product market plan is available onto to certain loyalty program members.

 

14.

Vas Indicator

   

15.

Gross ARPU

The expected monthly charge to the customer.

 

16.

Gross ARPU Local

   

17.

Gross ARPU Reporting

   

18.

Net ARPU

The revenue from the customer, excluding various cost or revenue sharing.

 

19.

Net ARPU Local

   

20.

Net ARPU Reporting

   

21.

Total Cost Upgrade

   

22.

Total Cost Upgrade Local

   

23.

Total Cost Upgrade Reporting

   

24.

Prepay Amount

How much prepayment must be made.

 

25.

Prepay Amount Local

   

26.

Prepay Amount Reporting

   

27.

Initial Deposit Amount

   

28.

Initial Deposit Amount Local

   

29.

Initial Deposit Amount Reporting

   

30.

Premium Pay Amount

Customer has to pay a certain amount to get premium.

 

31.

Premium Pay Amount Local

   

32.

Premium Pay Amount Reporting

   

33.

Discount Amount

The discount amount allowed on this product market plan.

 

34.

Discount Amount Local

   

35.

Discount Amount Reporting

   

36.

Expected Total Cost

   

37.

Expected Total Cost Local

   

38.

Expected Total Cost Reporting

   

39.

Expected Total Revenue

   

40.

Expected Total Revenue Local

   

41.

Expected Total Revenue Reporting

   

42.

Early Departure Penalty

The penalty amount if the customer decides to terminate the contract before the expected date.

 

43.

Early Departure Penalty Local

   

44.

Early Departure Penalty Reporting

   

45.

Service Time Unit Charge

   

46.

Service Time Unit Charge Local

   

47.

Service Time Unit Charge Reporting

   

48.

Effective From Date

   

49.

Effective To Date

   

50.

Status Code

   

Reading Type

Description: Reading Type

Reading Type Hierarchy

Standard Reading Type Hierarchy

Description of dim_reading_type.png follows
Description of the illustration dim_reading_type.png

Reading Type Levels

Table 3-89 shows Reading Type Total: All READING TYPE is the most aggregate level of the dimension.

Table 3-89 Reading Type Total

Sr. Number Attribute Description

1.

ALL READING TYPE

Identification for the top level value.


Table 3-90 shows Reading Type Detail: Detailed description for a type of a reading value.

Table 3-90 Reading Type Detail

Sr. Number Attribute Description Sample Value

1.

Reading Type Code

 

0.0.0.1.1.1.12.0.0.0.0.0.0.0.0.3.72.0

2.

Consumption Tier Code

   

3.

Critical Peak Period Code

   

4.

Currency Code

   

5.

Energy Flow Direction Code

   

6.

Interharmonics Code

   

7.

Measurement Kind Code

   

8.

Phase Code

   

9.

Reading Accumulation Behavior Code

   

10.

Reading Data Qualifier Code

   

11.

Reading Time Attribute Code

   

12.

Reading Time Period Code

   

13.

Time Of Use Code

   

14.

Unit Multiplier Code

   

15.

Unit Of Measure Code

   

16.

Utility Commodity Code

   

17.

Rational Number Code

   

18.

Reading Channel Code

   

19.

Macro Period

Time period of interest that reflects how the reading is viewed or captured over a long period of time.

 

20.

Aggregate

Salient attribute of the reading data aggregated from individual endpoints. This is mainly used to define a mathematical operation carried out over `macroPeriod`, but may also be used to describe an attribute of the data when the `macroPeriod` is not defined.

 

21.

Measuring Period

Time attribute inherent or fundamental to the reading value (as opposed to `macroPeriod` that supplies an adjective to describe aspects of a time period with regard to the measurement).

 

22.

Accumulation

Accumulation behavior of a reading over time, usually `measuringPeriod`, to be used with individual endpoints (as opposed to `macroPeriod` and `aggregate` that are used to describe aggregations of data from individual endpoints).

 

23.

Flow Direction

Flow direction for a reading where the direction of flow of the commodity is important (for electricity measurements this includes current, energy, power, and demand).

 

24.

Commodity

Commodity being measured.

 

25.

Measurement Kind

Identifies what is being measured, as refinement of `commodity`. When combined with `unit`, it provides detail to the unit of measure. For example, `energy` with a unit of measure of `kWh` indicates to the user that active energy is being measured.

 

26.

Interharmonic

Indication of a harmonic or interharmonic basis for the measurement. Value 0 in `numerator` and `denominator` means not applicable.

 

27.

Argument

Argument used to introduce numbers into the unit of measure description where they are needed (for example, 4 where the measure needs an argument such as CEMI(n=4)). Most arguments used in practice however will be integers (that is, `denominator`=1).

Value 0 in `nu

 

28.

Phases

Metering-specific phase code.

 

29.

Multiplier

Metering-specific multiplier.

 

30.

Unit

Metering-specific unit.

 

31.

Currency

Metering-specific currency.

 

32.

TOU

Time of use (TOU) bucket the reading value is attributed to. Value 0 means not applicable.

 

33.

CPP

Critical peak period (CPP) bucket the reading value is attributed to. Value 0 means not applicable. Even though CPP is usually considered a specialized form of time of use `tou`, this attribute is defined explicitly for flexibility.

 

34.

Consumption Tier

In case of common flat-rate pricing for power, in which all purchases are at a given rate, `consumptionTier`=0. Otherwise, the value indicates the consumption tier, which can be used in conjunction with TOU or CPP pricing.

 

Usage Point Group

Description: Usage Point Group

Usage Point Group Hierarchy

Standard Usage Point Group Hierarchy

Description of dim_usagepg.png follows
Description of the illustration dim_usagepg.png

Usage Point Group Levels

Table 3-91 shows Usage Point Group Total: All USAGE POINT GROUP is the most aggregate level of the dimension.

Table 3-91 Usage Point Group Total

Sr. Number Attribute Description

1.

ALL USAGE POINT GROUP

Identification for the top level value.


Table 3-92 shows Usage Point Group Detail: Abstraction for management of group communications within a two-way AMR system or the data for a group of related usage points. Commands can be issued to all of the usage points that belong to a usage point group using a defined group address and the underlying AMR communication infrastructure.

Table 3-92 Usage Point Location Detail

Sr. Number Attribute Description Sample Value

1.

Usage Point Group Code

 

1001


Zone

Description: Zone

Zone Hierarchy

Standard Usage Point Location Hierarchy

Description of dim_zone.png follows
Description of the illustration dim_zone.png

Zone Levels

Table 3-93 shows Zone Total: All Usage Point Location is the most aggregate level of the dimension.

Table 3-93 Zone Total

Sr. Number Attribute Description

1.

ALL ZONE

Identification for the top level value.


Table 3-94 shows Zone Detail: Location of an individual usage point.

Table 3-94 Zone Detail

Sr. Number Attribute Description Sample Value

1.

Zone Code

 

8838

2.

Zone Kind Code

Kind of this zone.

weatherZone