Funding Applications

Applications submitted to Funding Programs for specific Projects/Scenarios. Track the full lifecycle from eligibility check through approval and disbursement. Each application references a specific program version and contains measures, adjustments, and loans.

Source Files

Layer	Path
Schema	backend/src/db/schema.ts
Routes	backend/src/routes/funding-applications.ts
Service	backend/src/services/funding-application-service.ts
Calculator	backend/src/lib/funding-calculator.ts
Pages	frontend/src/pages/FundingApplications.tsx
Components	frontend/src/components/ (root: FundingApplicationCard.tsx, …) + components/funding-application-form/, components/funding-applications/
Frontend Lib	frontend/src/lib/funding/ (fundingFormService.ts, useFundingFormState.ts)
Queries	frontend/src/lib/queries/fundingApplicationQueries.ts

Database Tables

Table	Purpose
funding_applications	Main entity — program version, state, amounts, approval tracking
funding_measures	Individual measures within an application (cost, area, eligibility, rates)
funding_adjustments	Bonuses/deductions applied at measure, category, or program scope
funding_loans	Loan-specific details for loan-based programs (KfW)

Key Fields — Applications

Field	Type	Notes
buildingId	uuid FK	Parent building (cascade)
projectId	uuid FK	Parent project (cascade)
fundingProgramVersionId	uuid FK	References specific Funding Programs version
state	varchar	Application lifecycle state
totalEligibleCosts / totalEligibleArea	decimal	Aggregated from measures
calculatedFundingAmount / fundingAmount	decimal	System-calculated vs. actual
applicationDate / applicationReference	timestamp/varchar	Submission tracking
approvalDate / approvedFundingAmount	timestamp/decimal	Approval tracking
disbursedAmount	decimal	Actual payout received
isCombinable	boolean	Whether combinable with other funding
sourceFundingApplicationId	uuid FK	Self-referential for application variants

Key Fields — Measures

Field	Type	Notes
componentId	uuid FK	Optional link to Building Components
fundingProgramMeasureId	uuid FK	Links to program measure definition
measureCost / measureArea	decimal	Cost and area for this measure
fundingRate / calculatedAmount	decimal	Calculated funding values
eligibleCost / eligibleArea	decimal	Eligible amounts after caps
isEligible	boolean	Whether measure meets program criteria
calculationBasis	enum	How funding is calculated

Relationships

Funding Application *──1 Building
Funding Application *──1 Project
Funding Application *──1 Funding Program Version
Funding Application 1──* Funding Measures ──* Building Components
Funding Application 1──* Funding Adjustments
Funding Application 1──* Funding Loans
Funding Application *──* Quotes (via funding_quote_allocations)
Funding Application *──* Invoices (via funding_invoice_allocations)

Frontend Components

Component	Purpose
FundingApplicationCard	Summary card for a single application
FundingApplicationFormDialog	Create/edit application with measure configuration
CreateFundingApplicationWithProjectDialog	Quick-create with project selection
InlineFundingApplicationsTable	Compact table within Quotes/Invoices views
BuildingFundingApplicationsList	Applications scoped to a building
ProjectFundingApplications	Applications within a project detail view
ScenarioFundingApplications	Applications within a scenario view

Money Handling

All amount columns are decimal(12,2) — they leave Drizzle as strings and stay decimal strings on the wire. Arithmetic uses Big.js via @shared/money (fromString, add/sub/mul/div, round(m, 2) HALF_UP); never Number()/parseFloat() on money columns (spec 2026-04-24-money-arithmetic-bigjs-design.md).

Features

• Eligibility checking based on program version rules and building characteristics
• Funding calculation via funding-calculator.ts — applies rates, caps, and bonuses
• Adjustment system with three scopes: program-wide, category-level, measure-level
• Loan calculations for KfW programs (numberOfDwellings x loanPerDwelling)
• Combinability tracking for stacking multiple funding sources
• Application variants via sourceFundingApplicationId self-reference
• Cross-entity linking to Quotes and Invoices via allocation tables

Related Pages

Funding Programs | Projects | Buildings | Scenarios | Measures | Building Components | Quotes | Invoices | Financial Calculations | Energy Calculations | Database Architecture