AdminServers/esas: Difference between revisions
Jump to navigation
Jump to search
(30 intermediate revisions by 2 users not shown) | |||
Line 2: | Line 2: | ||
====Certificate file==== | ====Certificate file==== | ||
The certificate used to access esas webservices. | The certificate used to access esas webservices. | ||
[https://www.nets.eu/dk-da/kundeservice/medarbejdersignatur/oevrige-signaturer/Pages/bestil-funktionssignatur.aspx How to order function certificate] | |||
[https://confluence.umit.dk/display/esasdokumentation/Import+af+certifikater How to Certificates] | |||
====Certificate password==== | ====Certificate password==== | ||
Line 102: | Line 106: | ||
|esas_uddannelsesaktivitetId | |esas_uddannelsesaktivitetId | ||
|EducationID | |EducationID | ||
|From table | |From table ImportFromDBesas_Uddannelsesstruktur | ||
|- | |||
|esas_navn | |||
|EducationVersion | |||
|From table ImportFromDBesas_Uddannelsesstruktur | |||
|- | |- | ||
|esas_cosa_formaalskode | |esas_cosa_formaalskode | ||
| | |EducationCode | ||
|From table ImportFromDBesas_Uddannelsesaktivitet | |From table ImportFromDBesas_Uddannelsesaktivitet | ||
|- | |- | ||
|esas_aktivitetsgruppekode | |esas_aktivitetsgruppekode | ||
|EducationGroupCode | |||
|From table ImportFromDBesas_Uddannelsesaktivitet | |||
|- | |||
|esas_navn | |||
|Education | |Education | ||
|From table ImportFromDBesas_Uddannelsesaktivitet | |From table ImportFromDBesas_Uddannelsesaktivitet | ||
Line 167: | Line 179: | ||
|AlternativID | |AlternativID | ||
| | | | ||
|- | |||
|NationalAfgangsaarsag.esas_national_afgangsaarsagId | |||
|DepartureCauseCode | |||
| | |||
|- | |||
|NationalAfgangsaarsag.esas_navn | |||
|DepartureCause_Description | |||
| | |||
|- | |||
|Internationalisering | |||
|ActiveOnEducation | |||
|calculated Between ImportFromDBesas_Internationalisering.esas_startdato And ImportFromDBesas_Internationalisering.esas_slutdato | |||
and only for outgoing students | |||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 187: | Line 212: | ||
|Address1_Line1 | |Address1_Line1 | ||
|ActivityDepartmentStreet | |ActivityDepartmentStreet | ||
|If afdeling from | |If afdeling from Hold is null then use Aktivitetsudbud afdeling | ||
|- | |- | ||
|esas_postnummer | |esas_postnummer | ||
|ActivityDepartmentPostalCode | |ActivityDepartmentPostalCode | ||
|If afdeling from | |If afdeling from Hold is null then use Aktivitetsudbud afdeling | ||
|- | |- | ||
|esas_by | |esas_by | ||
|ActivityDepartmentCity | |ActivityDepartmentCity | ||
|If afdeling from | |If afdeling from Hold is null then use Aktivitetsudbud afdeling | ||
|- | |- | ||
|esas_afdelingId | |esas_afdelingId | ||
|ActivityDepartmentNumber | |ActivityDepartmentNumber | ||
|If afdeling from | |If afdeling from Hold is null then use Aktivitetsudbud afdeling | ||
|- | |- | ||
|esas_navn | |esas_navn | ||
|ActivityDepartmentName | |ActivityDepartmentName | ||
|If afdeling from | |If afdeling from Hold is null then use Aktivitetsudbud afdeling | ||
|- | |- | ||
|esas_institutionsnummer | |esas_institutionsnummer | ||
|AktivitetsAfdeling | |AktivitetsAfdeling | ||
|If afdeling from | |If afdeling from Hold is null then use Aktivitetsudbud afdeling | ||
|- | |||
|esas_uddannelseselement_planlaegningId | |||
|ExtraField2 | |||
|Is only used for Undervisningshold | |||
|- | |||
|esas_afdelingId | |||
|ExtraField3 | |||
|If afdeling from Hold is null then use AktivitetsudbudHoldAfdeling afdeling | |||
|- | |- | ||
|esas_holdId | |esas_holdId | ||
|AktivitetsID | |AktivitetsID | ||
| | |From Hold | ||
|- | |- | ||
|esas_navn_dansk | |esas_navn_dansk | ||
|Aktivitet | |Aktivitet | ||
| | |From Hold | ||
|- | |- | ||
|esas_navn_dansk | |esas_navn_dansk | ||
|ActivityDisplayName | |ActivityDisplayName | ||
| | |From Hold | ||
|- | |- | ||
|esas_navn_dansk | |esas_navn_dansk | ||
|ActivityDescription | |ActivityDescription | ||
| | |From Hold | ||
|- | |- | ||
|esas_navn_dansk | |esas_navn_dansk | ||
|Kort_Betegnelse | |Kort_Betegnelse | ||
| | |From Hold | ||
|- | |- | ||
| | | | ||
Line 243: | Line 272: | ||
|esas_publiceringsmulighed_institutionsspecifik | |esas_publiceringsmulighed_institutionsspecifik | ||
|Activity_PublicationCode | |Activity_PublicationCode | ||
| | |From Hold | ||
|- | |- | ||
|Label | |Label | ||
Line 287: | Line 316: | ||
|esas_uddannelsesaktivitetId | |esas_uddannelsesaktivitetId | ||
|Activity_EducationID | |Activity_EducationID | ||
| | |From table ImportFromDBesas_Uddannelsesstruktur | ||
|- | |||
|esas_navn | |||
|Activity_EducationVersion | |||
|From table ImportFromDBesas_Uddannelsesstruktur | |||
|- | |||
|esas_cosa_formaalskode | |||
|Activity_EducationCode | |||
|From table ImportFromDBesas_Uddannelsesaktivitet | |||
|- | |- | ||
|esas_aktivitetsgruppekode | |esas_aktivitetsgruppekode | ||
|Activity_EducationGroupCode | |||
|From table ImportFromDBesas_Uddannelsesaktivitet | |||
|- | |||
|esas_navn | |||
|Activity_Education | |Activity_Education | ||
| | |From table ImportFromDBesas_Uddannelsesaktivitet | ||
|- | |- | ||
|esas_betegnelse | |esas_betegnelse | ||
|Activity_EducationDescription | |Activity_EducationDescription | ||
| | |From table ImportFromDBesas_Uddannelsesaktivitet | ||
|- | |||
|esas_titel | |||
|Activity_EducationDescriptionShort | |||
|From table ImportFromDBesas_Uddannelsesaktivitet | |||
|- | |- | ||
|FirstName | |FirstName | ||
Line 308: | Line 353: | ||
|Activity_Teacher_SSN | |Activity_Teacher_SSN | ||
| | | | ||
|- | |||
|esas_uddannelseselement_planlaegningId | |||
|ExtraField2 | |||
| | |||
|- | |||
|esas_afdelingId | |||
|ExtraField3 | |||
|Uses Hold -> afdelings ID, if null use afdelings ID from hold -> Aktivitetsudbud | |||
|} | |} | ||
===Template criteria mapping=== | ===Template criteria mapping=== | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 337: | Line 391: | ||
| | | | ||
|- | |- | ||
|Activity Department | |PUE -> Activity Department | ||
|ActivityDepartmentName | |ActivityDepartmentName | ||
| | | | ||
| | |If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE | ||
|- | |- | ||
|Activity Cosa formaalskode | |Activity Cosa formaalskode | ||
Line 352: | Line 406: | ||
| | | | ||
|- | |- | ||
|Activity Institution code | |PUE -> Activity Institution code | ||
|AktivitetsAfdeling | |AktivitetsAfdeling | ||
| | | | ||
| | |If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE | ||
|- | |- | ||
|Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling | |Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling | ||
Line 366: | Line 420: | ||
| | | | ||
|You can find this in table ImportFromDBesas_Afdeling column esas_institutionsnummer | |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 | |||
|- | |||
|Studieforløb -> Uddannelsesstruktur -> Uddannelses type | |||
|EducationType | |||
| | |||
| | |||
|- | |||
|Hold -> aktivitetsudbud -> Uddannelsesstruktur -> navn | |||
|Activity_EducationVersion | |||
| | |||
|Only works for Hold | |||
|- | |||
|Studieforløb -> aktivitetsudbud -> Uddannelsesstruktur -> navn | |||
|EducationVersion | |||
| | |||
| | |||
|} | |} |
Latest revision as of 08:47, 26 September 2024
Certificate file
The certificate used to access esas webservices.
How to order function certificate
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_Uddannelsesstruktur |
esas_navn | EducationVersion | From table ImportFromDBesas_Uddannelsesstruktur |
esas_cosa_formaalskode | EducationCode | From table ImportFromDBesas_Uddannelsesaktivitet |
esas_aktivitetsgruppekode | EducationGroupCode | From table ImportFromDBesas_Uddannelsesaktivitet |
esas_navn | 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 | |
NationalAfgangsaarsag.esas_national_afgangsaarsagId | DepartureCauseCode | |
NationalAfgangsaarsag.esas_navn | DepartureCause_Description | |
Internationalisering | ActiveOnEducation | calculated Between ImportFromDBesas_Internationalisering.esas_startdato And ImportFromDBesas_Internationalisering.esas_slutdato
and only for outgoing students |
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 |
esas_postnummer | ActivityDepartmentPostalCode | If afdeling from Hold is null then use Aktivitetsudbud afdeling |
esas_by | ActivityDepartmentCity | If afdeling from Hold is null then use Aktivitetsudbud afdeling |
esas_afdelingId | ActivityDepartmentNumber | If afdeling from Hold is null then use Aktivitetsudbud afdeling |
esas_navn | ActivityDepartmentName | If afdeling from Hold is null then use Aktivitetsudbud afdeling |
esas_institutionsnummer | AktivitetsAfdeling | If afdeling from Hold is null then use Aktivitetsudbud afdeling |
esas_uddannelseselement_planlaegningId | ExtraField2 | Is only used for Undervisningshold |
esas_afdelingId | ExtraField3 | If afdeling from Hold is null then use AktivitetsudbudHoldAfdeling afdeling |
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 | From table ImportFromDBesas_Uddannelsesstruktur |
esas_navn | Activity_EducationVersion | From table ImportFromDBesas_Uddannelsesstruktur |
esas_cosa_formaalskode | Activity_EducationCode | From table ImportFromDBesas_Uddannelsesaktivitet |
esas_aktivitetsgruppekode | Activity_EducationGroupCode | From table ImportFromDBesas_Uddannelsesaktivitet |
esas_navn | Activity_Education | From table ImportFromDBesas_Uddannelsesaktivitet |
esas_betegnelse | Activity_EducationDescription | From table ImportFromDBesas_Uddannelsesaktivitet |
esas_titel | Activity_EducationDescriptionShort | From table ImportFromDBesas_Uddannelsesaktivitet |
FirstName | Activity_Teacher_FirstName | |
LastName | Activity_Teacher_LastName | |
esas_cpr_nummer_uden_formatering | Activity_Teacher_SSN | |
esas_uddannelseselement_planlaegningId | ExtraField2 | |
esas_afdelingId | ExtraField3 | Uses Hold -> afdelings ID, if null use afdelings ID from hold -> Aktivitetsudbud |
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 | |
Studieforløb -> Uddannelsesstruktur -> Uddannelses type | EducationType | ||
Hold -> aktivitetsudbud -> Uddannelsesstruktur -> navn | Activity_EducationVersion | Only works for Hold | |
Studieforløb -> aktivitetsudbud -> Uddannelsesstruktur -> navn | EducationVersion |