AdminServers/esas

From UmsWiki
Jump to navigation Jump to search

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
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
StudyEndDate StudyEnd_Education
StudyExpectedCompletionDate Expected_EducationEndDate
Department ID DepartmentID
Department Name Department
AddressLine Adresse
PostalCode PostNummer
Place Sted
CareOfAddressLine COAddress
ProtectedNameAndAddress SecretAddress
DepartmentEducation ID EducationDepartmentID
DepartmentEducation Name EducationDepartmentname
Student Studies EducationId EducationID
Student Studies EducationName Education
Student Studies EducationVersion EducationVersion
Student Studies Coesa COSA_FORMAL
Student Studies DsDepartmentNumber Skolekode
Guardian information Guardian information This is copied to the guardian fields in UMS
Extra fields when extracting students with rowtype
Student
Admin system UMS Remarks
Klassebetegnelse
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