Datadictionary OpenWave 3.1.11 |
|
View: vwomgadvies_behandelaar
Datadictionary OpenWave 3.1.11 |
|
View: vwomgadvies_behandelaar
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwomgadvies_behandelaar
Fields
Name | Data type | Description |
|---|---|---|
ddrappeldatum |
timestamp |
|
ddadviesdatum |
timestamp |
|
dvomschrijving |
varchar(40) |
|
dnkeyvergunning |
integer |
|
dvomschradviesinstantie |
varchar(40) |
|
dvcodemedewerker |
text |
|
dnkeyadvies |
integer |
|
dvibbcodemw |
char(5) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
ddrappeldatum,
ddadviesdatum,
dvomschrijving,
dnkeyvergunning,
dvomschradviesinstantie,
dvcodemedewerker,
dnkeyadvies,
dvibbcodemw)
AS
SELECT tbadviezen.ddrappeldatum, tbadviezen.ddadviesdatum,
tbadviezen.dvomschrijving,
tbadviezen.dnkeyomgvergunningen AS dnkeyvergunning,
tbadviesinstanties.dvomschrijving AS dvomschradviesinstantie,
btrim(tbadviezen.dvcodemedewerkers::text) AS dvcodemedewerker,
tbadviezen.dnkey AS dnkeyadvies,
tbinbehandelingbij.dvcodemedewerker AS dvibbcodemw
FROM tbadviezen
JOIN tbadviesinstanties ON tbadviezen.dvcodeadviesinstanties =
tbadviesinstanties.dvcode
LEFT JOIN tbinbehandelingbij ON tbadviezen.dnkeyomgvergunningen =
tbinbehandelingbij.dnkeyomgvergunningen
WHERE tbadviezen.ddrappeldatum IS NOT NULL AND tbadviezen.ddadviesdatum IS NULL
AND tbadviezen.ddvervallen IS NULL AND (tbadviezen.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 tbinbehandelingbij.dlactief = 'T'::bpchar;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|