Datadictionary OpenWave 3.1.4
Previous topic Chapter index Next topic

View: vwomgadvies_behandelaar

 

 

Schema

public

 

Owner

waveuser002

 

Descriptions

There is no description for view vwomgadvies_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.vwomgadvies_behandelaar (
   ddrappeldatum,
   ddadviesdatum,
   dvomschrijving,
   dnkeyvergunning,
   dvomschradviesinstantie,
   dvcodemedewerker,
   dnkeyadvies)
AS
SELECT
tbadviezen.ddrappeldatum, tbadviezen.ddadviesdatum,
           tbadviezen.dvomschrijving,
           tbadviezen.dnkeyomgvergunningen 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.dnkeyomgvergunningen IN (
   SELECT tbomgvergunning.dnkey
   FROM tbomgvergunning
   WHERE tbomgvergunning.ddblokkering IS NULL AND
       tbomgvergunning.ddingetrokken IS NULL AND (tbomgvergunning.ddaanhoudenvanaf IS NULL OR tbomgvergunning.ddaanhoudentotmet IS NOT NULL)
   ))
UNION
SELECT
tbadviezen.ddrappeldatum, tbadviezen.ddadviesdatum,
           tbadviezen.dvomschrijving,
           tbadviezen.dnkeyomgvergunningen AS dnkeyvergunning,
           tbadviesinstanties.dvomschrijving AS dvomschradviesinstantie,
           btrim(tbinbehandelingbij.dvcodemedewerker::text) AS dvcodemedewerker,
           tbadviezen.dnkey AS dnkeyadvies
FROM tbinbehandelingbij
     JOIN tbadviezen ON tbinbehandelingbij.dnkeyomgvergunningen =
         tbadviezen.dnkeyomgvergunningen
  JOIN tbadviesinstanties ON tbadviezen.dvcodeadviesinstanties =
      tbadviesinstanties.dvcode
WHERE tbinbehandelingbij.dlactief = 'T'::bpchar AND tbadviezen.ddrappeldatum IS
   NOT NULL AND
tbadviezen.ddadviesdatum IS NULL AND tbadviezen.ddvervallen IS NULL AND (tbadviezen.dnkeyomgvergunningen IN (
   SELECT tbomgvergunning.dnkey
   FROM tbomgvergunning
   WHERE tbomgvergunning.ddblokkering IS NULL AND
       tbomgvergunning.ddingetrokken IS NULL AND (tbomgvergunning.ddaanhoudenvanaf IS NULL OR tbomgvergunning.ddaanhoudentotmet IS NOT NULL)
   ));

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