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 12-9-2013 10:19 |
![]() ![]() ![]() |