Datadictionary OpenWave 3.1.11 |
|
View: vwrpmilvergadviezen
Datadictionary OpenWave 3.1.11 |
|
View: vwrpmilvergadviezen
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwrpmilvergadviezen
Fields
Name | Data type | Description |
|---|---|---|
dvadvinstantie |
varchar(40) |
|
ddadvaanvraag |
timestamp |
|
ddadvadvies |
timestamp |
|
dvsoortmilverg |
varchar(40) |
|
dvvergnummer |
varchar(20) |
|
dvdossierbehandelaar |
char(5) |
|
dvadviesbehandelaar |
char(5) |
|
dnkeymilinrichtingen |
integer |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dvadvinstantie,
ddadvaanvraag,
ddadvadvies,
dvsoortmilverg,
dvvergnummer,
dvdossierbehandelaar,
dvadviesbehandelaar,
dnkeymilinrichtingen)
AS
SELECT tbadviesinstanties.dvomschrijving AS dvadvinstantie,
tbadviezen.ddaanvraagdatum AS ddadvaanvraag,
tbadviezen.ddadviesdatum AS ddadvadvies,
tbsoortmilverg.dvomschrijving AS dvsoortmilverg,
tbmilvergunningen.dvvergnummer,
vwfrmactiefinbehbij.dvibbcodemw AS dvdossierbehandelaar,
tbadviezen.dvcodemedewerkers AS dvadviesbehandelaar,
tbmilvergunningen.dnkeymilinrichtingen
FROM tbadviezen
JOIN tbadviesinstanties ON tbadviezen.dvcodeadviesinstanties =
tbadviesinstanties.dvcode
JOIN tbmilvergunningen ON tbadviezen.dnkeymilvergunningen = tbmilvergunningen.dnkey
JOIN tbsoortmilverg ON tbmilvergunningen.dnkeysoortmilverg = tbsoortmilverg.dnkey
LEFT JOIN vwfrmactiefinbehbij ON tbadviezen.dnkeymilvergunningen =
vwfrmactiefinbehbij.dnkeymilvergunningen;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|