Changes

Jump to: navigation, search

AdminServers/UMSEnterprise

6,824 bytes added, 10:42, 25 May 2021
Created page with "none|thumb|656x656px ====Certificate file==== The certificate used to access esas webservices. [https://www.nets.eu/dk-da/kundeservice/medarbejd..."
[[File:AdminServer Esas.jpg|none|thumb|656x656px]]
====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]

[https://confluence.umit.dk/display/esasdokumentation/Import+af+certifikater How to Certificates]

====Certificate password====
Password for the certificate file.

===Username===
Username to access webservices.

This information in given by [https://ufm.dk/uddannelse/videregaende-uddannelse/studieadministrative-systemer/projekt-esas Esas]
===Password===
Password to access webservices.

This information in given by [https://ufm.dk/uddannelse/videregaende-uddannelse/studieadministrative-systemer/projekt-esas Esas]
===[[AdminServers/Export Settings|Export settings]]===

===Data mapping===
{| class="wikitable"
|+
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
|
|}
{| 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===
{| 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
|}
2,283
edits

Navigation menu