Field name?,Field Definition?,Note?,Data type?
aggID,internal numerical database code of agglomeration,,Long integer
aggState,Status of the agglomeration,"105=deactivated, 106=active",Integer
repID,internal numerical database code connecting data to proper reporting period (link to the table ReportPeriod),,Long integer
rptMStateKey,Member State,All data are linked to rpMStateKey; ISO 3166-alpha-2 code,Text(2)
aggCode,ID of the agglomeration,,Text(32)
aggName,Name of the agglomeration,,Text(255)
aggNUTS,internal numerical database code of Region (NUTS) (link to the codelist table NUTS),,Integer
aggLatitude,Latitude,,Decimal
aggLongitude,Longitude,,Decimal
aggGenerated,Generated load (p.e.),,Long integer
bigID,internal numerical database code of the big city/ big discharger (link to the table BigCity),,Long integer
aggCalculation,Methods used for calculation of the generated load of the agglomeration,,Memo
aggChanges,Are there any significant changes of the generated load compared to the previous Report?,,Long integer
aggChangesComment,Comments on significant changes of the generated load compared to the previous reported load,,Memo
aggPeriodOver,Date of the relevant deadline of UWWTD or Transitional Period,,Date
aggC1,Rate of generated load of agglomeration collected through collecting system (% of p.e.),,Decimal
aggMethodC1,"Method used to obtain the %-value (calculated or estimated, for aggC1)","14=calculated, 15=estimated",Integer
aggC2,Rate of generated load of agglomeration addressed through IAS (% of p.e.),,Decimal
aggMethodC2,"Method used to obtain the %-value (calculated or estimated, for aggC2),",,Integer
aggPercWithoutTreatment,Rate of generated load of agglomeration not collected through collecting systems and not addressed through IAS (% of p.e.),,Decimal
aggMethodWithoutTreatment,"Method used to obtain the %-value (calculated or estimated, for aggPercWithoutTreatment)",,Integer
