AdminServers/esas
Certificate file
The certificate used to access esas webservices.
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
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 | From table ImportFromDBesas_Hold |
| Admin system | UMS | Remarks |
|---|---|---|
| ActivityDepartmentStreet | ||
| ActivityDepartmentPostalCode | ||
| ActivityDepartmentCity | ||
| ExtraField2 | ||
| ActivityDepartmentNumber | ||
| ActivityDepartmentName | ||
| AktivitetsAfdeling | ||
| AktivitetsID | ||
| Aktivitet | ||
| ActivityDisplayName | ||
| ActivityDescription | ||
| Kort_Betegnelse | ||
| Activity_LMS_AllowRoll | ||
| Aktivitet_LMS | ||
| Activity_PublicationCode | ||
| ActivityType | ||
| StartDato | ||
| SlutDato | ||
| Aktiviteter_StartDato | ||
| Aktiviteter_SlutDato | ||
| Course_ID | ||
| Skolefag | ||
| Skolefag_Betegnelse | ||
| CourseLevel | ||
| CourseType | ||
| Activity_EducationID | ||
| Activity_Education | ||
| Activity_EducationDescription | ||
| Activity_Teacher_FirstName | ||
| Activity_Teacher_LastName | ||
| Activity_Teacher_SSN |
| Admin system | UMS | Remarks |
|---|---|---|
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 | ||
| Activity Department | ActivityDepartmentName | ||
| Activity Cosa formaalskode | You can find this in the ImportFromDBesas_Uddannelsesaktivitet table column esas_cosa_formaalskode | ||
| Activity gruppekode | Activity_Education | ||
| Activity Institution code | AktivitetsAfdeling | ||
| Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling | You can find this in the ImportFromDBesas_Afdeling table column esas_navn | ||
| Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling code | You can find this in the ImportFromDBesas_Afdeling table column esas_institutionsnummer |