Datadictionary OpenWave 3.1.11 |
|
View: vwmilklachten_behandelaar
Datadictionary OpenWave 3.1.11 |
|
View: vwmilklachten_behandelaar
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwmilklachten_behandelaar
Fields
Name | Data type | Description |
|---|---|---|
dddatumklacht |
timestamp |
|
ddafgerond |
timestamp |
|
dnkeymilinrichtingen |
integer |
|
dvomschrklacht |
varchar(50) |
|
dvcodemedewerkers |
char(5) |
|
dvdmszaakcode |
varchar(40) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dddatumklacht,
ddafgerond,
dnkeymilinrichtingen,
dvomschrklacht,
dvcodemedewerkers,
dvdmszaakcode)
AS
SELECT tbklachten.dddatumklacht, tbklachten.ddafgerond,
tbklachten.dnkeymilinrichtingen,
tbklachtoverlast.dvomsoverlast AS dvomschrklacht,
tbklachten.dvcodemedewerkers, tbklachten.dvdmszaakcode
FROM tbklachten
JOIN tbklachtoverlast ON tbklachten.dnkeyklachtoverlast = tbklachtoverlast.dnkey
JOIN tbmilinrichtingen ON tbklachten.dnkeymilinrichtingen = tbmilinrichtingen.dnkey
WHERE tbklachten.dddatumklacht IS NOT NULL AND tbklachten.ddafgerond IS NULL;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|