AdminServers/KMDStudica: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
← Older edit
VisualWikitext
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
No edit summary
 
(21 intermediate revisions by one other user not shown)
Line 16: Line 16:
|+
|+
Employees
Employees
!KMD Studica
!Admin system
!UMS
!UMS
!Remarks
!Remarks
Line 61: Line 61:
|-
|-
|PhoneNumber
|PhoneNumber
|WorkPhoneNumber
|
|-
|MobileNumber
|MobilePhone
|
|-
|MobileNumber
|WorkMobilePhone
|WorkMobilePhone
|
|
|-
|-
|PhoneNumber
|PrivatePhoneNumber
|MobilePhone
|PrivateMobilePhone
|
|
|-
|-
Line 122: Line 130:
|EmploymentStartDate
|EmploymentStartDate
|StartDato
|StartDato
|
|If department start date is after employment start date then department start date is used if not then employment start date is used
|-
|-
|EmploymentResignationDate
|EmploymentResignationDate
|SlutDato
|SlutDato
|
|If department end date is before employment resignation date then department end date is used if not then employment resignation date is used
|-
|-
|Department ValidFrom
|Department ValidFrom
Line 144: Line 152:
|
|
|-
|-
|AreasOfResponsibility Name
|AreasOfResponsibility.Name
|Employee_ResponsibilityArea
|Education_ResponsibilityAreaName
|Used by EducationalProgrammes
|-
|School code
|ExtraField1
|
|
|}
|}
Line 151: Line 163:
|+
|+
Students
Students
!KMD Studica
!Admin system
!UMS
!UMS
!Remarks
!Remarks
Line 218: Line 230:
|Department
|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
|EcucationCode
|
|-
|Student Studies DsDepartmentNumber
|Skolekode
|
|-
|Student Studies Type Name
|EducationStudentStudyType
|
|-
|Guardian information
|Guardian information
|This is copied to the guardian fields in UMS
|-
|EducationId
|Activity_EducationID
|From education on EducationalProgrammes
|-
|EducationCoesaNumber
|Activity_Education
|From education on EducationalProgrammes
|-
|EducationVersion
|Activity_EducationVersion
|From education on EducationalProgrammes
|-
|EducationName
|Activity_EducationDescription
|From education on EducationalProgrammes
|-
|Name
|Activity_EducationDescriptionShort
|From education on EducationalProgrammes
|-
|School code
|ExtraField1
|
|}
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>Student
!Admin system
!UMS
!Remarks
|-
|-
|SubjectCourse ID
|SubjectCourse ID
Line 243: Line 341:
|
|
|-
|-
|SubjectCourseStudentEnrollments StartDate
|Subject Course Enrollment StartDate
|StartDato
|StartDato
|
|
|-
|-
|SubjectCourseStudentEnrollments EndDate
|Subject Course Enrollment EndDate
|SlutDato
|SlutDato
|
|
Line 259: Line 357:
|
|
|-
|-
|SubjectCourseStudentEnrollmentsUVM ID
|UVM Course ID
|Course_ID
|Course_ID
|
|
|-
|-
|SubjectCourseStudentEnrollmentsUVM Subject
|UVM Course Subject
|Skolefag
|Skolefag
|
|
|-
|-
|SubjectCourseStudentEnrollmentsUVM Description
|UVM Course Description
|Skolefag_Betegnelse
|Skolefag_Betegnelse
|
|
|-
|-
|SubjectCourseStudentEnrollmentsUVM Level
|UVM Course Level
|CourseLevel
|CourseLevel
|
|If Level is a - then Null is written to UMS
|-
|-
|AddressLine
|Adresse
|
|
|SkoleFag_LMS
|Is set to true if there is a UVM course connected
|}
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>EducationProgram
!Admin system
!UMS
!Remarks
|-
|-
|PostalCode
|EducationalProgrammes ID
|PostNummer
|AktivitetsID
|
|
|-
|-
|Place
|EducationalProgrammes Designation
|Sted
|Aktivitet
|
|
|-
|-
|CareOfAddressLine
|EducationalProgrammes Designation
|COAddress
|ActivityDisplayName
|
|
|-
|-
|ProtectedNameAndAddress
|EducationalProgrammes Name
|SecretAddress
|ActivityDescription
|
|
|-
|-
|DepartmentEducation ID
|EducationalProgrammes Designation
|EducationDepartmentID
|Kort_Betegnelse
|
|
|-
|-
|DepartmentEducation Name
|EducationDepartmentname
|
|
|Aktivitet_LMS
|True
|-
|-
|Student Studies EducationId
|EducationalProgrammes StartDate
|EducationID
|StartDato
|
|
|-
|-
|Student Studies EducationName
|EducationalProgrammes EndDate
|Education
|SlutDato
|
|
|-
|-
|Student Studies EducationVersion
|EducationalProgrammes StartDate
|EducationVersion
|Aktiviteter_StartDato
|
|
|-
|-
|Student Studies Coesa
|EducationalProgrammes EndDate
|COSA_FORMAL
|Aktiviteter_SlutDato
|
|
|-
|}
|Student Studies DsDepartmentNumber
 
|Skolekode
===Template criteria mapping===
|
|-
|Guardian information
|Guardian information
|This is copied to the guardian fields in UMS
|}<br />
====Criteria mapping====
{| class="wikitable"
{| class="wikitable"
|+Employees
|+Employees
!UDDATA
!Admin system
!UMS
!UMS
!Picture from SIS
!Picture from admin system
!Remarks
!Remarks
|-
|-
|Institutions kode
|Institutions kode
|Institution number
|School Code
|
|
|
|
|-
|-
|Afdeling
|Afdelings navn
|Department
|Department
|
|
Line 352: Line 449:
{| class="wikitable"
{| class="wikitable"
|+Students
|+Students
!UDDATA
!Admin system
!UMS
!UMS
!Picture from SIS
!Picture from admin system
!Remarks
!Remarks
|-
|-
|Institutions kode
|Institutions kode
|Institution number
|SchoolCode
|
|
|-
|Cøsa (Uddannelses kode)
|Cosa Number
|
|
|
|
|-
|-
|Afdeling
|Afdelings navn
|Department
|Department
|
|
|
|
|-
|-
|Stamhold
|Uddannelses kode
|Homegroup
|COSA_FORMAL
|
|
|
|
|-
|-
|Aktivitets afdeling
|Uddannelsesforløbs kode
|Activity department
|ActivityDisplayName
|
|
|
|
|-
|-
|Aktivitets afdeling kort
|Ansvarsområde
|Activity department short
|Education_ResponsibilityAreaName
|
|
|
|
|-
|-
|Skole forløb
|Uddannelsesområde (udennalsesforløb)
|Skole forløb
|Activity_Education
|
|
|
|
|-
|-
|Skole periode
|Uddannelses navn
|Skole periode
|Education
|
|
|
|Student and Bridging student differs
|}
|}
==FAQ==
===What is needed for students to be extracted===
They need CPR number and an active Educational program
===What is needed for employees to be extracted===
They need CPR number

Latest revision as of 12:59, 24 September 2024

API Key

API key to access the webservice.

Client ID

Client ID to access the webservice.

Client secret

Client secret to access the webservice.

Export settings

Data mapping

Employees
Admin system UMS Remarks
Employee ID UMS_IDFromAdministrativeSystem
Employee ID IDFromAdministrativeSystem
GivenName Fornavn
Surname EFTERNAVN
Initials StudieNr
CivilRegistrationNumber CPR
AdUsername AlternativID
ProtectedGivenName PublicRegisteredFirstName
ProtectedSurname PublicRegisteredSurName
Email WorkMail
PhoneNumber WorkPhoneNumber
MobileNumber MobilePhone
MobileNumber WorkMobilePhone
PrivatePhoneNumber PrivateMobilePhone
JobTitle Employee_Description
Department ID DepartmentID
Department Name Department
AddressLine Adresse
PostalCode PostNummer
Place Sted
CareOfAddressLine COAddress
ProtectedNameAndAddress SecretAddress
Department ID AktivitetsID
Department Name Aktivitet
Department Name ActivityDisplayName
Department Name ActivityDescription
Department Name Kort_Betegnelse
EmploymentStartDate StartDato If department start date is after employment start date then department start date is used if not then employment start date is used
EmploymentResignationDate SlutDato If department end date is before employment resignation date then department end date is used if not then employment resignation date is used
Department ValidFrom Aktiviteter_StartDato
Department ValidTo Aktiviteter_SlutDato
EmploymentStartDate Employement_StartDate
EmploymentResignationDate Employement_EndDate
AreasOfResponsibility.Name Education_ResponsibilityAreaName Used by EducationalProgrammes
School code ExtraField1
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 EcucationCode
Student Studies DsDepartmentNumber Skolekode
Student Studies Type Name EducationStudentStudyType
Guardian information Guardian information This is copied to the guardian fields in UMS
EducationId Activity_EducationID From education on EducationalProgrammes
EducationCoesaNumber Activity_Education From education on EducationalProgrammes
EducationVersion Activity_EducationVersion From education on EducationalProgrammes
EducationName Activity_EducationDescription From education on EducationalProgrammes
Name Activity_EducationDescriptionShort From education on EducationalProgrammes
School code ExtraField1
Extra fields when extracting students with rowtype
Student
Admin system UMS Remarks
SubjectCourse ID AktivitetsID
SubjectCourse Designation Aktivitet
SubjectCourse Designation ActivityDisplayName
SubjectCourse Name ActivityDescription
SubjectCourse Designation Kort_Betegnelse
SubjectCourse LmsIndicator Aktivitet_LMS
Subject Course Enrollment StartDate StartDato
Subject Course Enrollment EndDate SlutDato
SubjectCourse StartDate Aktiviteter_StartDato
SubjectCourse EndDate Aktiviteter_SlutDato
UVM Course ID Course_ID
UVM Course Subject Skolefag
UVM Course Description Skolefag_Betegnelse
UVM Course Level CourseLevel If Level is a - then Null is written to UMS
SkoleFag_LMS Is set to true if there is a UVM course connected
Extra fields when extracting students with rowtype
EducationProgram
Admin system UMS 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

Template criteria mapping

Employees
Admin system UMS Picture from admin system Remarks
Institutions kode School Code
Afdelings navn Department
Ansvarsområde Responsibility area
Students
Admin system UMS Picture from admin system Remarks
Institutions kode SchoolCode
Afdelings navn Department
Uddannelses kode COSA_FORMAL
Uddannelsesforløbs kode ActivityDisplayName
Ansvarsområde Education_ResponsibilityAreaName
Uddannelsesområde (udennalsesforløb) Activity_Education
Uddannelses navn Education Student and Bridging student differs

FAQ

What is needed for students to be extracted

They need CPR number and an active Educational program

What is needed for employees to be extracted

They need CPR number

Retrieved from "http://wiki.inlogic.dk/index.php?title=AdminServers/KMDStudica&oldid=4927"