|
|
| Line 2: |
Line 2: |
|
| |
|
| ====Full path and name to database==== | | ====Full path and name to database==== |
| API key to access the webservice.
| | A file copy of the production database from ASV |
|
| |
|
| ====Path to java.exe==== | | ====Path to java.exe==== |
| Client ID to access the webservice.
| | <br /> |
|
| |
|
| ====Path to H2 bin folder==== | | ====Path to H2 bin folder==== |
| Client secret to access the webservice.
| | <br /> |
|
| |
|
| School year | | ==== School year ==== |
| | Specify the school year to extract data from. |
|
| |
|
| ===[[AdminServers/Export Settings|Export settings]]=== | | ===[[AdminServers/Export Settings|Export settings]]=== |
| Line 24: |
Line 25: |
| |Employee ID | | |Employee ID |
| |UMS_IDFromAdministrativeSystem | | |UMS_IDFromAdministrativeSystem |
| |
| |
| |-
| |
| |Employee ID
| |
| |IDFromAdministrativeSystem
| |
| |
| |
| |-
| |
| |GivenName
| |
| |Fornavn
| |
| |
| |
| |-
| |
| |Surname
| |
| |EFTERNAVN
| |
| |
| |
| |-
| |
| |Initials
| |
| |StudieNr
| |
| |
| |
| |-
| |
| |CivilRegistrationNumber
| |
| |CPR
| |
| |
| |
| |-
| |
| |AdUsername
| |
| |AlternativID
| |
| |
| |
| |-
| |
| |ProtectedGivenName
| |
| |PublicRegisteredFirstName
| |
| |
| |
| |-
| |
| |ProtectedSurname
| |
| |PublicRegisteredSurName
| |
| |
| |
| |-
| |
| |Email
| |
| |WorkMail
| |
| |
| |
| |-
| |
| |PhoneNumber
| |
| |WorkMobilePhone
| |
| |
| |
| |-
| |
| |PhoneNumber
| |
| |MobilePhone
| |
| |
| |
| |-
| |
| |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
| |
| |Employee_ResponsibilityArea
| |
| | | | | |
| |} | | |} |
| Line 160: |
Line 37: |
| |UMS_IDFromAdministrativeSystem | | |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
| |
| |
| |
| |-
| |
| |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
| |
| |-
| |
| |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
| |
| |} | | |} |
| ===Template criteria mapping=== | | ===Template criteria mapping=== |
| Line 343: |
Line 48: |
| |Institutions kode | | |Institutions kode |
| |School Code | | |School Code |
| |
| |
| |
| |
| |-
| |
| |Afdelings navn
| |
| |Department
| |
| |
| |
| |
| |
| |-
| |
| |Ansvarsområde
| |
| |Responsibility area
| |
| | | | | |
| | | | | |
| Line 365: |
Line 60: |
| |Institutions kode | | |Institutions kode |
| |School Code | | |School Code |
| |
| |
| |
| |
| |-
| |
| |Afdelings navn
| |
| |Department
| |
| |
| |
| |
| |
| |-
| |
| |Uddannelses kode
| |
| |CØSA Number
| |
| | | | | |
| | | | | |
| |} | | |} |
| | |
| | = FAQ = |
| | <br /> |
Full path and name to database
A file copy of the production database from ASV
Path to java.exe
Path to H2 bin folder
School year
Specify the school year to extract data from.
Data mapping
Employees
| Admin system
|
UMS
|
Remarks
|
| Employee ID
|
UMS_IDFromAdministrativeSystem
|
|
Students
| Admin system
|
UMS
|
Remarks
|
| Students ID
|
UMS_IDFromAdministrativeSystem
|
|
Template criteria mapping
Employees
| Admin system
|
UMS
|
Picture from admin system
|
Remarks
|
| Institutions kode
|
School Code
|
|
|
Students
| Admin system
|
UMS
|
Picture from admin system
|
Remarks
|
| Institutions kode
|
School Code
|
|
|
FAQ
