AdminServers/Ludus

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

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