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.
31 lines
762 B
31 lines
762 B
3 years ago
|
|
||
|
delete from costage_st_semester;
|
||
|
|
||
|
insert into costage_st_semester(
|
||
|
st_sem_nr,
|
||
|
semester_id,
|
||
|
semester_anfang,
|
||
|
semester_ende,
|
||
|
semester_bezeichnung,
|
||
|
studienjahr)
|
||
|
select
|
||
|
st_sem_nr,
|
||
|
semester_id,
|
||
|
semester_anfang,
|
||
|
semester_ende,
|
||
|
semester_bezeichnung,
|
||
|
studienjahr
|
||
|
from costage_st_semester_neu
|
||
|
;
|
||
|
|
||
|
--transformiere Semestercode nach SuperX Notation, d.h. JJJJ+1 (bei SoSe) oder 2 (bei Wise)
|
||
|
update costage_st_semester set semester_tid=val('20' || replace(replace(semester_id,'S','1'),'W','2'))
|
||
|
where year(date(semester_anfang)) >=2000;
|
||
|
|
||
|
;
|
||
|
update costage_st_semester set semester_tid=val('19' || replace(replace(semester_id,'S','1'),'W','2'))
|
||
|
where year(date(semester_anfang)) <2000;
|
||
|
|
||
|
;
|
||
|
|