Schnittstelle CampusOnline (TU Graz) zu SuperX-Modul COSTAGE
http://www.superx-projekt.de/doku/costage_modul/
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.
56 lines
4.4 KiB
56 lines
4.4 KiB
43180^Prüfungstyp^18^0^0^140^150^1^char^70^0^1^<<SQL>>select 'LV','reale Lehrveranstaltung' from xdummy\ |
|
union select 'FACH','Fach-/Modulprüfung' from xdummy\ |
|
order by 1^ ^^ |
|
43181^Seit Semester^3^0^0^140^80^1^integer^30^0^1^<<SQL>> select semester_tid, semester_bezeichnung from costage_st_semester order by 1 DESC;^ ^<<SQL>> select semester_tid, semester_bezeichnung from costage_st_semester where today()-365 between date(semester_anfang) and date(semester_ende);^ |
|
43182^Studiengang^9^0^0^130^150^50^char^30^0^12^<<SQL>> select tid,name,sortnr from sichten where art in ('COSTAGE-Studiengang-Sicht') order by 3,2;^^^ |
|
43183^Staatsangehörigkeit^36^0^0^130^150^10^sql^30^0^1^<<SQL>> SELECT st_land_nr, name from costage_st_laender order by 2;^^^ |
|
43184^Prüfungsstatus^14^350^-1^140^180^1^char^30^0^1^<<SQL>> select apnr,druck from cifx where key=622 order by 2^^ ^ |
|
43185^Auswertungsebene Prüfungen^25^330^-1^130^150^1^char^4^1^1^<<SQL>> select 'G','Gesamtabschluss' from xdummy\ |
|
union select 'F','Absolvent*innenfachfälle' from xdummy\ |
|
union select 'T','Teilstudienabschluss' from xdummy\ |
|
order by 1;^hidden^<<SQL>> select 'T','Teilstudienabschluss' from xdummy;^ |
|
43186^Weitere Tabellen^123^0^0^140^140^10^char^30^0^1^<<SQL>> \ |
|
--freemarker template\ |
|
select name,string_not_null(caption) || ' - ' || name from sx_tables where name in ('costage_st_studierendenstammdaten','costage_dim_studiengang')\ |
|
<#if <<tablestylesheet>>!='tabelle_html_datenblatt.xsl'>\ |
|
and name in (select distinct tablename from stylesheet_field where stylesheet_id in (select tid from sx_stylesheets where filename=<<tablestylesheet>>)) \ |
|
</#if>\ |
|
order by 2^^^ |
|
43187^Leistungsdetailtyp^20^350^-1^140^100^10^char^30^0^1^<<SQL>> select leistungsdetailtyp_kb,name_de from costage_leistungen_detail_typen\ |
|
where leistungsdetailtyp_kb in (select distinct leistungsdetailtyp_kb from costage_st_pruef_aggr);^ ^ ^ |
|
43189^Bis Semester^4^350^-1^140^80^1^integer^30^0^1^<<SQL>> select semester_tid, semester_bezeichnung from costage_st_semester order by 1 DESC;^ ^<<SQL>> select semester_tid, semester_bezeichnung from costage_st_semester where today() between date(semester_anfang) and date(semester_ende);^ |
|
43190^Matrikel-Nr.^50^350^-1^150^180^1^char^200^0^0^^^^ |
|
43191^Geschlecht^37^0^0^140^80^1^integer^30^0^1^<<SQL>> SELECT apnr,druck FROM cif WHERE cif.key = 9003 order by 2;^^^ |
|
43192^Felder^125^0^0^150^190^10^char^30^0^1^<<SQL>>\ |
|
--freemarker template\ |
|
select trim(F.table_name) || '.' || F.name,trim(T.caption) || ':' || trim(F.caption) || ' - ' || trim(F.name) from sx_fields F,\ |
|
sx_tables T where F.table_name=T.name and F.currentlyused=1\ |
|
--Pseudonyme eingeschaltet:\ |
|
and (F.name != 'matrikel_nr' or 0=(select \ |
|
count(*) from konstanten where beschreibung='SOS_MTKNR_EXT'\ |
|
and apnr=1)) \ |
|
<#if <<tablestylesheet>>='tabelle_html_datenblatt.xsl'>\ |
|
and (F.table_name ='costage_st_einzpruef_aggr'\ |
|
/* or F.table_name in (<<Weitere Tabellen>>) */) \ |
|
<#else>\ |
|
and trim(F.table_name) || '.' || F.name in (select trim(tablename)||'.'||trim(fieldname) from stylesheet_field where stylesheet_id in \ |
|
(select tid from sx_stylesheets where filename=<<tablestylesheet>>))\ |
|
</#if>\ |
|
order by 2;^^^ |
|
43193^Fach^6^0^0^140^150^50^char^30^0^1^<<SQL>>\ |
|
SELECT \ |
|
skz_key,\ |
|
skz_name\ |
|
FROM costage_st_studienkennzahlen\ |
|
/* where unikey=<<Hochschule>> */\ |
|
order by 2\ |
|
;^^^ |
|
43194^Schlüssel anzeigen^150^0^0^100^100^1^integer^30^1^1^<<SQL>> select 1,'Ja' from xdummy union select 0,'Nein' from xdummy^^<<SQL>> select 1,'Ja' from xdummy^ |
|
43195^tablestylesheet^121^0^0^100^200^1^char^200^1^1^<<SQL>> select distinct filename,X.caption,ord from sx_stylesheets X,sx_mask_style S where X.tid=S.stylesheet_id and S.maskeninfo_id=43180 order by ord^^<<SQL>> select distinct filename,X.caption from sx_stylesheets X,sx_mask_style S where X.tid=S.stylesheet_id and S.maskeninfo_id=43180 and S.ord=1^ |
|
43196^Ausgabeformat^2001^0^0^100^150^1^char^200^1^1^<<SQL>> select element_value,description from menu_element where element='Ausgabeformat' and nature::smallint<100 order by nature::smallint^^<<SQL>> select element_value,description from menu_element where element='Ausgabeformat' and description='HTML'^ |
|
43199^Hochschule^5^350^-1^140^80^1^char^255^0^1^<<SQL>>select distinct K.unikey,K.unikey\ |
|
from costage_st_studienkennzahlen K\ |
|
order by 2;^ ^<<SQL>> select distinct K.unikey,K.unikey\ |
|
from costage_st_studienkennzahlen K, hochschulinfo H\ |
|
where K.unikey=H.hs_nr::char(10)^ |
|
43200^##line##^10^0^0^100^100^1^char^5000^0^8^^^1^
|
|
|