Datadictionary OpenWave 3.1.32

View: vwfrmmilparametervervaldatum

Schema

public

Owner

waveuser005

Descriptions

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

Fields

Rules

Indices

There are no indices for table vwfrmmilparametervervaldatum

Definition

CREATE VIEW public.vwfrmmilparametervervaldatum (
   dnkeymilinrichtingen,
   dnkeyobject,
   dnkeyparameter,
   ddvervaldatum)
AS
SELECT source.dnkeymilinrichtingen,
   source.dnkeyobject,
   source.dnkeyparameter,
   max(source.ddvervaldatum) AS ddvervaldatum
FROM (
   SELECT kop.dnkeymilinrichtingen,
           kop.dnkeyobject,
           regels.dnkeyparameter,
               CASE
                   WHEN kop.dvrekeneenheid::text = 'm'::text THEN
                       make_date(date_part('year'::text, kop.ddmonsterdatum + (((kop.dfrekenwaarde + 1::double precision) || ' MONTHS'::text)::interval))::integer, date_part('month'::text, 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 source.dnkeymilinrichtingen, source.dnkeyobject, source.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.pgsqlmanager.com) at 2-5-2025 13:49