43021^Seit Semester^1^0^0^130^80^1^integer^30^1^1^<> select val('20' || replace(replace(semester_id,'S','1'),'W','2')) as semester_tid,semester_bezeichnung FROM costage_st_semester\ order by 1 DESC;^^<> select val('20' || replace(replace(semester_id,'S','1'),'W','2')) as semester_tid,semester_bezeichnung FROM costage_st_semester\ where today()-(5*365) between semester_anfang and semester_ende;^ 43025^Matrikelnr.^100^330^-1^130^100^1^char^30^0^0^ ^ ^ ^ 43027^Bis Semester^2^330^-1^130^100^1^integer^30^0^1^<> select val('20' || replace(replace(semester_id,'S','1'),'W','2')) as semester_tid,semester_bezeichnung FROM costage_st_semester\ order by 1 DESC;^Eintrag^<> select val('20' || replace(replace(semester_id,'S','1'),'W','2')) as semester_tid,semester_bezeichnung FROM costage_st_semester\ where today() between semester_anfang and semester_ende;^ 43032^Studiengangstyp^120^0^0^130^150^1^char^20^0^1^<> select 'ETSG','Einfach- und Teilstudiengänge' from xdummy\ union select 'EMSG','Einfach- und Mehrfachstudiengänge' from xdummy\ order by 2;^ ^<> select 'ETSG','Einfach- und Teilstudiengänge' from xdummy^