Datadictionary OpenWave 3.1.35 |
|
View: vwlegesregelsvergunningen
Datadictionary OpenWave 3.1.35 |
|
View: vwlegesregelsvergunningen
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwlegesregelsvergunningen
Columns
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
|
dvomschrijving |
varchar(40) |
|
dvnotanummer |
varchar(20) |
|
dflegesbedrag |
double precision |
|
ddexportdatum |
timestamp |
|
dnkeylegessoort |
integer |
|
dnkeyovvergunningen |
integer |
|
dnkeyhorecavergunningen |
integer |
|
dnkeyinfoaanvraag |
integer |
|
dnkeyomgvergunningen |
integer |
|
ovontvangstdatum |
timestamp |
|
ovvergunningnr |
varchar(40) |
|
soortovverg |
char(5) |
|
ovpublicatie |
varchar(100) |
|
ovbesluitdatum |
timestamp |
|
ovacceptgiro_verzdatum |
timestamp |
|
ovverzdatum_besch |
timestamp |
|
horaanvraagdatum |
timestamp |
|
horvergunningnr |
varchar(40) |
|
horlokaliteiten |
varchar(2000) |
|
soorthorverg |
integer |
|
horbesluitdatum |
timestamp |
|
horacceptgiro_verzdatum |
timestamp |
|
infaanvraagdatum |
timestamp |
|
infvergunningnr |
varchar(40) |
|
soortinfo |
integer |
|
infafgehandeld |
timestamp |
|
infacceptgiro_verzdatum |
timestamp |
|
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
Definition
dnkey,
dvomschrijving,
dvnotanummer,
dflegesbedrag,
ddexportdatum,
dnkeylegessoort,
dnkeyovvergunningen,
dnkeyhorecavergunningen,
dnkeyinfoaanvraag,
dnkeyomgvergunningen,
ovontvangstdatum,
ovvergunningnr,
soortovverg,
ovpublicatie,
ovbesluitdatum,
ovacceptgiro_verzdatum,
ovverzdatum_besch,
horaanvraagdatum,
horvergunningnr,
horlokaliteiten,
soorthorverg,
horbesluitdatum,
horacceptgiro_verzdatum,
infaanvraagdatum,
infvergunningnr,
soortinfo,
infafgehandeld,
infacceptgiro_verzdatum,
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.dnkeyovvergunningen,
tblegesregels.dnkeyhorecavergunningen,
tblegesregels.dnkeyinfoaanvraag,
tblegesregels.dnkeyomgvergunningen,
tbovvergunningen.ddontvangstdatum AS ovontvangstdatum,
tbovvergunningen.dvvergunningsnr AS ovvergunningnr,
tbovvergunningen.dvcodesoortovverg AS soortovverg,
tbovvergunningen.dvpublbouwwerk AS ovpublicatie,
tbovvergunningen.ddbesluitdatum AS ovbesluitdatum,
tbovvergunningen.ddlegesverzonden AS ovacceptgiro_verzdatum,
tbovvergunningen.ddverzenddatum AS ovverzdatum_besch,
tbhorecavergunningen.ddaanvraagdatum AS horaanvraagdatum,
tbhorecavergunningen.dvvergnummer AS horvergunningnr,
tbhorecavergunningen.dvlokaliteiten AS horlokaliteiten,
tbhorecavergunningen.dnkeysoortverg AS soorthorverg,
tbhorecavergunningen.dddatumbesluit AS horbesluitdatum,
tbhorecavergunningen.ddlegesverzonden AS horacceptgiro_verzdatum,
tbinfoaanvragen.ddaanvraagdatum AS infaanvraagdatum,
tbinfoaanvragen.dvinfonummer AS infvergunningnr,
tbinfoaanvragen.dnkeysoortinfoaanvraag AS soortinfo,
tbinfoaanvragen.ddafgehandeld AS infafgehandeld,
tbinfoaanvragen.ddlegesverzonden AS infacceptgiro_verzdatum,
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
LEFT JOIN tbovvergunningen ON tblegesregels.dnkeyovvergunningen =
tbovvergunningen.dnkey
LEFT JOIN tbhorecavergunningen ON tblegesregels.dnkeyhorecavergunningen =
tbhorecavergunningen.dnkey
LEFT JOIN tbinfoaanvragen ON tblegesregels.dnkeyinfoaanvraag =
tbinfoaanvragen.dnkey
LEFT JOIN tbomgvergunning ON tblegesregels.dnkeyomgvergunningen =
tbomgvergunning.dnkey
JOIN tblegessoort ON tblegesregels.dnkeylegessoort = tblegessoort.dnkey;
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 26/10/2026 11:10 |
|