AdminServers/esas

Certificate file

The certificate used to access esas webservices.

Certificate password

Password for the certificate file.

[1]

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