Commitments Module
Module purpose
The Commitments module manages multi-annual agri-environment commitments undertaken by farmers. These include AECM (Agri-Environment-Climate Measures), M11 (Organic Farming), LFA/ANC (Areas facing Natural Constraints) and similar schemes requiring multi-year obligations on specific parcels.
Key tables
Core tables
| Table |
Description |
Rows |
TCOM_COMMITMENT |
Main commitment records |
114,789 |
TCOM_COM_PARTICELLA |
Parcels under commitment |
1,589,667 |
TCOM_COM_ARBOREO |
Tree/permanent crop commitments |
135,904 |
TCOM_COM_DOMANDA |
Claims linked to commitments |
69,786 |
TCOM_COM_CONTRATTO |
Commitment contracts |
19,356 |
TCOM_LOG_MOVIMENTO |
Commitment workflow log |
108,666 |
TCOM_CNT_REGISTRO |
Commitment control register |
295,190 |
Definition tables
| Table |
Description |
Rows |
TCOM_DEF_COMMITMENT |
Commitment type definitions |
42 |
TCOM_DEF_WORKFLOW |
Workflow definitions |
2,147 |
TCOM_DEF_REGOLA |
Rule definitions |
32 |
TCOM_DEF_STATO_EDIT |
Edit state definitions |
450 |
TCOM_DEF_METADATA |
Metadata definitions |
2 |
Supporting tables
| Table |
Description |
Rows |
TCOM_COM_BEE_BOXES |
Beekeeping box commitments |
4,135 |
TCOM_COM_BEE_BOXES_MOV |
Bee box movements |
3,438 |
TCOM_COM_ANIMALE |
Animal-related commitments |
7,035 |
TCOM_COM_ORGANIC |
Organic farming records |
360 |
TCOM_COM_CROPS |
Crop-specific commitments |
3,163 |
TCOM_COM_SOM |
Self-declared commitments |
30,524 |
TCOM_COM_TRASFERIMENTO |
Commitment transfers |
6,064 |
TCOM_LOG_REFRESH |
Refresh log |
408,214 |
Key columns
TCOM_COMMITMENT (Main Commitment)
| Column |
Type |
Nullable |
Description |
PKID |
NUMBER |
N |
Primary key |
ID_COMMITMENT |
NUMBER |
N |
Unique commitment identifier |
COD_COMMITMENT |
VARCHAR2(20) |
N |
Commitment code |
ID_TIPO_COMMITMENT |
NUMBER |
N |
Link to commitment type definition |
ID_SOGGETTO |
NUMBER |
N |
Link to subject/farmer |
ANNO_INIZIO |
NUMBER |
N |
Start year |
ANNO_FINE |
NUMBER |
N |
End year |
COD_STATO / SCO_STATO |
VARCHAR2(6) |
N/Y |
Current status |
DT_INIZIO / DT_FINE |
DATE |
N |
Validity period |
DT_ULTIMO_AGG |
DATE |
N |
Last update timestamp |
TCOM_COM_PARTICELLA (Commitment Parcels)
| Column |
Type |
Nullable |
Description |
ID_COMMITMENT |
NUMBER |
N |
Link to commitment |
ANNO |
NUMBER |
N |
Campaign year |
COD_NAZIONALE |
VARCHAR2(4) |
N |
National code (locality) |
FOGLIO |
NUMBER |
N |
Map sheet |
PARTICELLA |
VARCHAR2(5) |
N |
Parcel number |
SUB |
VARCHAR2(3) |
N |
Sub-parcel |
AREA |
NUMBER |
Y |
Committed area (sqm) |
TCOM_DEF_COMMITMENT (Commitment Types)
| Column |
Type |
Nullable |
Description |
ID_TIPO_COMMITMENT |
NUMBER |
N |
Type identifier |
DS_TIPO_COMMITMENT |
VARCHAR2(250) |
N |
Description |
DURATA |
NUMBER |
Y |
Duration in years |
COD_INTERVENTO |
VARCHAR2(20) |
Y |
Intervention code |
ID_TIPO_CONTRATTO |
NUMBER |
Y |
Link to contract type |
Data flow
See diagram: 
Integration points
Inbound
- Applications: Annual claims create/update commitment records
- Dossier: Commitments link to farm registry via
ID_SOGGETTO
- Crop Plan: Parcel data from
TPIANO_COLTURE validates commitment parcels
Outbound
- Payments: Approved commitments trigger AECM/M11/ANC payments
- Selection: Commitments feed into control sampling
- Contracts: Long-term commitments link to formal contracts
- Reporting: Commitment data for EU RDP indicators
Key packages
| Package |
Purpose |
COMMITMENTS |
Main commitment processing |
COMMITMENT_UTILS |
Commitment utilities |
COMMITMENTS_ROUTINE_PCK |
Commitment workflow routines |
COM_COMMITMENTS_UTILS |
Additional commitment utilities |
COM_CONTROLLO |
Commitment control logic |
COM_CNT_CONTROLLO |
Commitment control checks |
Key views
| View |
Purpose |
COMMITMENT_HEADER_INFO |
Commitment header summary |
COMMITMENT_PARCELS_INFO |
Commitment parcel details |
PARCEL_COMMITMENT |
Parcel-commitment linking |
PARCEL_COMMITMENT_CROPS |
Commitment crops by parcel |
VIEW_AECM_CONTRACT_STATUS |
AECM contract status |
VIEW_M11_CONTRACT_STATUS |
M11 contract status |
VAECM_CONTRACT_STATUS |
AECM contract status view |
Configuration
Commitment types are defined in TCOM_DEF_COMMITMENT:
DURATA: Standard commitment duration (typically 5-7 years)COD_INTERVENTO: Links to RDP intervention codesID_TIPO_CONTRATTO: Links to formal contract type if applicable
Workflow transitions are configured in TCOM_DEF_WORKFLOW and linked to TWOR_DEF_WORKFLOW.
Quick reference
- Acronyms — full abbreviation list
- Glossary — term definitions and Italian translations
- Home — system overview