You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
26 lines
2.3 KiB
26 lines
2.3 KiB
47110^End Semester^5^0^0^150^100^1^integer^30^0^1^<<SQL>> select tid,druck from kenn_semester order by tid DESC;^ ^<<SQL>> select tid,druck from kenn_semester where today() between sem_beginn and sem_ende;^ |
|
47111^Stat. Kennzahl^80^0^0^150^150^6^char^30^0^1^<<SQL>> select apnr,druck from kenn_stichtagsart where aktiv='1'\ |
|
and (select apnr from konstanten where beschreibung='KENN_PROFIL') in (5,6)\ |
|
and 0!=(select count(*) from kenn_bestandsart_bland B, kenn_bestandsart K\ |
|
where B.bestandsart=K.apnr\ |
|
and K.stichtagsart_id=kenn_stichtagsart.apnr\ |
|
and B.bland ='SA')\ |
|
union\ |
|
select apnr,druck from kenn_stichtagsart where aktiv='1'\ |
|
and (select apnr from konstanten where beschreibung='KENN_PROFIL') in (1,2,3,4)\ |
|
and 0!=(select count(*) from kenn_bestandsart_bland B, kenn_bestandsart K\ |
|
where B.bestandsart=K.apnr\ |
|
and K.stichtagsart_id=kenn_stichtagsart.apnr\ |
|
and B.bland ='BW')\ |
|
order by 1,2\ |
|
;^ ^ ^ |
|
47112^End-Jahr^7^360^-1^100^50^1^integer^30^0^1^<<SQL>> SELECT distinct ord,name FROM aggregierung where kategorie='KENN-Jahr' order by 1;^ ^<<SQL>> SELECT ord,name FROM aggregierung where kategorie='KENN-Jahr' and ord=(year(today())-1) ;^ |
|
47113^nur zu berechnende Kennzahlen^110^0^0^150^50^1^char^30^0^999^<<SQL>> select '1','Ja' from xdummy union select '0','Nein' from xdummy;^ ^ ^ |
|
47114^Kennzahl Nr.^90^0^0^150^30^1^char^4^0^0^^ ^ ^ |
|
47115^Hochschule^1^0^0^150^200^5^char^30^0^12^<<SQL>> select tid, type, name,sortnr from sichten where art in('SXC_Hochschulen-Sicht') and aktiv=1 order by sortnr desc, name;^ ^ ^ |
|
47116^nur zu exportierende Kennzahlen^120^360^-1^100^50^1^char^30^0^999^<<SQL>> select '1','Ja' from xdummy union select '0' ,'Nein' from xdummy;^ ^ ^ |
|
47117^Filter bis Ebene^25^0^0^150^20^1^integer^30^0^0^^ ^1^ |
|
47118^Bericht^100^360^-1^100^200^1^char^30^1^1^<<SQL>> select 'MKWNRW_1','MKW NRW Hochschulkennzahlen';^ ^<<SQL>>select 'MKWNRW_1','MKW NRW Hochschulkennzahlen';^ |
|
47119^Start-Jahr^6^360^-1^100^50^1^integer^30^0^1^<<SQL>> SELECT distinct ord,name FROM aggregierung where kategorie='KENN-Jahr' order by 1;^ ^<<SQL>> SELECT ord,name FROM aggregierung where kategorie='KENN-Jahr' and ord=(year(today())-1) ;^ |
|
47120^Start Semester^4^0^0^150^100^1^integer^30^0^1^<<SQL>> select tid,druck from kenn_semester order by tid DESC;^ ^<<SQL>> select tid,druck from kenn_semester where today() between sem_beginn and sem_ende;^ |
|
47121^oder^30^0^0^120^200^1^char^30^0^13^^ ^ ^
|
|
|