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

Employees

Admin system	UMS	Remarks
indi_id	UMS_IDFromAdministrativeSystem
indi_id	IDFromAdministrativeSystem
Fornavn	Fornavn
EFTERNAVN	EFTERNAVN
initialer	StudieNr
cpr_nr	CPR
cpr_nr	BirthDay	First 6 numbers
initialer	AlternateAdminSystem_ID
afdel_id	AktivitetsID
afdeling	Aktivitet
Departments.beskrivelse	ActivityDisplayName	If null then use Departments.afdeling
Departments.beskrivelse	ActivityDescription
Departments.kortnavn	Kort_Betegnelse
Departments.startDato	StartDato
Departments.slutDato	SlutDato
Departments.startDato	Aktiviteter_STARTDATO
Departments.slutDato	Aktiviteter_SlutDato
Employments.gyldig_fra	Employement_StartDate
Employments.gyldig_til	Employement_EndDate
postnummer	Postnummer
sted	City
gade	Adresse
co	COAddress
Departments.afdel_id	DepartmentID
Departments.afdeling	DepartmentCode
Departments.afdeling	Department
Departments.beskrivelse	DepartmentDescription
Departments.kortnavn	DepartmentShortName
InstitutionNumber	Skolekode
Employments.ansvarsomrade	Employee_ResponsibilityArea
medarbejdertype	Employee_JobEmployment_Description
Departments.PrimaerAfd	PrimaryEmployment
unilogin	UniLogin
PrimaryPhone (PRIT)	PrivateMobilePhone
MT	PrivateMobilePhone	Used if primary phone is empty
MT	MobilePhone	Used if primary phone is empty
AT	WorkPhoneNumber
PT	PhoneNumber
Primary mail (PRIM)	PrivateMail
PM	PrivateMail	Used if primary mail is empty
MA	WorkMobilePhone
AM	WorkMail
Ø	OtherInfo
Ø1	ExtraField1
Ø2	ExtraField2

Students

Admin system	UMS	Remarks
indi_id	UMS_IDFromAdministrativeSystem
indi_id	IDFromAdministrativeSystem
Fornavn	Fornavn
EFTERNAVN	EFTERNAVN
indi_id	StudieNr
cpr_nr	CPR
cpr_nr	BirthDay	First 6 numbers
postnummer	Postnummer
sted	City
gade	Adresse
co	COAddress
Activities.akti	AktivitetsID
Activities.aktivitet	Aktivitet
Activities.aktivitet	ActivityDisplayName
Activities.betegnelse	ActivityDescription
Activities.kort_betegnelse	Kort_Betegnelse
Activities.lms	Aktivitet_LMS
ActivityEnrollments.startdato	StartDato
ActivityEnrollments.slutdato	SlutDato	Use Educations.afgangsdato if it lowest Use ActivityEnrollments.slutdato if it lowest Use Activities.slutdato if its lowest
Activities.startdato	Aktiviteter_STARTDATO
Activities.slutdato	Aktiviteter_SlutDato
Activities.ActivityDepartmentName	ActivityDepartmentName
Activities.ActivityDepartmentNameShort	ActivityDepartmentNameShort
unilogin	UniLogin
Educations.coesa	COSA_FORMAL
Educations.coesa_betegnelse	Education
Educations.coesa_kort_betegnelse	EducationDescriptionShort
Educations.betegnelse	EducationDescription
Educations.uddannelse_id	EducationID
Educations.uddannelseversion	EducationVersion
Educations.studiestartDato	StudyStart_Education
Educations.afgangsdato	StudyEnd_Education
Stamhold.aktivitet	HomeGroupName
Stamhold.aktivitet	Klassebetegnelse
Departments.afdel_id	DepartmentID
Departments.afdeling	DepartmentCode
Departments.afdeling	Department
Departments.beskrivelse	DepartmentDescription
Departments.kortnavn	DepartmentShortName
InstitutionNumber	Skolekode
SchoolCourse.skoleforloeb	SKOLEFORLOB
SchoolCourse.skoleperiode	SKOLEPERIODE
SchoolCourse.startDato	ELEV_I_SKOLEFORLOB_StartDato
SchoolCourse.slutdato	ELEV_I_SKOLEFORLOB_SlutDato
PrimaryPhone (PRIT)	PrivateMobilePhone
MT	PrivateMobilePhone	Used if primary phone is empty
MT	MobilePhone	Used if primary phone is empty
PT	PhoneNumber
Primary mail (PRIM)	PrivateMail
PM	PrivateMail	Used if primary mail is empty
Ø	OtherInfo
Ø1	ExtraField1
Ø2	ExtraField2

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