Datadictionary OpenWave 3.1.11 |
|
View: vwtoest_verlopen
Datadictionary OpenWave 3.1.11 |
|
View: vwtoest_verlopen
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwtoest_verlopen
Fields
Name | Data type | Description |
|---|---|---|
ddrappel |
timestamp |
|
dvomschrijving |
varchar(80) |
|
dnkeyvergunning |
integer |
|
dvcodemedewerker |
char(5) |
|
dvsoort |
varchar(40) |
|
dvzaakcode |
varchar(20) |
|
dvtype |
char(11) |
|
dvadres |
varchar(80) |
|
dvhuisnr |
varchar(15) |
|
dvkern |
varchar(80) |
|
dvbestemplan |
varchar(256) |
|
dvaanvrager |
varchar(221) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
ddrappel,
dvomschrijving,
dnkeyvergunning,
dvcodemedewerker,
dvsoort,
dvzaakcode,
dvtype,
dvadres,
dvhuisnr,
dvkern,
dvbestemplan,
dvaanvrager)
AS
SELECT tbtoestemmingen.ddgeldigtm AS ddrappel,
tbtoestemmingen.dvwerkzaamheden AS dvomschrijving,
tbtoestemmingen.dnkeyomgvergunningen AS dnkeyvergunning,
vwfrmactiefinbehbij.dvibbcodemw AS dvcodemedewerker,
vwfrmomgvergunningen.dvsoortaanvraag AS dvsoort,
vwfrmomgvergunningen.dvzaakcode, 'Toestemming'::character(11) AS dvtype,
vwfrmomgvergunningen.dvobjstraat AS dvadres,
vwfrmomgvergunningen.dvobjhuisnr AS dvhuisnr,
vwfrmomgvergunningen.dvobjplaats AS dvkern,
vwfrmomgvergunningen.dvgldbplnaam AS dvbestemplan,
CASE
WHEN vwomgavrcontacten.dvavrbedrijfsnaam IS NOT NULL THEN
vwomgavrcontacten.dvavrbedrijfsnaam::text
ELSE (((vwomgavrcontacten.dvavrnaam::text || ','::text) ||
vwomgavrcontacten.dvavrvoorl::text) || ''::text) || vwomgavrcontacten.dvavrtussenv::text
END::character varying(221) AS dvaanvrager
FROM tbtoestemmingen
JOIN vwfrmomgvergunningen ON tbtoestemmingen.dnkeyomgvergunningen =
vwfrmomgvergunningen.dnkeyomgvergunning
JOIN vwfrmactiefinbehbij ON vwfrmomgvergunningen.dnkeyomgvergunning =
vwfrmactiefinbehbij.dnkeyomgvergunningen
LEFT JOIN vwomgavrcontacten ON vwfrmomgvergunningen.dnkeyomgvergunning =
vwomgavrcontacten.dnkeyomgvergunningen
WHERE tbtoestemmingen.ddgeldigtm IS NOT NULL AND tbtoestemmingen.ddingetrokken IS NULL;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|