Schema
public
Owner
waveuser002
Descriptions
There is no description for view vwbouwadvies_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.vwbouwadvies_behandelaar (
ddrappeldatum,
ddadviesdatum,
dvomschrijving,
dnkeyvergunning,
dvomschradviesinstantie,
dvcodemedewerker,
dnkeyadvies)
AS
SELECT tbadviezen.ddrappeldatum, tbadviezen.ddadviesdatum,
tbadviezen.dvomschrijving,
tbadviezen.dnkeybouwvergunningen 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.dnkeybouwvergunningen IN (
SELECT tbbouwvergunningen.dnkey
FROM tbbouwvergunningen
WHERE tbbouwvergunningen.ddblokkering IS NULL AND
tbbouwvergunningen.ddingetrokken IS NULL
))
UNION
SELECT tbadviezen.ddrappeldatum, tbadviezen.ddadviesdatum,
tbadviezen.dvomschrijving,
tbadviezen.dnkeybouwvergunningen 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.dnkeybouwvergunningen =
tbadviezen.dnkeybouwvergunningen
WHERE tbinbehandelingbij.dlactief = 'T'::bpchar AND tbadviezen.ddrappeldatum IS
NOT NULL AND tbadviezen.ddadviesdatum IS NULL AND tbadviezen.ddvervallen IS NULL AND (tbadviezen.dnkeybouwvergunningen IN (
SELECT tbbouwvergunningen.dnkey
FROM tbbouwvergunningen
WHERE tbbouwvergunningen.ddblokkering IS NULL AND
tbbouwvergunningen.ddingetrokken IS NULL
));
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-01-2013 17:28 |
![]() ![]() ![]() |