Datadictionary OpenWave 3.1.11 |
|
View: vwhandhinvor_behandelaar
Datadictionary OpenWave 3.1.11 |
|
View: vwhandhinvor_behandelaar
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwhandhinvor_behandelaar
Fields
Name | Data type | Description |
|---|---|---|
dddatum |
timestamp |
|
ddafgehandeld |
timestamp |
|
dvomschrijving |
varchar(50) |
|
dnkeyvergunning |
integer |
|
dvcodemedewerker |
char(5) |
|
dlactief |
char(1) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dddatum,
ddafgehandeld,
dvomschrijving,
dnkeyvergunning,
dvcodemedewerker,
dlactief)
AS
SELECT tbhandhinvorderingen.dddatum, tbhandhinvorderingen.ddafgehandeld,
tbhandhinvorderingen.dvomschrijving,
tbhandhinvorderingen.dnkeyhandhavingen AS dnkeyvergunning,
tbinbehandelingbij.dvcodemedewerker, tbinbehandelingbij.dlactief
FROM tbhandhinvorderingen
LEFT JOIN tbinbehandelingbij ON tbhandhinvorderingen.dnkeyhandhavingen =
tbinbehandelingbij.dnkeyhandhavingen
WHERE tbinbehandelingbij.dlactief = 'T'::bpchar AND
tbhandhinvorderingen.dddatum IS NOT NULL AND tbhandhinvorderingen.ddafgehandeld IS NULL AND (tbhandhinvorderingen.dnkeyhandhavingen IN (
SELECT tbhandhavingen.dnkey
FROM tbhandhavingen
WHERE tbhandhavingen.ddblokkering IS NULL
));
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|