Selection Module

Module purpose

The Selection module implements sample selection for on-the-spot controls as required by CAP regulations. It manages risk analysis, random sampling, selection criteria and extraction campaigns. A minimum percentage of applications must be selected for field inspection each year.

Key tables

Core selection tables

Table Description Rows
TSEL_SELEZIONE Selection records 34,428
TSEL_SELEZIONE_IMPORTO Selection amounts 49,618
TSEL_SELEZIONE_PARTICELLA Selected parcels 2,002,696
TSEL_CAMPAGNA Selection campaigns 74
TSEL_CAMPAGNA_ATTIVAZIONE Campaign activation 183
TSEL_SAMPLE Random samples 9,419

Extraction tables

Table Description Rows
TESTR_ESTRAZIONE Extraction records 2,185
TESTR_ESTRAZIONE_DOM Extracted applications 175,689
TESTR_ESTRAZIONE_PARTICELLA Extracted parcels 66,839
TESTR_ESTRAZIONE_COMPONENTE Extraction components 68,476
TESTR_ESTRAZIONE_CAMPO Extraction field data 2,068,025
TESTR_OGGETTO Extraction objects 1,218,108

Risk analysis

Table Description Rows
TSEL_RISCHIO Risk scores 168,419
TSEL_RISCHIO_ANALISI Risk analysis 5,879
TSEL_RISCHIO_CAMPIONE Risk samples 1,073
TSEL_RISCHIO_FASCIA Risk bands 168
TSEL_RISCHIO_FORMULA Risk formulae 287
TSEL_RISCHIO_MISURA Risk by measure 1,176
TSEL_RISCHIO_PARAMETRO Risk parameters 5,508

Definition tables

Table Description Rows
TSEL_DEF_SELEZIONE Selection definitions 155
TSEL_DEF_CAMPAGNA Campaign definitions 17
TSEL_DEF_SAMPLE Sample definitions 55
TSEL_DEF_TIPO Selection type definitions 10
TSEL_DEF_CRITERIO Selection criteria definitions 185
TESTR_DEF_ESTRAZIONE Extraction definitions 157
TESTR_DEF_CAMPO Extraction field definitions 1,282
TESTR_DEF_COMPONENTE Extraction component definitions 176

Key columns

TSEL_SELEZIONE (Selection)

Column Type Nullable Description
PKID NUMBER N Primary key
ID_SELEZIONE NUMBER N Selection ID
ID_DOMANDA NUMBER Y Application ID
ID_CAMPAGNA NUMBER Y Campaign ID
COD_TIPO VARCHAR2(20) Y Selection type (random/risk)
COD_STATO VARCHAR2(10) Y Status code
DT_SELEZIONE DATE Y Selection date
PUNTEGGIO_RISCHIO NUMBER Y Risk score
ESITO VARCHAR2(10) Y Outcome

TSEL_RISCHIO (Risk Score)

Column Type Nullable Description
ID_RISCHIO NUMBER N Risk record ID
ID_DOMANDA NUMBER Y Application ID
ID_ANALISI NUMBER Y Analysis ID
PUNTEGGIO NUMBER Y Score
FASCIA VARCHAR2(10) Y Risk band
POSIZIONE NUMBER Y Ranking position

TESTR_ESTRAZIONE (Extraction)

Column Type Nullable Description
ID_ESTRAZIONE NUMBER N Extraction ID
COD_ESTRAZIONE VARCHAR2(50) Y Extraction code
ANNO NUMBER Y Year
COD_TIPO VARCHAR2(20) Y Type
DT_ESTRAZIONE DATE Y Extraction date
NUM_DOM NUMBER Y Number of applications

Data flow

See diagram: Selection Data Flow

Integration points

Inbound

  • Applications: Application data feeds risk analysis
  • Historical Controls: Past control results inform risk scores
  • External Data: Third-party data for risk factors
  • Anomalies: Anomaly patterns increase risk

Outbound

  • Controls: Selected applications trigger on-the-spot checks
  • Field Visits: Extraction data for field inspectors
  • Reporting: Selection statistics for EU reporting
  • Audit: Selection criteria and results for audit trail

Key packages

Package Purpose
SELECTION_PCK Main selection logic
SELECTION_ROUTINE_PCK Selection routines
RISCHIO_PCK Risk analysis
ESTRAZIONE_PCK Extraction processing
CAMPIONE_PCK Sample management
RANDOM_PCK Random selection algorithms

Key views

View Purpose
VSEL_SELEZIONE Selection summary
VSEL_RISCHIO Risk score view
VSEL_CAMPAGNA Campaign view
VESTR_ESTRAZIONE Extraction view
VSEL_SAMPLE Sample view

Selection types

Code Description
RND Random selection
RSK Risk-based selection
MAN Manual selection
TOP Top-up selection
REP Replacement selection

Risk analysis

Risk scores are calculated using configurable formulae stored in:

  • TSEL_RISCHIO_FORMULA: Formula definitions
  • TSEL_RISCHIO_PARAMETRO: Parameter weights
  • TSEL_RISCHIO_FASCIA: Band thresholds

Risk factors may include:

  • Previous control findings
  • Declared area vs. LPIS discrepancies
  • Anomaly history
  • Claim amount
  • New applicant status

Minimum selection rates

EU regulations require minimum on-the-spot control rates:

  • 5% of direct payment applications
  • 5% of RDP area-based applications
  • 100% of high-risk RDP investment projects

Selection campaigns track achievement against these targets.

Quick reference

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