Datadictionary OpenWave 3.1.32

View: vwmilzwemlabanalysekop

Schema

public

Owner

waveuser005

Descriptions

Haalt de gegevens van de labuitslagkoppen op. Basistabel tbmilzwemlabanalysekop

Fields

Rules

Indices

There are no indices for table vwmilzwemlabanalysekop

Definition

CREATE VIEW public.vwmilzwemlabanalysekop (
   dnkeylabanalysekop,
   dnkeymilinrichtingen,
   dvobjectnaamvoorlab,
   dvinrichtingnaam,
   dnkeyobject,
   dvobjectnaam,
   dnkeylaboratorium,
   dvlaboratoriumnaam,
   dvmonstercode,
   ddmonsterdatum,
   dlklasse1overtredingen,
   dlklasse2overtredingen,
   dlklasse3overtredingen,
   dlvervallen,
   ddontvangstdatum)
AS
SELECT labkop.dnkey AS dnkeylabanalysekop,
   obj.dnkeymilinrichtingen,
   obj.dvobjectnaamvoorlab,
   inr.dvinrichtingnaam,
   labkop.dnkeyobject,
   obj.dvobjectnaam,
   labkop.dnkeylaboratorium,
   lab.dvlaboratoriumnaam,
   labkop.dvmonstercode,
   labkop.ddmonsterdatum,
   (
   SELECT
               CASE
                   WHEN ((
       SELECT sum(vwmilzwemlabanalyseregels.dfklasse1overtreding) AS sum
       FROM vwmilzwemlabanalyseregels
       WHERE vwmilzwemlabanalyseregels.dnkeyanalysekop = labkop.dnkey
       )) > 0 THEN 'T'::text
                   ELSE 'F'::text
               END AS "case"
   ) AS dlklasse1overtredingen,
   (
   SELECT
               CASE
                   WHEN ((
       SELECT sum(vwmilzwemlabanalyseregels.dfklasse2overtreding) AS sum
       FROM vwmilzwemlabanalyseregels
       WHERE vwmilzwemlabanalyseregels.dnkeyanalysekop = labkop.dnkey
       )) > 0 THEN 'T'::text
                   ELSE 'F'::text
               END AS "case"
   ) AS dlklasse2overtredingen,
   (
   SELECT
               CASE
                   WHEN ((
       SELECT sum(vwmilzwemlabanalyseregels.dfklasse3overtreding) AS sum
       FROM vwmilzwemlabanalyseregels
       WHERE vwmilzwemlabanalyseregels.dnkeyanalysekop = labkop.dnkey
       )) > 0 THEN 'T'::text
                   ELSE 'F'::text
               END AS "case"
   ) AS dlklasse3overtredingen,
   (
   SELECT
               CASE
                   WHEN ((
       SELECT count(vwmilzwemlabanalyseregels.dlvervallen) AS count
       FROM vwmilzwemlabanalyseregels
       WHERE vwmilzwemlabanalyseregels.dnkeyanalysekop = labkop.dnkey AND
           vwmilzwemlabanalyseregels.dlvervallen = 'T'::text
       )) > 0 THEN 'T'::text
                   ELSE 'F'::text
               END AS "case"
   ) AS dlvervallen,
   labkop.ddontvangstdatum
FROM tbmilzwemlabanalysekop labkop
    LEFT JOIN tbmilzwemobjecten obj ON labkop.dnkeyobject = obj.dnkey
    LEFT JOIN vwmilzwemext inr ON obj.dnkeymilinrichtingen = inr.dnkeymilinrichtingen
    LEFT JOIN tbmilzwemlaboratoria lab ON labkop.dnkeylaboratorium = lab.dnkey;

COMMENT ON VIEW public.vwmilzwemlabanalysekop
IS 'Haalt de gegevens van de labuitslagkoppen op. Basistabel tbmilzwemlabanalysekop';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49