Changes

Jump to: navigation, search

AdminServers/UMSEnterprise

2,530 bytes removed, 11:49, 26 July 2021
no edit summary
Username to access webservices.
This information created in given by UMS Pro ([https://ufmumspro.dk umspro.dk/uddannelse/videregaende-uddannelse/studieadministrative-systemer/projekt-esas Esas])
===Password===
Password to access webservices.
This information created in given by UMS Pro ([https://ufmumspro.dk umspro.dk/uddannelse/videregaende-uddannelse/studieadministrative-systemer/projekt-esas Esas])
===[[AdminServers/Export Settings|Export settings]]===
{| class="wikitable"
|+
StudentsEmployees!ObjectType
!Admin system
!UMS
!Remarks
|-
|esas_personidEmployees|id
|UMS_IDFromAdministrativeSystem
|
|-
|ContactIdEmployees|id
|IDFromAdministrativeSystem
|
|-
|FirstName + MiddleNameEmployees|FornavnfirstName|Fornavne|If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
|-
|LastNameEmployees|lastName
|EFTERNAVN
|If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
|-
|esas_lokalt_studienummerEmployees|initials
|StudieNr
|
|-
|esas_cpr_nummer_uden_formateringEmployees|cprNumber
|CPR
|
|-
|BirthDateEmployees|BirthDayinitials|AlternateAdminSystem_ID
|
|-
|FirstName + MiddleNameEmployees|PublicRegisteredFirstNamerecruitmentDate|Employement_EndDate
|
|-
|LastNameEmployees|PublicRegisteredSurNameSeverancedate|Employement_EndDate
|
|-
|esas_postnummerEmployees|zipCode
|Postnummer
|
|-
|esas_byEmployees|city
|City
|
|-
|esas_kommune_idEmployees|Stedaddress|Adresse
|
|-
|Address1_Line1Employees|AdressetenantId|Skolekode
|
|-
|esas_privatemailEmployees|PrivateMailtelephoneNumber|WorkMobilePhone
|
|-
|esas_mobiltelefonnummerEmployees|PrivateMobilePhoneoptionalPhoneNo|WorkPhoneNumber
|
|-
|esas_mobiltelefonnummerFormOfEmployments|MobilePhonetitle|Employee_JobEmployment_Description
|
|-
|esas_sso_idTitles|OtherInfotitle|Employee_JobResponsibility_Description
|
|-
|esas_studieemailEmployees -> Manager|WorkMailinitials|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_addressebeskyttetEmployees -> Departments|SecretAddressAddToDepartmentDrive|AddToSecurityGroup
|
|-
|esas_uddannelsesaktivitetIdEmployees -> Departments|EducationIDIsPrimary|PrimaryEmployment|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|esas_cosa_formaalskodeEmployees -> Departments|COSA_FORMALStartDate|StartDato|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|esas_aktivitetsgruppekodeEmployees -> Departments|EducationStopDate|SlutDato|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|esas_betegnelseEmployees -> Departments|EducationDescriptionShortStartDate|Aktiviteter_STARTDATO|From table ImportFromDBesas_Uddannelsesaktivitet
|-
|esas_titelDepartments|EducationDescriptiondepartmentCode|From table ImportFromDBesas_UddannelsesaktivitetEmployee_PrimaryDepartmentCode|Is set if IsPrimary = true
|-
|esas_personoplysningerIdDepartments|ExtraField1id|DepartmentID
|
|-
|esas_studiestartDepartments|StudyStart_EducationdepartmentCode|DepartmentCode
|
|-
|esas_afgangsdatoDepartments|StudyEnd_EducationdepartmentName|Department|If null then use esas_forventet_afslutning
|-
|esas_forventet_afslutningDepartments|Expected_EducationEndDatedepartmentName|DepartmentDescription
|
|-
|esas_afdelingIdDepartments|DepartmentIDid|AktivitetsID
|
|-
|esas_navnDepartments|DepartmentdepartmentName|Aktivitet
|
|-
|Address1_Line1Departments|DepartmentStreetdepartmentName|ActivityDisplayName|From table ImportFromDBesas_InstitutionVirksomhed
|-
|esas_postnummerDepartments|DepartmentPostalCodedepartmentName|ActivityDescription
|
|-
|esas_byDepartments|DepartmentCitydepartmentLMS|Aktivitet_LMS
|
|-
|esas_institutionsnummerLocation|SkoleKodezipCode|DepartmentPostalCode
|
|-
|esas_navnLocation|EducationVersioncity|DepartmentCity
|
|-
|esas_lokalt_studienummerLocation|AlternativIDaddress|DepartmentStreet
|
|}
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>Student
!Admin system
!UMS
!Remarks
|-
|esas_navn_danskLocation|KlassebetegnelselocationId|This is based on esas_stamhold_id on StudieforloebDepartmentLocationIDesas_navn_dansk is from table ImportFromDBesas_Hold|
|}
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>Undervisningshold, Stamhold, Skabelonhold and SemesterholdRoles!ObjectType
!Admin system
!UMS
!Remarks
|-
|Address1_Line1|ActivityDepartmentStreet|If afdeling from Hold is null then use Aktivitetsudbud afdeling from HoldStartDato|Today
|-
|esas_postnummer|ActivityDepartmentPostalCode|If afdeling from Hold is null then use Aktivitetsudbud afdeling from HoldSlutDato|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_holdIdRoles|id
|AktivitetsID
|From Hold
|-
|esas_navn_danskRoles|title
|Aktivitet
|From Hold
|-
|esas_navn_danskRoles|title
|ActivityDisplayName
|From Hold
|-
|esas_navn_danskRoles|description
|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 setIs always true
|-
|esas_publiceringsmulighed_institutionsspecifikRoles|Activity_PublicationCoderoleType|From HoldActivity_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
|From table ImportFromDBesas_HoldToday
|-
|esas_slutdato|
|SlutDato
|Use Studieforloeb esas_afgangsdato if lower then ImportFromDBesas_Hold esas_slutdatoToday + 100
|-
|esas_startdato|Aktiviteter_StartDato|if null use PUE esas_startdatoAktiviteter_STARTDATO|Today
|-
|esas_slutdatoRoleGroups|Aktiviteter_SlutDatoid|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_EducationIDAktivitetsID
|
|-
|esas_aktivitetsgruppekodeRoleGroups|Activity_Educationtitle|Aktivitet
|
|-
|esas_betegnelseRoleGroups|Activity_EducationDescriptiontitle|ActivityDisplayName
|
|-
|FirstNameRoleGroups|Activity_Teacher_FirstNametitle|ActivityDescription
|
|-
|LastName
|Activity_Teacher_LastName
|
|-
|esas_cpr_nummer_uden_formatering
|Activity_Teacher_SSN
|
|Aktivitet_LMS
|Is always true
|}
 
===Template criteria mapping===
{| class="wikitable"
!Remarks
|-
|Cosa formaalskodetenantId|COSA_FORMALSkolekode
|
|
|-
|Studieforløb -> Uddannelsesstruktur -> Uddannelsesaktivitet -> Aktivitets gruppekodedepartmentCode|EducationDepartmentCode
|
|
|-
|Studieforløb Roles -> Departmenttitle|DepartmentAktivitet
|
|
|-
|Studieforløb RoleGroups -> 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_Educationtitle|Aktivitet
|
|-
|PUE -> Activity Institution code
|AktivitetsAfdeling
|
|If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE
|-
|Studieforløb FormOfEmployments -> Aktivitetsudbud -> Aktivitetsafdelingtitle|Employee_JobEmployment_Description
|
|
|You can find this in table ImportFromDBesas_Afdeling column esas_navn
|-
|Studieforløb Titles -> Aktivitetsudbud -> Aktivitetsafdeling codetitle|Employee_JobResponsibility_Description
|
|
|You can find this in table ImportFromDBesas_Afdeling column esas_institutionsnummer
|-
|Hold Department -> DepartmentLocation id|ActivityDepartmentNameDepartmentLocationID
|
|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
|}
38
edits

Navigation menu