Utility Bill Service Period
Entity
Name: Utility Bill Service Period
A utility bill service summary has one or more utility bill service periods which collate the utility bill line items for that period. Typically, there is a single period. Scenarios such as a mid-bill rate change there include one period per effective rate.
Details
- Industry Domain:
Customer - Relational Table Name:
UTILITY_BILL_SERVICE_PERIOD - JSON View Name:
UTILITY_BILL_SERVICE_PERIOD#JSON - Ontology Class:
ewok:UtilityBillServicePeriod
Properties
| Name | General Data Type | Oracle Data Type | Relational Column | Required? | Primary Key? | Validations | Related Graph Object |
|---|---|---|---|---|---|---|---|
| utility bill id | string | VARCHAR2 | UTILITY_BILL_ID |
Yes | Must match regex pattern | ewok:UtilityBill | |
| utility service summary id | string | VARCHAR2 | UTILITY_SERVICE_SUMMARY_ID |
Yes | Yes | Must match regex pattern | ewok:UtilityBillServiceSummary |
| utility service period id | string | VARCHAR2 | UTILITY_SERVICE_PERIOD_ID |
Yes | Yes | Must match regex pattern | ewok:UtilityBillServicePeriod |
| start date | date | DATE | START_DATE |
ewok:UtilityBillServicePeriod | |||
| end date | date | DATE | END_DATE |
ewok:UtilityBillServicePeriod | |||
| utility rate code | string | VARCHAR2 | UTILITY_RATE_CODE |
ewok:UtilityBillServicePeriod | |||
| utility rate effective date | date | DATE | UTILITY_RATE_EFFECTIVE_DATE |
ewok:UtilityBillServicePeriod | |||
| description on bill | string | VARCHAR2 | DESCRIPTION_ON_BILL |
ewok:UtilityBillServicePeriod |