Funding Programs

Government and institutional funding programs for building renovations. Covers federal (KfW, BAFA), state (IFB Hamburg), regional, and municipal programs. Programs are versioned to track rule changes over time.

Source Files

Layer	Path
Schema	backend/src/db/schema.ts (line ~1296)
Routes	backend/src/routes/funding-programs.ts
Admin Routes	backend/src/routes/admin/funding-programs/ (programs.ts, versions.ts, measures.ts, loans.ts)
Admin Pages	frontend/src/pages/admin/FundingProgramsList.tsx, FundingProgramDetail.tsx
Admin Forms	frontend/src/pages/admin/FundingProgramForm.tsx, FundingProgramVersionForm.tsx, FundingProgramMeasureForm.tsx, FundingProgramLoanForm.tsx
Queries	frontend/src/lib/queries/fundingProgramQueries.ts

Database Tables

Table	Purpose
funding_programs	Main entity — name, provider, type, validity period
funding_program_versions	Versioned rules — rates, max amounts, bonuses, validity windows

Key Fields — Programs

Field	Type	Notes
name	varchar(255)	Program name (e.g., “KfW BEG WG”)
provider	varchar(255)	Issuing body — KfW, BAFA, IFB Hamburg, etc.
type	enum	federal, state, regional, municipal, private
isActive	boolean	Whether the program is currently accepting applications
validFrom / validTo	timestamp	Program availability window

Key Fields — Versions

Field	Type	Notes
versionNumber	varchar	Version identifier
baseFundingRate	decimal	Base percentage for funding calculation
maxFundingAmount	decimal	Cap per application
maxEligibleCosts	decimal	Maximum eligible renovation costs
bonuses	jsonb	Array of bonus definitions (percentage, flat, per-unit) with applicability rules
applicationUrl	varchar	Link to official application form

Seed Data

Real German funding programs are seeded via backend/src/db/seeds/:

Program	Provider	Type
KfW BEG WG	KfW	Federal (loan-based)
KfW BEG EM	KfW	Federal (loan-based)
BAFA BEG EM	BAFA	Federal (grant-based)
IFB Hamburg	IFB	State (regional)

Bonus System

Versions support a flexible bonus structure stored in the bonuses JSONB column:

• Calculation types: percentage, flat_amount, per_unit
• Apply-to targets: eligible_cost, funding_amount, area, quantity
• Scoping rules: filter by measure IDs, measure types, measure categories, component types

Relationships

Funding Program 1──* Funding Program Versions
Funding Program Version 1──* Funding Program Measures
Funding Program Version 1──* Funding Program Loans
Funding Program Version *──* Funding Applications (via applications)

Features

• Version management — different rules over time, only one active per program
• Measure definitions per version specifying eligible renovation types and rates
• Loan definitions for loan-based programs (KfW) with per-dwelling calculations
• Bonus configuration with hierarchical applicability rules
• Admin management via Admin Dashboard with CRUD for programs, versions, measures, loans
• Calculator integration via Financial Calculations and backend/src/lib/funding-calculator.ts

Related Pages

Funding Applications | Measures | Financial Calculations | Energy Calculations | Admin Dashboard | Quotes | Invoices | Database Architecture