openwave 3.1.2
Previous topic Chapter index Next topic

View: vwowbkijkrechtopeningsscherm

 

 

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
Previous topic Chapter index Next topic