Annex B. Full list of variables in the uncleaned dataset
Variable | Short description | Additional variable description, if needed | Type |
---|---|---|---|
ADMINISTRACION_ANTE | Administration unit | What is the administration unit is providing the call | character |
DEPARTAMENTO_ANT | Department | Which department is providing the call | character |
ORGANO_ANTE | Body | Which official body is providing the call | character |
ADMINISTRACION | Administration unit | Which administration unit is providing the call | character |
DEPARTAMENTO | Department | Which department is providing the call | character |
ORGANO | Body | Which official body is providing the call | character |
DIR3_CON710 | Granting body | Identification of one or more competent bodies to resolve concessions of the call. | character |
DIR3_ANTE_CON705 | Organising body | Identification of the body opening the call | character |
CON100 | Call ID | Unique identifier of each call, automatically assigned by the computer system when registering the call in the BDNS | character |
REF_EXTERNA | Call manager | Who is the manager of the call | character |
DESC_CONV | Description of the call in Spanish | What is the description of call in Spanish | character |
BASEDESC_CON250 | Description of the regulatory bases | Text of the title of the regulation that contains the regulatory bases for managing the call | character |
BASEURL_CON260 | Regulation URL | Link to the website that contains the full text in Spanish of the regulatory bases | character |
ABIERTO_CON420 | Open admission period | Indicates if the call keeps the application admission period open permanently | factor |
INISOLICITUD_CON440 | Application period start date | Starting date of the period enabled to admit requests | date |
FINSOLICITUD_CON460 | End date of the application period | End date of the period enabled to admit requests | date |
AUDAESTADO_CON490 | Condition of State Aid | Indicates if the aid of the call should be classified as ADE | factor |
TIPOAYUDA_CON495 | Type of ADE authorisation | Aid authorisation mechanism | factor |
REGLAMENTO_CON502_50 | Regulation of exemption by category of aid + Regulation of exemption by amount | EU Regulation exemption from the obligation of prior notification to the Commission by category of aid | factor |
REFERENCIA_CON515 | EU aid reference | Reference assigned by the EU as the aid identifier | character |
FINALIDAD_CON540 | Purpose | Public utility or social interest or promotion of a public purpose pursued with the granting of the subsidy | factor |
FINJUSTIFICACION_CON600 | Justification final date | Absolute end date of the deadline for submitting justifications for any concession | date |
NOMINATIVA_CON610 | Nominative grant | Nominative grant condition | factor |
PUBLICABLE_CON620 | Publication | Condition of publicity of the concessions | factor |
IMPACTOGENERO_CON630 | Gender impact | It rates the expected results in relation to the elimination of inequalities between women and men and the fulfilment of the equality policy objectives | factor |
FECHA_ACTUALIZACION | Time at which a third party was updated in the database | What is the time at which a third party was updated in the database | date |
PAIS_TER100 | Third party country | Country that generates the identification of the third party | character |
ID_TER110 | Third party ID | Third party identifier | character |
NOMBRE_TER210_240.x | Lastname + Business name | According to the information provided to the body obligated by the third party | character |
PAISDOM_TER250 | Country of third party | What is the country of the third party | factor |
DOMICILIO_TER252 | Address of the third party | What is the address of the third party | character |
CODPOSTAL_TER254 | Postal code of the third party | What is the postal code of the third party | character |
PROVINCIA_TER258 | Province of the third party | What is the province of the third party | character |
MUNICIPIO_TER256 | Municipality of the third party | What is the municipality of the third party | character |
NATURALEZA_TER280 | Legal nature of the third party | What is the legal nature of the third party | factor |
TIPOBEN_TER290 | Third party type | Cataloguing of third parties based on their legal nature and economic activity | factor |
REGION_TER310 | Region | Region in which the third party is established | character |
ID_COS | Award ID | What is the unique identifier of award | character |
TIPO_CONC_CSU204 | Instrument | One of the legal or economic figures on the basis of which the grants and aid are awarded | factor |
DISCRIMINADOR_CSU130 | Discriminator | Grant award discriminator | character |
OBJETIVOS_CSU205 | Objective | Objective of the Aid Category Exemption Regulation | factor |
DAT_COS_CSU210 | Grant award date | Date of the resolution of the grant award | date |
COSTE_ACT_CSU240 | Costs | Amount of the fundable budget of the activity to which the grant award applies | numeric |
IMPORTE_CONCE_CSU220 | Amount awarded (grant) | Total amount committed in the grant award | numeric |
AYUDA_EQUI_CSU250 | Equivalent aid (grant) | Equivalent aid from grant award | numeric |
REGION_CSU260 | Region | Geographical location of the material application of the grant award | character |
Year | Year of the award | Which year the award took place | date |
CSU110 | Announcement | Call identification | character |
PAIS_CSU120 | Beneficiary country | What is the country of beneficiary | factor |
ID_CSU120 | Beneficiary | Identification of the beneficiary | character |
CSU130 | Discriminator | Own reference of the granting body, free content, used to discriminate each grant award to the same beneficiary in the same call | character |
DISCRIMINADOR_PAG110 | Payment discriminator | Own reference of the granting body, free content, used to discriminate each payment of the same concession | character |
FECHAPAGO_PAG210 | Payment date (grant) | When the grant was paid | date |
IMPORTE_PAG220 | Amount paid (grant) | What is the amount of award | numeric |
RETENCION_PAG230 | Retention | Condition of tax withholding carried out | factor |
PROYECTO_PRO130 | Project ID | Project identification | character |
DESCRIPCION_PRO210 | Description | Project description | character |
IMPORTEPROY220 | Grant amount | Grant award amount allocated to the project | numeric |
IMPORTEPROY230 | Loan amount | Amount of the loan granted to the project | numeric |
COSTE_PRO240 | Project costs | Fundable cost of the project | numeric |
AYUDA_PRO250 | Equivalent aid (project) | Support equivalent to the project | numeric |
REGION_PROY260 | Region | Geographical location of the project | character |
ANIO_EJE130 | Year | Project execution year | date |
EJE210 | Grant amount | Amount of the grant award assigned to the executing agency in the year. | numeric |
EJE220 | Loan amount | Amount of the loan concession assigned to the executing agency in the year. | numeric |
COSTE_EJE240 | Costs | Aid equivalent to the project executor in the year | numeric |
AYUDA_EJE250 | Equivalent help (executor) | What is the amount of the help provided to executor | numeric |
IDENTIFICADOR_EJE120 | Executor ID | Identification of the executor | character |
DISCRIMINADOR_REI110_1...8 | Reimbursement discriminator | Own reference of the granting body, free content, used to discriminate each reimbursement procedure of the same beneficiary derived from the same grant | character |
FECHADEV_REI210_1...8 | Refund resolution date | Date of the resolution of the proceeding refund procedure | date |
PRINCIPAL_REI230_1...8 | Principal | Amount of refund | numeric |
CAUSA_REI220_1...7 | Causes | One or more of the causes that support the origin of the refund | factor |
DISCRIMINADOR_DEV110 | Return discriminator | Own reference of the granting body, free content, used to discriminate each voluntary return of one or more payments of the same concession | character |
FECHADEV_DEV210 | Return date | Date of the administrative resolution of acceptance of the return. | date |
PRINCIPAL_DEV220 | Amount of the principal of the return | Amount of the principal that the beneficiary returns without any resolution of repayment. | numeric |
INTEERESES_DEV230 | Amount of interest on the return | Amount of default interest calculated | numeric |
CON550 | Economic activities | One or more of the sectors of the economy foreseen in the call | factor |
STRDESCRIPCION.x | Description of CON550 | Description of variable CON550 | character |
DIARIO_CON310 | Official journal of publication | Reference to the Official Gazette to which the extract of the call must be sent for publication | character |
DESCRIPCION_CON335 | Title in Spanish of the call | What is the Spanish title of the call | character |
FECHA_CON351 | Date of the signature of the call | When the call was signed | date |
LOCALIDAD_CON352 | Location of the signature footer of the call | Where the call was signed | character |
PUBLI_CON390 | Date of publication in the official gazette | When the call was published in the official gazette | date |
URL_CON400 | Reference in the official gazette of the extract in Spanish | What is the extract in official gazette in Spanish | character |
CON560 | Help instrument | One or more of the legal or economic figures on the basis of which the subsidies and aid are awarded | factor |
STRDESCRIPCION.y | Description of CON560 | The description of variable CON560 | character |
CON503 | Objectives of the Aid Category Exemption Regulation | What are the objectives of the Aid Category Exemption Regulation | factor |
STRDESCRIPCION_CON503 | Description of CON503 | Description of variable CON503 | character |
CON580 | Types of beneficiary | One or more of the types of beneficiary foreseen in the call | factor |
STRDESCRIPCION_CON580 | Description of CON580 | Description of variable CON580 | character |
CON570 | Geographic regions | One or more geographical locations of the material application of the subsidy or aid provided for in the call | factor |
STRDESCRIPCION_CON570 | Description of CON570 | Description of variable CON570 | character |
CON690 | EU Fund financing amount | The amount of EU funds financial support | numeric |
STRDESCRIPCION_CON690 | Description of CON690 | Description of variable CON560 | character |
STRVALOR | Type of EU financing institution | The EU financing institution | factor |
DATSANC_1...3x | Date of sanction | When the sanction was imposed | date |
STRDISCRIMINADOR_1...3x | Discriminator of the sanction | The organisation that is the discriminator of the sanction | character |
MULTALEVE_SAN250_1...3x | Fine for minor infractions | The fine amount for minor infractions | numeric |
MULTAGRAVE_SAN280_1...3x | Fine for serious infractions | The fine amount for serious infractions | numeric |
MULTAMUYGRAVE_1...3x | Fine for very serious infractions | The fine amount for very serious infractions | numeric |
PUBLICABLE_SAN440_1...3x | Condition of publicity of the sanction | Indicates whether the sanction should be public, according to art. 20.9 LGS | factor |
LIMITE_SAN450_1...3x | Advertising deadline | What is the deadline for advertising | character |
STRDESCRIPCION_SANC_1...3x | the description of STRVALOR value | Description of STRVALOR variable value | character |
STRVALOR2_1...3x | Type of violation | Mild behaviours + Serious behaviours + Very serious behaviours | factor |
ACTIVIDADES_TER320 | Third party economic activities | What are the third party economic activity types | factor |
DESC_ACTIVIDAD | Description of TER320 | Description of values of TER320 variable | character |
This document, as well as any data and map included herein, are without prejudice to the status of or sovereignty over any territory, to the delimitation of international frontiers and boundaries and to the name of any territory, city or area. Extracts from publications may be subject to additional disclaimers, which are set out in the complete version of the publication, available at the link provided.
© OECD 2021
The use of this work, whether digital or print, is governed by the Terms and Conditions to be found at http://www.oecd.org/termsandconditions.