View source for AdminServers/Ludus

[[File:AdminServer Ludus.jpg|none|thumb|656x656px]]

===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'''

===[[AdminServers/Export Settings|Export settings]]===

===Data mapping===
{| class="wikitable"
|+
DU Students
!Admin system
!UMS
!Remarks
|-
|duRetSlutDato
|ExtraDateField1
|
|}

{| class="wikitable"
|+
DU Students
!Admin system
!UMS
!Remarks
|-
|duRetSlutDato
|ExtraDateField1
|
|}

===Template criteria mapping===
This is somewhat found in the column '''RowType''' in Students table.

====Students====

{| class="wikitable"
|+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
|}

{| 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
|
|
|-
|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
|}


{| class="wikitable"
|+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
|}

{| 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
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
|
|
|Not used
|}