Gas Service Point
Entity
Name: Gas Service Point
A commodity service point specific to delivering gas.
Details
- Industry Domain:
Customer - Relational Table Name:
GAS_SERVICE_POINT - JSON View Name:
GAS_SERVICE_POINT#JSON - Ontology Class:
ewok:CommodityServicePoint.Gas
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.Gas |
| utility location id | string | VARCHAR2 | UTILITY_LOCATION_ID |
Yes | ewok:Location.Utility | ||
| actual start date time | dateTimeStamp | TIMESTAMP | ACTUAL_START_DATE_TIME |
ewok:CommodityServicePoint.Gas | |||
| actual end date time | dateTimeStamp | TIMESTAMP | ACTUAL_END_DATE_TIME |
ewok:CommodityServicePoint.Gas | |||
| status code | string | VARCHAR2 | STATUS_CODE |
Must match values in enumerated list from graph | ewok:StatusCodeType.GasServicePoint |