AdminServers/Tabulex: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
← Older edit
VisualWikitext
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
 
(6 intermediate revisions by the same user not shown)
Line 22: Line 22:
!Remarks
!Remarks
|-
|-
|Employee ID
|AnsatID
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|
|
|-
|-
|Employee ID
|Initialer
|IDFromAdministrativeSystem
|IDFromAdministrativeSystem
|
|
|-
|-
|GivenName
|Initialer
|Fornavn
|StudieNr
|
|
|-
|-
|Surname
|CPR
|EFTERNAVN
|CPR
|
|
|-
|-
|Initials
|ForNavn
|StudieNr
|
|
|
|-
|-
|CivilRegistrationNumber
|EFTERNAVN
|CPR
|
|
|
|-
|-
|AdUsername
|Privattlf
|AlternativID
|PhoneNumber
|
|
|-
|-
|ProtectedGivenName
|Mobiltlf
|PublicRegisteredFirstName
|MobilePhone
|
|
|-
|-
|ProtectedSurname
|SkoleID
|PublicRegisteredSurName
|ElevAfdelingsKode
|
|
|-
|-
|Email
|AnsatTypeBeskrivelse
|WorkMail
|Employee_Description
|
|
|-
|-
|PhoneNumber
|SkoleID
|WorkMobilePhone
|SkoleKode
|
|
|-
|-
|PhoneNumber
|Holdnavn
|MobilePhone
|Aktivitet
|
|
|-
|-
|JobTitle
|Holdnavn
|Employee_Description
|ActivityDisplayName
|
|
|-
|-
|Department ID
|Holdnavn
|DepartmentID
|Kort_Betegnelse
|
|
|-
|-
|Department Name
|Skolenavn
|Department
|AfdelingsNavn
|
|
|-
|-
|AddressLine
|Gade
|Adresse
|Adresse
|
|
|-
|-
|PostalCode
|Sted
|PostNummer
|
|-
|Place
|Sted
|Sted
|
|
|-
|-
|CareOfAddressLine
|PostNr
|COAddress
|PostNummer
|
|
|-
|-
|ProtectedNameAndAddress
|Holdnavn
|SecretAddress
|ActivityType
|
|If hold is not null then Activity is written to this field
|}
{| class="wikitable"
|+Extra fields when extracting employees with rowtype<br>Employee
!Admin system
!UMS
!Remarks
|-
|-
|Department ID
|AktivitetsID
|
|
|ActivityType
|is set to Activity
|-
|-
|Department Name
|Holdnavn
|Aktivitet
|Aktivitet
|
|
|-
|-
|Department Name
|Holdnavn
|ActivityDisplayName
|ActivityDisplayName
|
|
|-
|-
|Department Name
|Holdnavn
|ActivityDescription
|
|-
|Department Name
|Kort_Betegnelse
|Kort_Betegnelse
|
|
|-
|-
|EmploymentStartDate
|Skolenavn
|StartDato
|ActivityDescription
|If department start date is after employment start date then department start date is used if not then employment start date is used
|Is set to skolenavn if there are any students in with the same skolekode as the employee
|-
|}
|EmploymentResignationDate
{| class="wikitable"
|SlutDato
|+Extra fields when extracting employees with rowtype<br>EmployeeRole
|If department end date is before employment resignation date then department end date is used if not then employment resignation date is used
!Admin system
!UMS
!Remarks
|-
|-
|Department ValidFrom
|Aktiviteter_StartDato
|
|
|ActivityType
|is set to Role
|-
|-
|Department ValidTo
|RoleName
|Aktiviteter_SlutDato
|Aktivitet
|
|
|-
|-
|EmploymentStartDate
|RoleName
|Employement_StartDate
|ActivityDisplayName
|
|
|-
|-
|EmploymentResignationDate
|RoleName
|Employement_EndDate
|Kort_Betegnelse
|
|
|-
|-
|AreasOfResponsibility Name
|Skolenavn
|Employee_ResponsibilityArea
|ActivityDescription
|
|Is set to skolenavn if there are any students in with the same skolekode as the employee
|}
|}
{| class="wikitable"
{| class="wikitable"
Line 157: Line 157:
!Remarks
!Remarks
|-
|-
|Students ID
|Elevid
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|
|
|-
|-
|Students ID
|Elevid
|IDFromAdministrativeSystem
|IDFromAdministrativeSystem
|
|
|-
|-
|GivenName
|Elevid
|Fornavn
|StudieNr
|
|
|-
|-
|Surname
|CPR
|EFTERNAVN
|
|-
|CivilRegistrationNumber
|CPR
|CPR
|
|
|-
|-
|AdUsername
|ForNavn
|StudieNr
|
|
|-
|ProtectedGivenName
|PublicRegisteredFirstName
|
|
|-
|-
|ProtectedSurname
|EFTERNAVN
|PublicRegisteredSurName
|
|
|-
|Email
|PrivateMail
|
|
|-
|-
|Privattlf
|PhoneNumber
|PhoneNumber
|PrivateMobilePhone
|
|
|-
|-
|PhoneNumber
|Mobiltlf
|MobilePhone
|MobilePhone
|
|
|-
|-
|StudyStartDate
|SkoleKode
|StudyStart_Education
|ElevAfdelingsKode
|
|
|-
|-
|StudyEndDate
|Skolenavn
|StudyEnd_Education
|Afdelingsnavn
|
|
|-
|-
|StudyExpectedCompletionDate
|Klassetrin
|Expected_EducationEndDate
|Klassetrin
|
|
|-
|-
|Department ID
|Klassespor
|DepartmentID
|Klassespor
|
|
|-
|-
|Department Name
|Klassebetegnelse
|Department
|Klassebetegnelse
|
|
|-
|-
|SubjectCourse ID
|Klassebetegnelse
|AktivitetsID
|HomeGroupName
|
|
|-
|-
|SubjectCourse Designation
|Skolekode
|Skolekode
|
|-
|Holdnavn
|Aktivitet
|Aktivitet
|
|
|-
|-
|SubjectCourse Designation
|Holdnavn
|ActivityDisplayName
|ActivityDisplayName
|
|
|-
|-
|SubjectCourse Name
|Holdnavn
|ActivityDescription
|
|-
|SubjectCourse Designation
|Kort_Betegnelse
|Kort_Betegnelse
|
|
|-
|-
|SubjectCourse LmsIndicator
|Gade
|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
|Adresse
|
|
|-
|-
|PostalCode
|Sted
|PostNummer
|
|-
|Place
|Sted
|Sted
|
|
|-
|-
|CareOfAddressLine
|PostNr
|COAddress
|PostNummer
|
|
|-
|-
|ProtectedNameAndAddress
|SecretAddress
|
|
|ActivityType
|Depends on RowType
Default = Activity
StartYearAndClassTrack = Class
KlasseBetegnelse = Class
StartYear Alle Elever = Class
|-
|-
|DepartmentEducation ID
|EducationDepartmentID
|
|
|EnrollmentYear
|Is calculated from the fileyear written in first line of the students file
FileYear - Klassetrin
|-
|-
|DepartmentEducation Name
|EducationDepartmentname
|
|
|StartDato
|01-07-<FileYear>
|-
|-
|Student Studies EducationId
|EducationID
|
|
|SlutDato
|30-06-(<FileYear> + 1)
|-
|-
|Student Studies EducationName
|Education
|
|
|Aktiviteter_StartDato
|01-07-<FileYear>
|-
|-
|Student Studies EducationVersion
|EducationVersion
|
|
|-
|Aktiviteter_SlutDato
|Student Studies Coesa
|30-06-(<FileYear> + 1)
|COSA_FORMAL
|
|-
|Student Studies DsDepartmentNumber
|Skolekode
|
|-
|Guardian information
|Guardian information
|This is copied to the guardian fields in UMS
|}
|}


Line 357: Line 297:
|
|
|-
|-
|Type ID
|Roles
|ExtraField1
|Aktivitet
|
|
|
|Rowtype = EmployeeRole
|-
|-
|Hold
|Hold
|Aktivitet
|Aktivitet
|
|
|
|Rowtype = Employee
|}
|}
{| class="wikitable"
{| class="wikitable"

Latest revision as of 10:32, 2 February 2022

CSV fields definition

Tabulex


URL

This is the URL where UMS retrieves data from.

School number

This identifies the school to extract data from.

Key

This is an authentication key.

Export settings

Data mapping

Employees
Admin system UMS Remarks
AnsatID UMS_IDFromAdministrativeSystem
Initialer IDFromAdministrativeSystem
Initialer StudieNr
CPR CPR
ForNavn
EFTERNAVN
Privattlf PhoneNumber
Mobiltlf MobilePhone
SkoleID ElevAfdelingsKode
AnsatTypeBeskrivelse Employee_Description
SkoleID SkoleKode
Holdnavn Aktivitet
Holdnavn ActivityDisplayName
Holdnavn Kort_Betegnelse
Skolenavn AfdelingsNavn
Gade Adresse
Sted Sted
PostNr PostNummer
Holdnavn ActivityType If hold is not null then Activity is written to this field
Extra fields when extracting employees with rowtype
Employee
Admin system UMS Remarks
ActivityType is set to Activity
Holdnavn Aktivitet
Holdnavn ActivityDisplayName
Holdnavn Kort_Betegnelse
Skolenavn ActivityDescription Is set to skolenavn if there are any students in with the same skolekode as the employee
Extra fields when extracting employees with rowtype
EmployeeRole
Admin system UMS Remarks
ActivityType is set to Role
RoleName Aktivitet
RoleName ActivityDisplayName
RoleName Kort_Betegnelse
Skolenavn ActivityDescription Is set to skolenavn if there are any students in with the same skolekode as the employee
Students
Admin system UMS Remarks
Elevid UMS_IDFromAdministrativeSystem
Elevid IDFromAdministrativeSystem
Elevid StudieNr
CPR CPR
ForNavn
EFTERNAVN
Privattlf PhoneNumber
Mobiltlf MobilePhone
SkoleKode ElevAfdelingsKode
Skolenavn Afdelingsnavn
Klassetrin Klassetrin
Klassespor Klassespor
Klassebetegnelse Klassebetegnelse
Klassebetegnelse HomeGroupName
Skolekode Skolekode
Holdnavn Aktivitet
Holdnavn ActivityDisplayName
Holdnavn Kort_Betegnelse
Gade Adresse
Sted Sted
PostNr PostNummer
ActivityType Depends on RowType

Default = Activity

StartYearAndClassTrack = Class

KlasseBetegnelse = Class

StartYear Alle Elever = Class

EnrollmentYear Is calculated from the fileyear written in first line of the students file

FileYear - Klassetrin

StartDato 01-07-<FileYear>
SlutDato 30-06-(<FileYear> + 1)
Aktiviteter_StartDato 01-07-<FileYear>
Aktiviteter_SlutDato 30-06-(<FileYear> + 1)

Template criteria mapping

Employees
Admin system UMS Picture from admin system Remarks
Skole kode ElevAfdelingsKode
Skole kode SkoleKode
Type beskrivelse Employee_Description
Roles Aktivitet Rowtype = EmployeeRole
Hold Aktivitet Rowtype = Employee
Students
Admin system UMS Picture from admin system Remarks
Skole kode ElevAfdelingsKode
Skole kode Skolekode
Klassetrin Klassetrin
Klassespor Klassespor
Klassebetegnelse Klassebetegnelse
Klassebetegnelse HomeGroupName
Hold Aktivitet
Retrieved from "http://wiki.inlogic.dk/index.php?title=AdminServers/Tabulex&oldid=4260"