WP: Work plan master codes
_________________________________________________________________________________________________________________________[AR]
| field name | tables | codes |
|---|---|---|
| Access to vessels | 1.3 | Y, N, NA |
| Activity indicator | 3.1, 5.1, 5.2 | L, A, NA |
| Aquaculture species group | 6.1 | Salmon, Trout, Sea bass & Sea bream, Carp, Tuna, Eel, Sturgeon (eggs for human consumption), Other freshwater fish , Other marine fish , Mussel, Oyster, Clam, Crustaceans, Other molluscs, Multispecies, Macroalgae, Microalgae, Other aquatic animals |
| Aquaculture techniques | 6.1 | Ponds, Tanks and race-ways, Enclosures and pens, Recirculation systems, Other methods, Cages, Polyculture, Hatcheries & nurseries, Rafts, Longline, On-bottom, Other |
| Aquaculture thresholds | 6.1 | A, B, C, NA |
| Agreed at RCG | 2.3, 2.4 | Y, N, NA |
| Area | 2.1, 2.2, 2.4 | [Alphanumerical] |
| Area(s) covered | 2.4, 2.6, 4.1 | [Alphanumerical] |
| Availability of the data | 1.1 | [Date, as precise as possible] |
Average landings in the reference years (tonnes) | 2.1 | [Positive integer or 'None'] |
Average number of PSUs during the reference period | 2.5 | [Positive integer or 0] |
| Biological variable | 2.2 | Age, Weight, Sex, Length, Maturity, Fecundity |
| Body of water | 2.3 | [Text or 'NA'] |
| Catch fraction | 2.5 | Landings (HUC fraction), Landings (BMS fraction), Landings (IND fraction), Landings (All fractions), Catches (DIS fraction), Catches (PETS species), Catches (All fractions), Catches (All fractions, excl. PETS), Recreational catches (Release), Recreational catches (all), Recreational catches (Retained), Other |
| Contact persons | 1.3 | [Text] |
| Content | 1.3 | [Text] |
| Coordination | 1.3 | [Text] |
| Cost-sharing agreement signed by MS | 2.6 | Y, N |
| Covered by a commercial sampling scheme for length | 2.1 | Y, N |
| Data collection requested by end user | 2.2 | Y, N |
| Data collection scheme | 3.1, 5.2, 6.1, 7.1 | C, PSS, NPS, IND, NA |
| Data set | 1.1 | Biological data from commercial fisheries, Biological data from recreational fisheries, Biological data from diadromous species, Research surveys at sea data, Data on the activity of fishing vessels, Data on the impact of fisheries on the ecosystem, Socioeconomic data on fisheries, Socioeconomic and environmental data on aquaculture, Socioeconomic data on the fish processing sector |
| Data source | 3.1, 5.2, 6.1, 7.1 | Accounts, Questionnaires, Sales notes, Logbooks, Coastal logbooks, Fleet Register , Administrative sources , Other, EUROSTAT, FIDES, National statistics, RCG agreed statistics |
| Data source used for average national landings | 2.1 | EUROSTAT, FIDES, National statistics, RCG agreed statistics, RFMO statistics |
| Data source used for EU landings | 2.1 | EUROSTAT, FIDES, National statistics, RCG agreed statistics, RFMO statistics |
| Data subset | 1.1 | Commercial length structure, Commercial age structure, Individual biological parameters, Recreational catches, Recreational length structures, PETS occurences, River survey index, Diadromous catches, Research survey at sea index, Stomach sampling, Detailed samples, Economic data for fisheries, Social data for fisheries, Economic data for aquaculture, Social data for aquaculture, Economic data for processing industry, Social data for processing industry, Raw material data for processing industry, Capacity data, Effort data, Landings data |
| Data transmission | 1.3 | [Text] |
| Days at sea planned | 2.6 | [Positive integer or 0] |
| Description of sampling / sampling protocol / sampling intensity | 1.3 | [Text] |
| Diadromous variable | 2.3 | Standing stock, Recruits, Length, Weight, Sex ratio, Age, Smolt, Parr, Silver eel escapement, Ascending individuals, Other |
| Does the sampling protocol allow for the quantification of PETS observation effort? | 2.5 | Y, N, NA |
| Economic and social variables | 5.2, 6.1, 7.1 | 5.2, 6.1, 7.1 Consumption of fixed capital, ------------------- 5.2, 6.1 Investments in tangible assets (net purchase of assets), ------------------- 6.1, 7.1 Financial expenditures, |
| EU TAC (if any)(%) | 2.1 | [Percentage, 'None' or 'NA'] |
| Expected number of stomachs | 4.1 | [Positive integer or 'NA'] |
| Fishery / Independent data collection | 2.3 | F, I, NA |
| Fishing activity variable | 3.1 | Number of vessels, GT, kW, Vessel Age, Days at sea, Hours fished , Fishing days, kW * Days at sea, GT * Days at sea, kW * Fishing Days, GT * Fishing days, Number of trips, Number of fishing operations, Number of nets(m) * soak time (days), Number of nets / Length, Number of hooks, Number of lines, Numbers of pots, traps, Number of FADs/buoys, Number of support vessels, Value of landings total and per commercial species, Live Weight of landings total and per species, Average prices per species |
| Fishing technique | 5.1 | Beam trawlers, Demersal trawlers and/or demersal seiners, Pelagic trawlers, Purse seiners, Dredgers, Vessel using other active gears, Vessels using Polyvalent “active” gears only, Vessels using hooks, Drift and/or fixed netters, Vessels using Pots and/or traps, Vessels using other Passive gears, Vessels using Polyvalent “passive” gears only, Vessels using active and passive gears, Inactive vessels |
| Fish processing activity | 7.1 | Main activity, Non-main activity |
| Fish processing segment | 7.1 | ≤10, 11-49, 50-249, ≥250, NA |
| Frequency | 2.3, 2.4, 2.5, 2.6 | 2.5, 2.6 Irregular, ------------------------ 2.3, 2.4, 2.5, 2.6 Month, |
| Geo Indicator | 3.1, 5.1, 5.2 | NEU, IWE, NGI, P2, P3, IC, MA, GF, GP, MQ, MF, RE, YT, NK |
| Implementation year | 1.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 4.1, 5.1, 5.2, 6.1, 7.1 | [YYYY; YYYY-YYYY] |
| Is an annual estimate of the total catch planned? | 2.4 | Y, N, NA |
| Is an estimate of the annual percentage of catch released alive planned? | 2.4 | Y, N, NA |
| Is the collection of biological variables planned? | 2.4 | Y, N, NA |
| Is there a regional threshold for the collection of biological variables? | 2.4 | Y, N, NA |
| Length class | 5.1 | 0 - <6 m, 6 - <12 m, 0 - <8 m, 8 - <12 m, 0 - <10 m, 10 - <12 m, 12 - <18 m, 18 - <24 m, 24 - <40 m, 40 m or larger, 0 - <6 m*, 6 - <12 m*, 0 - <8 m*, 8 - 12 m*, 0 - <10 m*, 10 - <12 m*, 12 - <18 m*, 18 - <24 m*, 24 - <40 m*, 40 m or larger* |
| License | 2.4 | Y, N, NA |
| Life stage | 2.3 | Glass eel, Yellow eel, Silver eel, Parr, Smolt, Adult, Other |
| Link to stomach sampling protocol | 4.1 | [Hyperlink or 'NA'] |
| Link to survey manual | 2.6 | [Hyperlink, ‘No link available’ or ‘No manual available’] |
| Management unit / River | 2.3 | [Text] |
| Mandatory research survey | 2.6 | BITS_Q1, BITS_Q4, BIAS, GRAHS, SPRAS, RHLS_DEU, FEJUCS, CODS_Q4, IBTS_Q1, IBTS_Q3, BTS, DYFS, SNS_NLD, NSSS, ASH, NSMEGS, IHLS, NHAS, UWTV3-4, UWTV6, UWTV7, UWTV8, UWTV9, REDTAS, FCGS, GGS, PLATUXA_ESP, IBTS_Q4, IBTS_Q1, ISBCBTS, SWECOS_GBE, IBWSS, MEGS, SAHMAS, SDEPM, WESPAS_IRL, BIOMAN, UWTV11-13, UWTV14, UWTV15, UWTV16-17, UWTV19, UWTV20-22, UWTV30, NepS, CSHAS_IRL, ECOCADIZ_ESP, IESSNS, JUVENA_ESP, ORHAGO_Q4_FRA, PALPRO_ESP, IAMS_IRL, SIAMISS_GBS, PELTIC, ISAS, MEDIAS, BTSBS, PTSBS, MEDITS, SOLEMON, TUNIBAL |
| Meeting acronym | 1.2 | [Text] |
| Metagenomic techniques | 4.1 | Y, N |
| Methods | 2.3 | [Text or 'NA'] |
| Method of PSU selection | 2.5 | SRSWR, SRSWOR, UPSWR, UPSWOR, SYSS, CENSUS, NPQSRSWR, NPQSRSWOR, NPQSYSS, NPJS, NPCS, FIXED |
| MS | 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 4.1, 5.1, 5.2, 6.1, 7.1 | AUT, BEL, BGR, CYP, CZE, DEU, DEN, ESP, EST, FIN, FRA, GRC, HRV, HUN, IRL, ITA, LTU, LVA, MLT, NLD, POL, PRT, ROU, SVK, SVN, SWE |
| Name of meeting | 1.2 | [Text] |
| Name of research survey | 2.6 | [Text] |
| Name of the agreement | 1.3 | [Text] |
| Number of individuals to sample | 2.2 | [Positive integer, 'NA' or 0] |
| Number of sampling activities planned | 2.6 | [Positive integer or 0] |
| Observation type | 2.2, 2.3, 2.4, 2.5, 4.1 | 2.2, 2.3, 2.4, 2.5, [4.1] SciObsAtSea, --------------------- 2.3 SciObs water body, |
| Opportunistic (O) or planned (P) sampling | 2.2 | O, P |
| PETS observation covered within the sampling scheme | 2.5 | Y, N |
| Planned minimum number of units | 2.3 | [Positive integer or 0] |
| Planned number of PSUs | 2.5 | [Positive integer or 0] |
| Planned sample rate (%) | 3.1,5.2, 6.1, 7.1 | [Percentage] |
| PSU type | 2.5 | SRSWR, SRSWOR, UPSWR, UPSWOR, SYSS, CENSUS, NPQSRSWR, NPQSRSWOR, NPQSYSS, NPJS, NPCS, FIXED |
| Reasons for not sampling | 2.3, 2.4 | [Text] |
| Reference period | 2.1,2.5 | [YYYY-YYYY; YYYY, YYYY, YYYY] |
| Reference year | 1.1 | [N, N-1 etc. or 'YYYY'] |
| Region | 1.1, 1.2, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 4.1 | Baltic Sea, Mediterranean and Black Sea, North Sea and Eastern Arctic, North-East Atlantic, Other regions, Outermost regions, All Regions |
| Regional coordination agreement at stock level | 2.1 | Y, N |
| Regional work plan name | 2.2, 2.5, 2.6, 4.1 | [Text] |
| RFMO/RFO/IO | 1.1, 1.2, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 4.1 | CCAMLR, CCBSP, CCSBT, CECAF, EIFAAC, GFCM, IATTC, ICCAT, ICES, IOTC, NA NAFO, NASCO, NEAFC, SEAFO, SIOFA, SPRFMO, WCPFC, WECAFC |
| Relevant international planning group - RFMO/RFO/IO | 2.6 | [Acronym or 'NA'] |
| Research survey acronym | 2.6 | [Acronym or Mandatory survey acronym] |
| Research survey database | 2.6 | [Text] |
| Sampling frame description | 2.5 | [Text] |
| Sampling frame identifier | 2.5 | [Text] |
| Sampling frame spatial coverage | 2.5 | [Alphanumerical] |
| Sampling scheme identifier | 2.2, 2.3, 2.4, 2.5, 4.1 | [Text] |
| Sampling scheme type | 2.2, 2.3, 2.4, 2.5, 4.1 | Commercial fishing trip, Commercial by category, Recreational (off site surveys), Recreational (on site surveys), Research survey at sea, Biological parameters specific, Diadromous (commercial), Diadromous (market), Diadromous (recreational), Diadromous (scientific) |
| Segment or cluster name | 3.1, 5.1, 5.2 | [Text] |
| Selected for sampling of biological variables | 2.1 | Y, N |
| Share (%) in EU landings | 2.1 | [Percentage or 'None'] |
| Species | 2.1, 2.2, 2.3, 2.4 | [Text] |
| Species coverage | 2.5 | all species, Selected species/stocks, list of commercial species, list of PETS species |
| Species for stomach sampling | 4.1 | [Text] |
| Species present in the MS | 2.3, 2.4 | Y, N |
| Specific item | 1.1 | [Text] |
| Supra region | 3.1, 5.1, 5.2 | 3.1, 5.1, 5.2 Baltic Sea; ----------------------- 5.2 All Supra regions |
| Threshold rules used | 2.1, 2.6 | 2.1 TAC < 10%, ------------------ 2.4, 2.6 Regionally agreed rule ----------------------- 2.6 Implementing decision rule -------------------------- 2.1, 2.6 None |
| Time period (month) | 2.6 | [Numbers coma-separated] |
| Time period (quarter) | 4.1 | [Quarters, comma-separated] |
| Total population (WP) | 5.1 | [Positive integer or 0] |
| Type of MS participation | 2.6 | Financial , Technical, Personnel, Combination, NA |
| Type of sampling activities | 2.6 | Marine litter Benthic invertebrate samples Hydrography (CTD casts) Hydrography Stomach content Trawl hauls EDSU (nm) [text] NA |
| Type of variables (E/S) | 5.2, 6.1, 7.1 | E, S |
| Unit | 2.3 | [Text or 'NA'] |
| Validity | 1.3 | [YYYY] |
| WP comments | 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 4.1, 5.1, 5.2, 6.1, 7.1 | [text] |
| WP table | 1.1 | [Alphanumerical] |
AR: Annual report master codes
_________________________________________________________________________________________________________________________[WP]
| field name | tables | codes |
|---|---|---|
| Achieved % of PSUs | 2.5 | [Fills in automatically, formula in the template =(X4/R4)] |
| Achieved % of sampled individuals at national level | 2.2 | [Fills in automatically, formula in the template =IF(AND(M4="NA",P4="NA"),"NA",IF(AND(M4="NA",P4=0),"0",IF(M4<>"NA",P4/M4,"")))] |
| Achieved % of units | 2.3 | [Fills in automatically, formula in the template =V4/S4] |
| Achieved coverage (%) | 3.1, 5.2, 6.1, 7.1 | [Fills in automatically, formulas in the template (Table 3.1) =Q3/O3; (Table 5.2) =Q4/N4; (Table 6.1) =P4/M4; (Table 7.1) = O4/L4] |
| Achieved number of individuals measured for length at national level from commercial sampling | 2.1 | [Positive integer or 0] |
| Achieved number of PSUs in the implementation year | 2.5 | [Positive integer or 0] |
| Achieved number of sampled individuals at national level | 2.2 | [Positive integer or 0] |
| Achieved number of units | 2.3 | [Positive integer or 0] |
| Achieved number of samples | 2.2 | [Positive integer or 0] |
| Achieved number of samples for length at national level from commercial sampling | 2.1 | [Positive integer or 0] |
| Achieved response number | 3.1, 5.2, 6.1, 7.1 | [Positive integer or 0] |
| AR comments | 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 4.1, 5.1, 5.2, 6.1, 7.1 | [Text] |
| AR reference year | 3.1, 5.1, 5.2, 6.1, 7.1 | [YYYY] |
| Collection of biological data | 2.4 | Y, N, NA |
| Days at sea achieved | 2.6 | [Positive integer or 0] |
| Divergence (%) of implementation year vs. reference period | 2.5 | [Fills in automatically, formula in the template =(W4/Q4)] |
| Estimated annual catch quantities by species | 2.4 | Y, N, NA |
| Estimated annual percentage release | 2.4 | Y, N, NA |
| EU MAP section | 1.4 | [Number and text] |
| Evaluated by external experts/bodies | 2.4 | Y, N, NA |
| Follow-up action | 1.4 | [Text] |
| In case of financial participation, has the payment been made? | 2.6 | Y, N, NA |
| Indication if AR comments by MS are required concerning number of samples achieved | 4.1 | [Fills in automatically, formula in the template =IF(P4/L4<0.9;"x";IF(P4/L4>1.5;"X";""))] |
| Indication if AR comments required concerning achieved % of measured individuals | 2.2 | [Fills in automatically, formula in the template =IF(R4="","",IF(R4="NA","NA",IF(OR(R4<0.9,R4>1.5),"X","")))] |
| Indication if AR comments are required concerning number of PSUs achieved | 2.5 | [Fills in automatically, formula in the template =IF(OR(Y4<0.9;Y4>1.5);"X";"")] |
| Indication if AR comments required concerning achieved number of units | 2.3 | [Fills in automatically, formula in the template =IF(OR(W4<0.9;W4>1.5);"X";"")] |
| Indication if AR comments required concerning number of sampling activities achieved | 2.6 | [Fills in automatically, formula in the template =IF(OR(X5/R5<0.9;X5/R5>1.5),"X","")] |
| Indication if AR comments required concerning temporal and spatial coverage | 2.6, 4.1 | [Fills in automatically, formulas in the template (Table 2.6) =IF(OR(AA5="N",Z5="N",AA5="",Z5=""),"X",""); (Table 4.1) =IF(OR(Q4="N";R4="N";Q4="";R4="");"X";"")] |
| Number of enterprises | 6.1, 7.1 | [Positive integer or 0] |
| Number of fishing trips in the sampling frame | 2.5 | [Positive integer or 0] |
| Number of fishing trips sampled | 2.5 | [Positive integer or 0] |
| Number of fishing trips sampled with PETS mitigation device | 2.5 | [Positive integer or 0] |
| Number of MS participants | 1.2 | [Positive integer or 0] |
| Number of sampling activities achieved | 2.6 | [Positive integer or 0] |
| Number of species with length measurements | 2.5 | [Positive integer or 0] |
| Number of unique active vessels in the sampling frame | 2.5 | [Positive integer or 0] |
| Number of unique vessels sampled | 2.5 | [Positive integer or 0] |
| Number of vessels | 3.1 | [Positive integer or 0] |
| Other data submissions | 2.6 | Y, N |
| Percentage of sampled fishing trips where the observer dedicated time to record the bycatch of PETS | 2.5 | [Percentage] |
| Planned sample number | 3.1 | [Fills in automatically, formula in the template =ROUNDUP(O4*L4;0)] |
| Recommendation/Agreement | 1.4 | [Text] |
| Recommendation number | 1.4 | [Alphanumerical] |
| Response rate (%) | 3.1, 5.2, 6.1, 7.1 | [Fills in automatically, formulas in the template (table 3.1)=Q4/P4; (table 5.2) =Q4/P4; (table 6.1) =P4/(O4); (table 7.1) =O4/(N4)] |
| Sampled number of stomachs | 4.1 | [Positive integer or 0] |
| Source of recommendation/agreement | 1.4 | [Text] |
| Time when data was available | 1.1 | [Date, as precise as possible] |
| Topic | 1.4 | [Text] |
| Total number of PSUs in the implementation year | 2.5 | [Positive integer or 0] |
| Total population | 5.2 | [Positive integer or 0] |
| Total population (AR) | 5.1 | [Positive integer or 0] |
| Updated planned sample number | 5.2, 6.1, 7.1 | [Fills in automatically, formulas in the template (table 5.2) =ROUNDUP(N4*O4;0); (table 6.1) =ROUNDUP(N4*M4;0); (table 7.1) =ROUNDUP(M4*L4;0)] |
| Updated planned sample rate (%) | 5.2, 6.1, 7.1 | [Percentage] |
| Updated planned sample rate/planned sample rate (%) | 5.2, 6.1, 7.1 | [Percentage] |
| Was the sampling carried out within the official survey area? | 4.1 | Y, N |
| Was the sampling carried out within the planned area(s)? | 2.6 | Y, N |
| Was the sampling carried out within the planned quarter(s)? | 4.1 | Y, N |
| Was the survey carried out within the official time period? | 2.6 | Y, N |