Datadictionary OpenWave 3.1.11 |
|
View: vwmeldingen_termijnstappen
Datadictionary OpenWave 3.1.11 |
|
View: vwmeldingen_termijnstappen
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwmeldingen_termijnstappen
Fields
Name | Data type | Description |
|---|---|---|
dddeadline |
timestamp |
|
dvtermijnomschrijving |
varchar(40) |
|
dlingebruik |
char(1) |
|
dlfataal |
char(1) |
|
dnkeyhandhavingen |
integer |
|
dnkeybouwvergunningen |
integer |
|
dnkeyovvergunningen |
integer |
|
dnkeyhorecavergunningen |
integer |
|
dnkeybestemmingsplannen |
integer |
|
dnkeyinfoaanvraag |
integer |
|
dvcodemedewerkers |
char(5) |
|
dnkeymilvergunningen |
integer |
|
dnkeyomgvergunningen |
integer |
|
dvcodevoorwie |
char(5) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dddeadline,
dvtermijnomschrijving,
dlingebruik,
dlfataal,
dnkeyhandhavingen,
dnkeybouwvergunningen,
dnkeyovvergunningen,
dnkeyhorecavergunningen,
dnkeybestemmingsplannen,
dnkeyinfoaanvraag,
dvcodemedewerkers,
dnkeymilvergunningen,
dnkeyomgvergunningen,
dvcodevoorwie)
AS
SELECT tbtermijnbewstappen.dddeadline,
tbtermijnbewstappen.dvtermijnomschrijving, tbtermijnbewstappen.dlingebruik,
tbtermijnbewstappen.dlfataal, tbtermijnbewstappen.dnkeyhandhavingen,
tbtermijnbewstappen.dnkeybouwvergunningen,
tbtermijnbewstappen.dnkeyovvergunningen,
tbtermijnbewstappen.dnkeyhorecavergunningen,
tbtermijnbewstappen.dnkeybestemmingsplannen,
tbtermijnbewstappen.dnkeyinfoaanvraag,
tbtermijnbewstappen.dvcodemedewerkers,
tbtermijnbewstappen.dnkeymilvergunningen,
tbtermijnbewstappen.dnkeyomgvergunningen, tbtermijnbewstappen.dvcodevoorwie
FROM tbtermijnbewstappen
WHERE tbtermijnbewstappen.dvvoorwaardejn = 'N'::bpchar AND
tbtermijnbewstappen.ddafgehandeld IS NULL AND tbtermijnbewstappen.dddeadline IS NOT NULL AND tbtermijnbewstappen.dlfataal = 'T'::bpchar AND tbtermijnbewstappen.dlingebruik = 'T'::bpchar AND (tbtermijnbewstappen.dnkeybouwvergunningen IS NOT NULL AND (tbtermijnbewstappen.dnkeybouwvergunningen IN (
SELECT tbbouwvergunningen.dnkey
FROM tbbouwvergunningen
WHERE tbbouwvergunningen.ddblokkering IS NULL
)) OR tbtermijnbewstappen.dnkeyovvergunningen IS NOT NULL AND
(tbtermijnbewstappen.dnkeyovvergunningen IN (
SELECT tbovvergunningen.dnkey
FROM tbovvergunningen
WHERE tbovvergunningen.ddblokkering IS NULL
)) OR tbtermijnbewstappen.dnkeyhandhavingen IS NOT NULL AND
(tbtermijnbewstappen.dnkeyhandhavingen IN (
SELECT tbhandhavingen.dnkey
FROM tbhandhavingen
WHERE tbhandhavingen.ddblokkering IS NULL
)) OR tbtermijnbewstappen.dnkeyhorecavergunningen IS NOT NULL AND
(tbtermijnbewstappen.dnkeyhorecavergunningen IN (
SELECT tbhorecavergunningen.dnkey
FROM tbhorecavergunningen
WHERE tbhorecavergunningen.ddblokkering IS NULL
)) OR tbtermijnbewstappen.dnkeybestemmingsplannen IS NOT NULL AND
(tbtermijnbewstappen.dnkeybestemmingsplannen IN (
SELECT tbbestemmingsplannen.dnkey
FROM tbbestemmingsplannen
WHERE tbbestemmingsplannen.ddblokkeerdatum IS NULL
)) OR tbtermijnbewstappen.dnkeyinfoaanvraag IS NOT NULL AND
(tbtermijnbewstappen.dnkeyinfoaanvraag IN (
SELECT tbinfoaanvragen.dnkey
FROM tbinfoaanvragen
WHERE tbinfoaanvragen.ddblokkeerdatum IS NULL
)) OR tbtermijnbewstappen.dnkeymilvergunningen IS NOT NULL AND
(tbtermijnbewstappen.dnkeymilvergunningen IN (
SELECT tbmilvergunningen.dnkey
FROM tbmilvergunningen
WHERE tbmilvergunningen.ddblokkering IS NULL
)) OR tbtermijnbewstappen.dnkeyomgvergunningen IS NOT NULL AND
(tbtermijnbewstappen.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 22-2-2017 10:50 |
|