AdminServers/UMSEnterprise
Username
Username to access webservices.
This information in given by Esas
Password
Password to access webservices.
This information in given by Esas
Data mapping
| 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 |
| 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 |
| 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
| Admin system | UMS | Picture from admin system | Remarks |
|---|---|---|---|
| tenantId | Skolekode | ||
| departmentCode | DepartmentCode | ||
| Roles -> title | Aktivitet | ||
| RoleGroups -> title | Aktivitet | ||
| FormOfEmployments -> title | Employee_JobEmployment_Description | ||
| Titles -> title | Employee_JobResponsibility_Description | ||
| Location name | Not imported |