AdminServers/UDDATA

Username

Username to access webservices.

This information in given by IST

Password

Password to access webservices.

This information in given by IST

Institution numbers

Enter a list of institution number to extract from.

Data Extraction

Set User deactivation in Uddata+

If students are suddenly missing in data extraction from Uddata+, check the systemsettings in Uddata+.

Below setting in Uddata prevents user extraction in API 5 days after Activity_Enddate.

Data mapping

Contact information

Employees

Admin system	UMS	Remarks
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
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

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	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
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

Employees

Admin system	UMS	Picture from admin system	Remarks
Institutions kode	Institution number
Afdeling	Department
Ansvarsområde	Responsibility area

Students

Admin system	UMS	Picture from admin system	Remarks
Institutions kode	Institution number
Cøsa (Uddannelses kode)	Cosa Number
Afdeling	Department
Stamhold	Homegroup
Aktivitets afdeling	Activity department
Aktivitets afdeling kort	Activity department short
Skole forløb	Skole forløb
Skole periode	Skole periode