Loading Student data to costage, preparing data for SuperX-Student Module #1

Milestones as specified here:
http://www.superx-projekt.de/doku/costage_modul/f_Meilensteine.htm

I've improved the transfer from COSTAGE to SuperX-Student module:

Status of TSG is retrieved from the status in the MSG in the same term
Computation of heads /cases works (almost, I still have 10.000 heads too little, see next posting).
Computation is much faster now. The old "Primärfach"-computation took about 7h, and in COSTAGE it's only a couple of minutes (!). Thanks to Akash's ingeniuous RANK-function.

Our test case in superx1-p and superx2-p now works pretty well (see screenshot). This was a good test case for the issues above...

... here is the same thing in superx1-p...

Now about the 10.000 difference heads: One missing head is in Summer 21. It looks like the student had "studienstatustyp" "o", which I have excluded in loading, because the documentation says:
o: Studium offen (noch keine Weitermeldung erfolgt)

I also remove
a: Studienplatz angenommen

Of course I can remove the filters, but I would like to know why. Can we please take a look at this student in CO?

Cheers, Daniel

the next example is a "Gasthörer" in Summer 21.

Today's meeting, we agreed to exclude "a" and iclude "o".

I have checked, the student still wasn't visible in Summer 21 in COSTAGE. I found it was a bad example, because the Oracle Test DB ist a bit older: even in den old interface the student was not enrolled in summer 21.

Conclusion: I should't compare summer 21 to the PROD oder superx1-q system, because the COSTAGE system is out of date.

Can I connect superx1-q to CO-Q (instead of CO-Schulung)? This would make our work easier, because the data is the same.
Cheers, Daniel

In today's session we tested some "Mehrfachstudiengänge", the assignment of degree program number ("Studiengang-Nr.") and subject Nr. ("Fach-Nr.") seems to work.
We agreed to build an Excel file with test cases. I thought of committing this to git, but it occured to me that we might give read access to other universities, so we can't do this. I'll send this via Email, maybe we can put it into BSCW?

Here's the deeplink, you just have to change the parameters Term (Semester von and bis) and Matriculation Nr.

https://superx2.uni-koeln.de/superx/servlet/SuperXmlTabelle?&tid=160440&K%C3%B6pfe%20oder%20F%C3%A4lle%20%3F=1%3D1&Stichtag=0&Seit%20Semester=20211&Bis%20Semester=20211&Matrikel-Nr.=1234567&Felder=sos_stg_aggr.fach_sem_zahl%7Csos_stg_aggr.hssem%7Csos_stg_aggr.studiengang_nr%7Csos_stg_aggr.fach_nr%7Csos_stg_aggr.hrst%7Csos_stg_aggr.matrikel_nr%7Csos_stg_aggr.kz_rueck_beur_ein%7Csos_stg_aggr.sem_rueck_beur_ein%7Csos_stg_aggr.tid_stg%7Csos_stg_aggr.summe&Schl%C3%BCssel%20anzeigen=1&Ausgabeformat=text%2Fhtml

Cheers & happy testing, Daniel

Die "Generierung" von TSG bei länger laufendem MSG ist implementiert, neu sind auch die Spalten

"Automatisch generierter Datensatz" (1/0), dann sieht man welcher Datensatz generiert wurde
Studienstatus TSG (der Name ist selbstredend)