AdminServers/esas: Difference between revisions
Jump to navigation
Jump to search
| Line 337: | Line 337: | ||
| | | | ||
|- | |- | ||
|Activity Department | |PUE -> Activity Department | ||
|ActivityDepartmentName | |ActivityDepartmentName | ||
| | | | ||
|It is based on | |It is based on PUE information | ||
|- | |- | ||
|Activity Cosa formaalskode | |Activity Cosa formaalskode | ||
| Line 352: | Line 352: | ||
| | | | ||
|- | |- | ||
|Activity Institution code | |PUE -> Activity Institution code | ||
|AktivitetsAfdeling | |AktivitetsAfdeling | ||
| | | | ||
|It is based on | |It is based on PUE information | ||
|- | |- | ||
|Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling | |Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling | ||
| Line 366: | Line 366: | ||
| | | | ||
|You can find this in table ImportFromDBesas_Afdeling column esas_institutionsnummer | |You can find this in table ImportFromDBesas_Afdeling column esas_institutionsnummer | ||
|- | |||
|Hold -> Activity Department | |||
|ActivityDepartmentName | |||
| | |||
|It is based on Hold information | |||
|- | |||
|Hold -> Activity Institution code | |||
|AktivitetsAfdeling | |||
| | |||
|It is based on Hold information | |||
|} | |} | ||
Revision as of 09:18, 10 February 2021
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 | 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 PUE is null then use Aktivitetsudbud afdeling from PUE |
| esas_postnummer | ActivityDepartmentPostalCode | If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE |
| esas_by | ActivityDepartmentCity | If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE |
| esas_uddannelseselement_planlaegningId | ExtraField2 | |
| esas_afdelingId | ActivityDepartmentNumber | If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE |
| esas_navn | ActivityDepartmentName | If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE |
| esas_institutionsnummer | AktivitetsAfdeling | If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE |
| 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
| 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 | It is based on PUE information | |
| Activity Cosa formaalskode | You can find this in table ImportFromDBesas_Uddannelsesaktivitet column esas_cosa_formaalskode | ||
| Activity gruppekode | Activity_Education | ||
| PUE -> Activity Institution code | AktivitetsAfdeling | It is based on PUE information | |
| 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 -> Activity Department | ActivityDepartmentName | It is based on Hold information | |
| Hold -> Activity Institution code | AktivitetsAfdeling | It is based on Hold information |