AdminServers/esas: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
No edit summary
 
(39 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 19: Line 23:
{| class="wikitable"
{| class="wikitable"
|+
|+
Employees
Students
!Admin system
!Admin system
!UMS
!UMS
!Remarks
!Remarks
|-
|-
|Employee ID
|esas_personid
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|
|
|-
|-
|Employee ID
|ContactId
|IDFromAdministrativeSystem
|IDFromAdministrativeSystem
|
|
|-
|-
|GivenName
|FirstName + MiddleName
|Fornavn
|Fornavn
|
|If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
|-
|-
|Surname
|LastName
|EFTERNAVN
|EFTERNAVN
|
|If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
|-
|-
|Initials
|esas_lokalt_studienummer
|StudieNr
|StudieNr
|
|
|-
|-
|CivilRegistrationNumber
|esas_cpr_nummer_uden_formatering
|CPR
|CPR
|
|
|-
|-
|AdUsername
|BirthDate
|AlternativID
|BirthDay
|
|
|-
|-
|ProtectedGivenName
|FirstName + MiddleName
|PublicRegisteredFirstName
|PublicRegisteredFirstName
|
|
|-
|-
|ProtectedSurname
|LastName
|PublicRegisteredSurName
|PublicRegisteredSurName
|
|
|-
|-
|Email
|esas_postnummer
|WorkMail
|Postnummer
|
|
|-
|-
|PhoneNumber
|esas_by
|WorkMobilePhone
|City
|
|
|-
|-
|PhoneNumber
|esas_kommune_id
|MobilePhone
|Sted
|
|
|-
|-
|JobTitle
|Address1_Line1
|Employee_Description
|Adresse
|
|
|-
|-
|Department ID
|esas_privatemail
|DepartmentID
|PrivateMail
|
|
|-
|-
|Department Name
|esas_mobiltelefonnummer
|Department
|PrivateMobilePhone
|
|
|-
|-
|AddressLine
|esas_mobiltelefonnummer
|Adresse
|MobilePhone
|
|
|-
|-
|PostalCode
|esas_sso_id
|PostNummer
|OtherInfo
|
|
|-
|-
|Place
|esas_studieemail
|Sted
|WorkMail
|
|-
|CareOfAddressLine
|COAddress
|
|
|-
|-
|ProtectedNameAndAddress
|esas_navne_addressebeskyttet
|SecretAddress
|SecretAddress
|
|
|-
|-
|Department ID
|esas_uddannelsesaktivitetId
|AktivitetsID
|EducationID
|
|From table ImportFromDBesas_Uddannelsesstruktur
|-
|-
|Department Name
|esas_navn
|Aktivitet
|EducationVersion
|
|From table ImportFromDBesas_Uddannelsesstruktur
|-
|-
|Department Name
|esas_cosa_formaalskode
|ActivityDisplayName
|EducationCode
|
|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|-
|Department Name
|esas_aktivitetsgruppekode
|ActivityDescription
|EducationGroupCode
|
|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|-
|Department Name
|esas_navn
|Kort_Betegnelse
|Education
|
|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|-
|EmploymentStartDate
|esas_betegnelse
|StartDato
|EducationDescriptionShort
|If department start date is after employment start date then department start date is used if not then employment start date is used
|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|-
|EmploymentResignationDate
|esas_titel
|SlutDato
|EducationDescription
|If department end date is before employment resignation date then department end date is used if not then employment resignation date is used
|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|-
|Department ValidFrom
|esas_personoplysningerId
|Aktiviteter_StartDato
|ExtraField1
|
|
|-
|-
|Department ValidTo
|esas_studiestart
|Aktiviteter_SlutDato
|
|-
|EmploymentStartDate
|Employement_StartDate
|
|-
|EmploymentResignationDate
|Employement_EndDate
|
|-
|AreasOfResponsibility Name
|Employee_ResponsibilityArea
|
|}
{| class="wikitable"
|+
Students
!Admin system
!UMS
!Remarks
|-
|Students ID
|UMS_IDFromAdministrativeSystem
|
|-
|Students ID
|IDFromAdministrativeSystem
|
|-
|GivenName
|Fornavn
|
|-
|Surname
|EFTERNAVN
|
|-
|CivilRegistrationNumber
|CPR
|
|-
|AdUsername
|StudieNr
|
|-
|ProtectedGivenName
|PublicRegisteredFirstName
|
|-
|ProtectedSurname
|PublicRegisteredSurName
|
|-
|Email
|PrivateMail
|
|-
|PhoneNumber
|PrivateMobilePhone
|
|-
|PhoneNumber
|MobilePhone
|
|-
|StudyStartDate
|StudyStart_Education
|StudyStart_Education
|
|
|-
|-
|StudyEndDate
|esas_afgangsdato
|StudyEnd_Education
|StudyEnd_Education
|
|If null then use esas_forventet_afslutning
|-
|-
|StudyExpectedCompletionDate
|esas_forventet_afslutning
|Expected_EducationEndDate
|Expected_EducationEndDate
|
|
|-
|-
|Department ID
|esas_afdelingId
|DepartmentID
|DepartmentID
|
|
|-
|-
|Department Name
|esas_navn
|Department
|Department
|
|
|-
|-
|AddressLine
|Address1_Line1
|Adresse
|DepartmentStreet
|
|From table ImportFromDBesas_InstitutionVirksomhed
|-
|-
|PostalCode
|esas_postnummer
|PostNummer
|DepartmentPostalCode
|
|
|-
|-
|Place
|esas_by
|Sted
|DepartmentCity
|
|
|-
|-
|CareOfAddressLine
|esas_institutionsnummer
|COAddress
|SkoleKode
|
|
|-
|-
|ProtectedNameAndAddress
|esas_navn
|SecretAddress
|EducationVersion
|
|
|-
|-
|DepartmentEducation ID
|esas_lokalt_studienummer
|EducationDepartmentID
|AlternativID
|
|
|-
|-
|DepartmentEducation Name
|NationalAfgangsaarsag.esas_national_afgangsaarsagId
|EducationDepartmentname
|DepartureCauseCode
|
|
|-
|-
|Student Studies EducationId
|NationalAfgangsaarsag.esas_navn
|EducationID
|DepartureCause_Description
|
|
|-
|-
|Student Studies EducationName
|Internationalisering
|Education
|ActiveOnEducation
|
|calculated Between ImportFromDBesas_Internationalisering.esas_startdato And ImportFromDBesas_Internationalisering.esas_slutdato
|-
and only for outgoing students
|Student Studies EducationVersion
|}
|EducationVersion
{| class="wikitable"
|
|+Extra fields when extracting students with rowtype<br>Student
!Admin system
!UMS
!Remarks
|-
|-
|Student Studies Coesa
|esas_navn_dansk
|COSA_FORMAL
|Klassebetegnelse
|
|This is based on esas_stamhold_id on Studieforloeb
|-
esas_navn_dansk is from table ImportFromDBesas_Hold
|Student Studies DsDepartmentNumber
|Skolekode
|
|-
|Guardian information
|Guardian information
|This is copied to the guardian fields in UMS
|}
|}
{| class="wikitable"
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>
|+Extra fields when extracting students with rowtype<br>Undervisningshold, Stamhold, Skabelonhold and Semesterhold
Student
!Admin system
!Admin system
!UMS
!UMS
!Remarks
!Remarks
|-
|-
|SubjectCourse ID
|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
|AktivitetsID
|
|From Hold
|-
|-
|SubjectCourse Designation
|esas_navn_dansk
|Aktivitet
|Aktivitet
|
|From Hold
|-
|-
|SubjectCourse Designation
|esas_navn_dansk
|ActivityDisplayName
|ActivityDisplayName
|
|From Hold
|-
|-
|SubjectCourse Name
|esas_navn_dansk
|ActivityDescription
|ActivityDescription
|
|From Hold
|-
|-
|SubjectCourse Designation
|esas_navn_dansk
|Kort_Betegnelse
|Kort_Betegnelse
|From Hold
|-
|
|
|Activity_LMS_AllowRoll
|True if publication has been set
|-
|-
|SubjectCourse LmsIndicator
|
|Aktivitet_LMS
|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
|-
|-
|Subject Course Enrollment StartDate
|esas_startdato
|StartDato
|StartDato
|
|From table ImportFromDBesas_Hold
|-
|-
|Subject Course Enrollment EndDate
|esas_slutdato
|SlutDato
|SlutDato
|
|Use Studieforloeb esas_afgangsdato if lower then ImportFromDBesas_Hold esas_slutdato
|-
|-
|SubjectCourse StartDate
|esas_startdato
|Aktiviteter_StartDato
|Aktiviteter_StartDato
|
|if null use PUE esas_startdato
|-
|-
|SubjectCourse EndDate
|esas_slutdato
|Aktiviteter_SlutDato
|Aktiviteter_SlutDato
|
|if null use PUE esas_slutdato
|-
|-
|UVM Course ID
|esas_uddannelseselementId
|Course_ID
|Course_ID
|
|From SUE
|-
|-
|UVM Course Subject
|esas_uvm_fagkode
|Skolefag
|Skolefag
|
|From SUE
|-
|-
|UVM Course Description
|esas_navn
|Skolefag_Betegnelse
|Skolefag_Betegnelse
|
|From SUE
|-
|-
|UVM Course Level
|esas_fagkode_niveau
|CourseLevel
|CourseLevel
|If Level is a - then Null is written to UMS
|From SUE
|-
|-
|
|Label
|SkoleFag_LMS
|CourseType
|Is set to true if there is a UVM course connected
|Using Label from OptionSetValueString based on esas_fagtype
|}
|-
{| class="wikitable"
|esas_uddannelsesaktivitetId
|+Extra fields when extracting students with rowtype<br>
|Activity_EducationID
EducationProgram
|From table ImportFromDBesas_Uddannelsesstruktur
!Admin system
|-
!UMS
|esas_navn
!Remarks
|Activity_EducationVersion
|From table ImportFromDBesas_Uddannelsesstruktur
|-
|-
|EducationalProgrammes ID
|esas_cosa_formaalskode
|AktivitetsID
|Activity_EducationCode
|
|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|-
|EducationalProgrammes Designation
|esas_aktivitetsgruppekode
|Aktivitet
|Activity_EducationGroupCode
|
|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|-
|EducationalProgrammes Designation
|esas_navn
|ActivityDisplayName
|Activity_Education
|
|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|-
|EducationalProgrammes Name
|esas_betegnelse
|ActivityDescription
|Activity_EducationDescription
|
|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|-
|EducationalProgrammes Designation
|esas_titel
|Kort_Betegnelse
|Activity_EducationDescriptionShort
|
|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|-
|FirstName
|Activity_Teacher_FirstName
|
|
|Aktivitet_LMS
|True
|-
|-
|EducationalProgrammes StartDate
|LastName
|StartDato
|Activity_Teacher_LastName
|
|
|-
|-
|EducationalProgrammes EndDate
|esas_cpr_nummer_uden_formatering
|SlutDato
|Activity_Teacher_SSN
|
|
|-
|-
|EducationalProgrammes StartDate
|esas_uddannelseselement_planlaegningId
|Aktiviteter_StartDato
|ExtraField2
|
|
|-
|-
|EducationalProgrammes EndDate
|esas_afdelingId
|Aktiviteter_SlutDato
|ExtraField3
|
|Uses Hold -> afdelings ID, if null use afdelings ID from hold -> Aktivitetsudbud
|}
|}
===Template criteria mapping===
===Template criteria mapping===
{| class="wikitable"
{| class="wikitable"
|+Employees
|+Students
!Admin system
!Admin system
!UMS
!UMS
Line 397: Line 371:
!Remarks
!Remarks
|-
|-
|Institutions kode
|Cosa formaalskode
|School Code
|COSA_FORMAL
|
|
|-
|Studieforløb -> Uddannelsesstruktur -> Uddannelsesaktivitet -> Aktivitets gruppekode
|Education
|
|
|
|
|-
|-
|Afdelings navn
|Studieforløb -> Department
|Department
|Department
|
|
|
|
|-
|-
|Ansvarsområde
|Studieforløb -> Institution code
|Responsibility area
|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
{| class="wikitable"
|+Students
!Admin system
!UMS
!Picture from admin system
!Remarks
|-
|-
|Institutions kode
|Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling
|School Code
|
|
|
|
|You can find this in table ImportFromDBesas_Afdeling column esas_navn
|-
|-
|Afdelings navn
|Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling code
|Department
|
|
|
|
|You can find this in table ImportFromDBesas_Afdeling column esas_institutionsnummer
|-
|-
|Uddannelses kode
|Hold -> Department
|CØSA Number
|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
|-
|-
|Uddannelsesforløbs kode
|Studieforløb -> Uddannelsesstruktur -> Uddannelses type
|Educational program designation
|EducationType
|
|
|
|
|-
|-
|Ansvarsområde
|Hold -> aktivitetsudbud -> Uddannelsesstruktur -> navn
|Responsibility area
|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

How to Certificates

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

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_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

Extra fields when extracting students with rowtype
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

Extra fields when extracting students with rowtype
Undervisningshold, Stamhold, Skabelonhold and Semesterhold
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

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
Studieforløb -> Uddannelsesstruktur -> Uddannelses type EducationType
Hold -> aktivitetsudbud -> Uddannelsesstruktur -> navn Activity_EducationVersion Only works for Hold
Studieforløb -> aktivitetsudbud -> Uddannelsesstruktur -> navn EducationVersion