Datadictionary OpenWave 3.1.25

View: vwfrmalletaken2

Schema

public

Owner

waveuser005

Descriptions

View van alle openstaande taken m.b.t. processtappen (vwfrmeerstestapperproces), fataldedatums, verloopdatums en invorderingen en tot maximaal een instelbaar aantal dagen terug m.b.t adviezen, inspectiebezoeken, inspectietrajecten

Fields

Rules

Indices

There are no indices for table vwfrmalletaken2

Definition

CREATE VIEW public.vwfrmalletaken2 (
   dvmodule,
   dnkeymodule,
   dvtaakletter,
   dvmoduleoms,
   dvtaakoms,
   ddstreefdatum,
   dvbetreft,
   dvoorwie,
   dvomschrijving,
   dvinbehbij,
   dvobjadres,
   dvobjplaats,
   dvsoortzaak,
   dvinrichtingnaam,
   dvzaakcode,
   dvaanvrager,
   dvintzaakcode,
   dvgemeenteid,
   dvaction)
AS
SELECT vwfrmeerstestapperproces.dvmodule,
   vwfrmeerstestapperproces.dnkeymodule,
   'P'::text AS dvtaakletter,
       CASE
           WHEN vwfrmeerstestapperproces.dvmodule = 'B'::bpchar THEN 'bouw/sloop'::text
           WHEN vwfrmeerstestapperproces.dvmodule = 'C'::bpchar THEN 'horeca'::text
           WHEN vwfrmeerstestapperproces.dvmodule = 'E'::bpchar THEN
               'milieu/gebruik'::text
           WHEN vwfrmeerstestapperproces.dvmodule = 'H'::bpchar THEN 'handhaving'::text
           WHEN vwfrmeerstestapperproces.dvmodule = 'I'::bpchar THEN
               'infoaanvraag'::text
           WHEN vwfrmeerstestapperproces.dvmodule = 'O'::bpchar THEN 'apv/overig'::text
           WHEN vwfrmeerstestapperproces.dvmodule = 'W'::bpchar THEN 'omgeving'::text
           ELSE 'bestemmingsplan'::text
       END AS dvmoduleoms,
   'Processtap'::text AS dvtaakoms,
   vwfrmeerstestapperproces.dddeadline AS ddstreefdatum,
   vwfrmeerstestapperproces.dvomsaanvraag AS dvbetreft,
   vwfrmeerstestapperproces.dvstapbehandelaar AS dvoorwie,
   vwfrmeerstestapperproces.dvtermijnomschrijving AS dvomschrijving,
   vwfrmeerstestapperproces.dvdossierbehandelaar AS dvinbehbij,
   (vwfrmeerstestapperproces.dvobjstraat::text || ' '::text) ||
       vwfrmeerstestapperproces.dvobjhuisnummer::text AS dvobjadres,
   vwfrmeerstestapperproces.dvobjplaats,
   vwfrmeerstestapperproces.dvsoortverg AS dvsoortzaak,
   vwfrmeerstestapperproces.dvinrichtingnaam,
   vwfrmeerstestapperproces.dvzaakcode,
   vwfrmeerstestapperproces.dvaanvrager,
   vwfrmeerstestapperproces.dvintzaakcode,
   vwfrmeerstestapperproces.dvgemeenteid,
       CASE
           WHEN vwfrmeerstestapperproces.dvmodule = 'B'::bpchar THEN
               ('opentabpage(#bouwsloopdetail/'::text || vwfrmeerstestapperproces.dnkeymodule) || ')'::text
           WHEN vwfrmeerstestapperproces.dvmodule = 'O'::bpchar THEN
               ('opentabpage(#apvoverigdetail/'::text || vwfrmeerstestapperproces.dnkeymodule) || ')'::text
           WHEN vwfrmeerstestapperproces.dvmodule = 'V'::bpchar THEN
               ('opentabpage(#inrichtingdetail/'::text || vwfrmeerstestapperproces.dnkeymodule) || ')'::text
           WHEN vwfrmeerstestapperproces.dvmodule = 'E'::bpchar THEN
               ('opentabpage(#milieugebruikdetail/'::text || vwfrmeerstestapperproces.dnkeymodule) || ')'::text
           WHEN vwfrmeerstestapperproces.dvmodule = 'C'::bpchar THEN
               ('opentabpage(#horecadetail/'::text || vwfrmeerstestapperproces.dnkeymodule) || ')'::text
           WHEN vwfrmeerstestapperproces.dvmodule = 'W'::bpchar THEN
               ('opentabpage(#omgevingdetail/'::text || vwfrmeerstestapperproces.dnkeymodule) || ')'::text
           WHEN vwfrmeerstestapperproces.dvmodule = 'I'::bpchar THEN
               ('opentabpage(#infodetail/'::text || vwfrmeerstestapperproces.dnkeymodule) || ')'::text
           WHEN vwfrmeerstestapperproces.dvmodule = 'H'::bpchar THEN
               ('opentabpage(#handhavingdetail/'::text || vwfrmeerstestapperproces.dnkeymodule) || ')'::text
           ELSE ''::text
       END AS dvaction
FROM vwfrmeerstestapperproces
UNION ALL
SELECT vwfrmomgorkestrator_adv.dvmodule,
   vwfrmomgorkestrator_adv.dnkeymodule,
   'A'::text AS dvtaakletter,
       CASE
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'B'::bpchar THEN 'bouw/sloop'::text
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'C'::bpchar THEN 'horeca'::text
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'E'::bpchar THEN
               'milieu/gebruik'::text
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'H'::bpchar THEN 'handhaving'::text
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'I'::bpchar THEN
               'infoaanvraag'::text
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'O'::bpchar THEN 'apv/overig'::text
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'W'::bpchar THEN 'omgeving'::text
           ELSE 'bestemmingsplan'::text
       END AS dvmoduleoms,
   'Advies'::text AS dvtaakoms,
   vwfrmomgorkestrator_adv.ddrappeldatum AS ddstreefdatum,
   vwfrmomgorkestrator_adv.dvomsaanvraag AS dvbetreft,
   vwfrmomgorkestrator_adv.dvadviesbehandelaar AS dvoorwie,
   vwfrmomgorkestrator_adv.dvomschradviesinstantie AS dvomschrijving,
   vwfrmomgorkestrator_adv.dvdossierbehandelaar AS dvinbehbij,
   (vwfrmomgorkestrator_adv.dvobjstraat::text || ' '::text) ||
       vwfrmomgorkestrator_adv.dvobjhuisnummer::text AS dvobjadres,
   vwfrmomgorkestrator_adv.dvobjplaats,
   vwfrmomgorkestrator_adv.dvsoortverg AS dvsoortzaak,
   vwfrmomgorkestrator_adv.dvinrichtingnaam,
   vwfrmomgorkestrator_adv.dvzaakcode,
   vwfrmomgorkestrator_adv.dvaanvrager,
   vwfrmomgorkestrator_adv.dvintzaakcode,
   vwfrmomgorkestrator_adv.dvgemeenteid,
       CASE
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'B'::bpchar THEN
               ('opentabpage(#bouwsloopdetail/'::text || vwfrmomgorkestrator_adv.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'O'::bpchar THEN
               ('opentabpage(#apvoverigdetail/'::text || vwfrmomgorkestrator_adv.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'V'::bpchar THEN
               ('opentabpage(#inrichtingdetail/'::text || vwfrmomgorkestrator_adv.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'E'::bpchar THEN
               ('opentabpage(#milieugebruikdetail/'::text || vwfrmomgorkestrator_adv.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'C'::bpchar THEN
               ('opentabpage(#horecadetail/'::text || vwfrmomgorkestrator_adv.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'W'::bpchar THEN
               ('opentabpage(#omgevingdetail/'::text || vwfrmomgorkestrator_adv.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'I'::bpchar THEN
               ('opentabpage(#infodetail/'::text || vwfrmomgorkestrator_adv.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_adv.dvmodule = 'H'::bpchar THEN
               ('opentabpage(#handhavingdetail/'::text || vwfrmomgorkestrator_adv.dnkeymodule) || ')'::text
           ELSE ''::text
       END AS dvaction
FROM vwfrmomgorkestrator_adv
UNION ALL
SELECT
       CASE
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'E'::bpchar THEN 'V'::bpchar
           ELSE vwfrmomgorkestrator_insp.dvmodule
       END AS dvmodule,
   vwfrmomgorkestrator_insp.dnkeymodule,
   'B'::text AS dvtaakletter,
       CASE
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'B'::bpchar THEN 'bouw/sloop'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'C'::bpchar THEN 'horeca'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'E'::bpchar THEN 'inrichting'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'H'::bpchar THEN 'handhaving'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'I'::bpchar THEN
               'infoaanvraag'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'O'::bpchar THEN 'apv/overig'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'W'::bpchar THEN 'omgeving'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'V'::bpchar THEN 'inrichting'::text
           ELSE 'bestemmingsplan'::text
       END AS dvmoduleoms,
   'Inspectiebezoek'::text AS dvtaakoms,
   vwfrmomgorkestrator_insp.ddbezoekgepland AS ddstreefdatum,
   vwfrmomgorkestrator_insp.dvaanleiding AS dvbetreft,
   vwfrmomgorkestrator_insp.dvbezoekinspecteur AS dvoorwie,
   vwfrmomgorkestrator_insp.dvsoortbezoek AS dvomschrijving,
   vwfrmomgorkestrator_insp.dvtrajectinspecteur AS dvinbehbij,
   (vwfrmomgorkestrator_insp.dvobjstraat::text || ' '::text) ||
       vwfrmomgorkestrator_insp.dvobjhuisnummer::text AS dvobjadres,
   vwfrmomgorkestrator_insp.dvobjplaats,
   vwfrmomgorkestrator_insp.dvsoortzaak,
   vwfrmomgorkestrator_insp.dvinrichtingnaam,
   vwfrmomgorkestrator_insp.dvzaakcode,
   vwfrmomgorkestrator_insp.dvaanvrager,
   vwfrmomgorkestrator_insp.dvintzaakcode,
   vwfrmomgorkestrator_insp.dvgemeenteid,
       CASE
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'B'::bpchar THEN
               ('opentabpage(#bouwsloopdetail/'::text || vwfrmomgorkestrator_insp.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'O'::bpchar THEN
               ('opentabpage(#apvoverigdetail/'::text || vwfrmomgorkestrator_insp.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'V'::bpchar THEN
               ('opentabpage(#inrichtingdetail/'::text || vwfrmomgorkestrator_insp.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'E'::bpchar THEN
               ('opentabpage(#inrichtingdetail/'::text || vwfrmomgorkestrator_insp.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'C'::bpchar THEN
               ('opentabpage(#horecadetail/'::text || vwfrmomgorkestrator_insp.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'W'::bpchar THEN
               ('opentabpage(#omgevingdetail/'::text || vwfrmomgorkestrator_insp.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'I'::bpchar THEN
               ('opentabpage(#infodetail/'::text || vwfrmomgorkestrator_insp.dnkeymodule) || ')'::text
           WHEN vwfrmomgorkestrator_insp.dvmodule = 'H'::bpchar THEN
               ('opentabpage(#handhavingdetail/'::text || vwfrmomgorkestrator_insp.dnkeymodule) || ')'::text
           ELSE ''::text
       END AS dvaction
FROM vwfrmomgorkestrator_insp
UNION ALL
SELECT vwfrmomgorkestrator_benb.dvmodule,
   vwfrmomgorkestrator_benb.dnkey AS dnkeymodule,
   'J'::text AS dvtaakletter,
       CASE
           WHEN vwfrmomgorkestrator_benb.dvmodule = 'B'::bpchar THEN 'bouw/sloop'::text
           WHEN vwfrmomgorkestrator_benb.dvmodule = 'C'::bpchar THEN 'horeca'::text
           WHEN vwfrmomgorkestrator_benb.dvmodule = 'H'::bpchar THEN 'handhaving'::text
           WHEN vwfrmomgorkestrator_benb.dvmodule = 'O'::bpchar THEN 'apv/overig'::text
           WHEN vwfrmomgorkestrator_benb.dvmodule = 'W'::bpchar THEN 'omgeving'::text
           ELSE 'bestemmingsplan'::text
       END AS dvmoduleoms,
   'Bezwaar/beroep'::text AS dvtaakoms,
   vwfrmomgorkestrator_benb.ingediend AS ddstreefdatum,
   vwfrmomgorkestrator_benb.dvomssoortbezwaar AS dvbetreft,
   vwfrmomgorkestrator_benb.accman AS dvoorwie,
   vwfrmomgorkestrator_benb.dvomschrijving,
   vwfrmomgorkestrator_benb.beh AS dvinbehbij,
   (vwfrmomgorkestrator_benb.straat::text || ' '::text) ||
       vwfrmomgorkestrator_benb.nr::text AS dvobjadres,
   vwfrmomgorkestrator_benb.plaats AS dvobjplaats,
   vwfrmomgorkestrator_benb.proceduresrt AS dvsoortzaak,
   vwfrmomgorkestrator_benb.dvinrichtingnaam,
   vwfrmomgorkestrator_benb.zaakcode AS dvzaakcode,
   vwfrmomgorkestrator_benb.dvaanvrager,
   vwfrmomgorkestrator_benb.dvintzaakcode,
   vwfrmomgorkestrator_benb.dvgemeenteid,
       CASE
           WHEN vwfrmomgorkestrator_benb.dvmodule = 'B'::bpchar THEN
               ('opentabpage(#bouwsloopdetail/'::text || vwfrmomgorkestrator_benb.dnkey) || ')'::text
           WHEN vwfrmomgorkestrator_benb.dvmodule = 'O'::bpchar THEN
               ('opentabpage(#apvoverigdetail/'::text || vwfrmomgorkestrator_benb.dnkey) || ')'::text
           WHEN vwfrmomgorkestrator_benb.dvmodule = 'V'::bpchar THEN
               ('opentabpage(#inrichtingdetail/'::text || vwfrmomgorkestrator_benb.dnkey) || ')'::text
           WHEN vwfrmomgorkestrator_benb.dvmodule = 'E'::bpchar THEN
               ('opentabpage(#milieugebruikdetail/'::text || vwfrmomgorkestrator_benb.dnkey) || ')'::text
           WHEN vwfrmomgorkestrator_benb.dvmodule = 'C'::bpchar THEN
               ('opentabpage(#horecadetail/'::text || vwfrmomgorkestrator_benb.dnkey) || ')'::text
           WHEN vwfrmomgorkestrator_benb.dvmodule = 'W'::bpchar THEN
               ('opentabpage(#omgevingdetail/'::text || vwfrmomgorkestrator_benb.dnkey) || ')'::text
           WHEN vwfrmomgorkestrator_benb.dvmodule = 'I'::bpchar THEN
               ('opentabpage(#infodetail/'::text || vwfrmomgorkestrator_benb.dnkey) || ')'::text
           WHEN vwfrmomgorkestrator_benb.dvmodule = 'H'::bpchar THEN
               ('opentabpage(#handhavingdetail/'::text || vwfrmomgorkestrator_benb.dnkey) || ')'::text
           ELSE ''::text
       END AS dvaction
FROM vwfrmomgorkestrator_benb
WHERE vwfrmomgorkestrator_benb.uitspraakdatum IS NULL
UNION ALL
SELECT vwfrmalleaanvragen.dvmodule,
   vwfrmalleaanvragen.dnkeymodule,
   'F'::text AS dvtaakletter,
       CASE
           WHEN vwfrmalleaanvragen.dvmodule = 'B'::bpchar THEN 'bouw/sloop'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'C'::bpchar THEN 'horeca'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'E'::bpchar THEN 'inrichting'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'H'::bpchar THEN 'handhaving'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'I'::bpchar THEN 'infoaanvraag'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'O'::bpchar THEN 'apv/overig'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'W'::bpchar THEN 'omgeving'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'V'::bpchar THEN 'inrichting'::text
           ELSE 'bestemmingsplan'::text
       END AS dvmoduleoms,
   'Fatale datum'::text AS dvtaakoms,
   vwfrmalleaanvragen.ddfataledatum AS ddstreefdatum,
   vwfrmalleaanvragen.dvbetreft,
   vwfrmalleaanvragen.dvibbcodemw AS dvoorwie,
   COALESCE(vwfrmalleaanvragen.dvolonummer, NULL::character varying,
       ('olo:'::text || vwfrmalleaanvragen.dvolonummer::text)::character varying) AS dvomschrijving,
   vwfrmalleaanvragen.dvibbcodemw AS dvinbehbij,
   (vwfrmalleaanvragen.dvobjstraat::text || ' '::text) ||
       vwfrmalleaanvragen.dvobjhuisnr::text AS dvobjadres,
   vwfrmalleaanvragen.dvobjplaats,
   vwfrmalleaanvragen.dvsoortzaak,
   vwfrmalleaanvragen.dvinrichtingnaam,
   vwfrmalleaanvragen.dvzaakcode,
   vwfrmalleaanvragen.dvaanvrager,
   vwfrmalleaanvragen.dvintzaakcode,
   vwfrmalleaanvragen.dvgmntcode AS dvgemeenteid,
       CASE
           WHEN vwfrmalleaanvragen.dvmodule = 'B'::bpchar THEN
               ('opentabpage(#bouwsloopdetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'O'::bpchar THEN
               ('opentabpage(#apvoverigdetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'V'::bpchar THEN
               ('opentabpage(#inrichtingdetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'E'::bpchar THEN
               ('opentabpage(#milieugebruikdetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'C'::bpchar THEN
               ('opentabpage(#horecadetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'W'::bpchar THEN
               ('opentabpage(#omgevingdetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'I'::bpchar THEN
               ('opentabpage(#infodetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'H'::bpchar THEN
               ('opentabpage(#handhavingdetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           ELSE ''::text
       END AS dvaction
FROM vwfrmalleaanvragen
WHERE vwfrmalleaanvragen.ddblokkering IS NULL AND
   vwfrmalleaanvragen.ddfataledatum IS NOT NULL AND vwfrmalleaanvragen.ddeind IS NULL
UNION ALL
SELECT vwfrmalleaanvragen.dvmodule,
   vwfrmalleaanvragen.dnkeymodule,
   'V'::text AS dvtaakletter,
       CASE
           WHEN vwfrmalleaanvragen.dvmodule = 'B'::bpchar THEN 'bouw/sloop'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'C'::bpchar THEN 'horeca'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'E'::bpchar THEN 'inrichting'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'H'::bpchar THEN 'handhaving'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'I'::bpchar THEN 'infoaanvraag'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'O'::bpchar THEN 'apv/overig'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'W'::bpchar THEN 'omgeving'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'V'::bpchar THEN 'inrichting'::text
           ELSE 'bestemmingsplan'::text
       END AS dvmoduleoms,
   'Verloopdatum'::text AS dvtaakoms,
   vwfrmalleaanvragen.ddgeldigheid AS ddstreefdatum,
   vwfrmalleaanvragen.dvbetreft,
   vwfrmalleaanvragen.dvibbcodemw AS dvoorwie,
   COALESCE(vwfrmalleaanvragen.dvolonummer, NULL::character varying,
       ('olo:'::text || vwfrmalleaanvragen.dvolonummer::text)::character varying) AS dvomschrijving,
   vwfrmalleaanvragen.dvibbcodemw AS dvinbehbij,
   (vwfrmalleaanvragen.dvobjstraat::text || ' '::text) ||
       vwfrmalleaanvragen.dvobjhuisnr::text AS dvobjadres,
   vwfrmalleaanvragen.dvobjplaats,
   vwfrmalleaanvragen.dvsoortzaak,
   vwfrmalleaanvragen.dvinrichtingnaam,
   vwfrmalleaanvragen.dvzaakcode,
   vwfrmalleaanvragen.dvaanvrager,
   vwfrmalleaanvragen.dvintzaakcode,
   vwfrmalleaanvragen.dvgmntcode AS dvgemeenteid,
       CASE
           WHEN vwfrmalleaanvragen.dvmodule = 'B'::bpchar THEN
               ('opentabpage(#bouwsloopdetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'O'::bpchar THEN
               ('opentabpage(#apvoverigdetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'V'::bpchar THEN
               ('opentabpage(#inrichtingdetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'E'::bpchar THEN
               ('opentabpage(#milieugebruikdetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'C'::bpchar THEN
               ('opentabpage(#horecadetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'W'::bpchar THEN
               ('opentabpage(#omgevingdetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'I'::bpchar THEN
               ('opentabpage(#infodetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           WHEN vwfrmalleaanvragen.dvmodule = 'H'::bpchar THEN
               ('opentabpage(#handhavingdetail/'::text || vwfrmalleaanvragen.dnkeymodule) || ')'::text
           ELSE ''::text
       END AS dvaction
FROM vwfrmalleaanvragen
WHERE vwfrmalleaanvragen.ddgeldigheid IS NOT NULL
UNION ALL
SELECT 'H'::bpchar AS dvmodule,
   vwfrmhandhinvorderingen.dnkeyhandhavingen AS dnkeymodule,
   'I'::text AS dvtaakletter,
   'handhaving'::text AS dvmoduleoms,
   'Invorderingen'::text AS dvtaakoms,
   vwfrmhandhinvorderingen.dddatum AS ddstreefdatum,
   vwfrmhandhinvorderingen.dvbetreft,
   vwfrmhandhinvorderingen.dvibbcodemw AS dvoorwie,
   vwfrmhandhinvorderingen.dvsoortinvordering AS dvomschrijving,
   vwfrmhandhinvorderingen.dvibbcodemw AS dvinbehbij,
   vwfrmhandhinvorderingen.dvobjadres,
   vwfrmhandhinvorderingen.dvwoonplaatsnaam AS dvobjplaats,
   vwfrmhandhinvorderingen.dvsoortzaak,
   vwfrmhandhinvorderingen.dvinrichtingnaam,
   vwfrmhandhinvorderingen.dvzaakcode,
   vwfrmhandhinvorderingen.dvaanvrager,
   vwfrmhandhinvorderingen.dvintzaakcode,
   vwfrmhandhinvorderingen.dvgemeenteid,
   ('opentabpage(#handhavingdetail/'::text ||
       vwfrmhandhinvorderingen.dnkeyhandhavingen) || ')'::text AS dvaction
FROM vwfrmhandhinvorderingen
WHERE vwfrmhandhinvorderingen.ddafgehandeld IS NULL AND
   vwfrmhandhinvorderingen.ddblokkering IS NULL
UNION ALL
SELECT vwfrmopeninsptrajecten.dvmodule,
   vwfrmopeninsptrajecten.dnkeymodule,
   'T'::text AS dvtaakletter,
       CASE
           WHEN vwfrmopeninsptrajecten.dvmodule = 'B'::bpchar THEN 'bouw/sloop'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'C'::bpchar THEN 'horeca'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'E'::bpchar THEN
               'milieu/gebruik'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'H'::bpchar THEN 'handhaving'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'I'::bpchar THEN 'infoaanvraag'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'O'::bpchar THEN 'apv/overig'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'W'::bpchar THEN 'omgeving'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'V'::bpchar THEN 'inrichting'::text
           ELSE 'bestemmingsplan'::text
       END AS dvmoduleoms,
   'Inspectietraject'::text AS dvtaakoms,
   vwfrmopeninsptrajecten.ddtrajectgepland AS ddstreefdatum,
   vwfrmopeninsptrajecten.dvaanleiding AS dvbetreft,
   vwfrmopeninsptrajecten.dvtrajectinspecteur AS dvoorwie,
   vwfrmopeninsptrajecten.dvonderwerp AS dvomschrijving,
   vwfrmopeninsptrajecten.dvtrajectinspecteur AS dvinbehbij,
   (vwfrmopeninsptrajecten.dvobjstraat::text || ' '::text) ||
       vwfrmopeninsptrajecten.dvobjhuisnummer::text AS dvobjadres,
   vwfrmopeninsptrajecten.dvobjplaats,
   NULL::character varying AS dvsoortzaak,
   vwfrmopeninsptrajecten.dvinrichtingnaam,
   vwfrmopeninsptrajecten.dvzaakcode,
   NULL::character varying AS dvaanvrager,
   vwfrmopeninsptrajecten.dvintzaakcode,
   vwfrmopeninsptrajecten.dvgemeenteid,
       CASE
           WHEN vwfrmopeninsptrajecten.dvmodule = 'B'::bpchar THEN
               ('opentabpage(#bouwsloopdetail/'::text || vwfrmopeninsptrajecten.dnkeymodule) || ')'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'O'::bpchar THEN
               ('opentabpage(#apvoverigdetail/'::text || vwfrmopeninsptrajecten.dnkeymodule) || ')'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'V'::bpchar THEN
               ('opentabpage(#inrichtingdetail/'::text || vwfrmopeninsptrajecten.dnkeymodule) || ')'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'E'::bpchar THEN
               ('opentabpage(#inrichtingdetail/'::text || vwfrmopeninsptrajecten.dnkeymodule) || ')'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'C'::bpchar THEN
               ('opentabpage(#horecadetail/'::text || vwfrmopeninsptrajecten.dnkeymodule) || ')'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'W'::bpchar THEN
               ('opentabpage(#omgevingdetail/'::text || vwfrmopeninsptrajecten.dnkeymodule) || ')'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'I'::bpchar THEN
               ('opentabpage(#infodetail/'::text || vwfrmopeninsptrajecten.dnkeymodule) || ')'::text
           WHEN vwfrmopeninsptrajecten.dvmodule = 'H'::bpchar THEN
               ('opentabpage(#handhavingdetail/'::text || vwfrmopeninsptrajecten.dnkeymodule) || ')'::text
           ELSE ''::text
       END AS dvaction
FROM vwfrmopeninsptrajecten;

COMMENT ON VIEW public.vwfrmalletaken2
IS 'View van alle openstaande taken m.b.t. processtappen (vwfrmeerstestapperproces), fataldedatums, verloopdatums en invorderingen en tot maximaal een instelbaar aantal dagen terug m.b.t adviezen, inspectiebezoeken, inspectietrajecten';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13