Datadictionary OpenWave 3.1.11

View: vwovinsp_behandelaar

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwovinsp_behandelaar

Fields

Rules

Definition

CREATE VIEW public.vwovinsp_behandelaar (
   ddrappel,
   ddcontrole,
   dvomschrijving,
   dnkeyvergunning,
   dvcodemedewerker,
   dvzaakcode,
   dvtype,
   dvsoort,
   dvvantoepop,
   dvadres,
   dvhuisnummer,
   dvplaats,
   dvbestemmingsplan,
   dvaanvrager,
   dvdmszaakcode,
   dvibbcodemw)
AS
SELECT tbinspecties.ddrappel, tbinspecties.ddcontrole,
               CASE
                   WHEN tbinspecties.dvomschrijving IS NULL THEN
                       tbinspaanleiding.dvaanleiding
                   ELSE tbinspecties.dvomschrijving
               END::character varying(100) AS dvomschrijving,
           tbinspecties.dnkeyovvergunningen AS dnkeyvergunning,
           tbinspecties.dvcodemedewerkers AS dvcodemedewerker,
           tbovvergunningen.dvvergunningsnr AS dvzaakcode,
           'Inspectie-traject'::character varying(17) AS dvtype,
           tbsoortovverg.dvomschrijving AS dvsoort,
           'Overige'::character(7) AS dvvantoepop,
           tbopenbareruimte.dvopruimtenaam AS dvadres,
           (((((
               CASE
                   WHEN tbperceeladressen.dvaanduidingbijhuisnummer IS NULL
                       THEN ''::text
                   ELSE tbperceeladressen.dvaanduidingbijhuisnummer::text || ' '::text
               END || tbperceeladressen.dvhuisnummer::text) || ' '::text) ||
               CASE
                   WHEN tbperceeladressen.dvhuisletter IS NULL THEN ''::bpchar
                   ELSE tbperceeladressen.dvhuisletter
               END::text) ||
               CASE
                   WHEN rtrim(tbperceeladressen.dvhuisnummertoevoeging::text)
                       IS NULL THEN ''::text
                   ELSE replace('-'::text ||
                       tbperceeladressen.dvhuisnummertoevoeging::text, '--'::text, '-'::text)
               END))::character varying(15) AS dvhuisnummer,
           tbwoonplaats.dvwoonplaatsnaam AS dvplaats,
           tbbestemmingsplannen.dvnaam AS dvbestemmingsplan,
           vwfrmovavrcontacten.dvavrtav AS dvaanvrager,
           tbinspecties.dvdmszaakcode,
           tbinbehandelingbij.dvcodemedewerker AS dvibbcodemw
FROM tbinspecties
     LEFT JOIN tbinspaanleiding ON tbinspecties.dnkeyinspaanleiding =
         tbinspaanleiding.dnkey
  JOIN tbovvergunningen ON tbinspecties.dnkeyovvergunningen = tbovvergunningen.dnkey
  JOIN tbsoortovverg ON tbovvergunningen.dvcodesoortovverg = tbsoortovverg.dvcode
  JOIN tbperceeladressen ON tbovvergunningen.dnkeyperceeladressen =
      tbperceeladressen.dnkey
  JOIN tbopenbareruimte ON tbperceeladressen.dnkeyopenbruimte = tbopenbareruimte.dnkey
  JOIN tbwoonplaats ON tbopenbareruimte.dnkeywoonplaats = tbwoonplaats.dnkey
  LEFT JOIN tbbestemmingsplannen ON
      tbperceeladressen.dnkeygeldendbestemmingsplan = tbbestemmingsplannen.dnkey
  LEFT JOIN vwfrmovavrcontacten ON tbovvergunningen.dnkey =
      vwfrmovavrcontacten.dnkeyovvergunningen
  LEFT JOIN tbinbehandelingbij ON tbinspecties.dnkeyovvergunningen =
      tbinbehandelingbij.dnkeyovvergunningen
WHERE tbinspecties.ddrappel IS NOT NULL AND tbinspecties.ddcontrole IS NULL AND
   tbinspecties.dnkeyhandhavingen IS NULL AND tbinspecties.dnkeyovvergunningen IS NOT NULL AND (tbovvergunningen.ddblokkering IS NULL OR tbovvergunningen.ddblokkering IS NOT NULL AND ((
   SELECT COALESCE(tbinitialisatie.d1logic, 'F'::bpchar) AS "coalesce"
   FROM tbinitialisatie
   WHERE tbinitialisatie.dvsectie = 'InspectieMilieu'::bpchar AND
       tbinitialisatie.dvitem = 'NietBlokkerenMetHoofdzaak'::bpchar
   )) = 'T'::bpchar) AND tbinbehandelingbij.dlactief = 'T'::bpchar
UNION
SELECT tbinspbezoeken.ddgepland AS ddrappel,
           tbinspbezoeken.ddafgehandeld AS ddcontrole,
           COALESCE(tbinspsoortbezoek.dvomschrijving,
               tbinspaanleiding.dvaanleiding)::character varying(100) AS dvomschrijving,
           tbinspecties.dnkeyovvergunningen AS dnkeyvergunning,
           tbinspecties.dvcodemedewerkers AS dvcodemedewerker,
           tbovvergunningen.dvvergunningsnr AS dvzaakcode,
           'Inspectie-bezoek'::character varying(17) AS dvtype,
           tbsoortovverg.dvomschrijving AS dvsoort,
           'Overige'::character(7) AS dvvantoepop,
           tbopenbareruimte.dvopruimtenaam AS dvadres,
           (((((
               CASE
                   WHEN tbperceeladressen.dvaanduidingbijhuisnummer IS NULL
                       THEN ''::text
                   ELSE tbperceeladressen.dvaanduidingbijhuisnummer::text || ' '::text
               END || tbperceeladressen.dvhuisnummer::text) || ' '::text) ||
               CASE
                   WHEN tbperceeladressen.dvhuisletter IS NULL THEN ''::bpchar
                   ELSE tbperceeladressen.dvhuisletter
               END::text) ||
               CASE
                   WHEN rtrim(tbperceeladressen.dvhuisnummertoevoeging::text)
                       IS NULL THEN ''::text
                   ELSE replace('-'::text ||
                       tbperceeladressen.dvhuisnummertoevoeging::text, '--'::text, '-'::text)
               END))::character varying(15) AS dvhuisnummer,
           tbwoonplaats.dvwoonplaatsnaam AS dvplaats,
           tbbestemmingsplannen.dvnaam AS dvbestemmingsplan,
           vwfrmovavrcontacten.dvavrtav AS dvaanvrager,
           tbinspecties.dvdmszaakcode,
           tbinbehandelingbij.dvcodemedewerker AS dvibbcodemw
FROM tbinspbezoeken
     JOIN tbinspecties ON tbinspbezoeken.dnkeyinspecties = tbinspecties.dnkey
  LEFT JOIN tbinspaanleiding ON tbinspecties.dnkeyinspaanleiding =
      tbinspaanleiding.dnkey
  JOIN tbovvergunningen ON tbinspecties.dnkeyovvergunningen = tbovvergunningen.dnkey
  JOIN tbsoortovverg ON tbovvergunningen.dvcodesoortovverg = tbsoortovverg.dvcode
  JOIN tbperceeladressen ON tbovvergunningen.dnkeyperceeladressen =
      tbperceeladressen.dnkey
  JOIN tbopenbareruimte ON tbperceeladressen.dnkeyopenbruimte = tbopenbareruimte.dnkey
  JOIN tbwoonplaats ON tbopenbareruimte.dnkeywoonplaats = tbwoonplaats.dnkey
  LEFT JOIN tbbestemmingsplannen ON
      tbperceeladressen.dnkeygeldendbestemmingsplan = tbbestemmingsplannen.dnkey
  LEFT JOIN vwfrmovavrcontacten ON tbovvergunningen.dnkey =
      vwfrmovavrcontacten.dnkeyovvergunningen
  LEFT JOIN tbinbehandelingbij ON tbinspecties.dnkeyovvergunningen =
      tbinbehandelingbij.dnkeyovvergunningen
  LEFT JOIN tbinspsoortbezoek ON tbinspbezoeken.dnkeyinspsoortbezoek =
      tbinspsoortbezoek.dnkey
WHERE tbinspbezoeken.ddgepland IS NOT NULL AND tbinspbezoeken.ddafgehandeld IS
   NULL AND tbinspecties.dnkeyhandhavingen IS NULL AND tbinspecties.dnkeyovvergunningen IS NOT NULL AND (tbovvergunningen.ddblokkering IS NULL OR tbovvergunningen.ddblokkering IS NOT NULL AND ((
   SELECT COALESCE(tbinitialisatie.d1logic, 'F'::bpchar) AS "coalesce"
   FROM tbinitialisatie
   WHERE tbinitialisatie.dvsectie = 'InspectieMilieu'::bpchar AND
       tbinitialisatie.dvitem = 'NietBlokkerenMetHoofdzaak'::bpchar
   )) = 'T'::bpchar) AND tbinbehandelingbij.dlactief = 'T'::bpchar;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50