Datadictionary OpenWave 3.1.34 |
|
View: vwmeldingen_termijnstappen
Datadictionary OpenWave 3.1.34 |
|
View: vwmeldingen_termijnstappen
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwmeldingen_termijnstappen
Columns
Name | Data type | Description |
|---|---|---|
dddeadline |
timestamp |
|
dvtermijnomschrijving |
varchar(40) |
|
dlingebruik |
char(1) |
|
dlfataal |
char(1) |
|
dnkeyhandhavingen |
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 |
|
|
|
Indices
There are no indices for table vwmeldingen_termijnstappen
Definition
dddeadline,
dvtermijnomschrijving,
dlingebruik,
dlfataal,
dnkeyhandhavingen,
dnkeyovvergunningen,
dnkeyhorecavergunningen,
dnkeybestemmingsplannen,
dnkeyinfoaanvraag,
dvcodemedewerkers,
dnkeymilvergunningen,
dnkeyomgvergunningen,
dvcodevoorwie)
AS
SELECT dddeadline,
dvtermijnomschrijving,
dlingebruik,
dlfataal,
dnkeyhandhavingen,
dnkeyovvergunningen,
dnkeyhorecavergunningen,
dnkeybestemmingsplannen,
dnkeyinfoaanvraag,
dvcodemedewerkers,
dnkeymilvergunningen,
dnkeyomgvergunningen,
dvcodevoorwie
FROM tbtermijnbewstappen
WHERE dvvoorwaardejn = 'N'::bpchar AND ddafgehandeld IS NULL AND dddeadline IS
NOT NULL AND dlfataal = 'T'::bpchar AND dlingebruik = 'T'::bpchar AND (dnkeyovvergunningen IS NOT NULL AND (dnkeyovvergunningen IN (
SELECT tbovvergunningen.dnkey
FROM tbovvergunningen
WHERE tbovvergunningen.ddblokkering IS NULL
)) OR dnkeyhandhavingen IS NOT NULL AND (dnkeyhandhavingen IN (
SELECT tbhandhavingen.dnkey
FROM tbhandhavingen
WHERE tbhandhavingen.ddblokkering IS NULL
)) OR dnkeyhorecavergunningen IS NOT NULL AND (dnkeyhorecavergunningen IN (
SELECT tbhorecavergunningen.dnkey
FROM tbhorecavergunningen
WHERE tbhorecavergunningen.ddblokkering IS NULL
)) OR dnkeybestemmingsplannen IS NOT NULL AND (dnkeybestemmingsplannen IN (
SELECT tbbestemmingsplannen.dnkey
FROM tbbestemmingsplannen
WHERE tbbestemmingsplannen.ddblokkeerdatum IS NULL
)) OR dnkeyinfoaanvraag IS NOT NULL AND (dnkeyinfoaanvraag IN (
SELECT tbinfoaanvragen.dnkey
FROM tbinfoaanvragen
WHERE tbinfoaanvragen.ddblokkeerdatum IS NULL
)) OR dnkeymilvergunningen IS NOT NULL AND (dnkeymilvergunningen IN (
SELECT tbmilvergunningen.dnkey
FROM tbmilvergunningen
WHERE tbmilvergunningen.ddblokkering IS NULL
)) OR dnkeyomgvergunningen IS NOT NULL AND (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.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10 |
|