AdminServers/Ludus: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
Kia (talk | contribs)
 
(25 intermediate revisions by the same user not shown)
Line 35: Line 35:


===[[AdminServers/Export Settings|Export settings]]===
===[[AdminServers/Export Settings|Export settings]]===
===Data mapping===
{| class="wikitable"
|+
Students
!Admin system
!UMS
!Remarks
|-
|Kursist.sps
|SPS
|Nej = 0<br>
Ja = 1<br>
Ikke taget stilling = 2<br>
null = 2
|}
{| class="wikitable"
|+
DU Students
!Admin system
!UMS
!Remarks
|-
|Kursist.duRetSlutDato
|ExtraDateField1
|
|-
|DuBetaling.beregnetTabtDato
|ExtraDateField2
|
|}
===Template criteria mapping===
===Template criteria mapping===
This is somewhat found in the column '''RowType''' in Students table.
====Students====
{| class="wikitable"
{| class="wikitable"
|+Students
|+Other (Ludus Kerne)
!Admin system
!Admin system
!UMS
!UMS
Line 43: Line 80:
!Remarks
!Remarks
|-
|-
|Cosa formaalskode
|Activity name
|Aktivitet
|
|
|-
|Hold Institution code
|ElevAfdelingsKode
|
|
|-
|Ludus kerne -> Activity type
|ActivityType
|
|
|-
|CØSA Number
|COSA_FORMAL
|COSA_FORMAL
|
|
|
|
|-
|-
|Studieforløb -> Uddannelsesstruktur -> Uddannelsesaktivitet -> Aktivitets gruppekode
|Henvisnings kategori kode
|Education
|Internship_CategoryCode
|
|
|
|
|-
|-
|Studieforløb -> Department
|Undervisningssted navn
|Department
|AktivitetsAfdeling
AfdelingsNavn
|
|
|-
|Ludus web -> FKB Number
|EducationDirection
|
|Not used
|-
|Ludus web -> Elevorløb Institution code
|
|
|Not used
|-
|Ludus web -> Activity type
|ActivityType
|
|Not used
|}
 
{| class="wikitable"
|+OBU - FVU - DU - Kursist
!Admin system
!UMS
!Picture from admin system
!Remarks
|-
|Activity name
|Aktivitet
|
|Holdstart is appended
|-
|Hold Institution code
|ElevAfdelingsKode
|
|
|-
|Ludus kerne -> Activity type
|
|
|This is used from table WebHoldHoldType in Ludus DB
|-
|CØSA Number
|COSA_FORMAL
|
|
|-
|Henvisnings kategori kode
|Internship_CategoryCode
|
|
|-
|Undervisningssted navn
|AktivitetsAfdeling
AfdelingsNavn
|
|
|-
|Ludus web -> FKB Number
|EducationDirection
|
|
|-
|Ludus web -> Elevorløb Institution code
|
|
|Not used
|-
|Ludus web -> Activity type
|ActivityType
|
|
|}
 
{| class="wikitable"
|+Exam
!Admin system
!UMS
!Picture from admin system
!Remarks
|-
|Activity name
|ActivityDescription
|
|
|
|
|-
|-
|Studieforløb -> Institution code
|Hold Institution code
|SkoleKode
|ElevAfdelingsKode
|
|
|
|
|-
|-
|PUE -> Activity Department
|Ludus kerne -> Activity type
|ActivityDepartmentName
|ActivityType
|
|
|
|If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE
|-
|-
|Activity Cosa formaalskode
|CØSA Number
|COSA_FORMAL
|
|
|
|
|You can find this in table ImportFromDBesas_Uddannelsesaktivitet column esas_cosa_formaalskode
|-
|-
|Activity gruppekode
|Henvisnings kategori kode
|Activity_Education
|Internship_CategoryCode
|
|
|
|
|-
|-
|PUE -> Activity Institution code
|Undervisningssted navn
|AktivitetsAfdeling
|AktivitetsAfdeling
AfdelingsNavn
|
|
|-
|Ludus web -> FKB Number
|EducationDirection
|
|Not used
|-
|Ludus web -> Elevorløb Institution code
|
|
|Not used
|-
|Ludus web -> Activity type
|ActivityType
|
|Not used
|}
{| class="wikitable"
|+UddannelsesAftaler
!Admin system
!UMS
!Picture from admin system
!Remarks
|-
|Activity name
|
|
|If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE
|
|Not used
|-
|-
|Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling
|Hold Institution code
|ElevAfdelingsKode
|
|
|
|
|You can find this in table ImportFromDBesas_Afdeling column esas_navn
|-
|-
|Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling code
|Ludus kerne -> Activity type
|
|
|
|
|You can find this in table ImportFromDBesas_Afdeling column esas_institutionsnummer
|Not used
|-
|-
|Hold -> Department
|CØSA Number
|ActivityDepartmentName
|COSA_FORMAL
|
|
|
|If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
|-
|-
|Hold -> Institution code
|Henvisnings kategori kode
|
|
|Not used
|-
|Undervisningssted navn
|
|
|Not stored in UMS DB
|-
|Ludus web -> FKB Number
|
|
|Not used
|-
|Ludus web -> Elevorløb Institution code
|ElevAfdelingsKode
|
|
|-
|Ludus web -> Activity type
|
|
|Not used
|}
 
{| class="wikitable"
|+IDV
!Admin system
!UMS
!Picture from admin system
!Remarks
|-
|Activity name
|Aktivitet
|
|Holdstart is appended
|-
|Hold Institution code
|ElevAfdelingsKode
|
|
|-
|Ludus kerne -> Activity type
|
|
|Not used
|-
|CØSA Number
|
|
|Not used
|-
|Henvisnings kategori kode
|
|
|Not used
|-
|Undervisningssted navn
|AktivitetsAfdeling
|AktivitetsAfdeling
AfdelingsNavn
|
|
|-
|Ludus web -> FKB Number
|COSA_FORMAL
EducationDirection
|
|
|-
|Ludus web -> Elevorløb Institution code
|
|
|Not used
|-
|Ludus web -> Activity type
|ActivityType
|
|
|}
{| class="wikitable"
|+AMU
!Admin system
!UMS
!Picture from admin system
!Remarks
|-
|Activity name
|Aktivitet
|
|Holdstart is appended if chosen in configurator
|-
|Hold Institution code
|ElevAfdelingsKode
|
|
|-
|Ludus kerne -> Activity type
|
|
|Not used
|-
|CØSA Number
|COSA_FORMAL
Activity_Education
|
|
|-
|Henvisnings kategori kode
|
|
|Not used
|-
|Undervisningssted navn
|AktivitetsAfdeling
AfdelingsNavn
|
|
|-
|Ludus web -> FKB Number
|EducationDirection
|
|
|-
|Ludus web -> Elevorløb Institution code
|
|
|Not used
|-
|Ludus web -> Activity type
|ActivityType
|
|
|}
{| class="wikitable"
|+UM - Kursus
!Admin system
!UMS
!Picture from admin system
!Remarks
|-
|Activity name
|Aktivitet
|
|Holdstart is appended if chosen in configurator
|-
|Hold Institution code
|ElevAfdelingsKode
|
|
|-
|Ludus kerne -> Activity type
|
|
|Not used
|-
|CØSA Number
|COSA_FORMAL
|
|
|-
|Henvisnings kategori kode
|
|
|Not used
|-
|Undervisningssted navn
|AktivitetsAfdeling
AfdelingsNavn
|
|
|-
|Ludus web -> FKB Number
|EducationDirection
|
|
|-
|Ludus web -> Elevorløb Institution code
|
|
|Not stored in UMS DB
|-
|Ludus web -> Activity type
|ActivityType
|
|Not stored in UMS DB
|}
{| class="wikitable"
|+UddannelsesForloeb
!Admin system
!UMS
!Picture from admin system
!Remarks
|-
|Activity name
|
|
|Not stored in UMS DB
|-
|Hold Institution code
|
|
|Not stored in UMS DB
|-
|Ludus kerne -> Activity type
|
|
|Not used
|-
|CØSA Number
|COSA_FORMAL
|
|
|-
|Henvisnings kategori kode
|
|
|Not used
|-
|Undervisningssted navn
|
|
|Not stored in UMS DB
|-
|Ludus web -> FKB Number
|EducationDirection
|
|
|-
|Ludus web -> Elevorløb Institution code
|
|
|Not stored in UMS DB
|-
|Ludus web -> Activity type
|ActivityType
|
|
|}
{| class="wikitable"
|+ProeveHold
!Admin system
!UMS
!Picture from admin system
!Remarks
|-
|Activity name
|Aktivitet
|
|
|-
|Hold Institution code
|ElevAfdelingsKode
|
|
|-
|Ludus kerne -> Activity type
|
|
|Not used
|-
|CØSA Number
|COSA_FORMAL
|
|
|-
|Henvisnings kategori kode
|Internship_CategoryCode
|
|
|-
|Undervisningssted navn
|AfdelingsNavn
AktivitetsAfdeling
|
|
|-
|Ludus web -> FKB Number
|
|
|Not used
|-
|Ludus web -> Elevorløb Institution code
|
|
|Not used
|-
|Ludus web -> Activity type
|
|
|
|If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
|Not used
|}
|}

Latest revision as of 09:14, 27 April 2023

Server

DNS or IP address for the Sybase database server

Database

Name of the LUDUS database - Usually this is "VUC"

Port number

The port number of the Sybase database server

Username

Sybase Username to access the database.

Password

Sybase to access the database.

Webservice connection

This is used for the new webservices in Ludus

URL

URL of the LUDUS web service

Username

Username to access the webservice.

Password

Password to access the webservice.

Activity = HoldID + Holdstart

Hold vil blive få holdstart sat ind som en del af holdnavnet. Dette er et krav hvis man genbruger sine hold i LUDUS. Ellers kan man få hold der er sammensat af det nye og det tidligere hold.

Insert an underscore between HoldID + Holdstart. E.g. HoldID + _ + Holdstart

This puts an underscore between HoldID + _ + Holdstart

Export settings

Data mapping

Students
Admin system UMS Remarks
Kursist.sps SPS Nej = 0

Ja = 1
Ikke taget stilling = 2
null = 2

DU Students
Admin system UMS Remarks
Kursist.duRetSlutDato ExtraDateField1
DuBetaling.beregnetTabtDato ExtraDateField2

Template criteria mapping

This is somewhat found in the column RowType in Students table.

Students

Other (Ludus Kerne)
Admin system UMS Picture from admin system Remarks
Activity name Aktivitet
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type ActivityType
CØSA Number COSA_FORMAL
Henvisnings kategori kode Internship_CategoryCode
Undervisningssted navn AktivitetsAfdeling

AfdelingsNavn

Ludus web -> FKB Number EducationDirection Not used
Ludus web -> Elevorløb Institution code Not used
Ludus web -> Activity type ActivityType Not used
OBU - FVU - DU - Kursist
Admin system UMS Picture from admin system Remarks
Activity name Aktivitet Holdstart is appended
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type This is used from table WebHoldHoldType in Ludus DB
CØSA Number COSA_FORMAL
Henvisnings kategori kode Internship_CategoryCode
Undervisningssted navn AktivitetsAfdeling

AfdelingsNavn

Ludus web -> FKB Number EducationDirection
Ludus web -> Elevorløb Institution code Not used
Ludus web -> Activity type ActivityType
Exam
Admin system UMS Picture from admin system Remarks
Activity name ActivityDescription
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type ActivityType
CØSA Number COSA_FORMAL
Henvisnings kategori kode Internship_CategoryCode
Undervisningssted navn AktivitetsAfdeling

AfdelingsNavn

Ludus web -> FKB Number EducationDirection Not used
Ludus web -> Elevorløb Institution code Not used
Ludus web -> Activity type ActivityType Not used


UddannelsesAftaler
Admin system UMS Picture from admin system Remarks
Activity name Not used
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type Not used
CØSA Number COSA_FORMAL
Henvisnings kategori kode Not used
Undervisningssted navn Not stored in UMS DB
Ludus web -> FKB Number Not used
Ludus web -> Elevorløb Institution code ElevAfdelingsKode
Ludus web -> Activity type Not used
IDV
Admin system UMS Picture from admin system Remarks
Activity name Aktivitet Holdstart is appended
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type Not used
CØSA Number Not used
Henvisnings kategori kode Not used
Undervisningssted navn AktivitetsAfdeling

AfdelingsNavn

Ludus web -> FKB Number COSA_FORMAL

EducationDirection

Ludus web -> Elevorløb Institution code Not used
Ludus web -> Activity type ActivityType
AMU
Admin system UMS Picture from admin system Remarks
Activity name Aktivitet Holdstart is appended if chosen in configurator
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type Not used
CØSA Number COSA_FORMAL

Activity_Education

Henvisnings kategori kode Not used
Undervisningssted navn AktivitetsAfdeling

AfdelingsNavn

Ludus web -> FKB Number EducationDirection
Ludus web -> Elevorløb Institution code Not used
Ludus web -> Activity type ActivityType
UM - Kursus
Admin system UMS Picture from admin system Remarks
Activity name Aktivitet Holdstart is appended if chosen in configurator
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type Not used
CØSA Number COSA_FORMAL
Henvisnings kategori kode Not used
Undervisningssted navn AktivitetsAfdeling

AfdelingsNavn

Ludus web -> FKB Number EducationDirection
Ludus web -> Elevorløb Institution code Not stored in UMS DB
Ludus web -> Activity type ActivityType Not stored in UMS DB
UddannelsesForloeb
Admin system UMS Picture from admin system Remarks
Activity name Not stored in UMS DB
Hold Institution code Not stored in UMS DB
Ludus kerne -> Activity type Not used
CØSA Number COSA_FORMAL
Henvisnings kategori kode Not used
Undervisningssted navn Not stored in UMS DB
Ludus web -> FKB Number EducationDirection
Ludus web -> Elevorløb Institution code Not stored in UMS DB
Ludus web -> Activity type ActivityType
ProeveHold
Admin system UMS Picture from admin system Remarks
Activity name Aktivitet
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type Not used
CØSA Number COSA_FORMAL
Henvisnings kategori kode Internship_CategoryCode
Undervisningssted navn AfdelingsNavn

AktivitetsAfdeling

Ludus web -> FKB Number Not used
Ludus web -> Elevorløb Institution code Not used
Ludus web -> Activity type Not used