Applications and Forms

Purpose

The Applications' module manages the intake, validation, processing and workflow of aid applications (domande) submitted by farmers. It handles the complete lifecycle from submission through checks, calculations and final determination.

Table of Contents

Application types

Three main types of applications (from VDOSSIER_BATCH_REPORT_2024):

Type Name Description
ANC Areas of Natural Constraints Payments for farming in challenging areas
DP Direct Payments Income support schemes (BISS, YFS, VCS, SFS)
AECC Agri-Environment-Climate Commitments Voluntary environmental measures

Key tables

Core tables

Table Description Rows
TDOM_DOMANDA Main applications table containing all submitted claims 1,852,236
TDOM_MOVIMENTO_V1 Application workflow state transitions 2,184,580
TDOM_CHECK_ESITO Check/validation results for applications 4,363,648
TDOM_CLC_REGISTRO Calculation register for aid computations 2,764,547
TDOM_CNT_REGISTRO Control register for validation runs 487,612
TDOM_LOG_TRANSITION Workflow transition audit log 247,648
APPLICATION_LISTING_INFO Application summary view data 151,050

Definition tables

Table Description Rows
TDOM_MODULO_DECO Application module definitions 778
TDOM_SCHEDA_MODULO Form/card definitions within modules 5,878
TDOM_DEF_PROGRESS_STATUS Progress status definitions 122
TDOM_DEF_WORKFLOW_GROUP Workflow group definitions 147
TDOM_MODULO_RELAZIONE Module relationship definitions 4,847

Supporting tables

Table Description Rows
TDOM_SOGGETTO_LOCK Subject locks during processing 60,583
TDOM_STAMPA_LOG Print/report log 23,270
TDOM_STATO_WORKFLOW Workflow state records 36,797
TDOM_WIZ_REQUEST Wizard request records 5,869
TDOM_UPLOAD_FILE Uploaded file records 328

Key columns

TDOM_DOMANDA (Main Application)

Column Type Nullable Description
PKID NUMBER N Primary key
ID_DOMANDA NUMBER N Unique application identifier
ID_SOGGETTO NUMBER N Link to subject/farmer
ID_MODULO NUMBER N Link to module definition
COD_DOMANDA VARCHAR2(4000) Y Application code
COD_STATO / SCO_STATO VARCHAR2(6) N Current status code
DT_INIZIO / DT_FINE DATE N Validity period
ID_DOMANDA_RETTIFICATA NUMBER Y Link to rectified application
ID_ENTE NUMBER Y Link to agency/entity
DT_ULTIMO_AGG DATE N Last update timestamp
UTENTE VARCHAR2(20) N User who last modified

TDOM_MOVIMENTO_V1 (Workflow Movements)

Column Type Nullable Description
ID_MOVIMENTO NUMBER N Movement identifier
ID_DOMANDA NUMBER N Link to application
ID_WORKFLOW NUMBER N Link to workflow definition
DT_MOVIMENTO DATE N Movement timestamp
ID_REGISTRO NUMBER Y Link to register
NOTE VARCHAR2(4000) Y Movement notes

TDOM_CHECK_ESITO (Check Results)

Column Type Nullable Description
ID_CHECK_ESITO NUMBER N Check result identifier
ID_DOMANDA NUMBER N Link to application
ID_CHECK NUMBER N Link to check definition
ESITO VARCHAR2(1) N Result (P=Pass, F=Fail, etc.)
COD_STATO_DOMANDA VARCHAR2(6) N Application status at check time
NOTE VARCHAR2(4000) Y Check notes

Data flow

See diagram:

Applications Data Flow
Applications Data Flow

Integration points

Inbound

  • Dossier Module: Applications link to farm dossiers via ID_SOGGETTO
  • Import Module: Bulk application imports via TIMP_* tables
  • Portal: Web submissions populate TDOM_DOMANDA

Outbound

  • Commitments: Applications create/update commitments (TCOM_COM_DOMANDA)
  • Payments: Approved applications trigger payment processing
  • Selection: Applications feed into selection/sampling (TSEL_*)
  • Reporting: Application data exported for EU reporting

Key packages

Package Purpose
APPLICATION_ROUTINE_PCK Core application workflow routines
APPLICATION_CAPSP_PCK CAP Strategic Plan application processing
BPS_ROUTINE_PCK BPS routines
BPS_RULES_PCK BPS business rules
BPS_DOMANDA BPS application processing
DOMANDA_PCK General application package
DOM_CLC_CALCOLO Application calculations
DOM_CNT_CONTROLLO Application controls
DOM_CONTROLLO Domain control logic
DOM_APPLICATION_UTILS Application utilities

Key views

View Purpose
TDOMANDA Main application view
TDOM_MODULO Module view
TDOM_MODULO_WORKFLOW Module workflow view
TDOM_MOVIMENTO Movement view
APPLICATIONS_STATUS Application status summary
APPS_DETAILS Application details
APPS_FLOW Application workflow flow
APPS_LAND_DETAILS Land details per application
APPS_LIV_DETAILS Livestock details per application

Configuration

Application modules are configured in TDOM_MODULO_DECO with:

  • COD_SETTORE / SCO_SETTORE: Sector codes
  • ANNO: Campaign year
  • COD_TIPO_DOMANDA: Application type
  • DT_APERTURA_TER / DT_CHIUSURA_TER: Submission window
  • COD_FUNZIONE: Function code
  • DURATA: Duration

Form sections within modules are defined in TDOM_SCHEDA_MODULO with eligibility rules linked via ELIGIBILITY_RULE to TRUE_DEF_RULE_LIB.

Quick reference

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