Datadictionary OpenWave 3.1.5
Previous topic Chapter index Next topic

View: vwhorecaadvies_behandelaar

 

 

Schema

public

 

Owner

waveuser002

 

Descriptions

There is no description for view vwhorecaadvies_behandelaar

 

Fields

Name

Data type

Description

ddrappeldatum

timestamp

 

ddadviesdatum

timestamp

 

dvomschrijving

varchar(40)

 

dnkeyvergunning

integer

 

dvomschradviesinstantie

varchar(40)

 

dvcodemedewerker

text

 

dnkeyadvies

integer

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Definition

CREATE VIEW public.vwhorecaadvies_behandelaar (
   ddrappeldatum,
   ddadviesdatum,
   dvomschrijving,
   dnkeyvergunning,
   dvomschradviesinstantie,
   dvcodemedewerker,
   dnkeyadvies)
AS
SELECT
tbadviezen.ddrappeldatum, tbadviezen.ddadviesdatum,
           tbadviezen.dvomschrijving,
           tbadviezen.dnkeyhorecavergunningen AS dnkeyvergunning,
           tbadviesinstanties.dvomschrijving AS dvomschradviesinstantie,
           btrim(tbadviezen.dvcodemedewerkers::text) AS dvcodemedewerker,
           tbadviezen.dnkey AS dnkeyadvies
FROM tbadviezen
     JOIN tbadviesinstanties ON tbadviezen.dvcodeadviesinstanties =
         tbadviesinstanties.dvcode
WHERE tbadviezen.dvcodemedewerkers IS NOT NULL AND tbadviezen.ddrappeldatum IS
   NOT NULL AND
tbadviezen.ddadviesdatum IS NULL AND tbadviezen.ddvervallen IS NULL AND (tbadviezen.dnkeyhorecavergunningen IN (
   SELECT tbhorecavergunningen.dnkey
   FROM tbhorecavergunningen
   WHERE tbhorecavergunningen.ddblokkering IS NULL AND
       tbhorecavergunningen.ddingetrokken IS NULL
   ))
UNION
SELECT
tbadviezen.ddrappeldatum, tbadviezen.ddadviesdatum,
           tbadviezen.dvomschrijving,
           tbadviezen.dnkeyhorecavergunningen AS dnkeyvergunning,
           tbadviesinstanties.dvomschrijving AS dvomschradviesinstantie,
           btrim(tbinbehandelingbij.dvcodemedewerker::text) AS dvcodemedewerker,
           tbadviezen.dnkey AS dnkeyadvies
FROM tbadviezen
     JOIN tbadviesinstanties ON tbadviezen.dvcodeadviesinstanties =
         tbadviesinstanties.dvcode
  JOIN tbinbehandelingbij ON tbinbehandelingbij.dnkeyhorecavergunningen =
      tbadviezen.dnkeyhorecavergunningen
WHERE tbinbehandelingbij.dlactief = 'T'::bpchar AND tbadviezen.ddrappeldatum IS
   NOT NULL AND
tbadviezen.ddadviesdatum IS NULL AND tbadviezen.ddvervallen IS NULL AND (tbadviezen.dnkeyhorecavergunningen IN (
   SELECT tbhorecavergunningen.dnkey
   FROM tbhorecavergunningen
   WHERE tbhorecavergunningen.ddblokkering IS NULL AND
       tbhorecavergunningen.ddingetrokken IS NULL
   ));

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 15-5-2014 16:11
Previous topic Chapter index Next topic