AdminServers/UMSEnterprise
Username
Username to access webservices.
This information in given by Esas
Password
Password to access webservices.
This information in given by Esas
Export settings
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 |
|---|---|---|---|
| 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 |