Variable List Filter Variables by Questionnaire, group, type and/or unit

Questionnaire
Group
Type
Unit
# Code Name Variable Group Type
1 F.3 R_F3_GOVERNMENT_OWNED_BANK_IND None Numeric
2 C5.4 R_C_5_4_OTHER_IND Customers Relations Option
3 C5.2 R_C_5_2_COMPLAINT_RESPOND_IND Customers Relations Option
4 37a Number of complaints - total (per year) Customers Relations Numeric
5 C5.6 Do you have a call center? Customers Relations Option
  • No
  • Yes
6 C5.7 Is the call center integrated with a global Software/Database system to register & follow up calls/complaints? Customers Relations Option
  • No
  • Yes
7 C5.8 Do you register complaints by nature (e.g. invoice, technical problem, etc.) Customers Relations Option
  • No
  • Yes
8 C5.3 R_C_5_3_QUESTIONNAIRE_SURVEY_IND Customers Relations Option
9 37 R_37_COMPLAINT_MEANS Customers Relations Option
10 C5.1 R_C_5_1_COMPLAINT_LETTERS_IND Customers Relations Option
11 ALB_D029 Technical Complaints for Water and Wastewater Services (number) Customers Relations Numeric
12 ALB_D030 Technical Complaints Reviewed on Time (number) Customers Relations Numeric
13 ALB_D031 Commercial Complaints for Water and Wastewater Services (number) Customers Relations Numeric
14 ALB_D032 Commercial Complaints Reviewed in Time (number) Customers Relations Numeric
15 ALB_D033 Commercial Complaints Resolved in Time (number) Customers Relations Numeric
16 ALB_D039 Service Contracts concluded with Customers (number) Customers Relations Numeric
17 ALB_D039.1 Residential Customers (number) Customers Relations Numeric
18 ALB_D039.2 Commercial-Industrial Customers (number) Customers Relations Numeric
19 ALB_D039.3 Institutional Customers (number) Customers Relations Numeric
20 ALB_D040 No. of Applications for Service Connections (number) Customers Relations Numeric
21 ALB_D041 No. of Applications for Service Connections Reviewed in Time (number) Customers Relations Numeric
22 ALB_D042 Service Connectons Installed in Time (number) Customers Relations Numeric
23 ALB_D043 No. of Individual disconnections (number) Customers Relations Numeric
24 ALB_D044 No. of Applications for Collective Disconnections (number) Customers Relations Numeric
25 C5.5 R_OTHER_DESC Customers Relations Free Text
26 RS.vr.1 Important finished works in water supply system Financial Information Free Text
27 RS.vr.2 Value of important finished works in water supply system (LUC) Financial Information Numeric
28 RS.vr.3 Value of finished important works in WSS - own resources (LUC) Financial Information Numeric
29 RS.vr.4 Value of finished important works in WSS - external funds (LUC) Financial Information Numeric
30 RS.vr.5 Important finished works in sewage system Financial Information Free Text
31 RS.vr.6 Important finished works in sewage system (LUC) Financial Information Numeric
32 RS.vr.7 Value of finished important works in sewage - own resources (LUC) Financial Information Numeric
33 RS.vr.8 Value of finished important works in sewage - external funds (LUC) Financial Information Numeric
34 F.2 R_F2_BORROW_INTERNATIONAL_AGENCY_IND Financial Information Option
35 F.4 R_F4_COMMERCIAL_BANK_IND Financial Information Option
36 9 Month in which fiscal year starts (1 to 12) Financial Information Option
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
37 90 Total operating revenues (LUC/year) Financial Information Numeric
38 90a Total billings - residential (LUC/year) Financial Information Numeric
39 90b Total billings - industrial and commercial (LUC/year) Financial Information Numeric
40 91 Total water and wasterwater (cash) income (LUC/year) Financial Information Numeric
41 90c Total water operating billings (LUC/year) Financial Information Numeric
42 90e Total water billings to residential customers (LUC/year) Financial Information Numeric
43 90f Total water billings to industrial and commercial customers (LUC/year) Financial Information Numeric
44 90g Total water billings to institutions and others (LUC/year) Financial Information Numeric
45 90h Total water billings for treated bulk supplies (LUC/year) Financial Information Numeric
46 90d Total wastewater operating billings (LUC/year) Financial Information Numeric
47 90i Total wastewater billings to residential customers (LUC/year) Financial Information Numeric
48 90j Total wastewater billings to industrial and commercial customers (LUC/year) Financial Information Numeric
49 114 Total debt service (LUC/year) Financial Information Numeric
50 120 Year end accounts receivable (LUC) Financial Information Numeric
51 94 Total water and wastewater operational expenses (LUC/year) Financial Information Numeric
52 94a Total water operational expenses (LUC/year) Financial Information Numeric
53 94b Total wastewater operational expenses (LUC/year) Financial Information Numeric
54 115 New investments of the year (LUC/year) Financial Information Numeric
55 96 Labor costs (LUC/year) Financial Information Numeric
56 97 Electrical energy costs (LUC/year) Financial Information Numeric
57 98 Repair & maintenance costs (LUC/year) Financial Information Numeric
58 99 Contracted out services costs (LUC/year) Financial Information Numeric
59 112 Total gross fixed assets including work in progress (LUC) Financial Information Numeric
60 112a Gross fixed assets including work in progress - water (LUC) Financial Information Numeric
61 112b Gross fixed assets including work in progress - wastewater (LUC) Financial Information Numeric
62 113 Depreciation of fixed assets water and wastewater (LUC) Financial Information Numeric
63 113a Depreciation of fixed assets water (LUC) Financial Information Numeric
64 113b Depreciation of fixed assets wastewater (LUC) Financial Information Numeric
65 F.1 Grants or government transfers to the utility Financial Information Numeric
66 F.5 Does the company benefit from Gov loans? Financial Information Option
  • No
  • Yes
67 F.6 Does the company has access and subscribed commercial loans from local  banks? Financial Information Option
  • No
  • Yes
68 F.7 Does the company has access and subscribed  loans from international banks or markets? Financial Information Option
  • No
  • Yes
69 ALB_D013 Total billing (LUC/month) Financial Information Numeric
70 ALB_D013.1 Billing for water services (LUC/month) Financial Information Numeric
71 ALB_D013.1.1 Residential Customers (LUC/month) Financial Information Numeric
72 ALB_D013.1.2 Commercial- Industrial Customers (LUC/month) Financial Information Numeric
73 ALB_D013.1.3 Institutional Customers (LUC/month) Financial Information Numeric
74 ALB_D013.2 Billing for wastewater services (LUC/month) Financial Information Numeric
75 ALB_D013.2.1 Residential Customers (LUC/month) Financial Information Numeric
76 ALB_D013.2.2 Commercial- Industrial Customers (LUC/month) Financial Information Numeric
77 ALB_D013.2.3 Institutional Customers (LUC/month) Financial Information Numeric
78 ALB_D013.3 Billing for fixed tariff (LUC/month) Financial Information Numeric
79 ALB_D013.3.1 Residential Customers (LUC/month) Financial Information Numeric
80 ALB_D013.3.2 Commercial- Industrial Customers (LUC/month) Financial Information Numeric
81 ALB_D013.3.3 Institutional Customers (LUC/month) Financial Information Numeric
82 ALB_D017.1 Residential Customers (LUC/month) Financial Information Numeric
83 ALB_D017.2 Commercial- Industrial Customers (LUC/month) Financial Information Numeric
84 ALB_D017.3 Institutional Customers (LUC/month) Financial Information Numeric
85 ALB_D018 Other Operative Revenue (LUC/month) Financial Information Numeric
86 ALB_D019 Operative Revenue (LUC/month) Financial Information Numeric
87 ALB_D020 Cash in Cashbox and Bank (LUC/month) Financial Information Numeric
88 ALB_D021.1.1 Purchased Bulk Water (untreated) (LUC/month) Financial Information Numeric
89 ALB_D021.1.2 Salaries (LUC/month) Financial Information Numeric
90 ALB_D021.1.3 Maintenance (LUC/month) Financial Information Numeric
91 ALB_D021.1.4 Energy (LUC/month) Financial Information Numeric
92 ALB_D021.1.5 Fuel (LUC/month) Financial Information Numeric
93 ALB_D021.1.6 Costs of materials and consumable materials (LUC/month) Financial Information Numeric
94 ALB_D021.1.7 Other expenses (LUC/month) Financial Information Numeric
95 ALB_D021.2.1 Salaries (LUC/month) Financial Information Numeric
96 ALB_D021.2.2 Maintenance (LUC/month) Financial Information Numeric
97 ALB_D021.2.3 Energy (LUC/month) Financial Information Numeric
98 ALB_D021.2.4 Fuel (LUC/month) Financial Information Numeric
99 ALB_D021.2.5 Costs of materials and consumable materials (LUC/month) Financial Information Numeric
100 ALB_D021.2.6 Other expenses (LUC/month) Financial Information Numeric
101 ALB_D022 Non-operating expenses (LUC/month) Financial Information Numeric
102 ALB_D023.1 Aggregate amount of the loan payment for water service (LUC/month) Financial Information Numeric
103 ALB_D023.1.1 Water supply amount of principal (LUC/month) Financial Information Numeric
104 ALB_D023.1.2 Amount of interest for water services (LUC/month) Financial Information Numeric
105 ALB_D023.1.3 Amount of tax credit, undertaking for water services (LUC/month) Financial Information Numeric
106 ALB_D023.2 Aggregate amount of the loan payment for water and wastewater service (LUC/month) Financial Information Numeric
107 ALB_D023.2.1 Amount of principal/Shuma e kryegjësë/principalit për shërbimet e ujërave të zeza (LUC/month) Financial Information Numeric
108 ALB_D023.2.2 Amount of interest for water services (LUC/month) Financial Information Numeric
109 ALB_D023.2.3 Amount of tax credit, undertaking for wastewater services (LUC/month) Financial Information Numeric
110 ALB_D025 Other accounts receivable (LUC/month) Financial Information Numeric
111 ALB_D026 Accounts payables (Creditors) (LUC/month) Financial Information Numeric
112 ALB_D027 Stocks (LUC/month) Financial Information Numeric
113 ALB_D047 Total investment for Water and Wastewater (RWC) (LUC/month) Financial Information Numeric
114 ALB_D047.1 Capital Investment for Resuorces and Water Treatment (RWC) (LUC/month) Financial Information Numeric
115 ALB_D047.2 Capital Investment for Water Distribution (RWC) (LUC/month) Financial Information Numeric
116 ALB_D047.3 Capital Investment for Business Activity for Water (RWC) (LUC/month) Financial Information Numeric
117 ALB_D047.4 Capital Investment for Wastewater Collection (RWC) (LUC/month) Financial Information Numeric
118 ALB_D047.5 Capital Investment for Wastewater Treatment (RWC) (LUC/month) Financial Information Numeric
119 ALB_D047.6 Capital Investment for Treatment and Sludge Discharge (RWC) (LUC/month) Financial Information Numeric
120 ALB_D047.7 Capital Investment for Business Activities of Wastewater (RWC) (LUC/month) Financial Information Numeric
121 ALB_D048 Total investment for Water and Wastewater (GRANTS) (LUC/month) Financial Information Numeric
122 ALB_D048.1 Capital Investment for Resurces and Water Treatment (GRANTS) (LUC/month) Financial Information Numeric
123 ALB_D048.2 Capital Investment for Water Distribution (GRANTS) (LUC/month) Financial Information Numeric
124 ALB_D048.3 Capital Investment for Water Business Activitits (GRANTS) (LUC/month) Financial Information Numeric
125 ALB_D048.4 Capital Investment for Wastewater Collection (GRANTS) (LUC/month) Financial Information Numeric
126 ALB_D048.5 Capital Investment for Wastewater Treatment (GRANTS) (LUC/month) Financial Information Numeric
127 ALB_D048.6 Capital Investment for Treatment and Sludge Discharge (GRANTS) (LUC/month) Financial Information Numeric
128 ALB_D048.7 Capital Investment for Business Activities of Wastewater (GRANTS) (LUC/month) Financial Information Numeric
129 ALB_D049 Total ivestment for Water and Wastewater (LOANS) (LUC/month) Financial Information Numeric
130 ALB_D049.1 Capital investment for Resurces and Water Treatment (LOANS) (LUC/month) Financial Information Numeric
131 ALB_D049.2 Capital investment for Water Distribution (LOANS) (LUC/month) Financial Information Numeric
132 ALB_D049.3 Capital Investment for Water Business Activities (LOANS (LUC/month) Financial Information Numeric
133 ALB_D049.4 Capital Investment for Wasterwater Collection (LOANS) (LUC/month) Financial Information Numeric
134 ALB_D049.5 Capital Investment for Wasterwater Treatment (LOANS) (LUC/month) Financial Information Numeric
135 ALB_D049.6 Capital Investment for Treatment and Sludge Discharge (LOANS) (LUC/month) Financial Information Numeric
136 ALB_D049.7 Capital Investment for Wastewater Business Activities (LOANS) (LUC/month) Financial Information Numeric
137 ALB_D050 Capital Investment for Water Infrastructure Renewal (RWC) (LUC/month) Financial Information Numeric
138 ALB_D051 Capital Investment for Wastewater Infrastructure Renewal (RWC) (LUC/month) Financial Information Numeric
139 ALB_D052 Capital Investment for Water Infrastructure Renewal (GRANTS) (LUC/month) Financial Information Numeric
140 ALB_D053 Capital Investment for Wastewater Infrastructure Renewal (GRANTE) (LUC/month) Financial Information Numeric
141 ALB_D054 Capital Investment for Water Infrastructure Renewal (LOANS) (LUC/month) Financial Information Numeric
142 ALB_D055 Capital Investment for Wastewater Infrastructure Renewal (GRANTS) (LUC/month) Financial Information Numeric
143 6a PPP_CONVERSION_FACTOR General Information Numeric
144 5a GNI_PER_CAPITA_PPP General Information Numeric
145 5 GNI per capita (Atlas) (US$/person/year) General Information Numeric
146 6 Exchange rate (LUC/U$S) General Information Numeric
147 RS.54 Network Mapping (number) Service Area Numeric
148 RS54.A Network Mapping GIS (number) Service Area Numeric
149 RS.54.B Network Mapping CAD (number) Service Area Numeric
150 RS.54.C Network Mapping PAPER (number) Service Area Numeric
151 RS.40 User's geospatial distribution (inhabitants) Service Area Numeric
152 34 Number of Towns served with water (full figure ) Service Area Numeric
153 35 Number of Towns served with sewage (full figure ) Service Area Numeric
154 30 Total population living in the service area - water supply (inhabitants) Service Area Numeric
155 30a Total population living in the service area - wastewater (inhabitants) Service Area Numeric
156 70 Population served - sewerage (inhabitants) Sewerage Service Numeric
157 71 Sewerage connections (number) Sewerage Service Numeric
158 74 Length of sewers (km) Sewerage Service Numeric
159 79 Number of sewerage blockages (per year) Sewerage Service Numeric
160 81a Total volume of wastewater collected (m3/year) Sewerage Service Numeric
161 81b Volume of wastewater collected - residential (m3/year) Sewerage Service Numeric
162 81c Volume of wastewater collected - industrial & commercial (m3/year) Sewerage Service Numeric
163 81d Volume of wastewater collected that is treated to primary level (m3/year) Sewerage Service Numeric
164 81e Volume of wastewater collected that is treated to at least secondary level (m3/year) Sewerage Service Numeric
165 RS.30.2 Total installed power in wastewater supply system (kW) Sewerage Service Numeric
166 RS.82.1 Separate sanitary and storm sewerage systems? Sewerage Service Option
  • Yes
  • No
167 RS.82.2 Length of storm collection system, without connections (km) Sewerage Service Numeric
168 ALB_D009.1 Residential Customers (number) Sewerage Service Numeric
169 ALB_D009.2 Commercial- Industrial Customers (number) Sewerage Service Numeric
170 ALB_D009.3 Institutional Customers (number) Sewerage Service Numeric
171 ALB_D045 Length of purified wastwater network (km) Sewerage Service Numeric
172 122 Number of women in the company (full figure ) Staff Numeric
173 123 Number of engineer positions hold by female personnel (full figure ) Staff Numeric
174 121 Total labor cost (salary and other remuneration) to female personnel (LUC/year) Staff Numeric
175 36 Total number of staff (full figure ) Staff Numeric
176 36a Total number of staff - water (full figure ) Staff Numeric
177 36b Total number of staff - wastewater (full figure ) Staff Numeric
178 HR.1 Has a skills and training strategy for all staff Staff Option
  • No
  • Yes
179 HR.2 Has an annual appraisal and target setting for managers Staff Option
  • No
  • Yes
180 HR.3 Has an annual appraisal and target setting for all staff Staff Option
  • No
  • Yes
181 HR.4 Has a reward and recognition programme for all staff Staff Option
  • No
  • Yes
182 HR.5 Has the ability to recruit and dismiss staff (within an agreed plan) Staff Option
  • No
  • Yes
183 RS.36.1 Total number of staff (ETF) (full figure ) Staff Numeric
184 RS.36.2 Number of staff with VII degree of education (full figure ) Staff Numeric
185 RS.36.3 Number of staff with VI degree of education (full figure ) Staff Numeric
186 RS.36.4 Number of staff with V degree of education (full figure ) Staff Numeric
187 RS.36.5 Number of staff with IV degree of education (full figure ) Staff Numeric
188 RS.36.6 Number of staff with III degree of education (full figure ) Staff Numeric
189 RS.36.7 Number of staff with II degree of education (full figure ) Staff Numeric
190 RS.36.8 Number of employees in shared services (full figure ) Staff Numeric
191 RS.36.9 Number of employees in other services (full figure ) Staff Numeric
192 RS.36.10 Number of employees in W&WW services, without shared services (full figure ) Staff Numeric
193 140 Posted tariff water per m3- population (LUC) Tariff Information Numeric
194 141 Posted tariff water per m3- other consumers (LUC) Tariff Information Numeric
195 142 Posted tariff water of public points per m3 (LUC) Tariff Information Numeric
196 C.4 What would be the monthly water bill for a household consuming 6m3 of water per month through a household or shared yard tap (but excluding the use of standposts)?: (LUC) Tariff Information Numeric
197 146 Fixed charge per month for water and wastewater services for residential customers (LUC/month) Tariff Information Numeric
198 146a Fixed charge per month for water services for residential customers (LUC/month) Tariff Information Numeric
199 146b Fixed charge per month for wastewater services for residential customers (LUC/month) Tariff Information Numeric
200 147 Connection charges - water (LUC) Tariff Information Numeric
201 148 Connection charges - sewers (LUC) Tariff Information Numeric
202 C.1 Does the utility offer more than one level of service for household or shared water supplies (excluding free standing pipes)?: Tariff Information Option
  • No
  • Yes
203 C.2 Does the utility offer more than one level of sanitation or sewerage service/ technology for households (excluding free public toilets)?: Tariff Information Option
  • No
  • Yes
204 C.3 Does the utility offer a flexible/ amortized repayment option to spread the costs of connection to the water and/or sanitation network?: Tariff Information Option
  • No
  • Yes
205 ALB_Ibnet-147 Water connections tariffs Tariff Information Numeric
206 40 Population served - water (inhabitants) Water Service Numeric
207 40a Population served - direct water supply & shared taps (inhabitants) Water Service Numeric
208 40b Population served - public water points (inhabitants) Water Service Numeric
209 41 Water connections year end (number) Water Service Numeric
210 53 Connections with operating meter (number) Water Service Numeric
211 42 Design capacity of all water intakes (full figure ) Water Service Numeric
212 43 Number of public water points (full figure ) Water Service Numeric
213 54 Length of water distribution network (km) Water Service Numeric
214 54a Length of network renewed during the year (km) Water Service Numeric
215 60 Number of pipe breaks (per year) Water Service Numeric
216 61 Duration of supply (hours per day) Water Service Numeric
217 61a Number of customers receiving intermittent supply (inhabitants) Water Service Numeric
218 55 Volume of water produced (m3/year) Water Service Numeric
219 59 Volume of water sold (m3/year) Water Service Numeric
220 58 Volume of water sold through operating meters (m3/year) Water Service Numeric
221 59a Volume of water sold - residential (m3/year) Water Service Numeric
222 59a1 Volume of water sold to residential customers through direct supplies (m3/year) Water Service Numeric
223 59a2 Volume of water sold to residential customers through public water points (m3/year) Water Service Numeric
224 59b Volume of water sold to industrial and commercial customers (m3/year) Water Service Numeric
225 59c Volume of water sold to institutions and others (m3/year) Water Service Numeric
226 59d Volume of water sold treated in bulk (m3/year) Water Service Numeric
227 63 Required number of tests of treated water for residual chlorine (per year) Water Service Numeric
228 64 Number of tests of treated water for residual chlorine carried out (per year) Water Service Numeric
229 65 Number of tests of treated water for residual chlorine passed (per year) Water Service Numeric
230 RS.40.1 Number of households in municipality covered with water supply (full figure ) Water Service Numeric
231 RS.40.2 Number of commercial customers (full figure ) Water Service Numeric
232 RS.34.1 Number of public water supply systems in municipality that are not under control of company (full figure ) Water Service Numeric
233 RS.42.1 Water metering at water sources (number) Water Service Numeric
234 RS.42.2 Flow meter on WSS (full figure ) Water Service Numeric
235 RS.43.1 Public taps on network (full figure ) Water Service Numeric
236 RS.54.1 Length of asbestos pipes in distribution network (km) Water Service Numeric
237 ALB_D002 Commercial losses (m3/month) Water Service Numeric
238 ALB_D003 Physical losses (m3/month) Water Service Numeric
239 ALB_D004.1 Residential Customers Water Service Numeric
240 ALB_D004.2 Commercial-Industrial Customers Water Service Numeric
241 ALB_D004.3 Institutional Customer Water Service Numeric
242 ALB_D004.4 Total bulk treated water sold Water Service Numeric
243 ALB_D005 Authorized non-revenue water (water free of charge) (m3/month) Water Service Numeric
244 ALB_D006.3 Billed Wastewater Volume for Institutional Customers (m3/month) Water Service Numeric
245 ALB_D008.1 Residential Customers (number) Water Service Numeric
246 ALB_D008.2 Commercial- Industrial Customers (number) Water Service Numeric
247 ALB_D008.3 Institutional Customers (number) Water Service Numeric
248 ALB_D035 Discontinuous water supply (number) Water Service Numeric
249 ALB_D036 Average discontinuous water supply Water Service Numeric
250 ALB_D037 Prior notice to water disconnection (number) Water Service Numeric
251 ALB_D010.1 Residential Customers (number) Water Service Numeric
252 ALB_D010.2 Commercial- Industrial Customers (number) Water Service Numeric
253 ALB_D010.3 Institutional Customers (number) Water Service Numeric
254 ALB_D011.1 Residential Customers (m3/month) Water Service Numeric
255 ALB_D011.2 Commercial- Industrial Customers (m3/month) Water Service Numeric
256 ALB_D011.3 Institutional Customers (m3/month) Water Service Numeric
257 RS.30.1 Total installed power in water supply system (kW) Water Service Numeric
258 32a Type of service Services Information Option
  • Water only
  • Wastewater only
  • Water and Wastewater company
  • Water, Wastewater and other services
259 32d Do you provide other services? Services Information Option
  • No
  • Yes
260 32c Describe other services if you provide them Services Information Free Text
261 3a Type of service provider Services Information Option
  • Municipal company
  • Regional company
  • National company
262 32b Nature of service area Services Information Option
  • urban
  • rural
  • mixed
263 3 Private sector involvement Services Information Option
264 3b More than 50% owned by the State, the municipality or a public body? Services Information Option
  • No
  • Yes
265 p6 Who calculates tariffs? Process information Option
  • Company
  • Regulator
  • Ministry
  • Municipality
  • Other
266 p7 Who decides the final tariff? Process information Option
  • Company
  • Regulator
  • Ministry
  • Municipality
  • Other
267 p2 R_P2_PLANNING_PROCESS_OTHER_DESC Process information Free Text
268 p1 R_P1_PLANNING_PROCESS Process information Option
269 p5 What best describes the utility's planning process? Process information Option
  • No detailed planning
  • Only Next year Budget
  • Budget + (3-5) years Plan
  • Budget + 10 years Plan
270 p3 Who has general oversight of the utility's services and prices? Process information Option
271 p4 If other, please enter description Process information Free Text
272 30.01 Total electricity consumption (kWh/year) Electricity Consumption Numeric
273 30.02 Electricity consumption - Water (kWh/year) Electricity Consumption Numeric
274 30.03 Electricity consumption - Wastewater (kWh/year) Electricity Consumption Numeric
275 30.04 Electricity consumption other services and admin buildings (kWh/year) Electricity Consumption Numeric