Controls Module

Module purpose

The Controls module implements administrative and on-the-spot checks required by CAP regulations. It validates application data, detects anomalies, manages control campaigns and tracks control outcomes. This includes cross-checks, LPIS verification, livestock controls and risk-based sample selection.

Used by inspectors to perform checks on submitted applications before payments are made. Applications may have penalties deducted based on findings.

The paying agency (ARPA) has a dedicated Control Unit performing this work.

Sectors

A categorisation of control system type is called a sector. For Malta, the control system is split per application type. Sector types are defined in SITISETT.

Accessing controls

Navigate to Main Menu > IACS > Control System:

  1. Select year
  2. Select sector
  3. Select customer controls
  4. Search for farmer by FIC (Fiscal Code)
  5. Select the customer row in the customer list
  6. The Customer B.O. Portal menu opens

Key tables

Core control tables

Table Description Rows
TCNT_CONTROLLO Control records 2,946,877
TCNT_ANOMALIA Detected anomalies 2,133,461
TCNT_ANOMALIA_STORIA Anomaly history 1,097,298
TCNT_CAMPAGNA Control campaigns 1,084
TCNT_CAMPAGNA_ATTIVAZIONE Campaign activation 6,432
TCNT_BLOCCO Control blocks 170,588
TCNT_MSG Control messages 31,181

Control results

Table Description Rows
TCNT_RISULTATO Control results 486,216
TCNT_RETTIFICA Control corrections 9,987
TCNT_RETTIFICA_IMPORTO Correction amounts 168,905
TCNT_ISTRUTTORIA Investigation records 4,779
TCNT_SIS_IRREGOLARE System irregularities 1,893,553

Control definitions

Table Description Rows
TCNT_DEF_ANOMALIA Anomaly definitions 1,739
TCNT_DEF_CONTROLLO Control definitions 4,614
TCNT_DEF_TIPO_CONTROLLO Control type definitions 92
TCNT_DEF_BLOCCO Block definitions 178
TCNT_DEF_CAMPAGNA Campaign definitions 115
TCNT_DEF_GRUPPO Control group definitions 35
TCNT_DEF_FAMIGLIA Control family definitions 88

Cross-control tables

Table Description Rows
TCNT_XC Cross-control records 4,049,680
TCNT_XC_STORIA Cross-control history 3,979,814
TCNT_XC_2 Cross-control v2 1,073,879
TCNT_XC_2_STORIA Cross-control v2 history 1,027,389
TCNT_XC_DEF_CAMPO Cross-control field definitions 185

LPIS Controls

Table Description Rows
TCNT_LPIS LPIS control records 1,088,679
TCNT_LPIS_CHECK LPIS check results 2,069,403
TCNT_LPIS_CHECK_RECORD LPIS check details 3,010,932
TCNT_LPIS_DEF LPIS definitions 4
TCNT_LPIS_DEF_CHECK LPIS check definitions 48

Field controls

Table Description Rows
TCNT_VISITA Field visit records 22,927
TCNT_VISITA_COMPONENTE Visit components 20,451
TCNT_VISITA_COMPONENTE_DEF Visit component definitions 130
TCNT_VISITA_CONTABILITA Visit accounting 221
TCNT_VISITA_ESITO Visit outcomes 25,688
TCNT_VISITA_GIS Visit GIS data 17,091

Key columns

TCNT_ANOMALIA (Anomaly)

Column Type Nullable Description
PKID NUMBER N Primary key
ID_ANOMALIA NUMBER N Anomaly ID
ID_CONTROLLO NUMBER N Control ID
ID_DOMANDA NUMBER Y Application ID
COD_ANOMALIA VARCHAR2(20) Y Anomaly code
MSG_ANOMALIA VARCHAR2(4000) Y Anomaly message
COD_STATO VARCHAR2(10) Y Status code
COD_GRAVITA VARCHAR2(10) Y Severity code
DT_CREAZIONE DATE Y Creation date
DT_RISOLUZIONE DATE Y Resolution date
ESCLUDI VARCHAR2(1) Y Exclude flag

TCNT_CONTROLLO (Control)

Column Type Nullable Description
PKID NUMBER N Primary key
ID_CONTROLLO NUMBER N Control ID
ID_DOMANDA NUMBER Y Application ID
COD_TIPO_CONTROLLO VARCHAR2(20) Y Control type code
COD_STATO VARCHAR2(10) Y Status code
DT_CONTROLLO DATE Y Control date
ESITO VARCHAR2(10) Y Outcome
NOTE VARCHAR2(4000) Y Notes

TCNT_CAMPAGNA (Campaign)

Column Type Nullable Description
ID_CAMPAGNA NUMBER N Campaign ID
COD_CAMPAGNA VARCHAR2(20) Y Campaign code
ANNO NUMBER Y Year
COD_TIPO VARCHAR2(20) Y Campaign type
DT_INIZIO DATE Y Start date
DT_FINE DATE Y End date
COD_STATO VARCHAR2(10) Y Status

Data flow

See diagram: Controls Data Flow

Integration points

Inbound

  • Applications: Applications trigger administrative checks
  • LPIS: Land parcel data for spatial controls
  • External Registers: Cross-checks with livestock, vehicle, land registries
  • Selection: Sample selection for on-the-spot controls

Outbound

  • Calculations: Control results feed reduction calculations
  • Payments: Blocking anomalies prevent payment
  • Workflow: Anomalies generate investigation tasks
  • Reporting: Control statistics for EU reporting

Key packages

Package Purpose
CONTROL_ROUTINE_PCK Control processing routines
CONTROLLI_PCK Main control operations
CONTROLLI_LPIS_PCK LPIS-specific controls
CONTROLLI_XC_PCK Cross-control processing
ANOMALIA_PCK Anomaly management
CHECK_ROUTINE_PCK Check routines
CAMPAGNA_PCK Campaign management

Key views

View Purpose
VCNT_ANOMALIA Anomaly summary view
VCNT_CONTROLLO Control summary view
VCNT_BLOCCO Blocking anomalies view
VCNT_LPIS LPIS control view
VCNT_VISITA Field visit view
VCNT_XC Cross-control view

Control types

Control types are defined in TCNT_DEF_TIPO_CONTROLLO:

Type Description
ADM Administrative controls
OTS On-the-spot checks
XC Cross-checks
LPIS LPIS verification
RM Remote sensing
VET Veterinary controls

Anomaly severity

Anomalies are classified by severity:

Code Description
B Blocking - prevents processing
W Warning - requires review
I Informational - logged only

Control campaigns

Controls are organised into campaigns (TCNT_CAMPAGNA) by year and type:

  • Administrative control campaign
  • On-the-spot control campaign
  • LPIS verification campaign
  • Cross-compliance campaign

Quick reference

  • Acronyms — full abbreviation list
  • Glossary — term definitions and Italian translations
  • Home — system overview