Field name,Field Definition,Note,Data type
aggState,Status of the agglomeration,"105=deactivated, 106=active",Integer
rptMStateKey,Member State,All data are linked to rpMStateKey; ISO 3166-alpha-2 code,Text(2)
aggID,internal numerical database code of agglomeration,,Long integer
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 table NUTS),,Integer
aggLatitude,Latitude,,Decimal(18)
aggLongitude,Longitude,,Decimal(18)
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(10)
aggC1,Rate of generated load of agglomeration collected through collecting system (% of p.e.),,Decimal(18)
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(18)
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(18)
aggMethodWithoutTreatment,"Method used to obtain the %-value (calculated or estimated, for aggPercWithoutTreatment)",,Integer
