Datadictionary OpenWave 3.1.25 |
|
View: vwlegesregelsvergunningen
Datadictionary OpenWave 3.1.25 |
|
View: vwlegesregelsvergunningen
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwlegesregelsvergunningen
Fields
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 |
|
bouwontvangstdatum |
timestamp |
|
bouwvergunningnr |
varchar(40) |
|
soortbouwverg |
integer |
|
bouwpublicatie |
varchar(50) |
|
bouwbesluitdatum |
timestamp |
|
bouwacceptgiro_verzdatum |
timestamp |
|
bouwverzdatum_besch |
timestamp |
|
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,
dnkeybouwvergunningen,
dnkeyovvergunningen,
dnkeyhorecavergunningen,
dnkeyinfoaanvraag,
dnkeyomgvergunningen,
bouwontvangstdatum,
bouwvergunningnr,
soortbouwverg,
bouwpublicatie,
bouwbesluitdatum,
bouwacceptgiro_verzdatum,
bouwverzdatum_besch,
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.dnkeybouwvergunningen,
tblegesregels.dnkeyovvergunningen,
tblegesregels.dnkeyhorecavergunningen,
tblegesregels.dnkeyinfoaanvraag,
tblegesregels.dnkeyomgvergunningen,
tbbouwvergunningen.ddontvangstdatum AS bouwontvangstdatum,
tbbouwvergunningen.dvbouwnr AS bouwvergunningnr,
tbbouwvergunningen.dnsoortplan AS soortbouwverg,
tbbouwvergunningen.dvpublbouwwerk AS bouwpublicatie,
tbbouwvergunningen.ddbesluitdatum AS bouwbesluitdatum,
tbbouwvergunningen.ddlegesverzonden AS bouwacceptgiro_verzdatum,
tbbouwvergunningen.ddverzenddatum AS bouwverzdatum_besch,
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 tbbouwvergunningen ON tblegesregels.dnkeybouwvergunningen =
tbbouwvergunningen.dnkey
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.pgsqlmanager.com) at 5-1-2022 14:13 |
|