Wastewater Service Contract
Entity
Name: Wastewater Service Contract
A commodity service contract specific to removal of wastewater. Often there is no commodity meter in place for this type of contract and usage is calculated as a derivative of water usage.
Details
- Industry Domain:
Customer
- Relational Table Name:
WASTEWATER_SERVICE_CONTRACT
- JSON View Name:
WASTEWATER_SERVICE_CONTRACT#JSON
- Ontology Class:
ewok:WastewaterServiceContract
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:WastewaterServiceContract |
utility account id | string | VARCHAR2 | UTILITY_ACCOUNT_ID |
Yes | Must match regex pattern | ewok:UtilityAccount | |
start date time | dateTimeStamp | TIMESTAMP | START_DATE_TIME |
ewok:WastewaterServiceContract | |||
end date time | dateTimeStamp | TIMESTAMP | END_DATE_TIME |
ewok:WastewaterServiceContract | |||
utility division | string | VARCHAR2 | UTILITY_DIVISION |
ewok:WastewaterServiceContract | |||
utility rate code | string | VARCHAR2 | UTILITY_RATE_CODE |
ewok:UtilityRate |