Utility Location
Entity
Name: Utility Location
The utility location is the physical location of a person or organization where a utility company supplies service.
Details
- Industry Domain:
Customer - Relational Table Name:
UTILITY_LOCATION - JSON View Name:
UTILITY_LOCATION#JSON - Ontology Class:
ewok:UtilityLocation
Properties
| Name | General Data Type | Oracle Data Type | Relational Column | Required? | Primary Key? | Validations | Related Graph Object |
|---|---|---|---|---|---|---|---|
| utility location id | string | VARCHAR2 | UTILITY_LOCATION_ID |
Yes | Yes | Must match regex pattern | ewok:UtilityLocation |
| parent utility location id | string | VARCHAR2 | PARENT_UTILITY_LOCATION_ID |
ewok:UtilityLocation | |||
| utility location type | string | VARCHAR2 | UTILITY_LOCATION_TYPE |
ewok:UtilityLocation | |||
| street address | string | VARCHAR2 | STREET_ADDRESS |
geo:StreetAddress | |||
| city | string | VARCHAR2 | CITY |
geo:StreetAddress | |||
| postal code | string | VARCHAR2 | POSTAL_CODE |
Must match regex pattern | geo:PostalCode | ||
| address county | string | VARCHAR2 | ADDRESS_COUNTY |
geo:StreetAddress | |||
| address region code | string | VARCHAR2 | ADDRESS_REGION_CODE |
Must match regex pattern | geo:Subterritory | ||
| country code | string | VARCHAR2 | COUNTRY_CODE |
Must match values in enumerated list from graph | geo:Country | ||
| street address type | string | VARCHAR2 | STREET_ADDRESS_TYPE |
Must match values in enumerated list from graph | core:AddressType_Physical | ||
| latitude | double | NUMBER | LATITUDE |
Must match regex pattern | geo:GeoPoint | ||
| longitude | double | NUMBER | LONGITUDE |
Must match regex pattern | geo:GeoPoint |