Contracts Module

Module purpose

The Contracts module manages investment contracts under Rural Development Programme (RDP) measures. These include farm modernisation (M4.1, M4.4), processing investments (M4.2), infrastructure projects and other capital investment schemes requiring formal grant agreements.

Key tables

Core tables

Table Description Rows
TCON_CONTRATTO Main contract records 52,220
TCON_CONT_COMPONENTE Contract cost components/line items 1,247,234
TCON_CONT_IMPORTO Contract amounts by type 47,297
TCON_CONT_RICEVUTA Contract receipts/invoices 34,237
TCON_LOG_MOVIMENTO Contract workflow log 49,989
TCON_LOG_STAMPA Contract print log 13,613

Definition tables

Table Description Rows
TCON_DEF_CONTRATTO Contract type definitions 63
TCON_DEF_CONTRATTO_FASE Contract phase definitions 665
TCON_DEF_CONTRATTO_MODULO Contract module definitions 109
TCON_DEF_WORKFLOW Workflow definitions 2,288
TCON_DEF_REGOLA Rule definitions 19
TCON_DEF_STATO_EDIT Edit state definitions 587
TCON_DEF_STATO_STAMPA Print state definitions 971
TCON_DEF_EMAIL Email template definitions 67
TCON_DEF_DURABILITY_MATRIX Durability requirements 30

Supporting tables

Table Description Rows
TCON_CONT_FATTURA Contract invoices 12,533
TCON_CONT_MACCHINA Machinery/equipment 3,074
TCON_CONT_FABBRICATO Buildings/structures 600
TCON_CONT_FIDEIUSSIONE Guarantees 106
TCON_CONT_ENTE Related entities 20,864
TCON_CONT_SOGGETTO Related subjects 20,930
TCON_CONT_PUNTI Scoring points 16,906
TCON_CONT_DOMANDA Linked applications 5,172
TCON_CONT_DISBUR_SCHED Disbursement schedules 2,201
TCON_CONT_IMPL_SCHED Implementation schedules 2,981
TCON_CONT_CAPPING Capping records 53
TCON_CONT_PERMIT Permits 150
TCON_CONT_SUPPLIER Suppliers 54
TCON_CONT_DURABILITY Durability tracking 38
TCON_CONT_FORECAST Forecasts 99
TCON_CONT_EMAIL_MAINTENANCE Email maintenance 222
TCON_CONT_IMPORTO_HISTORY Amount history 8,523
TCON_CONT_PPR_EXPIRY PPR expiry tracking 386

Key columns

TCON_CONTRATTO (Main Contract)

Column Type Nullable Description
PKID NUMBER N Primary key
ID_CONTRATTO NUMBER N Unique contract identifier
COD_CONTRATTO VARCHAR2(50) Y Contract code
ID_TIPO_CONTRATTO NUMBER N Link to contract type
DS_CONTRATTO VARCHAR2(4000) Y Description
COD_STATO / SCO_STATO VARCHAR2(6) N Current status
DT_INIZIO / DT_FINE DATE N Validity period
DT_ULTIMO_AGG DATE N Last update timestamp

TCON_CONT_COMPONENTE (Cost Components)

Column Type Nullable Description
ID_CONTRATTO NUMBER N Link to contract
ID_COMPONENTE NUMBER N Component identifier
ID_AZIONE NUMBER Y Link to action/measure
COD_ATTIVITA VARCHAR2(6) N Activity code
DS_COMPONENTE VARCHAR2(4000) Y Description
IMPORTO_NETTO NUMBER N Net amount
IMPORTO_TASSA NUMBER N VAT amount
IMPORTO_ELEGGIBILE NUMBER N Eligible amount
IMPORTO_RISPARMIO NUMBER N Savings amount
IMPORTO_PAGATO NUMBER N Paid amount

TCON_CONT_IMPORTO (Contract Amounts)

Column Type Nullable Description
ID_CONTRATTO NUMBER N Link to contract
IMPORTO NUMBER N Amount
COD_TIPO / SCO_TIPO VARCHAR2(6) N Amount type

Data flow

See diagram: Contracts Data Flow

Integration points

Inbound

  • Applications: Project proposals create contracts after ranking
  • Dossier: Contracts link to beneficiary dossiers
  • Ranking: Ranked projects create contracts via TGRAD_*

Outbound

  • Payments: Approved invoices trigger disbursements
  • Commitments: Some contracts create linked commitments
  • Reporting: Contract data for EU RDP indicators
  • OTS: Contracts feed into on-the-spot inspection selection

Key packages

Package Purpose
CONTRATTO Main contract processing
CON_CONTROLLO Contract control logic
CON_QUADRO_PCK Contract form processing
PSR_QUADRO_PCK PSR form processing
PSR_QUADRO_PILLAR_II_PCK Pillar II form processing
PSR_CONTROLLO PSR control logic
PSR_CNT_CONTROLLO PSR control checks
CAP_SP_MA_RULES CAP SP management authority rules
CAP_SP_MA_TASKS CAP SP management authority tasks
CAP_SP_MA_UTILS CAP SP utilities

Key views

View Purpose
TCONTRACT_HISTORY_REPORT Contract history
VIEW_RD_INVESTMENT_DATA_1420 RD investment data 2014-2020
VW_RD_INVEST_DATA_LINE_ITEMS RD line items
TRD_INV_DATA_VIEW RD investment data view
V_CAPSP_INVESTMENT_DATA CAP SP investment data
V_CAPSP_INVESTMENT_DATA_LINE_ITEMS CAP SP line items

PSR project tables

Table Description Rows
TQDO_PSR_PROGETTO PSR project details 6,702
TQDO_PSR_IMPEGNO_PARTICELLA Project parcel commitments 1,393,031
TQDO_PSR_IMPEGNO_AZIONE Project action commitments 77,147
TQDO_PSR_PROGETTO_COMPONENTE Project components 25,037
TQDO_PSR_PROGETTO_ATTIVITA Project activities 22,219
TQDO_PSR_PROGETTO_PIANO Project plans 58,996
TQDO_PSR_PROGETTO_CLASSE Project classifications 6,012
TQDO_PSR_PROGETTO_CONSEGUENZA Project consequences 852
TQDO_PSR_COMPONENTE_FATTURA Project invoices 48,896
TQDO_PSR_COMPONENTE_IMPLEMEN Implementation components 5,055
TQDO_PSR_COMPONENTE_DISBUR Disbursement components 3,970

Configuration

Contract types are defined in TCON_DEF_CONTRATTO:

  • DS_TIPO_CONTRATTO: Description
  • DT_INIZIO / DT_FINE: Validity period

Phases within contracts are configured in TCON_DEF_CONTRATTO_FASE and linked to workflow definitions in TCON_DEF_WORKFLOW.

Quick reference

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