AdminServers/esas

Certificate file

The certificate used to access esas webservices.

How to order function certificate

How to Certificates

Certificate password

Password for the certificate file.

Username

Username to access webservices.

This information in given by Esas

Password

Password to access webservices.

This information in given by Esas

Data mapping

Students

Admin system	UMS	Remarks
esas_personid	UMS_IDFromAdministrativeSystem
ContactId	IDFromAdministrativeSystem
FirstName + MiddleName	Fornavn	If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
LastName	EFTERNAVN	If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
esas_lokalt_studienummer	StudieNr
esas_cpr_nummer_uden_formatering	CPR
BirthDate	BirthDay
FirstName + MiddleName	PublicRegisteredFirstName
LastName	PublicRegisteredSurName
esas_postnummer	Postnummer
esas_by	City
esas_kommune_id	Sted
Address1_Line1	Adresse
esas_privatemail	PrivateMail
esas_mobiltelefonnummer	PrivateMobilePhone
esas_mobiltelefonnummer	MobilePhone
esas_sso_id	OtherInfo
esas_studieemail	WorkMail
esas_navne_addressebeskyttet	SecretAddress
esas_uddannelsesaktivitetId	EducationID	From table ImportFromDBesas_Uddannelsesstruktur
esas_navn	EducationVersion	From table ImportFromDBesas_Uddannelsesstruktur
esas_cosa_formaalskode	EducationCode	From table ImportFromDBesas_Uddannelsesaktivitet
esas_aktivitetsgruppekode	EducationGroupCode	From table ImportFromDBesas_Uddannelsesaktivitet
esas_navn	Education	From table ImportFromDBesas_Uddannelsesaktivitet
esas_betegnelse	EducationDescriptionShort	From table ImportFromDBesas_Uddannelsesaktivitet
esas_titel	EducationDescription	From table ImportFromDBesas_Uddannelsesaktivitet
esas_personoplysningerId	ExtraField1
esas_studiestart	StudyStart_Education
esas_afgangsdato	StudyEnd_Education	If null then use esas_forventet_afslutning
esas_forventet_afslutning	Expected_EducationEndDate
esas_afdelingId	DepartmentID
esas_navn	Department
Address1_Line1	DepartmentStreet	From table ImportFromDBesas_InstitutionVirksomhed
esas_postnummer	DepartmentPostalCode
esas_by	DepartmentCity
esas_institutionsnummer	SkoleKode
esas_navn	EducationVersion
esas_lokalt_studienummer	AlternativID
NationalAfgangsaarsag.esas_national_afgangsaarsagId	DepartureCauseCode
NationalAfgangsaarsag.esas_navn	DepartureCause_Description
Internationalisering	ActiveOnEducation	calculated Between ImportFromDBesas_Internationalisering.esas_startdato And ImportFromDBesas_Internationalisering.esas_slutdato and only for outgoing students

Extra fields when extracting students with rowtype
Student

Admin system	UMS	Remarks
esas_navn_dansk	Klassebetegnelse	This is based on esas_stamhold_id on Studieforloeb esas_navn_dansk is from table ImportFromDBesas_Hold

Extra fields when extracting students with rowtype
Undervisningshold, Stamhold, Skabelonhold and Semesterhold

Admin system	UMS	Remarks
Address1_Line1	ActivityDepartmentStreet	If afdeling from Hold is null then use Aktivitetsudbud afdeling
esas_postnummer	ActivityDepartmentPostalCode	If afdeling from Hold is null then use Aktivitetsudbud afdeling
esas_by	ActivityDepartmentCity	If afdeling from Hold is null then use Aktivitetsudbud afdeling
esas_afdelingId	ActivityDepartmentNumber	If afdeling from Hold is null then use Aktivitetsudbud afdeling
esas_navn	ActivityDepartmentName	If afdeling from Hold is null then use Aktivitetsudbud afdeling
esas_institutionsnummer	AktivitetsAfdeling	If afdeling from Hold is null then use Aktivitetsudbud afdeling
esas_uddannelseselement_planlaegningId	ExtraField2	Is only used for Undervisningshold
esas_afdelingId	ExtraField3	If afdeling from Hold is null then use AktivitetsudbudHoldAfdeling afdeling
esas_holdId	AktivitetsID	From Hold
esas_navn_dansk	Aktivitet	From Hold
esas_navn_dansk	ActivityDisplayName	From Hold
esas_navn_dansk	ActivityDescription	From Hold
esas_navn_dansk	Kort_Betegnelse	From Hold
	Activity_LMS_AllowRoll	True if publication has been set
	Aktivitet_LMS	True if publication has been set
esas_publiceringsmulighed_institutionsspecifik	Activity_PublicationCode	From Hold
Label	ActivityType	Using Label from OptionSetValueString based on esas_holdtype
esas_startdato	StartDato	From table ImportFromDBesas_Hold
esas_slutdato	SlutDato	Use Studieforloeb esas_afgangsdato if lower then ImportFromDBesas_Hold esas_slutdato
esas_startdato	Aktiviteter_StartDato	if null use PUE esas_startdato
esas_slutdato	Aktiviteter_SlutDato	if null use PUE esas_slutdato
esas_uddannelseselementId	Course_ID	From SUE
esas_uvm_fagkode	Skolefag	From SUE
esas_navn	Skolefag_Betegnelse	From SUE
esas_fagkode_niveau	CourseLevel	From SUE
Label	CourseType	Using Label from OptionSetValueString based on esas_fagtype
esas_uddannelsesaktivitetId	Activity_EducationID	From table ImportFromDBesas_Uddannelsesstruktur
esas_navn	Activity_EducationVersion	From table ImportFromDBesas_Uddannelsesstruktur
esas_cosa_formaalskode	Activity_EducationCode	From table ImportFromDBesas_Uddannelsesaktivitet
esas_aktivitetsgruppekode	Activity_EducationGroupCode	From table ImportFromDBesas_Uddannelsesaktivitet
esas_navn	Activity_Education	From table ImportFromDBesas_Uddannelsesaktivitet
esas_betegnelse	Activity_EducationDescription	From table ImportFromDBesas_Uddannelsesaktivitet
esas_titel	Activity_EducationDescriptionShort	From table ImportFromDBesas_Uddannelsesaktivitet
FirstName	Activity_Teacher_FirstName
LastName	Activity_Teacher_LastName
esas_cpr_nummer_uden_formatering	Activity_Teacher_SSN
esas_uddannelseselement_planlaegningId	ExtraField2
esas_afdelingId	ExtraField3	Uses Hold -> afdelings ID, if null use afdelings ID from hold -> Aktivitetsudbud

Template criteria mapping

Students

Admin system	UMS	Picture from admin system	Remarks
Cosa formaalskode	COSA_FORMAL
Studieforløb -> Uddannelsesstruktur -> Uddannelsesaktivitet -> Aktivitets gruppekode	Education
Studieforløb -> Department	Department
Studieforløb -> Institution code	SkoleKode
PUE -> Activity Department	ActivityDepartmentName		If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE
Activity Cosa formaalskode			You can find this in table ImportFromDBesas_Uddannelsesaktivitet column esas_cosa_formaalskode
Activity gruppekode	Activity_Education
PUE -> Activity Institution code	AktivitetsAfdeling		If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE
Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling			You can find this in table ImportFromDBesas_Afdeling column esas_navn
Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling code			You can find this in table ImportFromDBesas_Afdeling column esas_institutionsnummer
Hold -> Department	ActivityDepartmentName		If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
Hold -> Institution code	AktivitetsAfdeling		If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
Studieforløb -> Uddannelsesstruktur -> Uddannelses type	EducationType
Hold -> aktivitetsudbud -> Uddannelsesstruktur -> navn	Activity_EducationVersion		Only works for Hold
Studieforløb -> aktivitetsudbud -> Uddannelsesstruktur -> navn	EducationVersion