Differences

This shows you the differences between two versions of the page.

--- annex_code_lists [2020/03/30 07:42] – created matsz
+++ annex_code_lists [2020/03/30 08:54] – [Table 4: List of activities in the supply model] matsz
@@ Line 1: / Line 1: @@
 ======Annex: Code lists======
+====Table 1: Codes used for storing the original REGIO tables in the data base and their description, rows====
+^Codes used in CAPRI’s REGIO tables^Original REGIO description^
+|TOTL|Territorial area|
+|FORE|Forest land|
+|AGRI|Utilized agricultural area|
+|GARD|Private gardens|
+|GRAS|Permanent grassland|
+|PERM|Permanent crops|
+|VINE|Vineyards|
+|OLIV|Olive plantations|
+|ARAB|Arable land|
+|GREF|Green fodder on arable land|
+|CERE|Cereals (including rice)|
+|WHEA|Soft and durum wheat and spelt|
+|BARL|Barley|
+|MAIZ|Grain maize|
+|RICE|Rice|
+|POTA|Potatoes|
+|SUGA|Sugar beet|
+|OILS|Oilseeds (total)|
+|RAPE|Rape|
+|SUNF|Sunflower|
+|TOBA|Tobacco|
+|MAIF|Fodder maize|
+|CATT|Cattle (total)|
+|COWT|Cows (total)|
+|DCOW|Dairy cows|
+|CALV|Other cows|
+|CAT1|Total cattle under one year|
+|CALF|Slaughter calves|
+|CABM|Male breeding calves (<1 year)|
+|CABF|Female breeding calves (<1 year)|
+|BUL2|Male cattle (1-2 years)|
+|H2SL|Slaughter heifers (1-2 years)|
+|H2BR|Female cattle (1-2 years)|
+|BUL3|Male cattle (2 years and above)|
+|H3SL|Slaughter heifers (2 years and above)|
+|H3BR|Breeding heifers|
+|BUFF|Total buffaloes|
+|PIGS|Total pigs (total)|
+|PIG1|Piglets under 20 kg|
+|PIG2|Piglets under 50 kg and over 20 kg|
+|PIG3|Fattening pigs over 50 kg|
+|BOAR|Breeding boars|
+|SOW2|Total breeding sows|
+|SOW1|Sows having farrowed|
+|GILT|Gilts having farrowed for the first time|
+|SOWM|Maiden sows|
+|GILM|Maiden gilts|
+|SHEP|Sheep total)|
+|GOAT|Goats (total)|
+|EUQI|Equidae (total)|
+|POUL|Poultry (total)|
+|OUTP|Final production|
+|CROP|Total crops production|
+|DWHE|Durum wheat|
+|PULS|Pulses|
+|ROOT|Roots and tubers|
+|INDU|Industrial crops|
+|TEXT|Textile fibre plants|
+|HOPS|Hops|
+|VEGE|Fresh vegetables|
+|TOMA|Tomatoes|
+|CAUL|Cauliflowers|
+|FRUI|Fresh fruit|
+|APPL|Apples|
+|PEAR|Pears|
+|PEAC|Peaches|
+|CITR|Citrus fruit (total)|
+|ORAN|Oranges|
+|LEMN|Lemons|
+|MAND|Mandarins|
+|GRAP|Table grapes|
+|WINE|Wine|
+|TABO|Table olives|
+|OLIO|Olive oil|
+|NURS|Nursery plants|
+|FLOW|Flowers and ornamental plants|
+|OCRO|Other crops|
+|ANIT|Total animal production|
+|ANIM|Animal|
+|SHGO|Sheep and goats|
+|ANIP|Animal products|
+|MILK|Milk|
+|EGGS|Eggs|
+|INPU|Intermediate consumption (total)|
+|FEED|Animal feeding stuffs|
+|FDGR|Animal compounds for grazing livestock|
+|FDPI|Animal compounds for pigs|
+|FDPO|Animal compounds for poultry|
+|FODD|Straight feeding stuffs|
+|FERT|Fertilizers and enrichments|
+|ENER|Energy and lubricants|
+|INPO|Other inputs|
+|GVAM|Gross value added at market prices|
+|SUBS|Subsidies|
+|TAXS|Taxes linked to production (including VAT balance)|
+|GVAF|Gross value added at factor costs|
+|DEPM|Depreciation|
+|LABO|Compensation and social security contributions of employees|
+|RENT|Rent and other payments|
+|INTE|Interests|
+|GFCF|Total of gross fixed capital formation|
+|BUIL|Buildings and other structures|
+|MACH|Transport equipment and machinery|
+|GFCO|Other gross fixed capital formation|
+====Table 2: Codes used for storing the original REGIO tables in the data base and their description, columns====
+^Codes used in CAPRI’s REGIO tables	^Original REGIO description^
+|LEVL|Herd size / Area / # of persons|
+|LSUN|Live stock units|
+|PROP|Physical production|
+|YILD|Yield|
+|VALE|EAA position in ECU|
+|VALN|EAA position in NC|
+====Table 3: Connection between CAPRI and REGIO crop areas, crop production and herd sizes====
+^SPEL-code ^REGIO-code	^REGIO-code	^REGIO-code	^REGIO-code	^Description of SPEL activity^
+|SWHE|WHEA|CERE|ARAB|	   |Soft wheat|
+|DWHE|WHEA|CERE|ARAB|	   |Durum wheat|
+|RYE |   |CERE|ARAB|	   |Rye|
+|BARL|BARL|CERE|ARAB|	   |Barley|
+|OATS|   |CERE|ARAB|	   |Oats|
+|MAIZ|MAIZ|CERE|ARAB|	   |Maize|
+|OCER|   |CERE|ARAB|	   |Other cereals (excl. rice)|
+|PARI|RICE|CERE|ARAB|	   |Paddy rice|
+|PULS|   |   |ARAB|	   |Pulses|
+|POTA|POTA|   |ARAB|	   |Potatoes|
+|SUGB|SUGA|   |ARAB|	   |Sugar beet|
+|RAPE|RAPE|OILS|ARAB|	   |Rape and turnip rape|
+|SUNF|SUNF|OILS|ARAB|	   |Sunflower seed|
+|SOYA|   |OILS|ARAB|	   |Soya beans|
+|OLIV|   |OLIV|PERM|	   |Olives for oil|
+|OOIL|   |OILS|ARAB|	   |Other oil seeds and oleaginous fruits|
+|FLAX|   |   |ARAB|	   |Flax and hemp  (faser) |
+|TOBA|TOBA|   |ARAB|	   |Tobacco, unmanufactured, incl. dried|
+|OIND|   |   |ARAB|	   |Other industrial crops|
+|CAUL|   |   |ARAB|	   |Cauliflowers|
+|TOMA|   |   |ARAB|	   |Tomatoes|
+|OVEG|   |   |ARAB|	   |Other vegetables|
+|APPL|   |   |PERM|	   |Apples, pears and peaches|
+|OFRU|   |   |PERM|	   |Other fresh fruits|
+|CITR|   |   |PERM|	   |Citrus fruits|
+|TAGR|   |VINE|PERM|	   |Table grapes|
+|TABO|   |OLIV|PERM|	   |Table olives|
+|TWIN|   |VINE|PERM|	   |Table wine|
+|OWIN|   |VINE|PERM|	   |Other wine|
+|NURS|   |   |PERM|	   |Nursery plants|
+|FLOW|   |   |ARAB|	   |Flowers,ornamental plants, etc.|
+|OCRO|   |   |ARAB|	   |Other final crop products|
+|MILK|DCOW|   |   |	   |Dairy cows|
+|BEEF|BUL2|BUL3| |	   |Bulls fattening|
+|CALF|CALF|   |   |	   |Calves fattening   (old VEAL)|
+|PORK|PIG3|PIG2|PIG1|	   |Pig fattening|
+|MUTM|GOAT|HEP|   |	   |Ewes and goats|
+|MUTT|GOAT|SHEP|   |	   |Sheep and goat fattening|
+|EGGS|POUL|   |	  |	   |Laying hens|
+|POUL|POUL|   |	  |	   |Poultry fattening|
+|OANI|   |   |  |	   |Other animals|
+|OROO|   |   |ARAB|	   |Other root crops|
+|GRAS|GRAS|   |   |	   |Green fodder|
+|SILA|GREF|   |ARAB|	   |Silage|
+|CALV|CALV|   |   |	   |Suckler cows|
+|RCAL|CABM|CABF|	   |	   |Calves, raising|
+|HEIF|H2SL|H2BR|H3SL|H3BR|Heifers|
+|PIGL|SOW2|   |   |	   |Pig breeding|
+|FALL|   |   |FALL|	   |Fallow land|
+====Table 4: List of activities in the supply model====
+^Group	^Activity	^Code^
+|**Cereals**|Soft wheat|SWHE|
+|:::|Durum wheat|DWHE|
+|:::|Rye and Meslin|RYEM|
+|:::|Barley|BARL|
+|:::|Oats|OATS|
+|:::|Paddy rice|PARI|
+|:::|Maize|MAIZ|
+|:::|Other cereals|OCER|
+|**Oilseeds**|Rape|RAPE|
+|:::|Sunflower|SUNF|
+|:::|Soya|SOYA|
+|:::|Olives for oil|OLIV|
+|:::|Other oilseeds|OOIL|
+|**Other annual crops**|Pulses|PULS|
+|:::|Potatoes|POTA|
+|:::|Sugar beet|SUGB|
+|:::|Flax and hemp|TEXT|
+|:::|Tobacco|TOBA|
+|:::|Other industrial crops|OIND|
+|**Vegetables \\
+Fruits \\
+Other perennials**|Tomatoes|TOMA|
+|:::|Other vegetables|OVEG|
+|:::|Apples, pear & peaches|APPL|
+|:::|Citrus fruits|CITR|
+|:::|Other fruits|OFRU|
+|:::|Table grapes|TAGR|
+|:::|Table olives|TABO|
+|:::|Table wine|TWIN|
+|:::|Nurseries|NURS|
+|:::|Flowers|FLOW|
+|:::|Other marketable crops|OCRO|
+|**Fodder production**|Fodder maize|MAIF|
+|:::|Fodder root crops|ROOF|
+|:::|Other fodder on arable land|OFAR|
+|:::|Graze and grazing|GRAS|
+|**Fallow land and set-aside**|Set-aside idling|SETA|
+|:::|Non food production on set-aside|NONF|
+|:::|Fallow land|FALL|
+|**Cattle**|Dairy cows|DCOW|
+|:::|Sucker cows|SCOW|
+|:::|Male adult cattle fattening|BULF|
+|:::|Heifers fattening|HEIR|
+|:::|Heifers raising|HEIF|
+|:::|Fattening of male calves|CAMF|
+|:::|Fattening of female calves|CAFF|
+|:::|Raising of male calves|CAMR|
+|:::|Raising of female calves|CAFR|
+|**Pigs, poultry and other animals**|Pig fattening|PIGF|
+|:::|Pig breeding|SOWS|
+|:::|Poultry fattening|POUF|
+|:::|Laying hens|HENS|
+|:::|Sheep and goat fattening|SHGF|
+|:::|Sheep and goat for milk|SHGM|
+|:::|Other animals|OANI|
+====Table 5: Output, inputs, income indicators, policy variables and processed products in the data base====
+^Group	^Item	^Code^
+|**Outputs**|||
+|**Cereals**|Soft wheat|SWHE|
+|:::|Durum wheat|DWHE|
+|:::|Rye and Meslin|RYEM|
+|:::|Barley|BARL|
+|:::|Oats|OATS|
+|:::|Paddy rice|PARI|
+|:::|Maize|MAIZ|
+|:::|Other cereals|OCER|
+|**Oilseeds**|Rape|RAPE|
+|:::|Sunflower|SUNF|
+|:::|Soya|SOYA|
+|:::|Olives for oil|OLIV|
+|:::|Other oilseeds|OOIL|
+|**Other annual crops**|Pulses|PULS|
+|:::|Potatoes|POTA|
+|:::|Sugar beet|SUGB|
+|:::|Flax and hemp|TEXT|
+|:::|Tobacco|TOBA|
+|:::|Other industrial crops|OIND|
+|**Vegetables \\
+Fruits \\
+Other perennials**|Tomatoes|TOMA|
+|:::|Other vegetables|OVEG|
+|:::|Apples, pear & peaches|APPL|
+|:::|Citrus fruits|CITR|
+|:::|Other fruits|OFRU|
+|:::|Table grapes|TAGR|
+|:::|Table olives|TABO|
+|:::|Table wine|TWIN|
+|:::|Nurseries|NURS|
+|:::|Flowers|FLOW|
+|:::|Other marketable crops|OCRO|
+Fodder	Gras
+Fodder maize
+Other fodder from arable land
+Fodder root crops
+Straw	GRAS
+MAIF
+OFAR
+ROOF
+STRA
+Marketable products
+from animal product	Milk from cows
+Beef
+Pork meat
+Sheep and goat meat
+Sheep and goat milk
+Poultry meat
+Other marketable animal products	COMI
+BEEF
+PORK
+SGMT
+SGMI
+POUM
+OANI
+Intermediate products
+from animal production	Milk from cows for feeding
+Milk from sheep and goat cows for feeding
+Young cows
+Young bulls
+Young heifers
+Young male calves
+Young female calves
+Piglets
+Lambs
+Chicken
+Nitrogen from manure
+Phosphate from manure
+Potassium from manure	COMF
+SGMF
+YCOW
+YBUL
+YHEI
+YCAM
+YCAF
+YPIG
+YLAM
+YCHI
+MANN
+MANP
+MANK
+Other Output from EAA	Renting of milk quota
+Agricultural services	RQUO
+SERO
+Inputs
+Mineral and organic fertiliser
+Seed and plant protection	Nitrogen fertiliser
+Phosphate fertiliser
+Potassium fertiliser
+Calcium fertiliser
+Seed
+Plant protection	NITF
+PHOF
+POTF
+CAOF
+SEED
+PLAP
+Feedings tuff	Feed cereals
+Feed rich protein
+Feed rich energy
+Feed based on milk products
+Gras
+Fodder maize
+Other Feed from arable land
+Fodder root crops
+Feed other
+Straw	FCER
+FPRO
+FENE
+FMIL
+FGRA
+FMAI
+FOFA
+FROO
+FOTH
+FSTRA
+Young animal
+Other animal specific inputs	Young cow
+Young bull
+Young heifer
+Young male calf
+Young female calf
+Piglet
+Lamb
+Chicken
+Pharmaceutical inputs	ICOW
+IBUL
+IHEI
+ICAM
+ICAF
+IPIG
+ILAM
+ICHI
+IPHA
+General inputs	Maintennce machinery
+Maintennce buildings
+Electricity
+Heating gas and oil
+Fuels
+Lubricants
+Water
+Agricultural services input
+Other inputs	REPM
+REPB
+ELEC
+EGAS
+EFUL
+ELUB
+WATR
+SERI
+INPO
+Income indicators	Production value
+Total input costs
+Gross value added at producer prices
+Gross value added at basic prices
+Gross value added at market prices plus CAP premiums	TOOU
+TOIN
+GVAP
+GVAB
+MGVA
+Activity level	Cropped area, slaughtered heads or herd size	LEVL
+Policy variables
+Relating to activities	Premium ceiling
+Historic yield
+Premium per ton historic yield
+Set-aside rate
+Premium declared below base area/herd
+Premium effectively paid
+Premium amount in regulation
+Type of premium application
+Factor converting PRMR into PRMD
+Ceiling cut factor	PRMC
+HSTY
+PRET
+SETR
+PRMD
+PRME
+PRMR
+APPTYPE
+APPFACT
+CEILCUT
+Processed products	Rice milled
+Molasse
+Starch
+Sugar
+Rape seed oil
+Sunflower seed oil
+Soya oil
+Olive oil
+Other oil
+Rape seed cake
+Sunflower seed cake
+Soya cake
+Olive cakes
+Other cakes
+Gluten feed from ethanol production
+Biodiesel
+Bioethanol
+Palm oil
+Butter
+Skimmed milk powder
+Cheese
+Fresh milk products
+Creams
+Concentrated milk
+Whole milk powder
+Whey powder
+Casein and caseinates
+Feed rich protein imports or byproducts
+Feed rich energy imports or byproducts	RICE
+MOLA
+STAR
+SUGA
+RAPO
+SUNO
+SOYO
+OLIO
+OTHO
+RAPC
+SUNC
+SOYC
+OLIC
+OTHC
+GLUE
+BIOD
+BIOE
+PLMO
+BUTT
+SMIP
+CHES
+FRMI
+CREM
+COCM
+WMIO
+WHEP
+CASE
+FPRI
+FENI