Schema
public
Owner
waveuser002
Descriptions
There is no description for view vwowbkijkrechtopeningsscherm
Fields
Name | Data type | Description |
---|---|---|
dvloginnaam |
varchar(50) |
|
dvachternaam |
varchar(40) |
|
dvvoorletters |
varchar(10) |
|
dvtussenvoegsel |
varchar(10) |
|
dvmodulekijkrechten |
varchar(8) |
|
dvlaatstemodule |
char(1) |
|
dnlaatstekey |
integer |
|
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Definition
CREATE VIEW public.vwowbkijkrechtopeningsscherm (
dvloginnaam,
dvachternaam,
dvvoorletters,
dvtussenvoegsel,
dvmodulekijkrechten,
dvlaatstemodule,
dnlaatstekey)
AS
SELECT a.dvloginnaam, a.dvomschrijving AS dvachternaam, a.dvvoorletters,
a.dvtussenvoegsel,
(((((((
CASE
WHEN b.dlaomgvsb = 'T'::bpchar THEN 'W'::text
ELSE ''::text
END ||
CASE
WHEN b.dlabwvvsb = 'T'::bpchar THEN 'B'::text
ELSE ''::text
END) ||
CASE
WHEN b.dlaovvvsb = 'T'::bpchar THEN 'O'::text
ELSE ''::text
END) ||
CASE
WHEN b.dlahahvsb = 'T'::bpchar THEN 'H'::text
ELSE ''::text
END) ||
CASE
WHEN b.dlahorvsb = 'T'::bpchar THEN 'C'::text
ELSE ''::text
END) ||
CASE
WHEN b.dlainfovsb = 'T'::bpchar THEN 'I'::text
ELSE ''::text
END) ||
CASE
WHEN b.dlamilvsb = 'T'::bpchar THEN 'EV'::text
ELSE ''::text
END))::character varying(8) AS dvmodulekijkrechten,
a.dvlaatstemodule, a.dnlaatsterecord AS dnlaatstekey
FROM tbmedewerkers a
LEFT JOIN tbrechten b ON a.dnkeyrechten = b.dnkey;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-01-2013 17:28 |
![]() ![]() ![]() |