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_Uddannelsesaktivitet
esas_cosa_formaalskode	COSA_FORMAL	From table ImportFromDBesas_Uddannelsesaktivitet
esas_aktivitetsgruppekode	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

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 from Hold
esas_postnummer	ActivityDepartmentPostalCode	If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
esas_by	ActivityDepartmentCity	If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
esas_afdelingId	ActivityDepartmentNumber	If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
esas_navn	ActivityDepartmentName	If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
esas_institutionsnummer	AktivitetsAfdeling	If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
esas_uddannelseselement_planlaegningId	ExtraField2
esas_holdId	AktivitetsID
esas_navn_dansk	Aktivitet
esas_navn_dansk	ActivityDisplayName
esas_navn_dansk	ActivityDescription
esas_navn_dansk	Kort_Betegnelse
	Activity_LMS_AllowRoll	True if publication has been set
	Aktivitet_LMS	True if publication has been set
esas_publiceringsmulighed_institutionsspecifik	Activity_PublicationCode
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
esas_aktivitetsgruppekode	Activity_Education
esas_betegnelse	Activity_EducationDescription
FirstName	Activity_Teacher_FirstName
LastName	Activity_Teacher_LastName
esas_cpr_nummer_uden_formatering	Activity_Teacher_SSN

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