Datadictionary OpenWave 3.1.33 |
|
View: vwfrmcbsomgw011_b
Datadictionary OpenWave 3.1.33 |
|
View: vwfrmcbsomgw011_b
Schema
public
Owner
waveuser005
Descriptions
View van alle omgevingsvergunningskeys (tbomgvergunningen.dnkey) die voldoen aan de criteria om een CBS W011-formulier aan te maken. Basistabel tbtoestemmingen/tbomgvergunning
Columns
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
Primary key van de omgevingsvergunning (tbomgvergunningen.dnkey) die voldoet aan de CBS-W011-criteria |
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwfrmcbsomgw011_b
Definition
dnkey)
AS
SELECT tbomgvergunning.dnkey
FROM tbomgvergunning
JOIN tbsoortomgverg ON tbomgvergunning.dnkeysoortomgverg = tbsoortomgverg.dnkey
JOIN vwcbsomgw011_a ON tbomgvergunning.dnkey = vwcbsomgw011_a.dnkey
WHERE vwcbsomgw011_a.dfkosten >= tbsoortomgverg.dfcbsbedrag AND
tbomgvergunning.dlbeperktetoegang = 'F'::bpchar;
COMMENT ON VIEW public.vwfrmcbsomgw011_b
IS 'View van alle omgevingsvergunningskeys (tbomgvergunningen.dnkey) die voldoen aan de criteria om een CBS W011-formulier aan te maken. Basistabel tbtoestemmingen/tbomgvergunning';
COMMENT ON COLUMN public.vwfrmcbsomgw011_b.dnkey
IS 'Primary key van de omgevingsvergunning (tbomgvergunningen.dnkey) die voldoet aan de CBS-W011-criteria';
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 21-10-2025 10:22 |
|