AdminServers/esas: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
← Older editNewer edit →
VisualWikitext
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
Line 24: Line 24:
!Remarks
!Remarks
|-
|-
|Students ID
|esas_personid
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|
|
|-
|-
|Students 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
|-
|esas_lokalt_studienummer
|StudieNr
|
|
|-
|-
|CivilRegistrationNumber
|esas_cpr_nummer_uden_formatering
|CPR
|CPR
|
|
|-
|-
|AdUsername
|BirthDate
|StudieNr
|BirthDay
|
|
|-
|-
|ProtectedGivenName
|FirstName + MiddleName
|PublicRegisteredFirstName
|PublicRegisteredFirstName
|
|
|-
|-
|ProtectedSurname
|LastName
|PublicRegisteredSurName
|PublicRegisteredSurName
|
|
|-
|-
|Email
|esas_postnummer
|PrivateMail
|Postnummer
|
|
|-
|-
|PhoneNumber
|esas_by
|PrivateMobilePhone
|City
|
|
|-
|-
|PhoneNumber
|esas_kommune_id
|MobilePhone
|Sted
|
|
|-
|-
|StudyStartDate
|Address1_Line1
|StudyStart_Education
|Adresse
|
|
|-
|-
|StudyEndDate
|esas_privatemail
|StudyEnd_Education
|PrivateMail
|
|
|-
|-
|StudyExpectedCompletionDate
|esas_mobiltelefonnummer
|Expected_EducationEndDate
|PrivateMobilePhone
|
|
|-
|-
|Department ID
|esas_mobiltelefonnummer
|DepartmentID
|MobilePhone
|
|
|-
|-
|Department Name
|esas_sso_id
|Department
|OtherInfo
|
|
|-
|-
|AddressLine
|esas_studieemail
|Adresse
|WorkMail
|
|
|-
|-
|PostalCode
|esas_navne_addressebeskyttet
|PostNummer
|SecretAddress
|
|
|-
|-
|Place
|esas_uddannelsesaktivitetId
|Sted
|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
|
|
|-
|-
|CareOfAddressLine
|esas_studiestart
|COAddress
|StudyStart_Education
|
|
|-
|-
|ProtectedNameAndAddress
|esas_afgangsdato
|SecretAddress
|StudyEnd_Education
|If null then use esas_forventet_afslutning
|-
|esas_forventet_afslutning
|Expected_EducationEndDate
|
|
|-
|-
|DepartmentEducation ID
|esas_afdelingId
|EducationDepartmentID
|DepartmentID
|
|
|-
|-
|DepartmentEducation Name
|esas_navn
|EducationDepartmentname
|Department
|
|
|-
|-
|Student Studies EducationId
|Address1_Line1
|EducationID
|DepartmentStreet
|From table ImportFromDBesas_InstitutionVirksomhed
|-
|esas_postnummer
|DepartmentPostalCode
|
|
|-
|-
|Student Studies EducationName
|esas_by
|Education
|DepartmentCity
|
|
|-
|-
|Student Studies EducationVersion
|esas_institutionsnummer
|EducationVersion
|SkoleKode
|
|
|-
|-
|Student Studies Coesa
|esas_navn
|COSA_FORMAL
|EducationVersion
|
|
|-
|-
|Student Studies DsDepartmentNumber
|esas_lokalt_studienummer
|Skolekode
|AlternativID
|
|
|-
|Guardian information
|Guardian information
|This is copied to the guardian fields in UMS
|}
|}
{| class="wikitable"
{| class="wikitable"
Line 146: Line 174:
!Remarks
!Remarks
|-
|-
|
|esas_navn_dansk
|Klassebetegnelse
|Klassebetegnelse
|
|From table ImportFromDBesas_Hold
|}
|}
{| class="wikitable"
{| class="wikitable"

Revision as of 08:53, 1 February 2021

Certificate file

The certificate used to access esas webservices.

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_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
Extra fields when extracting students with rowtype
Student
Admin system UMS Remarks
esas_navn_dansk Klassebetegnelse From table ImportFromDBesas_Hold
Extra fields when extracting students with rowtype
Undervisningshold
Admin system UMS Remarks
ActivityDepartmentStreet
ActivityDepartmentPostalCode
ActivityDepartmentCity
ExtraField2
ActivityDepartmentNumber
ActivityDepartmentName
AktivitetsAfdeling
AktivitetsID
Aktivitet
ActivityDisplayName
ActivityDescription
Kort_Betegnelse
Activity_LMS_AllowRoll
Aktivitet_LMS
Activity_PublicationCode
ActivityType
StartDato
SlutDato
Aktiviteter_StartDato
Aktiviteter_SlutDato
Course_ID
Skolefag
Skolefag_Betegnelse
CourseLevel
CourseType
Activity_EducationID
Activity_Education
Activity_EducationDescription
Activity_Teacher_FirstName
Activity_Teacher_LastName
Activity_Teacher_SSN
Extra fields when extracting students with rowtype
Stamhold
Admin system UMS Remarks

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
Activity Department ActivityDepartmentName
Activity Cosa formaalskode You can find this in the ImportFromDBesas_Uddannelsesaktivitet table column esas_cosa_formaalskode
Activity gruppekode Activity_Education
Activity Institution code AktivitetsAfdeling
Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling You can find this in the ImportFromDBesas_Afdeling table column esas_navn
Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling code You can find this in the ImportFromDBesas_Afdeling table column esas_institutionsnummer
Retrieved from "http://wiki.inlogic.dk/index.php?title=AdminServers/esas&oldid=3775"