om_waterbalance - Giswater/giswater_dbmodel GitHub Wiki
Description:
Table that stores the information needed to make water balances according to IWA standards by joining information from CRM values and SCADA.
Fields:
| Column name | Data type | Description |
|---|---|---|
| expl_id | integer | Id of an exploitation |
| dma_id | integer | Id of DMA |
| cat_period_id | varchar(16) | Id of a period |
| total_sys_input | double precision | Total DMA input volume |
| auth_bill_met_export | double precision | Billed water exported |
| auth_bill_met_hydro | double precision | Billed metered consumption |
| auth_bill_unmet | double precision | Authorized unmetered billed volume |
| auth_unbill_met | double precision | Unbilled metered consumption |
| auth_unbill_unmet | double precision | Unbilled unmetered consumption |
| loss_app_unath | double precision | Unauthorized consumption |
| loss_app_met_error | double precision | Customer metering innacuracies |
| loss_app_data_error | double precision | Systematic data handlig error |
| loss_real_leak_main | double precision | Leak on mains |
| loss_real_leak_service | double precision | Leak on service lines |
| loss_real_storage | double precision | Leak & overflows at storage |
| type | varchar(50) | Feature name used by the system, non-customizable, defined on sys_feature_cat |
| descript | text | Descript |
| startdate | date | Start date |
| enddate | date | End date |
| total_in | numeric | System inputs discounting system outputs |
| total_out | numeric | System outputs |
| ili | numeric | Infrastructure leakage index |