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 141: Line 141:
|}
|}
{| class="wikitable"
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>
|+Extra fields when extracting students with rowtype<br>Student
Student
!Admin system
!Admin system
!UMS
!UMS
!Remarks
!Remarks
|-
|-
|SubjectCourse ID
|
|Klassebetegnelse
|
|}
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>Undervisningshold
!Admin system
!UMS
!Remarks
|-
|
|ActivityDepartmentStreet
|
|-
|
|ActivityDepartmentPostalCode
|
|-
|
|ActivityDepartmentCity
|
|-
|
|ExtraField2
|
|-
|
|ActivityDepartmentNumber
|
|-
|
|ActivityDepartmentName
|
|-
|
|AktivitetsAfdeling
|
|-
|
|AktivitetsID
|AktivitetsID
|
|
|-
|-
|SubjectCourse Designation
|
|Aktivitet
|Aktivitet
|
|
|-
|-
|SubjectCourse Designation
|
|ActivityDisplayName
|ActivityDisplayName
|
|
|-
|-
|SubjectCourse Name
|
|ActivityDescription
|ActivityDescription
|
|
|-
|-
|SubjectCourse Designation
|
|Kort_Betegnelse
|Kort_Betegnelse
|
|
|-
|-
|SubjectCourse LmsIndicator
|
|Activity_LMS_AllowRoll
|
|-
|
|Aktivitet_LMS
|Aktivitet_LMS
|
|
|-
|-
|Subject Course Enrollment StartDate
|
|Activity_PublicationCode
|
|-
|
|ActivityType
|
|-
|
|StartDato
|StartDato
|
|
|-
|-
|Subject Course Enrollment EndDate
|
|SlutDato
|SlutDato
|
|
|-
|-
|SubjectCourse StartDate
|
|Aktiviteter_StartDato
|Aktiviteter_StartDato
|
|
|-
|-
|SubjectCourse EndDate
|
|Aktiviteter_SlutDato
|Aktiviteter_SlutDato
|
|
|-
|-
|UVM Course ID
|
|Course_ID
|Course_ID
|
|
|-
|-
|UVM Course Subject
|
|Skolefag
|Skolefag
|
|
|-
|-
|UVM Course Description
|
|Skolefag_Betegnelse
|Skolefag_Betegnelse
|
|
|-
|-
|UVM Course Level
|
|CourseLevel
|CourseLevel
|If Level is a - then Null is written to UMS
|
|-
|
|CourseType
|
|-
|-
|
|
|SkoleFag_LMS
|Activity_EducationID
|Is set to true if there is a UVM course connected
|
|-
|
|Activity_Education
|
|-
|
|Activity_EducationDescription
|
|-
|
|Activity_Teacher_FirstName
|
|-
|
|Activity_Teacher_LastName
|
|-
|
|Activity_Teacher_SSN
|
|}
|}
{| class="wikitable"
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>
|+Extra fields when extracting students with rowtype<br>Stamhold
EducationProgram
!Admin system
!Admin system
!UMS
!UMS
!Remarks
!Remarks
|-
|-
|EducationalProgrammes ID
|
|AktivitetsID
|
|
|
|-
|-
|EducationalProgrammes Designation
|
|Aktivitet
|
|
|
|-
|-
|EducationalProgrammes Designation
|
|ActivityDisplayName
|
|
|
|-
|-
|EducationalProgrammes Name
|
|ActivityDescription
|
|
|
|-
|-
|EducationalProgrammes Designation
|
|Kort_Betegnelse
|
|
|
|-
|-
|
|
|Aktivitet_LMS
|
|True
|
|-
|-
|EducationalProgrammes StartDate
|
|StartDato
|
|
|
|-
|-
|EducationalProgrammes EndDate
|
|SlutDato
|
|
|
|-
|-
|EducationalProgrammes StartDate
|
|Aktiviteter_StartDato
|
|
|
|-
|-
|EducationalProgrammes EndDate
|
|Aktiviteter_SlutDato
|
|
|
|}
|}
Line 263: Line 335:
!Remarks
!Remarks
|-
|-
|Institutions kode
|Cosa formaalskode
|School Code
|COSA_FORMAL
|
|
|
|
|-
|-
|Afdelings navn
|Studieforløb -> Uddannelsesstruktur -> Uddannelsesaktivitet -> Aktivitets gruppekode
|Education
|
|
|-
|Studieforløb -> Department
|Department
|Department
|
|
|
|
|-
|-
|Uddannelses kode
|Studieforløb -> Institution code
|CØSA Number
|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
|
|
|
|
|-
|-
|Uddannelsesforløbs kode
|Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling
|Educational program designation
|
|
|
|
|You can find this in the ImportFromDBesas_Afdeling table column esas_navn
|-
|-
|Ansvarsområde
|Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling code
|Responsibility area
|
|
|
|
|You can find this in the ImportFromDBesas_Afdeling table column esas_institutionsnummer
|}
|}

Revision as of 08:33, 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
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
Retrieved from "http://wiki.inlogic.dk/index.php?title=AdminServers/esas&oldid=3774"