Water Service Point
Entity
Name: Water Service Point
A commodity service point specific to delivering water. Often a water service point is responsible for delivering both water and wastewater services.
Details
- Industry Domain:
Customer - Relational Table Name:
WATER_SERVICE_POINT - JSON View Name:
WATER_SERVICE_POINT#JSON - Ontology Class:
ewok:CommodityServicePoint.Water
Table: Properties
| Name | General Data Type | Oracle Data Type | Relational Column | Required? | Primary Key? | Validations | Related Graph Object |
|---|---|---|---|---|---|---|---|
| utility service point id | string | VARCHAR2 | UTILITY_SERVICE_POINT_ID |
Yes | Yes | Must match regex pattern: ^\S{1,}$ |
ewok:CommodityServicePoint.Water |
| utility location id | string | VARCHAR2 | UTILITY_LOCATION_ID |
Yes | ewok:Location.Utility | ||
| actual start date time | dateTimeStamp | TIMESTAMP | ACTUAL_START_DATE_TIME |
ewok:CommodityServicePoint.Water | |||
| actual end date time | dateTimeStamp | TIMESTAMP | ACTUAL_END_DATE_TIME |
ewok:CommodityServicePoint.Water | |||
| status code | string | VARCHAR2 | STATUS_CODE |
Must match values in enumerated list from graph | ewok:StatusCodeType.WaterServicePoint |