Datadictionary OpenWave 3.1.33 |
|
View: vwmeldingen_termijnstappen_bt
Datadictionary OpenWave 3.1.33 |
|
View: vwmeldingen_termijnstappen_bt
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwmeldingen_termijnstappen_bt
Columns
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 |
|
|
|
Indices
There are no indices for table vwmeldingen_termijnstappen_bt
Definition
dddeadline,
dvtermijnomschrijving,
dlingebruik,
dlfataal,
dnkeyhandhavingen,
dnkeybouwvergunningen,
dnkeyovvergunningen,
dnkeyhorecavergunningen,
dnkeybestemmingsplannen,
dnkeyinfoaanvraag,
dvcodemedewerkers,
dnkeymilvergunningen,
dnkeyomgvergunningen,
dvcodevoorwie)
AS
SELECT dddeadline,
dvtermijnomschrijving,
dlingebruik,
dlfataal,
dnkeyhandhavingen,
dnkeybouwvergunningen,
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 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) AND tbomgvergunning.dlbeperktetoegang = 'T'::bpchar
));
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 21-10-2025 10:22 |
|