Water Service Contract
Entity
Name: Water Service Contract
A commodity service contract specific to the provision of water to a water service point.
Details
- Industry Domain:
Customer - Relational Table Name:
WATER_SERVICE_CONTRACT - JSON View Name:
WATER_SERVICE_CONTRACT#JSON - Ontology Class:
ewok:ServiceContract.Water
Properties
| Name | General Data Type | Oracle Data Type | Relational Column | Required? | Primary Key? | Validations | Related Graph Object |
|---|---|---|---|---|---|---|---|
| utility service contract id | string | VARCHAR2 | UTILITY_SERVICE_CONTRACT_ID |
Yes | Yes | Must match regex pattern | ewok:ServiceContract.Water |
| utility account id | string | VARCHAR2 | UTILITY_ACCOUNT_ID |
Yes | ewok:UtilityBilling.UtilityAccount | ||
| start date time | dateTimeStamp | TIMESTAMP | START_DATE_TIME |
ewok:ServiceContract.Water | |||
| end date time | dateTimeStamp | TIMESTAMP | END_DATE_TIME |
ewok:ServiceContract.Water | |||
| utility division | string | VARCHAR2 | UTILITY_DIVISION |
ewok:ServiceContract.Water | |||
| utility rate code | string | VARCHAR2 | UTILITY_RATE_CODE |
ewok:UtilityRate | |||
| rate code effective date | dateTimeStamp | TIMESTAMP | RATE_CODE_EFFECTIVE_DATE |
ewok:ServiceContract.Water | |||
| service contract type | string | VARCHAR2 | SERVICE_CONTRACT_TYPE |
ewok:ServiceContract.Water | |||
| status code | string | VARCHAR2 | STATUS_CODE |
Must match values in enumerated list from graph | ewok:StatusCodeType.UtilityServiceContract | ||
| billing specialized condition | string | VARCHAR2 | BILLING_SPECIALIZED_CONDITION |
Must match values in enumerated list from graph | ewok:BillingSpecializedConditionType |