AdminServers/UMSEnterprise: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
VisualWikitext
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
Created page with "none|thumb|656x656px ====Certificate file==== The certificate used to access esas webservices. [https://www.nets.eu/dk-da/kundeservice/medarbejd..."
 
Cna (talk | contribs)
engineering, Administrators
72 edits
No edit summary
 
(19 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[File:AdminServer Esas.jpg|none|thumb|656x656px]]
[[File:AdminServer UMSEnterprise.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===
Username to access webservices.
Username to access webservices.


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


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


Line 23: Line 14:
{| class="wikitable"
{| class="wikitable"
|+
|+
Students
Employees
!ObjectType
!Admin system
!Admin system
!UMS
!UMS
!Remarks
!Remarks
|-
|-
|esas_personid
|Employees
|id
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|
|
|-
|-
|ContactId
|Employees
|id
|IDFromAdministrativeSystem
|IDFromAdministrativeSystem
|
|
|-
|-
|FirstName + MiddleName
|Employees
|Fornavn
|firstName
|If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
|Fornavne
|
|-
|-
|LastName
|Employees
|lastName
|EFTERNAVN
|EFTERNAVN
|If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
|
|-
|-
|esas_lokalt_studienummer
|Employees
|initials
|StudieNr
|StudieNr
|
|
|-
|-
|esas_cpr_nummer_uden_formatering
|Employees
|cprNumber
|CPR
|CPR
|
|
|-
|-
|BirthDate
|Employees
|BirthDay
|initials
|AlternateAdminSystem_ID
|
|
|-
|-
|FirstName + MiddleName
|Employees
|PublicRegisteredFirstName
|recruitmentDate
|Employement_EndDate
|
|
|-
|-
|LastName
|Employees
|PublicRegisteredSurName
|Severancedate
|Employement_EndDate
|
|
|-
|-
|esas_postnummer
|Employees
|zipCode
|Postnummer
|Postnummer
|
|
|-
|-
|esas_by
|Employees
|city
|City
|City
|
|
|-
|-
|esas_kommune_id
|Employees
|Sted
|address
|Adresse
|
|
|-
|-
|Address1_Line1
|Employees
|Adresse
|tenantId
|Skolekode
|
|
|-
|-
|esas_privatemail
|Employees
|PrivateMail
|telephoneNumber
|WorkMobilePhone
|
|
|-
|-
|esas_mobiltelefonnummer
|Employees
|PrivateMobilePhone
|optionalPhoneNo
|WorkPhoneNumber
|
|
|-
|-
|esas_mobiltelefonnummer
|FormOfEmployments
|MobilePhone
|title
|Employee_JobEmployment_Description
|
|
|-
|-
|esas_sso_id
|Titles
|OtherInfo
|title
|Employee_JobResponsibility_Description
|
|
|-
|-
|esas_studieemail
|Employees -> Manager
|WorkMail
|initials
|Manager
|Uses department manager if Employees -> Manager is null
|-
|Employees -> Manager
|id
|Manager_ID
|Uses department manager if Employees -> Manager is null
|}
{| class="wikitable"
|+Extra fields when extracting rowtype<br>Department
!ObjectType
!Admin system
!UMS
!Remarks
|-
|Employees -> Departments
|AddToDepartmentEmail
|AddToDistributionGroup
|
|
|-
|-
|esas_navne_addressebeskyttet
|Employees -> Departments
|SecretAddress
|AddToDepartmentDrive
|AddToSecurityGroup
|
|
|-
|-
|esas_uddannelsesaktivitetId
|Employees -> Departments
|EducationID
|IsPrimary
|From table ImportFromDBesas_Uddannelsesaktivitet
|PrimaryEmployment
|
|-
|-
|esas_cosa_formaalskode
|Employees -> Departments
|COSA_FORMAL
|StartDate
|From table ImportFromDBesas_Uddannelsesaktivitet
|StartDato
|
|-
|-
|esas_aktivitetsgruppekode
|Employees -> Departments
|Education
|StopDate
|From table ImportFromDBesas_Uddannelsesaktivitet
|SlutDato
|
|-
|-
|esas_betegnelse
|Employees -> Departments
|EducationDescriptionShort
|StartDate
|From table ImportFromDBesas_Uddannelsesaktivitet
|Aktiviteter_STARTDATO
|
|-
|-
|esas_titel
|Departments
|EducationDescription
|departmentCode
|From table ImportFromDBesas_Uddannelsesaktivitet
|Employee_PrimaryDepartmentCode
|Is set if IsPrimary = true
|-
|-
|esas_personoplysningerId
|Departments
|ExtraField1
|id
|DepartmentID
|
|
|-
|-
|esas_studiestart
|Departments
|StudyStart_Education
|departmentCode
|DepartmentCode
|
|
|-
|-
|esas_afgangsdato
|Departments
|StudyEnd_Education
|departmentName
|If null then use esas_forventet_afslutning
|Department
|
|-
|-
|esas_forventet_afslutning
|Departments
|Expected_EducationEndDate
|departmentName
|DepartmentDescription
|
|
|-
|-
|esas_afdelingId
|Departments
|DepartmentID
|id
|AktivitetsID
|
|
|-
|-
|esas_navn
|Departments
|Department
|departmentName
|Aktivitet
|
|
|-
|-
|Address1_Line1
|Departments
|DepartmentStreet
|departmentName
|From table ImportFromDBesas_InstitutionVirksomhed
|ActivityDisplayName
|
|-
|-
|esas_postnummer
|Departments
|DepartmentPostalCode
|departmentName
|ActivityDescription
|
|
|-
|-
|esas_by
|Departments
|DepartmentCity
|departmentLMS
|Aktivitet_LMS
|
|
|-
|-
|esas_institutionsnummer
|Location
|SkoleKode
|zipCode
|DepartmentPostalCode
|
|
|-
|-
|esas_navn
|Location
|EducationVersion
|city
|DepartmentCity
|
|
|-
|-
|esas_lokalt_studienummer
|Location
|AlternativID
|address
|DepartmentStreet
|
|
|}
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>Student
!Admin system
!UMS
!Remarks
|-
|-
|esas_navn_dansk
|Location
|Klassebetegnelse
|locationId
|This is based on esas_stamhold_id on Studieforloeb
|DepartmentLocationID
esas_navn_dansk is from table ImportFromDBesas_Hold
|
|}
|}
{| class="wikitable"
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>Undervisningshold, Stamhold, Skabelonhold and Semesterhold
|+Extra fields when extracting rowtype<br>Roles
!ObjectType
!Admin system
!Admin system
!UMS
!UMS
!Remarks
!Remarks
|-
|-
|Address1_Line1
|
|ActivityDepartmentStreet
|
|If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
|StartDato
|Today
|-
|-
|esas_postnummer
|
|ActivityDepartmentPostalCode
|
|If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
|SlutDato
|Today + 100
|-
|-
|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
|
|
|
|Aktiviteter_STARTDATO
|Today
|-
|-
|esas_holdId
|Roles
|id
|AktivitetsID
|AktivitetsID
|From Hold
|
|-
|-
|esas_navn_dansk
|Roles
|title
|Aktivitet
|Aktivitet
|From Hold
|
|-
|-
|esas_navn_dansk
|Roles
|title
|ActivityDisplayName
|ActivityDisplayName
|From Hold
|
|-
|-
|esas_navn_dansk
|Roles
|description
|ActivityDescription
|ActivityDescription
|From Hold
|
|-
|esas_navn_dansk
|Kort_Betegnelse
|From Hold
|-
|-
|
|
|Activity_LMS_AllowRoll
|True if publication has been set
|-
|
|
|Aktivitet_LMS
|Aktivitet_LMS
|True if publication has been set
|Is always true
|-
|-
|esas_publiceringsmulighed_institutionsspecifik
|Roles
|Activity_PublicationCode
|roleType
|From Hold
|Activity_GroupType
|
|}
{| class="wikitable"
|+Extra fields when extracting rowtype<br>RoleGroups<br>This is NOT IMPORTED yet
!ObjectType
!Admin system
!UMS
!Remarks
|-
|-
|Label
|
|ActivityType
|
|Using Label from OptionSetValueString based on esas_holdtype
|-
|esas_startdato
|StartDato
|StartDato
|From table ImportFromDBesas_Hold
|Today
|-
|-
|esas_slutdato
|
|
|SlutDato
|SlutDato
|Use Studieforloeb esas_afgangsdato if lower then ImportFromDBesas_Hold esas_slutdato
|Today + 100
|-
|-
|esas_startdato
|
|Aktiviteter_StartDato
|
|if null use PUE esas_startdato
|Aktiviteter_STARTDATO
|Today
|-
|-
|esas_slutdato
|RoleGroups
|Aktiviteter_SlutDato
|id
|if null use PUE esas_slutdato
|AktivitetsID
|-
|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
|RoleGroups
|Activity_Education
|title
|Aktivitet
|
|
|-
|-
|esas_betegnelse
|RoleGroups
|Activity_EducationDescription
|title
|ActivityDisplayName
|
|
|-
|-
|FirstName
|RoleGroups
|Activity_Teacher_FirstName
|title
|ActivityDescription
|
|
|-
|-
|LastName
|Activity_Teacher_LastName
|
|
|-
|esas_cpr_nummer_uden_formatering
|Activity_Teacher_SSN
|
|
|Aktivitet_LMS
|Is always true
|}
|}
===Template criteria mapping===
===Template criteria mapping===
{| class="wikitable"
{| class="wikitable"
Line 322: Line 329:
!Remarks
!Remarks
|-
|-
|Cosa formaalskode
|tenantId
|COSA_FORMAL
|Skolekode
|
|
|
|
|-
|-
|Studieforløb -> Uddannelsesstruktur -> Uddannelsesaktivitet -> Aktivitets gruppekode
|departmentCode
|Education
|DepartmentCode
|
|
|
|
|-
|-
|Studieforløb -> Department
|Roles -> title
|Department
|Aktivitet
|
|
|
|
|-
|-
|Studieforløb -> Institution code
|RoleGroups -> title
|SkoleKode
|Aktivitet
|
|
|-
|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
|FormOfEmployments -> title
|Employee_JobEmployment_Description
|
|
|
|
|You can find this in table ImportFromDBesas_Afdeling column esas_navn
|-
|-
|Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling code
|Titles -> title
|Employee_JobResponsibility_Description
|
|
|
|
|You can find this in table ImportFromDBesas_Afdeling column esas_institutionsnummer
|-
|-
|Hold -> Department
|Department -> Location id
|ActivityDepartmentName
|DepartmentLocationID
|
|
|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
|}
|}

Latest revision as of 11:49, 26 July 2021

Username

Username to access webservices.

This information created in UMS Pro (umspro.dk)

Password

Password to access webservices.

This information created in UMS Pro (umspro.dk)

Export settings

Data mapping

Employees
ObjectType Admin system UMS Remarks
Employees id UMS_IDFromAdministrativeSystem
Employees id IDFromAdministrativeSystem
Employees firstName Fornavne
Employees lastName EFTERNAVN
Employees initials StudieNr
Employees cprNumber CPR
Employees initials AlternateAdminSystem_ID
Employees recruitmentDate Employement_EndDate
Employees Severancedate Employement_EndDate
Employees zipCode Postnummer
Employees city City
Employees address Adresse
Employees tenantId Skolekode
Employees telephoneNumber WorkMobilePhone
Employees optionalPhoneNo WorkPhoneNumber
FormOfEmployments title Employee_JobEmployment_Description
Titles title Employee_JobResponsibility_Description
Employees -> Manager initials Manager Uses department manager if Employees -> Manager is null
Employees -> Manager id Manager_ID Uses department manager if Employees -> Manager is null
Extra fields when extracting rowtype
Department
ObjectType Admin system UMS Remarks
Employees -> Departments AddToDepartmentEmail AddToDistributionGroup
Employees -> Departments AddToDepartmentDrive AddToSecurityGroup
Employees -> Departments IsPrimary PrimaryEmployment
Employees -> Departments StartDate StartDato
Employees -> Departments StopDate SlutDato
Employees -> Departments StartDate Aktiviteter_STARTDATO
Departments departmentCode Employee_PrimaryDepartmentCode Is set if IsPrimary = true
Departments id DepartmentID
Departments departmentCode DepartmentCode
Departments departmentName Department
Departments departmentName DepartmentDescription
Departments id AktivitetsID
Departments departmentName Aktivitet
Departments departmentName ActivityDisplayName
Departments departmentName ActivityDescription
Departments departmentLMS Aktivitet_LMS
Location zipCode DepartmentPostalCode
Location city DepartmentCity
Location address DepartmentStreet
Location locationId DepartmentLocationID
Extra fields when extracting rowtype
Roles
ObjectType Admin system UMS Remarks
StartDato Today
SlutDato Today + 100
Aktiviteter_STARTDATO Today
Roles id AktivitetsID
Roles title Aktivitet
Roles title ActivityDisplayName
Roles description ActivityDescription
Aktivitet_LMS Is always true
Roles roleType Activity_GroupType
Extra fields when extracting rowtype
RoleGroups
This is NOT IMPORTED yet
ObjectType Admin system UMS Remarks
StartDato Today
SlutDato Today + 100
Aktiviteter_STARTDATO Today
RoleGroups id AktivitetsID
RoleGroups title Aktivitet
RoleGroups title ActivityDisplayName
RoleGroups title ActivityDescription
Aktivitet_LMS Is always true

Template criteria mapping

Students
Admin system UMS Picture from admin system Remarks
tenantId Skolekode
departmentCode DepartmentCode
Roles -> title Aktivitet
RoleGroups -> title Aktivitet
FormOfEmployments -> title Employee_JobEmployment_Description
Titles -> title Employee_JobResponsibility_Description
Department -> Location id DepartmentLocationID
Retrieved from "http://wiki.inlogic.dk/index.php?title=AdminServers/UMSEnterprise&oldid=3993"