Fuentes de Financiación Maestras

Modo Maestro

Fuentes de Financiación Maestras

Catálogo base de fuentes de financiación que heredan todos los tenants. Define el origen de los recursos para apropiaciones presupuestales.

Total Fuentes

Activas

Tenants Sincronizados

7 / 7

Filtros:

Código	Nombre	Tipo	Reembolsable	Estado
FF-SGP	SGP — Gratuidad Educativa	No Reembolsable	—	Activa
FF-CAL	SGP — Calidad Educativa	No Reembolsable	—	Activa
FF-FSE	Fondos de Servicios Educativos (FSE)	No Reembolsable	—	Activa
FF-RP	Recursos Propios	No Reembolsable	—	Activa

-- ============================================================ -- TABLA: master_funding_sources -- Módulo: Gestor de Fuentes de Financiación Maestras (SA) -- Contexto: catálogo maestro plano; sin tenant_id (Super Admin) -- se hereda a tenants vía tenant_funding_sources -- ============================================================ CREATE TABLE master_funding_sources ( id UUID STORAGE PLAIN DEFAULT gen_random_uuid() NOT NULL, code VARCHAR(20) NOT NULL, -- formato FF-[A-Z0-9-]+, inmutable post-creación name_short VARCHAR(100) NOT NULL, -- nombre de la fuente (3–100 chars) name_long VARCHAR(300), -- descripción / marco normativo (opcional, max 300) type VARCHAR(30) NOT NULL, -- enum cerrado: ver CHECK abajo is_reimbursable BOOLEAN NOT NULL DEFAULT false, -- genera obligación de pago futuro (deuda) icon_id INTEGER STORAGE PLAIN NOT NULL, state_id VARCHAR(100) NOT NULL, origin_id INTEGER STORAGE PLAIN NOT NULL, created_at TIMESTAMP WITH TIME ZONE STORAGE PLAIN DEFAULT now() NOT NULL, updated_at TIMESTAMP WITH TIME ZONE STORAGE PLAIN DEFAULT now() NOT NULL, created_by UUID STORAGE PLAIN NOT NULL, updated_by UUID STORAGE PLAIN NOT NULL, archived_at TIMESTAMP WITH TIME ZONE STORAGE PLAIN, archived_by UUID STORAGE PLAIN, CONSTRAINT pk_master_funding_sources PRIMARY KEY (id), CONSTRAINT uq_mfs_code UNIQUE (code), CONSTRAINT chk_mfs_type CHECK (type IN ( 'recursos_propios', 'transferencias', 'credito_interno', 'credito_externo', 'cofinanciacion', 'donaciones', 'recursos_balance', 'regalias', 'otros' )), CONSTRAINT fk_mfs_icon FOREIGN KEY (icon_id) REFERENCES icons(id), CONSTRAINT fk_mfs_origin FOREIGN KEY (origin_id) REFERENCES origins(id), CONSTRAINT fk_mfs_created FOREIGN KEY (created_by) REFERENCES users(id), CONSTRAINT fk_mfs_updated FOREIGN KEY (updated_by) REFERENCES users(id), CONSTRAINT fk_mfs_archby FOREIGN KEY (archived_by) REFERENCES users(id) ); -- Índices operacionales CREATE INDEX idx_mfs_code ON master_funding_sources (code); CREATE INDEX idx_mfs_type ON master_funding_sources (type) WHERE archived_at IS NULL; CREATE INDEX idx_mfs_state ON master_funding_sources (state_id) WHERE archived_at IS NULL; CREATE INDEX idx_mfs_reimbursable ON master_funding_sources (is_reimbursable) WHERE archived_at IS NULL; -- ============================================================ -- NOTAS DE INTEGRIDAD REFERENCIAL (cadena hacia tenants) -- ============================================================ -- La FK desde tenant_funding_sources se define en el módulo tenant: -- ALTER TABLE tenant_funding_sources -- ADD CONSTRAINT fk_tfs_master_source -- FOREIGN KEY (master_source_id) REFERENCES master_funding_sources(id) -- ON DELETE RESTRICT; -- -- Las FKs desde tablas de presupuestación/ejecución apuntan a tenant_funding_sources: -- tenant_apropiacion.source_id → tenant_funding_sources(id) ON DELETE RESTRICT -- tenant_cdp.source_id → tenant_funding_sources(id) ON DELETE RESTRICT -- tenant_rp.source_id → tenant_funding_sources(id) ON DELETE RESTRICT -- tenant_obligacion.source_id → tenant_funding_sources(id) ON DELETE RESTRICT -- tenant_orden_pago.source_id → tenant_funding_sources(id) ON DELETE RESTRICT -- -- Soft delete: archivar = archived_at = NOW() + archived_by = currentUser -- Hard delete prohibido. El backend verifica dependencias antes de archivar → 409 HAS_DEPENDENCIES. -- ============================================================

Fuentes de Financiación Maestras

Nueva Fuente