Datadictionary OpenWave 3.1.33

View: vwfrmmilparametervervaldatum

Schema

public

Owner

waveuser005

Descriptions

Haalt per object per parameter de vervaldatum op indien object open i.

Columns

Rules

Indices

There are no indices for table vwfrmmilparametervervaldatum

Definition

CREATE VIEW public.vwfrmmilparametervervaldatum (
   dnkeymilinrichtingen,
   dnkeyobject,
   dnkeyparameter,
   ddvervaldatum)
AS
SELECT dnkeymilinrichtingen,
   dnkeyobject,
   dnkeyparameter,
   max(ddvervaldatum) AS ddvervaldatum
FROM (
   SELECT kop.dnkeymilinrichtingen,
           kop.dnkeyobject,
           regels.dnkeyparameter,
               CASE
                   WHEN kop.dvrekeneenheid::text = 'm'::text THEN
                       make_date(EXTRACT(year
   FROM kop.ddmonsterdatum + (((kop.dfrekenwaarde + 1::double precision) ||
       ' MONTHS'::text)::interval))::integer, EXTRACT(month
   FROM kop.ddmonsterdatum + (((kop.dfrekenwaarde + 1::double precision) ||
       ' MONTHS'::text)::interval))::integer, 15)::timestamp without time zone
                   ELSE kop.ddmonsterdatum
               END AS ddvervaldatum
   FROM tbmilzwemlabanalyseregels regels
            JOIN vwmilzwemlabanalysekopparameterset kop ON
                regels.dnkeyanalysekop = kop.dnkeyanalysekop AND regels.dnkeyparameter = kop.dnkeyparameter AND kop.dlisopencombi = 'T'::text
   ) source
GROUP BY dnkeymilinrichtingen, dnkeyobject, dnkeyparameter;

COMMENT ON VIEW public.vwfrmmilparametervervaldatum
IS 'Haalt per object per parameter de vervaldatum op indien object open i.';

This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 21-10-2025 10:22