AdminServers/Tabulex: Difference between revisions

Latest revision as of 10:32, 2 February 2022

This is the URL where UMS retrieves data from.

This identifies the school to extract data from.

This is an authentication key.

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)

Employees
Admin system	UMS	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

@@ Line 97: / Line 97: @@
 |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
+|-
+|
+|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
+|}
+{| class="wikitable"
+|+Extra fields when extracting employees with rowtype<br>EmployeeRole
+!Admin system
+!UMS
+!Remarks
 |-
-|AnsatTypeId
-|ExtraField1
 |
+|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
 |}
 {| class="wikitable"
@@ Line 249: / Line 297: @@
 |
 |-
-|Type ID
+|Roles
-|ExtraField1
+|Aktivitet
-|
 |
+|Rowtype = EmployeeRole
 |-
 |Hold
 |Aktivitet
 |
-|
+|Rowtype = Employee
 |}
 {| class="wikitable"