Line 1:
Line 1: [[File:AdminServer Esas.jpg|none|thumb|656x656px]]
[[File:AdminServer MitID Erhverv .jpg|none|thumb|765x765px ]]
====Certificate file====
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]
===Certificate file===
The certificate used to access the webservices .
[https://confluence.umit.dk/display/esasdokumentation/Import+af+certifikater How to Certificates]
==== How to order test certificate ====
Creating new certificate:
====Certificate password====
See picture below for example
Password for the certificate file.
===Username===
Or
Username to access webservices.
This information in given by [https://ufm.dk/uddannelse/videregaende-uddannelse/studieadministrative-systemer/projekt-esas Esas]
* "Typer af cerfikater"
===Password===
** Oces organisationscertifikat
Password to access webservices.
* "Metode til identifikation"
** Bruger -login
* "Ja, gå direkte til udstedelse efter bestilling"
** Check this
* "Metode til udstedelse"
** Internetbrowser
This information in given by [https://ufm.dk/uddannelse/videregaende-uddannelse/studieadministrative-systemer/projekt-esas Esas]
<br />
===[[AdminServers/Export Settings|Export settings]]===
[[File:MitId Erhverv Order certificate picture.jpg|none|thumb |1102x1102px ]]
===Data mapping===
===Certificate password ===
{| class="wikitable"
Password for the certificate file .
|+
Students
!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
|
|-
|NationalAfgangsaarsag.esas_national_afgangsaarsagId
|DepartureCauseCode
|
|-
|NationalAfgangsaarsag.esas_navn
|DepartureCause_Description
|
|}
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>Student
!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
|}
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>Undervisningshold, Stamhold, Skabelonhold and Semesterhold
!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===
This will be given to you when you login after completing the order.
{| class="wikitable"
|+Students
!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
|}
Certificate file The certificate used to access the webservices.
How to order test certificate Creating new certificate:
See picture below for example
Or
"Typer af cerfikater"
Oces organisationscertifikat
"Metode til identifikation"
"Ja, gå direkte til udstedelse efter bestilling"
"Metode til udstedelse"
Certificate password Password for the certificate file.
This will be given to you when you login after completing the order.
