Wastewater Service Contracted Item
Entity
Name: Wastewater Service Contracted Item
An utility service contracted item specific to the provision of wastewater to a wastewater service point for a wastewater service contract.
Details
- Industry Domain:
Customer - Relational Table Name:
WASTEWATER_SERVICE_CONTRACTED_ITEM - JSON View Name:
WASTEWATER_SERVICE_CONTRACTED_ITEM#JSON - Ontology Class:
ewok:UtilityServiceContractedItem.Wastewater
Properties
| Name | General Data Type | Oracle Data Type | Relational Column | Required? | Primary Key? | Validations | Related Graph Object |
|---|---|---|---|---|---|---|---|
| utility service contracted item id | string | VARCHAR2 | UTILITY_SERVICE_CONTRACTED_ITEM_ID |
Yes | Yes | Must match regex pattern | ewok:UtilityServiceContractedItem.Wastewater |
| utility service contract id | string | VARCHAR2 | UTILITY_SERVICE_CONTRACT_ID |
Yes | Must match regex pattern | ewok:ServiceContract.Wastewater | |
| utility service point id | string | VARCHAR2 | UTILITY_SERVICE_POINT_ID |
Yes | ewok:CommodityServicePoint.Wastewater | ||
| start date time | dateTimeStamp | TIMESTAMP | START_DATE_TIME |
ewok:UtilityServiceContractedItem.Wastewater | |||
| end date time | dateTimeStamp | TIMESTAMP | END_DATE_TIME |
ewok:UtilityServiceContractedItem.Wastewater | |||
| usage calculation operation | string | VARCHAR2 | USAGE_CALCULATION_OPERATION |
Must match values in enumerated list from graph | ewok:UsageCalculationOperationType | ||
| usage calculation percentage | double | NUMBER | USAGE_CALCULATION_PERCENTAGE |
ewok:UtilityServiceContractedItem.Wastewater |