Entitlements Module

Module purpose

The Entitlements module manages payment rights (titoli) under the Basic Payment Scheme (BPS). Each entitlement has a unit value and must be activated with eligible hectares to generate a payment. The module tracks entitlement allocation, transfers, convergence and annual activation.

Key tables

Core entitlement tables

Table Description Rows
TTITOLO Payment entitlements 105,896
TTITOLO_OLD Historical entitlements 10,019
TTITOLO_NAZIONALE National entitlement registry 59,626
TTIT_TRASFERIMENTO Entitlement transfers 1,298
TTIT_IMPORTO Entitlement values 105,896
TTIT_IMPORTO_DS Entitlement value details 105,896
TTITOLO_RNI National reserve entitlements 4,165

Entitlement activation

Table Description Rows
TTIT_ATTIVAZIONE Entitlement activation 2,380,178
TTIT_ATTIVAZIONE_PC Activation per crop plan 5,054,858
TTIT_ACCERTAMENTO Entitlement verification 62,668
TTIT_CONFERMA Entitlement confirmation 105,896
TTIT_AGGIORNAMENTO Entitlement updates 19,645
TTIT_SCADENZA Entitlement expiry 14

Convergence

Table Description Rows
TTIT_CONVERGENZA Entitlement convergence 105,896
TTIT_CONVERGENZA_CLC Convergence calculations 105,896
TTIT_CONVERGENZA_LOG Convergence log 0

Definition tables

Table Description Rows
TTIT_DEF_TITOLO Entitlement type definitions 29
TTIT_DEF_CONVERGENZA Convergence definitions 10
TTIT_DEF_TIPO_TRASFERIMENTO Transfer type definitions 8
TTIT_DEF_STATO Entitlement status definitions 10
TTIT_DEF_ORIGIN Entitlement origin definitions 10

Key columns

TTITOLO (Entitlement)

Column Type Nullable Description
ID_TITOLO NUMBER N Entitlement ID
ID_SOGGETTO NUMBER N Owner subject ID
COD_TITOLO VARCHAR2(50) Y Entitlement code
VALORE NUMBER Y Unit value
SUPERFICIE NUMBER Y Surface area (ha)
UBA NUMBER Y Livestock units (for coupled)
COD_TIPO_TITOLO VARCHAR2(20) Y Entitlement type code
ANNO_CAMPAGNA NUMBER Y Campaign year
COD_STATO VARCHAR2(10) Y Status code
DT_DECORRENZA DATE Y Effective date
DT_SCADENZA DATE Y Expiry date
COD_ORIGINE VARCHAR2(20) Y Origin code
COD_REGIONE VARCHAR2(10) Y Region code

TTIT_ATTIVAZIONE (Activation)

Column Type Nullable Description
ID_ATTIVAZIONE NUMBER N Activation ID
ID_TITOLO NUMBER N Entitlement ID
ID_DOMANDA NUMBER N Application ID
ANNO_CAMPAGNA NUMBER Y Campaign year
SUP_ATTIVATA NUMBER Y Activated area
VALORE_ATTIVATO NUMBER Y Activated value
COD_STATO VARCHAR2(10) Y Status code

TTIT_TRASFERIMENTO (Transfer)

Column Type Nullable Description
ID_TRASFERIMENTO NUMBER N Transfer ID
ID_TITOLO NUMBER N Entitlement ID
ID_SOGGETTO_CEDENTE NUMBER N Transferor subject ID
ID_SOGGETTO_CESSIONARIO NUMBER N Transferee subject ID
COD_TIPO_TRASFERIMENTO VARCHAR2(10) Y Transfer type
DT_TRASFERIMENTO DATE Y Transfer date
SUP_TRASFERITA NUMBER Y Transferred area
VALORE_TRASFERITO NUMBER Y Transferred value

Data flow

See diagram: Entitlements Data Flow

Integration points

Inbound

  • National Registry: SIAN/AGEA national entitlement registry
  • Applications: BPS applications provide eligible hectares
  • Transfers: Entitlement transfers between beneficiaries

Outbound

  • Payments: Activated entitlements determine BPS payment amounts
  • Controls: Entitlement checks for over-claims
  • Reporting: Entitlement portfolio reports

Key packages

Package Purpose
TITOLI_PCK Entitlement management
TITOLI_ROUTINE_PCK Entitlement processing routines
BPS_ROUTINE_PCK BPS processing
CONVERGENZA_PCK Convergence calculations
TRASFERIMENTO_PCK Transfer processing

Key views

View Purpose
VTITOLO Entitlement summary view
VTIT_ATTIVAZIONE Activation view
VTIT_PORTAFOGLIO Entitlement portfolio
VTIT_DISPONIBILE Available entitlements
VTIT_TRASFERIMENTO Transfer view

Entitlement types

Entitlement types are defined in TTIT_DEF_TITOLO:

Code Description
BPS Basic Payment Scheme
SAPS Single Area Payment Scheme
RNI National Reserve
SPEC Special entitlements

Convergence

The CAP requires entitlement values to converge towards a national/regional average. This is tracked in:

  • TTIT_CONVERGENZA: Convergence parameters per entitlement
  • TTIT_CONVERGENZA_CLC: Calculated convergence adjustments
  • TTIT_DEF_CONVERGENZA: Convergence rules by year

Two-year rule

Entitlements not activated for two consecutive years are clawed back to the national reserve. Expiry is tracked in:

  • TTIT_SCADENZA: Expiry records
  • TTITOLO.DT_SCADENZA: Expiry date on main record

Quick reference

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