Field Name,Field definition,Note,Data Type
aggID,internal numerical database code of Agglomeration,,Long integer
aggState,Status of the Agglomeration (link to the field lovID in the codelist table T_LOV),"105 = inactive, 106 = active",Integer
repID,"internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod)",,Long integer
rptMStateKey,Member State abbreviation,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 field nutID in the codelist table T_NUTS),,Integer
aggLatitude,"Latitude (ETRS89, decimal degrees)",,Decimal
aggLongitude,"Longitude (ETRS89, decimal degrees)",,Decimal
aggGenerated,Generated load (p.e.),,Long integer
bigID,internal numerical database code of the Big city / Big discharger (link to the field bigID in the codelist table T_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? (link to the field lovID in the codelist table T_LOV),"122 = No, 123 = Yes",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) (link to the field lovID in the codelist table T_LOV)","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) (link to the field lovID in the codelist table T_LOV)","14 = calculated, 15 = estimated",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) (link to the field lovID in the codelist table T_LOV)","0 = information not available, 14 = calculated, 15 = estimated",Integer
