create table superx_sva (pgd_join_id integer, pgd_join_id_ldsg integer,sgd_join_id integer); 

create table superx_sva (pgd_join_id integer, pgd_join_id_ldsg integer,sgd_join_id integer); 

create table superx_sva (pgd_join_id integer, pgd_join_id_ldsg integer,sgd_join_id integer); 

execute procedure sp_pgd_join_id_ld('$ANONYM');

select sp_pgd_join_id_ld('"$ANONYM"');

insert into superx_sva(pgd_join_id,pgd_join_id_ldsg)
SELECT  distinct P.pgd_join_id,P.pgd_join_id_ldsg
FROM    pgd_join_id_ldsg P,pbv V
where V.pbv_pgd_join_id=P.pgd_join_id
and ('$SVA_AKTIV'  <= V.pbv_bis 
or V.pbv_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900') );

insert into superx_sva(sgd_join_id)
SELECT  distinct  sgd_join_id
FROM    sgd
where sgd_status=0
and ('$SVA_AKTIV' <= sgd_bis 
or sgd_bis is null
or date('$SVA_AKTIV')=date('01.01.1900') );

insert into superx_sva(pgd_join_id,pgd_join_id_ldsg)
SELECT distinct P.pgd_join_id,P.pgd_join_id_ldsg
FROM    pgd_join_id_ldsg P,pbv V
where V.pbv_pgd_join_id=P.pgd_join_id
and (date('"$SVA_AKTIV"') <= V.pbv_bis 
or V.pbv_bis is null
 or ('"$SVA_AKTIV"')=date('01.01.1900')

 );

insert into superx_sva(pgd_join_id,pgd_join_id_ldsg)
SELECT  distinct  V.pbv_pgd_join_id,V.pbv_pgd_join_id
FROM    pbv V
where (#$SVA_AKTIV# <= V.pbv_bis
or V.pbv_bis is null
 or '$SVA_AKTIV'='1900-01-01' );

insert into superx_sva(sgd_join_id)
SELECT  distinct sgd_join_id
FROM    sgd
where sgd_status=0
and (#$SVA_AKTIV# <= sgd_bis
or sgd_bis is null
 or '$SVA_AKTIV'='1900-01-01' );

insert into superx_sva(sgd_join_id)
SELECT  sgd_join_id
FROM    sgd
where sgd_status=0
and (date('"$SVA_AKTIV"') <= sgd_bis 
or sgd_bis is null
 or date('"$SVA_AKTIV"')=date('01.01.1900') );

select 1,left(version,1),'SVA-Version' from db_version 
 where his_system like '%SVA%' 
 
;

select 1,$VERSION,'SVA-Version' from db_version 
 where his_system like '%SVA%' 
 
;

select 1,$VERSION,'SVA-Version' from db_version 
 where his_system like '%SVA%' 
 
;

select 1,$VERSION,'SVA-Version' from sva4.db_version 
 where his_system like '%SVA%' 
 
;

select distinct  
  pbv_pgd_join_id,
  pbv_nr ,
'R' ,
  pbv_art ,
pbv_von,
pbv_bis,
    pbv_befr_bis,
  pbv_befr_grund,
  pbv_dienstart,
pbv_hoechstdauer,
pbv_serial,
pbv_rechtsstell
FROM pbv
WHERE
 pbv_status=0
and ('$SVA_AKTIV'  <= pbv_bis 
or pbv_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900') )
;

select  distinct
  P.pgd_join_id_ldsg,
  pbv_nr ,
'R' ,
  pbv_art ,
pbv_von,
pbv_bis,
    pbv_befr_bis,
  pbv_befr_grund,
  pbv_dienstart,
pbv_hoechstdauer,
pbv_serial,
pbv_rechtsstell
FROM pbv,superx_sva P
WHERE
pbv_pgd_join_id=P.pgd_join_id
and pbv_status=0
and ('$SVA_AKTIV'  <= pbv.pbv_bis 
or pbv.pbv_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  distinct
  pbv_pgd_join_id,
  pbv_nr ,
'R'::char(1)  ,
  pbv_art ,
pbv_von,
pbv_bis,
    pbv_befr_bis,
  pbv_befr_grund,
  pbv_dienstart,
pbv_hoechstdauer,
pbv_serial,
pbv_rechtsstell
FROM pbv
WHERE
 pbv_status=0
and ('$SVA_AKTIV'  <= pbv_bis 
or pbv_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900') )
;

select  distinct
  P.pgd_join_id_ldsg,
  pbv_nr ,
'R'::char(1) ,
  pbv_art ,
pbv_von,
pbv_bis,
    pbv_befr_bis,
  pbv_befr_grund,
  pbv_dienstart,
pbv_hoechstdauer,
pbv_serial,
pbv_rechtsstell
FROM pbv,superx_sva P
WHERE
pbv_pgd_join_id=P.pgd_join_id
and pbv_status=0
and ('$SVA_AKTIV'  <= pbv.pbv_bis 
or pbv.pbv_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  distinct 
  P.pgd_join_id_ldsg,
  pbv_nr ,
'R' ,
  pbv_art ,
pbv_von,
pbv_bis,
    pbv_befr_bis,
  pbv_befr_grund,
  pbv_dienstart,
pbv_hoechstdauer,
pbv_serial,
pbv_rechtsstell
FROM pbv,superx_sva P
WHERE
pbv_pgd_join_id=P.pgd_join_id
and pbv_status=0
and ('$SVA_AKTIV'  <= pbv.pbv_bis 
or pbv.pbv_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
  pfi_pbv_nr ,
  P.pgd_join_id_ldsg,  
    pfi_serial,
'R' ::char(1),
  pfi_kapitel,
  pfi_titel,
    pfi_utitel,
    pfi_fb_projekt,
    pfi_inst_ausg_1,
    pfi_inst_ausg_2,
    pfi_inst_ausg_3,
  pfi_geldgeber,
  pfi_prozent,
  pfi_kostenziffer,
  pfi_von,
  pfi_bis,
pfi_poz_serial,
pfi_inst_ausg_1, 
'' ,
''
FROM pfi,superx_sva P
WHERE
pfi_pgd_join_id=P.pgd_join_id
and pfi_status=0
and (pfi_uebernahme != 900 or pfi_uebernahme is null)
and ('$SVA_AKTIV'  <= pfi.pfi_bis 
or pfi.pfi_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
  pfi_pbv_nr ,
  P.pgd_join_id_ldsg,   
    pfi_serial,
'R',
  pfi_kapitel,
  pfi_titel,
    pfi_utitel,
    pfi_fb_projekt,
    pfi_inst_ausg_1,
    pfi_inst_ausg_2,
    pfi_inst_ausg_3,
  pfi_geldgeber,
  pfi_prozent,
  pfi_kostenziffer,
  pfi_von,
  pfi_bis,
pfi_poz_serial,
pfi_kostenstelle,
pfi_projekt,
pfi_kostenart
FROM pfi ,superx_sva P
WHERE
pfi_pgd_join_id=P.pgd_join_id
and
  pfi_status=0
  and (pfi_uebernahme != 900 or pfi_uebernahme is null)
and ('$SVA_AKTIV'  <= pfi.pfi_bis 
or pfi.pfi_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
  pfi_pbv_nr ,
  P.pgd_join_id_ldsg,   
    pfi_serial,
'R',
  pfi_kapitel,
  pfi_titel,
    pfi_utitel,
    pfi_fb_projekt,
    pfi_inst_ausg_1,
    pfi_inst_ausg_2,
    pfi_inst_ausg_3,
  pfi_geldgeber,
  pfi_prozent,
  pfi_kostenziffer,
  pfi_von,
  pfi_bis,
'',--pfi_poz_serial,
pfi_kostenstelle,
pfi_projekt,
pfi_kostenart
FROM pfi ,superx_sva P
WHERE
pfi_pgd_join_id=P.pgd_join_id
and
  pfi_status=0
  and (pfi_uebernahme != 900 or pfi_uebernahme is null)
and ('$SVA_AKTIV'  <= pfi.pfi_bis 
or pfi.pfi_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
  pfi_pbv_nr ,
  pfi_pgd_join_id,  
    pfi_serial,
'R' ,
  pfi_kapitel,
  pfi_titel,
    pfi_utitel,
    pfi_fb_projekt,
    pfi_inst_ausg_1,
    pfi_inst_ausg_2,
    pfi_inst_ausg_3,
  pfi_geldgeber,
  pfi_prozent,
  pfi_kostenziffer,
  pfi_von,
  pfi_bis,
pfi_poz_serial,
pfi_inst_ausg_1, 
'' ,
''
FROM pfi
WHERE
pfi_status=0
and (pfi_uebernahme != 900 or pfi_uebernahme is null)
and ('$SVA_AKTIV'  <= pfi.pfi_bis 
or pfi.pfi_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
  pfi_pbv_nr ,
  pfi_pgd_join_id,   
    pfi_serial,
'R',
  pfi_kapitel,
  pfi_titel,
    pfi_utitel,
    pfi_fb_projekt,
    pfi_inst_ausg_1,
    pfi_inst_ausg_2,
    pfi_inst_ausg_3,
  pfi_geldgeber,
  pfi_prozent,
  pfi_kostenziffer,
  pfi_von,
  pfi_bis,
pfi_poz_serial,
pfi_kostenstelle,
pfi_projekt,
pfi_kostenart
FROM pfi 
WHERE
  pfi_status=0
  and (pfi_uebernahme != 900 or pfi_uebernahme is null)
and ('$SVA_AKTIV'  <= pfi.pfi_bis 
or pfi.pfi_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
  pfi_pbv_nr ,
  pfi_pgd_join_id,   
    pfi_serial,
'R',
  pfi_kapitel,
  pfi_titel,
    pfi_utitel,
    pfi_fb_projekt,
    pfi_inst_ausg_1,
    pfi_inst_ausg_2,
    pfi_inst_ausg_3,
  pfi_geldgeber,
  pfi_prozent,
  pfi_kostenziffer,
  pfi_von,
  pfi_bis,
'',--pfi_poz_serial,
pfi_kostenstelle,
pfi_projekt,
pfi_kostenart
FROM pfi 
WHERE
  pfi_status=0
  and (pfi_uebernahme != 900 or pfi_uebernahme is null)
and ('$SVA_AKTIV'  <= pfi.pfi_bis 
or pfi.pfi_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
poz_pbv_nr, 
P.pgd_join_id_ldsg,  
poz_serial, 
'',
'R' as poz_status,
  poz_institut,
poz_von , 
poz_bis, 
poz_anteil_proz,
'' ,
poz_dienststelle
from poz,superx_sva P
WHERE
poz_pgd_join_id=P.pgd_join_id
and
 poz_status = 0
and ('$SVA_AKTIV'  <= poz.poz_bis 
or poz.poz_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
poz_pbv_nr, 
P.pgd_join_id_ldsg,  
poz_serial,  
'',
'R' as poz_status,
  poz_institut,
poz_von , 
poz_bis, 
poz_anteil_proz,
poz_pbv_serial,
poz_dienststelle
from poz,superx_sva P
WHERE
poz_pgd_join_id=P.pgd_join_id
and
poz_status = 0
and ('$SVA_AKTIV'  <= poz.poz_bis 
or poz.poz_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
pfi_pbv_nr, 
P.pgd_join_id_ldsg, 
'',
pfi_serial, 
'R' as poz_status,
  poz_institut,
pfi_von , 
pfi_bis, 
100,
pfi_serial,
poz_dienststelle
from pfi,superx_sva P
WHERE
pfi_pgd_join_id=P.pgd_join_id
and
pfi_status = 0
and ('$SVA_AKTIV'  <= pfi.pfi_bis 
or pfi.pfi_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
poz_pbv_nr, 
poz_pgd_join_id,  
poz_serial, 
'', 
'R' as poz_status,
  poz_institut,
poz_von , 
poz_bis, 
poz_anteil_proz,
'' ,
''
from poz
WHERE
 poz_status = 0
and ('$SVA_AKTIV'  <= poz.poz_bis 
or poz.poz_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
poz_pbv_nr, 
poz_pgd_join_id,  
poz_serial, 
'', 
'R' as poz_status,
  poz_institut,
poz_von , 
poz_bis, 
poz_anteil_proz,
poz_pbv_serial,
''
from poz
WHERE
poz_status = 0
and ('$SVA_AKTIV'  <= poz.poz_bis 
or poz.poz_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
pfi_pbv_nr, 
pfi_pgd_join_id, 
'',  
pfi_serial, 
'R' as poz_status,
  poz_institut,
pfi_von , 
pfi_bis, 
100,
pfi_serial,
poz_dienststelle
from pfi
WHERE
pfi_status = 0
and ('$SVA_AKTIV'  <= pfi.pfi_bis 
or pfi.pfi_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
  pbl_pbv_nr ,
 P.pgd_join_id_ldsg,   
pbl_serial,
  'R' as pbl_status,
  pbl_bvl_gruppe,
  pbl_laufbahn,
  pbl_bewaehr_ab,
  pbl_adt_bez,
  pbl_adt_von,
pbl_betrag,
pbl_betragsart,
  pbl_von,
  pbl_bis,
	pbl_kostenart,
'',
'',--pbl_fallgruppe,
'',--pbl_teil,
'',--pbl_abschnitt,
'' ,--pbl_unterabsch
'' --pbl_tvl_stufe
FROM  pbl,superx_sva P
WHERE
pbl_pgd_join_id=P.pgd_join_id
and
 pbl_status=0
and ('$SVA_AKTIV'  <= pbl.pbl_bis 
or pbl.pbl_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
  pbl_pbv_nr ,
P.pgd_join_id_ldsg,   
pbl_serial,
  'R' as pbl_status,
  pbl_bvl_gruppe,
  pbl_laufbahn,
  pbl_bewaehr_ab,
  pbl_adt_bez,
  pbl_adt_von,
pbl_betrag,
pbl_betragsart,
  pbl_von,
  pbl_bis,
pbl_kostenart,
pbl_pbv_serial,
pbl_fallgruppe,
pbl_teil,
pbl_abschnitt,
pbl_unterabsch,
'' --pbl_tvl_stufe
FROM  pbl,superx_sva P
WHERE
pbl_pgd_join_id=P.pgd_join_id
and pbl_status=0
and ('$SVA_AKTIV'  <= pbl.pbl_bis 
or pbl.pbl_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
  pbl_pbv_nr ,
P.pgd_join_id_ldsg,   
pbl_serial,
  'R' as pbl_status,
  pbl_bvl_gruppe,
  pbl_laufbahn,
  pbl_bewaehr_ab,
  pbl_adt_bez,
  pbl_adt_von,
pbl_betrag,
pbl_betragsart,
  pbl_von,
  pbl_bis,
pbl_kostenart,
pbl_pbv_serial,
pbl_fallgruppe,
pbl_teil,
pbl_abschnitt,
pbl_unterabsch,
pbl_tvl_stufe
FROM  pbl,superx_sva P
WHERE
pbl_pgd_join_id=P.pgd_join_id
and pbl_status=0
and ('$SVA_AKTIV'  <= pbl.pbl_bis 
or pbl.pbl_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
  pbl_pbv_nr ,
 pbl_pgd_join_id,   
pbl_serial,
  'R' as pbl_status,
  pbl_bvl_gruppe,
  pbl_laufbahn,
  pbl_bewaehr_ab,
  pbl_adt_bez,
  pbl_adt_von,
pbl_betrag,
pbl_betragsart,
  pbl_von,
  pbl_bis,
	pbl_kostenart,
'',
'',--pbl_fallgruppe,
'',--pbl_teil,
'',--pbl_abschnitt,
'', --pbl_unterabsch
'' --pbl_tvl_stufe
FROM  pbl
where pbl_status=0
and ('$SVA_AKTIV'  <= pbl.pbl_bis 
or pbl.pbl_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
  pbl_pbv_nr ,
pbl_pgd_join_id,   
pbl_serial,
  'R' as pbl_status,
  pbl_bvl_gruppe,
  pbl_laufbahn,
  pbl_bewaehr_ab,
  pbl_adt_bez,
  pbl_adt_von,
pbl_betrag,
pbl_betragsart,
  pbl_von,
  pbl_bis,
	pbl_kostenart,
pbl_pbv_serial,
pbl_fallgruppe,
pbl_teil,
pbl_abschnitt,
pbl_unterabsch,
'' --pbl_tvl_stufe

FROM  pbl
WHERE
 pbl_status=0
and ('$SVA_AKTIV'  <= pbl.pbl_bis 
or pbl.pbl_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select  
  pbl_pbv_nr ,
pbl_pgd_join_id,   
pbl_serial,
  'R' as pbl_status,
  pbl_bvl_gruppe,
  pbl_laufbahn,
  pbl_bewaehr_ab,
  pbl_adt_bez,
  pbl_adt_von,
pbl_betrag,
pbl_betragsart,
  pbl_von,
  pbl_bis,
	pbl_kostenart,
pbl_pbv_serial,
pbl_fallgruppe,
pbl_teil,
pbl_abschnitt,
pbl_unterabsch,
pbl_tvl_stufe

FROM  pbl
WHERE
 pbl_status=0
and ('$SVA_AKTIV'  <= pbl.pbl_bis 
or pbl.pbl_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
 P.pgd_join_id_ldsg,   
    'R' as status ,
    '' ,
    '',
    '' ,
$pgd_titel ,
$pgd_geburtsdatum,
$pgd_geschlecht,
$pgd_fam_stand,
$pgd_staatsangehoer ,
$pgd_plz ,
$pgd_wohnort ,
$pgd_land ,
$pgd_kategorie ,
$pgd_matrikelnummer ,
$pgd_austrittsdatum ,
$pgd_beschaeft_von ,
$pgd_besold_dienst ,
$pgd_dienstzeit ,
$pgd_eintrittsdatum ,
$pgd_eintritt_land ,
$pgd_jubi_25_datum ,
$pgd_jubi_40_datum ,
$pgd_jubi_50_datum ,
$pgd_jubi_berech ,
$pgd_leb_alterstufe ,
$pgd_verleihung,
$pgd_ablauf_probe ,
$pgd_rentendatum,
$pgd_widerrufdatum,
'',
$pgd_habil_jahr ,
$pgd_habil_hochsch ,
$pgd_habil_fach,
$pgd_berufungsjahr,
$pgd_lehrfach_einw,
"" --pgd_akad_grad
FROM  pgd G,superx_sva P
WHERE
G.pgd_join_id=P.pgd_join_id
and
pgd_status=0

  ;

select
 P.pgd_join_id_ldsg,   
    'R' as status ,
    '' ,
    '',
    '' ,
$pgd_titel ,
$pgd_geburtsdatum,
$pgd_geschlecht,
$pgd_fam_stand,
$pgd_staatsangehoer ,
$pgd_plz ,
$pgd_wohnort ,
$pgd_land ,
$pgd_kategorie ,
$pgd_matrikelnummer ,
$pgd_austrittsdatum ,
$pgd_beschaeft_von ,
$pgd_besold_dienst ,
$pgd_dienstzeit ,
$pgd_eintrittsdatum ,
$pgd_eintritt_land ,
$pgd_jubi_25_datum ,
$pgd_jubi_40_datum ,
$pgd_jubi_50_datum ,
$pgd_jubi_berech ,
$pgd_leb_alterstufe ,
$pgd_verleihung,
$pgd_ablauf_probe ,
$pgd_rentendatum,
$pgd_widerrufdatum,
'',
$pgd_habil_jahr ,
$pgd_habil_hochsch ,
$pgd_habil_fach,
$pgd_berufungsjahr,
$pgd_lehrfach_einw,
$pgd_akad_grad
FROM  pgd G,superx_sva P
WHERE
G.pgd_join_id=P.pgd_join_id
and
 pgd_status=0
  ;

select
 P.pgd_join_id_ldsg,   
    'R' as status ,
     '' ,
    '',
    '' ,
$pgd_titel ,
$pgd_geburtsdatum,
$pgd_geschlecht,
$pgd_fam_stand,
$pgd_staatsangehoer ,
$pgd_plz ,
$pgd_wohnort ,
$pgd_land ,
$pgd_kategorie ,
$pgd_matrikelnummer ,
$pgd_austrittsdatum ,
$pgd_beschaeft_von ,
$pgd_besold_dienst ,
$pgd_dienstzeit ,
$pgd_eintrittsdatum ,
$pgd_eintritt_land ,
$pgd_jubi_25_datum ,
$pgd_jubi_40_datum ,
$pgd_jubi_50_datum ,
$pgd_jubi_berech ,
$pgd_leb_alterstufe ,
$pgd_verleihung,
$pgd_ablauf_probe ,
$pgd_rentendatum,
$pgd_widerrufdatum,
'',
$pgd_habil_jahr ,
$pgd_habil_hochsch ,
$pgd_habil_fach,
$pgd_berufungsjahr,
$pgd_lehrfach_einw,
$pgd_akad_grad
FROM  pgd G,superx_sva P
WHERE
G.pgd_join_id=P.pgd_join_id
and
 pgd_status=0

  ;

select
P.pgd_join_id_ldsg,    
    'R' as status ,
    pgd_name ,
    pgd_suchname,
    pgd_vornamen ,
    pgd_titel ,
    pgd_geburtsdatum,
    pgd_geschlecht,
    pgd_fam_stand,
    pgd_staatsangehoer ,
    pgd_plz ,
    pgd_wohnort ,
    pgd_land ,
    pgd_kategorie ,
    pgd_matrikelnummer ,
    pgd_austrittsdatum ,
    pgd_beschaeft_von ,
    pgd_besold_dienst ,
    pgd_dienstzeit ,
    pgd_eintrittsdatum ,
    pgd_eintritt_land ,
    pgd_jubi_25_datum ,
    pgd_jubi_40_datum ,
    pgd_jubi_50_datum ,
    pgd_jubi_berech ,
    pgd_leb_alterstufe ,
    pgd_verleihung,
    pgd_ablauf_probe ,
    pgd_rentendatum,
    pgd_widerrufdatum,
    '',
    pgd_habil_jahr ,
    pgd_habil_hochsch ,
    pgd_habil_fach,
pgd_berufungsjahr,
    pgd_lehrfach_einw,
'' --pgd_akad_grad
FROM  pgd G,superx_sva P
WHERE
G.pgd_join_id=P.pgd_join_id
and pgd_status=0
  ;

select
 P.pgd_join_id_ldsg,   
    'R' as status ,
    pgd_name ,
    pgd_suchname,
    pgd_vornamen ,
    pgd_titel ,
    pgd_geburtsdatum,
    pgd_geschlecht,
    pgd_fam_stand,
    pgd_staatsangehoer ,
    pgd_plz ,
    pgd_wohnort ,
    pgd_land ,
    pgd_kategorie ,
    pgd_matrikelnummer ,
    pgd_austrittsdatum ,
    pgd_beschaeft_von ,
    pgd_besold_dienst ,
    pgd_dienstzeit ,
    pgd_eintrittsdatum ,
    pgd_eintritt_land ,
    pgd_jubi_25_datum ,
    pgd_jubi_40_datum ,
    pgd_jubi_50_datum ,
    pgd_jubi_berech ,
    pgd_leb_alterstufe ,
    pgd_verleihung,
    pgd_ablauf_probe ,
    pgd_rentendatum,
    pgd_widerrufdatum,
    '',
    pgd_habil_jahr ,
    pgd_habil_hochsch ,
    pgd_habil_fach,
pgd_berufungsjahr,
    pgd_lehrfach_einw,
pgd_akad_grad
FROM  pgd G,superx_sva P
WHERE
G.pgd_join_id=P.pgd_join_id
and pgd_status=0
  ;

select
pgd_join_id,    
    'R' as status ,
    $pgd_name ,
    $pgd_suchname,
    $pgd_vornamen ,
 $pgd_titel ,
$pgd_geburtsdatum,
$pgd_geschlecht,
$pgd_fam_stand,
$pgd_staatsangehoer ,
$pgd_plz ,
$pgd_wohnort ,
$pgd_land ,
$pgd_kategorie ,
$pgd_matrikelnummer ,
$pgd_austrittsdatum ,
$pgd_beschaeft_von ,
$pgd_besold_dienst ,
$pgd_dienstzeit ,
$pgd_eintrittsdatum ,
$pgd_eintritt_land ,
$pgd_jubi_25_datum ,
$pgd_jubi_40_datum ,
$pgd_jubi_50_datum ,
$pgd_jubi_berech ,
$pgd_leb_alterstufe ,
$pgd_verleihung,
$pgd_ablauf_probe ,
$pgd_rentendatum,
$pgd_widerrufdatum,
'',
$pgd_habil_jahr ,
$pgd_habil_hochsch ,
$pgd_habil_fach,
$pgd_berufungsjahr,
$pgd_lehrfach_einw,
"" --pgd_akad_grad
FROM  pgd G
WHERE
 pgd_status=0
  ;

select
 pgd_join_id,   
    'R' as status ,
    $pgd_name ,
    $pgd_suchname,
    $pgd_vornamen ,
$pgd_titel ,
$pgd_geburtsdatum,
$pgd_geschlecht,
$pgd_fam_stand,
$pgd_staatsangehoer ,
$pgd_plz ,
$pgd_wohnort ,
$pgd_land ,
$pgd_kategorie ,
$pgd_matrikelnummer ,
$pgd_austrittsdatum ,
$pgd_beschaeft_von ,
$pgd_besold_dienst ,
$pgd_dienstzeit ,
$pgd_eintrittsdatum ,
$pgd_eintritt_land ,
$pgd_jubi_25_datum ,
$pgd_jubi_40_datum ,
$pgd_jubi_50_datum ,
$pgd_jubi_berech ,
$pgd_leb_alterstufe ,
$pgd_verleihung,
$pgd_ablauf_probe ,
$pgd_rentendatum,
$pgd_widerrufdatum,
'',
$pgd_habil_jahr ,
$pgd_habil_hochsch ,
$pgd_habil_fach,
$pgd_berufungsjahr,
$pgd_lehrfach_einw,
$pgd_akad_grad
FROM  pgd 
WHERE
 pgd_status=0

  ;

select
 pgd_join_id,   
    'R' as status ,
    $pgd_name ,
    $pgd_suchname,
    $pgd_vornamen ,
$pgd_titel ,
$pgd_geburtsdatum,
$pgd_geschlecht,
$pgd_fam_stand,
$pgd_staatsangehoer ,
$pgd_plz ,
$pgd_wohnort ,
$pgd_land ,
$pgd_kategorie ,
$pgd_matrikelnummer ,
$pgd_austrittsdatum ,
$pgd_beschaeft_von ,
$pgd_besold_dienst ,
$pgd_dienstzeit ,
$pgd_eintrittsdatum ,
$pgd_eintritt_land ,
$pgd_jubi_25_datum ,
$pgd_jubi_40_datum ,
$pgd_jubi_50_datum ,
$pgd_jubi_berech ,
$pgd_leb_alterstufe ,
$pgd_verleihung,
$pgd_ablauf_probe ,
$pgd_rentendatum,
$pgd_widerrufdatum,
'',
$pgd_habil_jahr ,
$pgd_habil_hochsch ,
$pgd_habil_fach,
$pgd_berufungsjahr,
$pgd_lehrfach_einw,
$pgd_akad_grad
FROM  pgd 
WHERE
pgd_status=0

  ;

SELECT 
$pbz_pgd_join_id,
$pbz_pbv_nr,
$pbz_serial,
'R' as status ,
$pbz_von,
$pbz_bis,
$pbz_info_1,
$pbz_info_2,
$pbz_berech_datum,
$pbz_grundverguet,
$pbz_ortszuschlag,
$pbz_zulage1,
$pbz_zulage2,
$pbz_zulage3,
$pbz_zulage4,
$pbz_vermoegenlst,
$pbz_kv_zuschuss,
$pbz_pv_zuschuss,
$pbz_sonstige1,
$pbz_sonstige2,
$pbz_sonstige3,
$pbz_sonstige4,
$pbz_av_zuschuss,
$pbz_rv_zuschuss,
$pbz_kindergeld,
$pbz_sonstige5,
$pbz_sonstige6,
$pbz_gesamtbetrag,
$pbz_kuerzungen,
$pbz_vbl_steuer,
$pbz_aus_mon_soll,
$pbz_zuschuss_405,
$pbz_sv_gesamt,
$pbz_imp_serial,
$pbz_pbv_serial,
$pbz_pfi_serial,
$pbz_pfi_uebernahme,
$pbz_vr_betrag,
$pbz_vr_zulagen
FROM  pbz B
WHERE
 '' || $pbz_pgd_join_id !=''
and pbz_status=0
and ('$SVA_AKTIV'  <= B.pbz_bis 
or B.pbz_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
  ;

select
 P.pgd_join_id_ldsg,   
$pbz_pbv_nr,
$pbz_serial,
'R' as status ,
$pbz_von,
$pbz_bis,
$pbz_info_1,
$pbz_info_2,
$pbz_berech_datum,
$pbz_grundverguet,
$pbz_ortszuschlag,
$pbz_zulage1,
$pbz_zulage2,
$pbz_zulage3,
$pbz_zulage4,
$pbz_vermoegenlst,
$pbz_kv_zuschuss,
$pbz_pv_zuschuss,
$pbz_sonstige1,
$pbz_sonstige2,
$pbz_sonstige3,
$pbz_sonstige4,
$pbz_av_zuschuss,
$pbz_rv_zuschuss,
$pbz_kindergeld,
$pbz_sonstige5,
$pbz_sonstige6,
$pbz_gesamtbetrag,
$pbz_kuerzungen,
$pbz_vbl_steuer,
$pbz_aus_mon_soll,
$pbz_zuschuss_405,
$pbz_sv_gesamt,
$pbz_imp_serial,
$pbz_pbv_serial,
$pbz_pfi_serial,
$pbz_pfi_uebernahme,
$pbz_vr_betrag,
$pbz_vr_zulagen
FROM  pbz B,superx_sva P
WHERE
B.pbz_pgd_join_id=P.pgd_join_id
and '' || $pbz_pgd_join_id !=''
and pbz_status=0
and ('$SVA_AKTIV'  <= B.pbz_bis 
or B.pbz_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
  ;

SELECT 
       pbv_to_pbz_serial,
       pgd_join_id,
       pbv_nr,
       pbv_to_pbz_von,
       pbv_to_pbz_bis,
       prozent,
       festbetrag,
       aufteil_art,
       '' as pbv_serial,
       'R' as pbv_to_pbz_status
FROM pbv_to_pbz
where $pbv_to_pbz_unload ='true'
and pbv_to_pbz_status=0
and ('$SVA_AKTIV'  <= pbv_to_pbz_bis 
or pbv_to_pbz_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))

;

SELECT 
       pbv_to_pbz_serial,
       P.pgd_join_id_ldsg,
       pbv_nr,
       pbv_to_pbz_von,
       pbv_to_pbz_bis,
       prozent,
       festbetrag,
       aufteil_art,
       '' as pbv_serial,
       'R' as pbv_to_pbz_status
FROM pbv_to_pbz B,superx_sva P
WHERE
B.pgd_join_id=P.pgd_join_id
and $pbv_to_pbz_unload ='true'
and pbv_to_pbz_status=0
and ('$SVA_AKTIV'  <= B.pbv_to_pbz_bis 
or B.pbv_to_pbz_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
  S.sgd_join_id,
  'R',
  sgd_ansatz_proz,
  sgd_von,
  sgd_bis,
  sgd_restkont_proz,
  sgd_genehm_jahr,
  '',
  sgd_kategorie,
sgd_besetzung,
sgd_geteilt,
sgd_sis_vermerk1,
sgd_sis_vermerk2,
sgd_sis_vermerk3

FROM  sgd S,superx_sva P
WHERE
S.sgd_join_id=P.sgd_join_id
and sgd_status=0
and ('$SVA_AKTIV'  <= S.sgd_bis 
or S.sgd_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))

;

select
  sgd_join_id,
  'R',
  sgd_ansatz_proz,
  sgd_von,
  sgd_bis,
  sgd_restkont_proz,
  sgd_genehm_jahr,
  '',
  sgd_kategorie,
sgd_besetzung,
sgd_geteilt,
sgd_sis_vermerk1,
sgd_sis_vermerk2,
sgd_sis_vermerk3

FROM  sgd S
WHERE
sgd_status=0
and ('$SVA_AKTIV'  <= S.sgd_bis 
or S.sgd_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
  swe_sgd_join_id,
swe_serial,
  'R',
  swe_dienstart,
  swe_stellengruppe,
  swe_bezeichnung,
  swe_von,
  swe_bis,
swe_z_stellengrp,
swe_z_dienstart,
swe_z_bezeichnung,
swe_sis_wert,
swe_fallgruppe,
swe_kapitel,
swe_titel,
swe_fb_projekt,
swe_laufbahn

FROM  swe,superx_sva P
WHERE
swe_sgd_join_id=P.sgd_join_id
and swe_status=0
and ('$SVA_AKTIV'  <= swe_bis 
or swe_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
  swe_sgd_join_id,
swe_serial,
  'R',
  swe_dienstart,
  swe_stellengruppe,
  swe_bezeichnung,
  swe_von,
  swe_bis,
swe_z_stellengrp,
swe_z_dienstart,
swe_z_bezeichnung,
swe_sis_wert,
swe_fallgruppe,
swe_kapitel,
swe_titel,
swe_fb_projekt,
swe_laufbahn

FROM  swe
WHERE
swe_status=0
and ('$SVA_AKTIV'  <= swe_bis 
or swe_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
  soe_sgd_join_id,
soe_serial,
  'R',
  soe_institut,
    soe_lehreinheit, 
  soe_kapitel,
  soe_titel,
  soe_kostenstelle,
  soe_von,
  soe_bis,
  soe_u_institut,
soe_zuord_pgd,
soe_zuord_sgd,
soe_dienststelle,
    soe_anteil_proz

FROM  soe,superx_sva P
WHERE
soe_sgd_join_id=P.sgd_join_id
and soe_status=0
and ('$SVA_AKTIV'  <= soe_bis 
or soe_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))

;

select
  soe_sgd_join_id,
soe_serial,
  'R',
  soe_institut,
    soe_lehreinheit, 
  soe_kapitel,
  soe_titel,
  soe_kostenstelle,
  soe_von,
  soe_bis,
  soe_u_institut,
soe_zuord_pgd,
soe_zuord_sgd,
soe_dienststelle,
    soe_anteil_proz

FROM  soe
WHERE
 soe_status=0
 and ('$SVA_AKTIV'  <= soe_bis 
or soe_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
  shv_sgd_join_id,
shv_serial,
  'R',
  shv_hh_vermerk,
  shv_von,
  shv_bis,
 shv_kategorie_ziel,
 shv_bvlgruppe_ziel,
 shv_laufbahn_ziel,
 shv_dienstbez_ziel,
 shv_kw_faell_hh

FROM  shv,superx_sva P
WHERE
shv_sgd_join_id=P.sgd_join_id
and shv_status=0
and ('$SVA_AKTIV'  <= shv_bis 
or shv_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
  shv_sgd_join_id,
shv_serial,
  'R',
  shv_hh_vermerk,
  shv_von,
  shv_bis,
 shv_kategorie_ziel,
 shv_bvlgruppe_ziel,
 shv_laufbahn_ziel,
 shv_dienstbez_ziel,
 shv_kw_faell_hh

FROM  shv
WHERE
shv_status=0
and ('$SVA_AKTIV'  <= shv_bis 
or shv_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pbe_nr,
pbe_pbv_nr,
P.pgd_join_id_ldsg,
pbe_sgd_join_id,
pbe_serial,
'R' as pbe_status,
pbe_art,
pbe_tarif_std,
pbe_anteil_stdpro,
pbe_anteil_prozent,
pbe_anteil_std,
pbe_kennzeichen,
pbe_grund,
pbe_von,
pbe_bis,
pbe_endegrund,
pbe_genehmigung,
pbe_genehmigung_v,
pbe_ms_schluessel,
pbe_ms_ziel,
pbe_ms_bis,
'',
pbe_sis_ia,
pbe_sis_wert,
pbe_ms_prog_bis,
pbe_serial_storno,
'', 
'' ,
''

from  pbe ,superx_sva P
WHERE
pbe_pgd_join_id=P.pgd_join_id
and
 pbe_status=0
 and ('$SVA_AKTIV'  <= pbe_bis 
or pbe_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))

;

select
pbe_nr,
pbe_pbv_nr,
P.pgd_join_id_ldsg,
pbe_sgd_join_id,
pbe_serial,
'R' as pbe_status,
pbe_art,
pbe_tarif_std,
pbe_anteil_stdpro,
pbe_anteil_prozent,
pbe_anteil_std,
pbe_kennzeichen,
pbe_grund,
pbe_von,
pbe_bis,
pbe_endegrund,
pbe_genehmigung,
pbe_genehmigung_v,
pbe_ms_schluessel,
pbe_ms_ziel,
pbe_ms_bis,
'',
pbe_sis_ia,
pbe_sis_wert,
pbe_ms_prog_bis,
pbe_serial_storno,
pbe_soe_serial,
'' ,
''

from  pbe,superx_sva P
WHERE
pbe_pgd_join_id=P.pgd_join_id
and
 pbe_status=0
 and ('$SVA_AKTIV'  <= pbe_bis 
or pbe_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pbe_nr,
pbe_pbv_nr,
P.pgd_join_id_ldsg,
pbe_sgd_join_id,
pbe_serial,
'R' as pbe_status,
pbe_art,
pbe_tarif_std,
pbe_anteil_stdpro,
pbe_anteil_prozent,
pbe_anteil_std,
pbe_kennzeichen,
pbe_grund,
pbe_von,
pbe_bis,
pbe_endegrund,
pbe_genehmigung,
pbe_genehmigung_v,
pbe_ms_schluessel,
pbe_ms_ziel,
pbe_ms_bis,
'',
pbe_sis_ia,
pbe_sis_wert,
pbe_ms_prog_bis,
pbe_serial_storno,
pbe_soe_serial,
'' ,
pbe_pfi_serial

from  pbe,superx_sva P
WHERE
pbe_pgd_join_id=P.pgd_join_id
and
 pbe_status=0
 and ('$SVA_AKTIV'  <= pbe_bis 
or pbe_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pbe_nr,
pbe_pbv_nr,
pbe_pgd_join_id,
pbe_sgd_join_id,
pbe_serial,
'R' as pbe_status,
pbe_art,
pbe_tarif_std,
pbe_anteil_stdpro,
pbe_anteil_prozent,
pbe_anteil_std,
pbe_kennzeichen,
pbe_grund,
pbe_von,
pbe_bis,
pbe_endegrund,
pbe_genehmigung,
pbe_genehmigung_v,
pbe_ms_schluessel,
pbe_ms_ziel,
pbe_ms_bis,
'',
pbe_sis_ia,
pbe_sis_wert,
pbe_ms_prog_bis,
pbe_serial_storno,
'', 
'' 

from  pbe 
WHERE
 pbe_status=0
 and ('$SVA_AKTIV'  <= pbe_bis 
or pbe_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
 ;

select
pbe_nr,
pbe_pbv_nr,
pbe_pgd_join_id,
pbe_sgd_join_id,
pbe_serial,
'R' as pbe_status,
pbe_art,
pbe_tarif_std,
pbe_anteil_stdpro,
pbe_anteil_prozent,
pbe_anteil_std,
pbe_kennzeichen,
pbe_grund,
pbe_von,
pbe_bis,
pbe_endegrund,
pbe_genehmigung,
pbe_genehmigung_v,
pbe_ms_schluessel,
pbe_ms_ziel,
pbe_ms_bis,
'',
pbe_sis_ia,
pbe_sis_wert,
pbe_ms_prog_bis,
pbe_serial_storno,
pbe_soe_serial,
'' ,
''

from  pbe
WHERE
 pbe_status=0
  and ('$SVA_AKTIV'  <= pbe_bis 
or pbe_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pbe_nr,
pbe_pbv_nr,
pbe_pgd_join_id,
pbe_sgd_join_id,
pbe_serial,
'R' as pbe_status,
pbe_art,
pbe_tarif_std,
pbe_anteil_stdpro,
pbe_anteil_prozent,
pbe_anteil_std,
pbe_kennzeichen,
pbe_grund,
pbe_von,
pbe_bis,
pbe_endegrund,
pbe_genehmigung,
pbe_genehmigung_v,
pbe_ms_schluessel,
pbe_ms_ziel,
pbe_ms_bis,
'',
pbe_sis_ia,
pbe_sis_wert,
pbe_ms_prog_bis,
pbe_serial_storno,
pbe_soe_serial,
'' ,
pbe_pfi_serial

from  pbe
WHERE
 pbe_status=0
  and ('$SVA_AKTIV'  <= pbe_bis 
or pbe_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pbu_pbv_nr, 
P.pgd_join_id_ldsg,  
pbu_serial,
pbu_art,
pbu_von,
pbu_bis,
pbu_ununter_seit,
'' 
from pbu,superx_sva P
WHERE
pbu_pgd_join_id=P.pgd_join_id
and
 pbu_status =0
  and ('$SVA_AKTIV'  <= pbu_bis 
or pbu_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pbu_pbv_nr, 
P.pgd_join_id_ldsg,  
pbu_serial,
pbu_art,
pbu_von,
pbu_bis,
pbu_ununter_seit,
pbu_pbv_serial
from pbu,superx_sva P 
WHERE
pbu_pgd_join_id=P.pgd_join_id
and
 pbu_status =0
   and ('$SVA_AKTIV'  <= pbu_bis 
or pbu_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pbu_pbv_nr, 
pbu_pgd_join_id,  
pbu_serial,
pbu_art,
pbu_von,
pbu_bis,
pbu_ununter_seit,
'' 
from pbu
WHERE
 pbu_status =0
   and ('$SVA_AKTIV'  <= pbu_bis 
or pbu_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pbu_pbv_nr, 
pbu_pgd_join_id,  
pbu_serial,
pbu_art,
pbu_von,
pbu_bis,
pbu_ununter_seit,
pbu_pbv_serial
from pbu
WHERE
 pbu_status =0
   and ('$SVA_AKTIV'  <= pbu_bis 
or pbu_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select 
paz_pbv_nr,
P.pgd_join_id_ldsg, 
'', 
'R' ,
paz_tarif_std,
paz_arbzeit_stdpro,
paz_tz_std, 
paz_tz_proz, 
paz_tz_art, 
paz_von, 
paz_bis, 
paz_art_zeit,
'',
'', 
'' 
from paz,superx_sva P
WHERE
paz_pgd_join_id=P.pgd_join_id
and
 paz_status=0
   and ('$SVA_AKTIV'  <= paz_bis 
or paz_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select 
paz_pbv_nr,
P.pgd_join_id_ldsg, 
paz_pbv_serial,
'R' as paz_status,
paz_tarif_std,
paz_arbzeit_stdpro,
paz_tz_std, 
paz_tz_proz, 
paz_tz_art, 
paz_von, 
paz_bis, 
paz_art_zeit,
paz_pbv_serial,
paz_atz_block,
paz_atz_teilzeit
from paz,superx_sva P
WHERE
paz_pgd_join_id=P.pgd_join_id
and
 paz_status=0
    and ('$SVA_AKTIV'  <= paz_bis 
or paz_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select 
paz_pbv_nr,
paz_pgd_join_id, 
'', 
'R' ,
paz_tarif_std,
paz_arbzeit_stdpro,
paz_tz_std, 
paz_tz_proz, 
paz_tz_art, 
paz_von, 
paz_bis, 
paz_art_zeit,
'',
'', 
'' 
from paz
WHERE
 paz_status=0
    and ('$SVA_AKTIV'  <= paz_bis 
or paz_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select 
paz_pbv_nr,
paz_pgd_join_id, 
paz_pbv_serial,
'R' as paz_status,
paz_tarif_std,
paz_arbzeit_stdpro,
paz_tz_std, 
paz_tz_proz, 
paz_tz_art, 
paz_von, 
paz_bis, 
paz_art_zeit,
paz_pbv_serial,
paz_atz_block,
paz_atz_teilzeit
from paz
WHERE
 paz_status=0
    and ('$SVA_AKTIV'  <= paz_bis 
or paz_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
    sbu_serial,
    sbu_pbe_serial,
    'R' as sbu_status,
    sbu_stdpro,
    sbu_prozent,
    sbu_stunden,
    sbu_von,
    sbu_bis,
    sbu_grund
from sbu,pbe,superx_sva P
WHERE
sbu_pbe_serial=pbe_serial
and pbe_pgd_join_id=P.pgd_join_id 
and sbu_status = 0
   and ('$SVA_AKTIV'  <= sbu_bis 
or sbu_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
    sbu_serial,
    sbu_pbe_serial,
    'R' as sbu_status,
    sbu_stdpro,
    sbu_prozent,
    sbu_stunden,
    sbu_von,
    sbu_bis,
    sbu_grund
from sbu,pbe
WHERE
sbu_pbe_serial=pbe_serial
and sbu_status = 0
   and ('$SVA_AKTIV'  <= sbu_bis 
or sbu_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pdp_pbv_nr,
P.pgd_join_id_ldsg,
pdp_serial,
'R' as pdp_status,
pdp_lehreinheit,
pdp_stunden,
pdp_vermerk,
pdp_von,
pdp_bis,
pdp_praesenztage,
'', 
'', 
'' 
from pdp,superx_sva P
WHERE
pdp_pgd_join_id=P.pgd_join_id
and
 pdp_status= 0
    and ('$SVA_AKTIV'  <= pdp_bis 
or pdp_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pdp_pbv_nr,
P.pgd_join_id_ldsg,
pdp_serial,
'R' as pdp_status,
pdp_lehreinheit,
pdp_stunden,
pdp_vermerk,
pdp_von,
pdp_bis,
pdp_praesenztage,
pdp_pbv_serial,
pdp_iststunden,
pdp_institut
from pdp,superx_sva P
WHERE
pdp_pgd_join_id=P.pgd_join_id
and
 pdp_status= 0
     and ('$SVA_AKTIV'  <= pdp_bis 
or pdp_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pdp_pbv_nr,
pdp_pgd_join_id,
pdp_serial,
'R' as pdp_status,
pdp_lehreinheit,
pdp_stunden,
pdp_vermerk,
pdp_von,
pdp_bis,
pdp_praesenztage,
'', 
'', 
'' 
from pdp
WHERE
 pdp_status= 0
     and ('$SVA_AKTIV'  <= pdp_bis 
or pdp_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pdp_pbv_nr,
pdp_pgd_join_id,
pdp_serial,
'R' as pdp_status,
pdp_lehreinheit,
pdp_stunden,
pdp_vermerk,
pdp_von,
pdp_bis,
pdp_praesenztage,
pdp_pbv_serial,
pdp_iststunden,
pdp_institut
from pdp
WHERE
 pdp_status= 0
     and ('$SVA_AKTIV'  <= pdp_bis 
or pdp_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pmi_pdp_serial,
pmi_serial,
'R' as pmi_status,
pmi_minderungsgrd,
pmi_minderungsstd,
pmi_von,
pmi_bis
from pmi M, pdp P,superx_sva S
where pmi_status = 0
and P.pdp_serial=M.pmi_pdp_serial
and P.pdp_pgd_join_id=S.pgd_join_id
    and ('$SVA_AKTIV'  <= pmi_bis 
or pmi_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

select
pmi_pdp_serial,
pmi_serial,
'R' as pmi_status,
pmi_minderungsgrd,
pmi_minderungsstd,
pmi_von,
pmi_bis
from pmi M, pdp P
where pmi_status = 0
and P.pdp_serial=M.pmi_pdp_serial
    and ('$SVA_AKTIV'  <= pmi_bis 
or pmi_bis is null
 or ('$SVA_AKTIV')=date('01.01.1900'))
;

SELECT 
 key_bvlgruppe,
 '', 
 kurz_bvlgruppe,
 druck_bvlgruppe,
 text_bvlgruppe,
 sort_key,
 bund_bvlgruppe,
 bund_dienstverh,
 land_bvlgruppe,
 key_von,
 key_bis,
 land_laufbahn,
 key_ms_wert,
 key_kalkulation,
 key_urlaubsgrp,
 hh_bvlgruppe,
 '',
 tarifklasse
FROM k_bvlgruppe;

SELECT 
 key_bvlgruppe,
 ueberkey,
 kurz_bvlgruppe,
 druck_bvlgruppe,
 text_bvlgruppe,
 sort_key,
 bund_bvlgruppe,
 bund_dienstverh,
 land_bvlgruppe,
 key_von,
 key_bis,
 land_laufbahn,
 key_ms_wert,
 key_kalkulation,
 key_urlaubsgrp,
 hh_bvlgruppe,
 '' , 
 tarifklasse
FROM k_bvlgruppe;

select 
 key_amtsdienstbez,
 '', 
 kurz_adbz_m,
 kurz_adbz_w,
 druck_adbz_m,
 druck_adbz_w,
 text_adbz_m,
 text_adbz_w,
 sort_key,
 bund_adbz,
 land_adbz,
 key_von,
 key_bis,
 gremienwahl
 FROM k_amtsdienstbez;
 

select 
 key_amtsdienstbez,
 ueberkey,
 kurz_adbz_m,
 kurz_adbz_w,
 druck_adbz_m,
 druck_adbz_w,
 text_adbz_m,
 text_adbz_w,
 sort_key,
 bund_adbz,
 land_adbz,
 key_von,
 key_bis,
 gremienwahl
 FROM k_amtsdienstbez;
 

SELECT 
 key_beurlaubart,
  '', 
kurz_beurlaubart,
 druck_beurlaubart,
 text_beurlaubart,
 key_von,
 key_bis,
 bezuege_kz,
 his_system_key,
 frauenfoerderplan,
 gremienwahl
FROM k_beurlaubart;

SELECT 
 key_beurlaubart,
  ueberkey,
kurz_beurlaubart,
 druck_beurlaubart,
 text_beurlaubart,
 key_von,
 key_bis,
 bezuege_kz,
 his_system_key,
 frauenfoerderplan,
 gremienwahl
FROM k_beurlaubart;

SELECT 
 key_pbeart,
  '', 
 kurz_pbeart,
 druck_pbeart,
 text_pbeart,
 key_von,
 key_bis,
 schoepfung,
 berechnung,
 karte
FROM k_pbeart;

SELECT 
 key_pbeart,
  ueberkey,
 kurz_pbeart,
 druck_pbeart,
 text_pbeart,
 key_von,
 key_bis,
 schoepfung,
 berechnung,
 karte
FROM k_pbeart;

SELECT 
 key_pbekennz,
 '', 
 kurz_pbekennz,
 druck_pbekennz,
 text_pbekennz,
 key_von,
 key_bis,
 bund_besetzung,
 his_system_key,
 '' 
FROM k_pbekennzeichen
where key_pbekennz is not null;

SELECT 
 key_pbekennz,
 ueberkey,
 kurz_pbekennz,
 druck_pbekennz,
 text_pbekennz,
 key_von,
 key_bis,
 bund_besetzung,
 his_system_key,
 '' 
FROM k_pbekennzeichen
where key_pbekennz is not null;

SELECT 
 key_pbekennz,
 ueberkey,
 kurz_pbekennz,
 druck_pbekennz,
 text_pbekennz,
 key_von,
 key_bis,
 bund_besetzung,
 his_system_key,
 land_pbekennz
FROM k_pbekennzeichen
where key_pbekennz is not null;

SELECT 
 key_teilzeitart,
  '', 
kurz_teilzeitart,
 druck_teilzeitart,
 text_teilzeitart,
 key_von,
 key_bis
FROM k_teilzeitart
where key_teilzeitart is not null;

SELECT 
 key_teilzeitart,
  ueberkey,
kurz_teilzeitart,
 druck_teilzeitart,
 text_teilzeitart,
 key_von,
 key_bis
FROM k_teilzeitart
where key_teilzeitart is not null;

SELECT 
 key_vertragsart,
 '', 
kurz_vertragsart_m,
 kurz_vertragsart_w,
 druck_vertragsartm,
 druck_vertragsartw,
 text_vertragsart_m,
 text_vertragsart_w,
 bund_taetigkeit,
 key_von,
 key_bis,
 his_system_key,
 bundstat_relevant,
 schwstat_relevant,
 pers_kost_modus
FROM k_vertragsart

SELECT 
 key_vertragsart,
 ueberkey,
kurz_vertragsart_m,
 kurz_vertragsart_w,
 druck_vertragsartm,
 druck_vertragsartw,
 text_vertragsart_m,
 text_vertragsart_w,
 bund_taetigkeit,
 key_von,
 key_bis,
 his_system_key,
 bundstat_relevant,
 schwstat_relevant,
 pers_kost_modus
FROM k_vertragsart

SELECT 
 key_dienstart,
  '', 
kurz_dienstart,
 druck_dienstart,
 text_dienstart,
 bund_dienstart,
 key_von,
 key_bis,
 frauenfoerderplan,
 ministerium
FROM k_dienstart

SELECT 
 key_dienstart,
  ueberkey,
kurz_dienstart,
 druck_dienstart,
 text_dienstart,
 bund_dienstart,
 key_von,
 key_bis,
 frauenfoerderplan,
 ministerium
FROM k_dienstart

SELECT 
 key_hhvermerk,
 '' , 
 kurz_hhvermerk,
 druck_hhvermerk,
 text_hhvermerk,
 key_von,
 key_bis,
 hh_hhvermerk,
 his_system_key
FROM k_haushaltsverm;

SELECT 
 key_hhvermerk,
 ueberkey,
 kurz_hhvermerk,
 druck_hhvermerk,
 text_hhvermerk,
 key_von,
 key_bis,
 hh_hhvermerk,
 his_system_key
FROM k_haushaltsverm;

SELECT 
 key_kategorie,
 '', 
 kurz_kategorie,
 druck_kategorie,
 text_kategorie,
 key_von,
 key_bis,
 hh_kategorie,
 bundstat_relevant,
 his_system_key
FROM k_sgd_kategorie

SELECT 
 key_kategorie,
 ueberkey,
 kurz_kategorie,
 druck_kategorie,
 text_kategorie,
 key_von,
 key_bis,
 hh_kategorie,
 bundstat_relevant,
 his_system_key
FROM k_sgd_kategorie

SELECT
key_mind_grund,'', 
kurz_mind_grund,
druck_mind_grund,
text_mind_grund
 FROM k_minderungsgrd;

SELECT
key_mind_grund,ueberkey,
kurz_mind_grund,
druck_mind_grund,
text_mind_grund
 FROM k_minderungsgrd;

SELECT 
 wert,
 besold,
 kztxt,
 latxt,
 '',
 ''
FROM k_sis_wert;

SELECT 
 wert,
 besold,
 kztxt,
 latxt,
 his_system_key,
 deputat
FROM k_sis_wert;

SELECT 
 key_rechtsstell,
 '', 
 kurz_rechtsstell_m,
 druck_rechtsstellm,
 text_rechtsstell_m,
 key_von,
 key_bis
FROM k_rechtsstell;

SELECT 
 key_rechtsstell,
 ueberkey,
 kurz_rechtsstell_m,
 druck_rechtsstellm,
 text_rechtsstell_m,
 key_von,
 key_bis
FROM k_rechtsstell;

SELECT 
 key_laufbahn,
 '', 
 kurz_laufbahn,
 druck_laufbahn,
 text_laufbahn,
 key_von,
 key_bis,
 sort_key,
 bund_laufbahn,
 ''
FROM k_laufbahn;

SELECT 
 key_laufbahn,
 ueberkey,
 kurz_laufbahn,
 druck_laufbahn,
 text_laufbahn,
 key_von,
 key_bis,
 sort_key,
 bund_laufbahn,
 land_laufbahn
FROM k_laufbahn;

select
inst_nr,
uebinst_nr,
dname,
lname1,
key_von,
key_bis,
orgstruktur,
fins,
lehr,
bund_kategorie,
 bund_lehr_forsch,
 bund_fachgebiet,
 land_fachgebiet,
'',
 land_institut,
 bund_rahmenplan
 
from inst
where svarel='1';

select distinct 
inst_nr,
uebinst_nr,
dname,
lname1,
key_von,
key_bis,
orgstruktur,
fins,
lehr,
bund_kategorie,
 bund_lehr_forsch,
 bund_fachgebiet,
 land_fachgebiet,
'',-- sis_fachbereich,
 land_institut,
 bund_rahmenplan
 
from inst left outer join pfi on (inst.inst_nr=pfi.pfi_kostenstelle and pfi.pfi_status=0)
where inst.svarel='1' or (inst.svarel != '1' and pfi_kostenstelle is not null);

select distinct
inst_nr,
uebinst_nr,
dname,
lname1,
key_von,
key_bis,
orgstruktur,
fins,
lehr,
bund_kategorie,
 bund_lehr_forsch,
 bund_fachgebiet,
 land_fachgebiet,
'',-- sis_fachbereich,
 land_institut,
 bund_rahmenplan
 
from inst left outer join pfi on (inst.inst_nr=pfi.pfi_kostenstelle and pfi.pfi_status=0)
where inst.svarel='1' or (inst.svarel != '1' and pfi_kostenstelle is not null);

select 
ggnr ,
'', 
ggkey  ,
fikey,
ggkurz   ,
ggdruck  ,
ggname1  ,
ggname2,
ggname3  ,
key_von     ,
key_bis ,
bund_geldgeber ,
'' 
from gege
where svarel='1' 
and ggnr is not null

SELECT
key_lehreinh,'', 
kurz_lehreinh,
druck_lehreinh,
     text_lehreinh,
key_von,
key_bis
 FROM k_lehreinh;

SELECT
key_lehreinh,ueberkey,
kurz_lehreinh,
druck_lehreinh,
     text_lehreinh,
key_von,
key_bis
 FROM k_lehreinh;

SELECT count(*) from pbv WHERE
    pbv_status=0
    and (now() >= pbv_von or pbv_von is null)
    and
     (
    now() <= pbv_bis
    or (pbv_bis is null and pbv_befr_bis >= now())
    or (pbv_bis is null and pbv_befr_bis is null)
    );

SELECT "" || round(count(*),0) from pbv WHERE
    pbv_status=0
    and (today >= pbv_von or pbv_von is null)
    and
     (
    today <= pbv_bis
    or (pbv_bis is null and pbv_befr_bis >= today)
    or (pbv_bis is null and pbv_befr_bis is null)
    );

SELECT count(*) from pbv WHERE
    pbv_status=0
    and (current_date >= pbv_von or pbv_von is null)
    and
     (
    current_date <= pbv_bis
    or (pbv_bis is null and pbv_befr_bis >= current_date)
    or (pbv_bis is null and pbv_befr_bis is null)
    );

SELECT count(*) from sgd WHERE
 sgd_status=0
and (now() between sgd_von and sgd_bis
 or (now() >= sgd_von and sgd_bis is null)
 );

SELECT "" || round(count(*),0) from sgd WHERE
sgd_status=0
and (TODAY between sgd_von and sgd_bis
 or (TODAY >= sgd_von and sgd_bis is null)
 );

SELECT count(*) from sgd WHERE
sgd_status=0
and (CURRENT_DATE between sgd_von and sgd_bis
 or (CURRENT_DATE >= sgd_von and sgd_bis is null)

 );

SELECT key_staat, '', kurz_land, druck_land, text_land, 
bund_staat, eg_mitglied, key_von, key_bis
FROM k_staat;

SELECT key_staat, ueberkey,  kurz_land, druck_land, text_land, 
bund_staat, eg_mitglied, key_von, key_bis
FROM k_staat;

SELECT 
 key_art_zeit,
 ueberkey, 
 kurz_art_zeit,
 druck_art_zeit,
 text_art_zeit,
 key_von,
 key_bis,
 his_system_key
FROM k_art_zeit;

drop table superx_sva ; 

drop table superx_sva ; 

drop table superx_sva ;