Administrative Database ‘LAD IT system’

Rationale of use

In Latvia, the LAD IT system efficiently manages agricultural data, earning international recognition for its role in timely CAP implementation, including awards such as the "WSIS Prize 2017" and "UN Public Service Award 2015."

Functioning

The workflow of the RSS information system is as follows: 1. Identification of needs/requirements and analysis of indicators for the needs of the RSS, Ministry of Agriculture, and evaluators. 2. Inclusion of the required information in the application/reporting forms. 3. Farmers and beneficiaries enter the data in the electronic portal where logical and data existence checks are conducted. 4. The data is managed in a structured way for most of indicators. 5. Creation of data classifiers in the database so data can be easily processed and analysed. 6. Data is transferred to the Oracle Business Intelligence data warehouse (OBI– tool used for reporting and data analysis) where it can be easily queried for the purpose of evaluation, reporting, or research in order to not overload the database with report requests.

Types of outputs

The tool acts as a database that can be accessed directly by 50 users, including the RSS, Ministry of Agriculture, Institute of Agricultural Resources and Economics, evaluators, and others, with more than 1000 different processes performed each day. Therefore, evaluators have information about applicants stored in other systems.

Relevant CAP objective

All

Sources

https://www.lad.gov.lv/lv/mobila-lietotne-0