Ersten akademischen Titel anzeigen

Nutzen Sie diese Variable, wenn Sie den akademischen Titel vor dem Namen anzeigen möchten.

Variablename: sva_aggr_CUSTOM

Inhalt der Variable:

update sva_pbv_aggr S set name= (select distinct druck||' '||vornamen||' '||name from sva_pgd P,sva_cifx C where P.titel=C.apnr and C.key=610 and S.personal_nr=P.pgd_join_id) where personal_nr in (select pgd_join_id from sva_pgd where titel is not null and titel!=''); update sva_pbv_aggr S set name= (select distinct vornamen||' '||name from sva_pgd P where S.personal_nr=P.pgd_join_id) where personal_nr not in (select pgd_join_id from sva_pgd where titel is not null and titel!=''); update sva_pbv_aggr_stich S set name= (select distinct druck||' '||vornamen||' '||name from sva_pgd P,sva_cifx C where P.titel=C.apnr and C.key=610 and S.personal_nr=P.pgd_join_id) where personal_nr in (select pgd_join_id from sva_pgd where titel is not null and titel!=''); update sva_pbv_aggr_stich S set name= (select distinct vornamen||' '||name from sva_pgd P where S.personal_nr=P.pgd_join_id) where personal_nr not in (select pgd_join_id from sva_pgd where titel is not null and titel!='');

Sachgebiet: Personal

Aktiv : 1

Gültig von 1.1.1900

Gültig bis 1.1.3000