Utility Bill Usage Disaggregation
Entity
Name: Utility Bill Usage Disaggregation
Appliance-level disaggregation is a core feature of the Opower customer engagement solution.
Details
- Industry Domain:
Customer - Relational Table Name:
UTILITY_BILL_USAGE_DISAGGREGATION - JSON View Name:
UTILITY_BILL_USAGE_DISAGGREGATION#JSON - Ontology Class:
ewok:UtilityBilling.UtilityBillUsageDisaggregation
Table: Properties
| Name | General Data Type | Oracle Data Type | Relational Column | Required? | Primary Key? | Validations | Related Graph Object |
|---|---|---|---|---|---|---|---|
| utility account id | string | VARCHAR2 | UTILITY_ACCOUNT_ID |
Yes | Yes | Must match regex pattern: ^\S{1,}$ |
ewok:UtilityBilling.UtilityAccount |
| commodity type | string | VARCHAR2 | COMMODITY_TYPE |
Yes | Yes | Must match values in enumerated list from graph | ewok:CommodityType |
| disaggregation category type | string | VARCHAR2 | DISAGGREGATION_CATEGORY_TYPE |
Yes | Yes | Must match values in enumerated list from graph | ewok:DisaggregationCategoryType |
| bill period start date | dateTime | DATE | BILL_PERIOD_START_DATE |
Yes | Yes | ewok:UtilityBilling.UtilityBillUsageDisaggregation | |
| bill period end date | dateTime | DATE | BILL_PERIOD_END_DATE |
Yes | Yes | ewok:UtilityBilling.UtilityBillUsageDisaggregation | |
| ratio | double | NUMBER | RATIO |
ewok:UtilityBilling.UtilityBillUsageDisaggregation | |||
| unit of measure | string | VARCHAR2 | UNIT_OF_MEASURE |
Must match values in enumerated list from graph | uom:UnitOfMeasure | ||
| currency | string | VARCHAR2 | CURRENCY |
Must match values in enumerated list from graph | uom:Currency | ||
| usage amount | double | NUMBER | USAGE_AMOUNT |
ewok:UtilityBilling.UtilityBillUsageDisaggregation | |||
| cost amount | double | NUMBER | COST_AMOUNT |
ewok:UtilityBilling.UtilityBillUsageDisaggregation |