Datadictionary OpenWave 3.1.33 |
|
View: vwlegesregelsvergunningen_bt
Datadictionary OpenWave 3.1.33 |
|
View: vwlegesregelsvergunningen_bt
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwlegesregelsvergunningen_bt
Columns
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
|
dvomschrijving |
varchar(40) |
|
dvnotanummer |
varchar(20) |
|
dflegesbedrag |
double precision |
|
ddexportdatum |
timestamp |
|
dnkeylegessoort |
integer |
|
dnkeybouwvergunningen |
integer |
|
dnkeyovvergunningen |
integer |
|
dnkeyhorecavergunningen |
integer |
|
dnkeyinfoaanvraag |
integer |
|
dnkeyomgvergunningen |
integer |
|
omgaanvraagdatum |
timestamp |
|
omgvergunningnr |
varchar(40) |
|
soortomgverg |
integer |
|
omgpublicatie |
varchar(200) |
|
omgbesluitdatum |
timestamp |
|
omgacceptgiro_verzdatum |
timestamp |
|
omgverzdatum_besch |
timestamp |
|
dnlegesmoment |
integer |
|
ddcontrole |
timestamp |
|
dvcodemwcontrole |
char(5) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwlegesregelsvergunningen_bt
Definition
dnkey,
dvomschrijving,
dvnotanummer,
dflegesbedrag,
ddexportdatum,
dnkeylegessoort,
dnkeybouwvergunningen,
dnkeyovvergunningen,
dnkeyhorecavergunningen,
dnkeyinfoaanvraag,
dnkeyomgvergunningen,
omgaanvraagdatum,
omgvergunningnr,
soortomgverg,
omgpublicatie,
omgbesluitdatum,
omgacceptgiro_verzdatum,
omgverzdatum_besch,
dnlegesmoment,
ddcontrole,
dvcodemwcontrole)
AS
SELECT tblegesregels.dnkey,
CASE
WHEN tblegesregels.dvomschrijving IS NOT NULL THEN
tblegesregels.dvomschrijving
ELSE tblegessoort.dvomschrijving
END::character varying(40) AS dvomschrijving,
tblegesregels.dvnotanummer,
tblegesregels.dflegesbedrag,
tblegesregels.ddexportdatum,
tblegesregels.dnkeylegessoort,
tblegesregels.dnkeybouwvergunningen,
tblegesregels.dnkeyovvergunningen,
tblegesregels.dnkeyhorecavergunningen,
tblegesregels.dnkeyinfoaanvraag,
tblegesregels.dnkeyomgvergunningen,
tbomgvergunning.ddaanvraag AS omgaanvraagdatum,
tbomgvergunning.dvzaakcode AS omgvergunningnr,
tbomgvergunning.dnkeysoortomgverg AS soortomgverg,
tbomgvergunning.dvaanvraagnaam AS omgpublicatie,
tbomgvergunning.ddbesluitdatum AS omgbesluitdatum,
tbomgvergunning.ddlegesverzonden AS omgacceptgiro_verzdatum,
tbomgvergunning.ddbeschverzonden AS omgverzdatum_besch,
tblegesregels.dnlegesmoment,
tblegesregels.ddcontrole,
tblegesregels.dvcodemwcontrole
FROM tblegesregels
JOIN tbomgvergunning ON tblegesregels.dnkeyomgvergunningen = tbomgvergunning.dnkey
JOIN tblegessoort ON tblegesregels.dnkeylegessoort = tblegessoort.dnkey
WHERE 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 |
|