Jump to content

AdminServers/Lectio: Difference between revisions

From UmsWiki
← Older editNewer edit →
VisualWikitext
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
Line 21: Line 21:
!Remarks
!Remarks
|-
|-
|ASV.SVP_LEHRER_STAMM.ID
|TeacherInfo_Initials
|IDFromAdministrativeSystem
|IDFromAdministrativeSystem
|
|
|-
|-
|'E' + ASV.SVP_LEHRER_STAMM.ID
|TeacherInfo_TeacherID
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|Prefixed with increase identifier + '_' if used
|Prefixed with increase identifier + '_' if used
|-
|-
|ASV.SVP_LEHRER_SCHULJAHR_SCHULE.NAMENSKUERZEL
|TeacherInfo_Initials
|StudieNr
|StudieNr
|
|
|-
|-
|'E' + ASV.SVP_LEHRER_STAMM.ID
|TeacherInfo_CprNo
|CPR
|CPR
|Prefixed with increase identifier + '_' if used
|Prefixed with increase identifier + '_' if used
|-
|-
|ASV.SVP_LEHRER_STAMM.GEBURTSDATUM
|TeacherInfo_CprNo
|BirthDay
|BirthDay
|
|First 6 numbers
|-
|-
|ASV.SVP_LEHRER_STAMM.RUFNAME
|TeacherInfo_FirstName
|Fornavne
|Fornavne
|
|
|-
|-
|ASV.SVP_LEHRER_STAMM.FAMILIENNAME
|TeacherInfo_LastName
|Efternavn
|Efternavn
|
|
|-
|-
|ASV.SVP_LEHRER_STAMM.VORNAMEN
|Telefon1
|PublicRegisteredFirstName
|PhoneNumber
|
|
|-
|-
|ASV.SVP_LEHRER_STAMM.FAMILIENNAME
|Telefon2
|PublicRegisteredSurName
|WorkPhoneNumber
|
|
|-
|-
|ASV.SVP_LEHRER_STAMM.WL_GESCHLECHT_ID
|TeacherInfo_AddrStreetName
|Gender
|Adresse
|1099_1 = Male else female
|-
|ASV.SVP_SCHULE_STAMM.SCHULNUMMER
|Skolekode
|
|
|-
|-
|ASV.SVP_LEHRER_STAMM.DIENSTVERHAELTNIS_VON
|TeacherInfo_AddrAreaName
|StartDato
|Sted
|
|
|-
|-
|ASV.SVP_LEHRER_STAMM.DIENSTVERHAELTNIS_BIS
|TeacherInfo_AddrZipCode
|SlutDato
|PostNummer
|
|
|-
|-
|ASV.SVP_LEHRER_STAMM.DIENSTVERHAELTNIS_VON
|TeacherInfo_AddrZipCodeArea
|Employement_StartDate
|City
|
|
|-
|-
|ASV.SVP_LEHRER_STAMM.DIENSTVERHAELTNIS_BIS
|TeacherInfo_AddrCoName
|Employement_EndDate
|COAddress
|
|
|-
|-
|ASV.SVP_WL_AMTSBEZEICHNUNG.LANGFORM
|Employee_Description
|
|
|MobilePhone
|Telefon1 or Telefon2 depends on what has been set in configurator
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|TeacherInfo_EmailAddress
|PrivateMail
|PrivateMail
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|TeacherInfo_Note1
|PhoneNumber
|Employee_Note
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|PrivateMobilePhone
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|MobilePhone
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|-
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|TeacherInfo_Note2
|Adresse
|Employee_Note2
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|TeacherInfo_Note3
|postnummer
|Employee_Note3
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|TeacherInfo_Afdeling
|City
|DepartmentCode
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.ORTSTEIL
|TeacherInfo_Afdeling
|Sted
|Department
|
|
|}
|}
Line 124: Line 112:
!Remarks
!Remarks
|-
|-
|ASV.SVP_SCHUELER_STAMM.ID
|StudentInfo_Logon
|IDFromAdministrativeSystem
|IDFromAdministrativeSystem
|
|
|-
|-
|'S' + ASV.SVP_SCHUELER_STAMM.ID
|StudentInfo_ElevId
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|Prefixed with increase identifier + '_' if used
|Prefixed with increase identifier + '_' if used
|-
|-
|ASV.SVP_SCHUELER_STAMM.ID
|
|StudieNr
|StudieNr
|
|PNr or Brugernavn depends on what has been set in configurator
|-
|-
|'S' + ASV.SVP_SCHUELER_STAMM.ID
|StudentInfo_StudentCpr
|CPR
|CPR
|Prefixed with increase identifier + '_' if used
|Prefixed with increase identifier + '_' if used
|-
|-
|ASV.SVP_SCHUELER_STAMM.GEBURTSDATUM
|
|BirthDay
|BirthDay
|
|First 6 numbers
|-
|-
|ASV.SVP_SCHUELER_STAMM.RUFNAME
|StudentInfo_FirstName
|Fornavne
|Fornavne
|
|
|-
|-
|ASV.SVP_SCHUELER_STAMM.FAMILIENNAME
|StudentInfo_LastName
|Efternavn
|Efternavn
|
|
|-
|-
|ASV.SVP_SCHUELER_STAMM.VORNAMEN
|StudentInfo_ElevId
|AlternateAdminSystem_ID
|
|-
|StudentInfo_RealFirstName
|PublicRegisteredFirstName
|PublicRegisteredFirstName
|
|
|-
|-
|ASV.SVP_SCHUELER_STAMM.FAMILIENNAME
|StudentInfo_RealLastName
|PublicRegisteredSurName
|PublicRegisteredSurName
|
|
|-
|-
|ASV.SVP_SCHUELER_STAMM.WL_GESCHLECHT_ID
|Gender
|1099_1 = Male else female
|-
|ASV.SVP_SCHULE_STAMM.SCHULNUMMER
|Skolekode
|
|
|PhoneNumber
|StudentInfo_PhoneNo or StudentInfo_PhoneNo2 depends on what has been set in configurator
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|StudentInfo_Email
|PrivateMail
|PrivateMail
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|PhoneNumber
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|PrivateMobilePhone
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|MobilePhone
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|Adresse
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|StudentInfo_CprRegisterNavnebeskyttelse
|postnummer
|SecretAddress
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|City
|
|
|-
|ASV.SVP_ANSCHRIFT.ORTSTEIL
|Sted
|
|
|-
|ASV.SVP_SCHUELER_STAMM.SCHUELERNUMMER
|AlternativID
|
|
|-
|-
|ASV.SVP_WL_JAHRGANGSSTUFE.KURZFORM
|YearLevel
|
|
|-
|ASV.SVP_KLASSENGRUPPE.ID
|AktivitetsID
|
|
|-
|ASV.SVP_KLASSE.KLASSENNAME
|Aktivitet
|Adds '_' + ASV.SVP_KLASSENGRUPPE.KENNUNG if it's not 1
|-
|ASV.SVP_KLASSE.KLASSENNAME
|ActivityDisplayName
|Adds '_' + ASV.SVP_KLASSENGRUPPE.KENNUNG if it's not 1
|-
|ASV.SVP_KLASSE.KLASSENNAME_LANG
|ActivityDescription
|
|
|-
|-
|ASV.SVP_WL_SCHULJAHR.BEGINN
|Aktiviteter_StartDato
|
|
|-
|ASV.SVP_WL_SCHULJAHR.Ende
|Aktiviteter_SlutDato
|
|
|-
|ASV.SVP_KOPPEL.ID
|ExtraField1
|
|
|-
|-
|ASV.SVP_WL_SCHULJAHR.BEGINN
|StartDato
|Uses ASV.SVP_SCHUELER_STAMM.EINTRITTSDATUM if this is after ASV.SVP_WL_SCHULJAHR.BEGINN
|-
|ASV.SVP_WL_SCHULJAHR.Ende
|SlutDato
|Uses ASV.SVP_SCHUELER_STAMM.AUSTRITTSDATUM if it is before ASV.SVP_WL_SCHULJAHR.Ende
|-
|ASV.SVP_SCHUELERFACH.ID
|Course_ID
|
|
|-
|ASV.SVP_SCHUELERFACH.Kurzform
|SkoleFag
|Adds '_' + ASV.SVP_FACHGRUPPE.Nummer if it's not 1
|-
|IsNull(ASV.SVP_SCHUELERFACH.LANGFORM, ASV.SVP_SCHUELERFACH.ANZEIGEFORM)
|SkoleFag_betegnelse
|
|
|-
|ASV.SVP_SCHUELERFACH.Kurzform
|SkoleFag_Kort_Betegnelse
|Adds '_' + ASV.SVP_FACHGRUPPE.Nummer if it's not 1
|-
|'E' + ASV.SVP_LEHRER_STAMM.ID
|Activity_Teacher_SSN
|
|
|-
|-
|ASV.SVP_LEHRER_STAMM.VORNAMEN
|Activity_Teacher_FirstName
|
|
|-
|ASV.SVP_LEHRER_STAMM.FAMILIENNAME
|Activity_Teacher_LastName
|
|
|-
|ASV.SVP_PERSON.ID
|Guardian1SSN
|AUSKUNFTSBERECHTIGT = 1 And REITER_NR = 1
|-
|ASV.SVP_PERSON.VORNAMEN
|Guardian1Name
|
|
|-
|-
|ASV.SVP_PERSON.FAMILIENNAME
|Guardian1SurName
|
|
|-
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|Guardian1Address
|
|
|-
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|Guardian1City
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|Guardian1PostalCode
|
|
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Guardian1PhoneNumber
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Guardian1Mail
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Guardian1MobilePhoneNumber
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|ASV.SVP_PERSON.ID
|Guardian2SSN
|AUSKUNFTSBERECHTIGT = 1 And REITER_NR = 12
|-
|ASV.SVP_PERSON.VORNAMEN
|Guardian2Name
|
|
|-
|ASV.SVP_PERSON.FAMILIENNAME
|Guardian2SurName
|
|-
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|Guardian2Address
|
|-
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|Guardian2City
|
|-
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|Guardian2PostalCode
|
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Guardian2PhoneNumber
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Guardian2Mail
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Guardian2MobilePhoneNumber
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|}
{| class="wikitable"
|+
Parents
!Admin system
!UMS
!Remarks
|-
|ASV.SVP_PERSON.ID
|IDFromAdministrativeSystem
|
|-
|'P' + ASV.SVP_PERSON.ID
|UMS_IDFromAdministrativeSystem
|Prefixed with increase identifier + '_' if used
|-
|ASV.SVP_PERSON.ID
|StudieNr
|
|-
|'P' + ASV.SVP_PERSON.ID
|CPR
|Prefixed with increase identifier + '_' if used
|-
|ASV.SVP_PERSON.GEBURTSDATUM
|BirthDay
|
|-
|ASV.SVP_PERSON.VORNAMEN
|Fornavne
|
|-
|ASV.SVP_PERSON.FAMILIENNAME
|Efternavn
|
|-
|ASV.SVP_PERSON.VORNAMEN
|PublicRegisteredFirstName
|
|-
|ASV.SVP_PERSON.FAMILIENNAME
|PublicRegisteredSurName
|
|-
|ASV.SVP_PERSON.WL_GESCHLECHT_ID
|Gender
|1099_1 = Male else female
|-
|ASV.SVP_SCHULE_STAMM.SCHULNUMMER
|Skolekode
|
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|PrivateMail
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|PhoneNumber
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|PrivateMobilePhone
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|MobilePhone
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|Adresse
|
|-
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|postnummer
|
|-
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|City
|
|-
|ASV.SVP_ANSCHRIFT.ORTSTEIL
|Sted
|
|
|}
|}
===Template criteria mapping===
===Template criteria mapping===
{| class="wikitable"
{| class="wikitable"

Revision as of 13:30, 17 January 2022


Institution number

Enter the institution number (STIL) of your SIS database

Username

Lectio Username to access Lectio.

Password

Lectio Password to access Lectio.

Export settings

Data mapping

Employees
Admin system UMS Remarks
TeacherInfo_Initials IDFromAdministrativeSystem
TeacherInfo_TeacherID UMS_IDFromAdministrativeSystem Prefixed with increase identifier + '_' if used
TeacherInfo_Initials StudieNr
TeacherInfo_CprNo CPR Prefixed with increase identifier + '_' if used
TeacherInfo_CprNo BirthDay First 6 numbers
TeacherInfo_FirstName Fornavne
TeacherInfo_LastName Efternavn
Telefon1 PhoneNumber
Telefon2 WorkPhoneNumber
TeacherInfo_AddrStreetName Adresse
TeacherInfo_AddrAreaName Sted
TeacherInfo_AddrZipCode PostNummer
TeacherInfo_AddrZipCodeArea City
TeacherInfo_AddrCoName COAddress
MobilePhone Telefon1 or Telefon2 depends on what has been set in configurator
TeacherInfo_EmailAddress PrivateMail
TeacherInfo_Note1 Employee_Note
TeacherInfo_Note2 Employee_Note2
TeacherInfo_Note3 Employee_Note3
TeacherInfo_Afdeling DepartmentCode
TeacherInfo_Afdeling Department
Students
Admin system UMS Remarks
StudentInfo_Logon IDFromAdministrativeSystem
StudentInfo_ElevId UMS_IDFromAdministrativeSystem Prefixed with increase identifier + '_' if used
StudieNr PNr or Brugernavn depends on what has been set in configurator
StudentInfo_StudentCpr CPR Prefixed with increase identifier + '_' if used
BirthDay First 6 numbers
StudentInfo_FirstName Fornavne
StudentInfo_LastName Efternavn
StudentInfo_ElevId AlternateAdminSystem_ID
StudentInfo_RealFirstName PublicRegisteredFirstName
StudentInfo_RealLastName PublicRegisteredSurName
PhoneNumber StudentInfo_PhoneNo or StudentInfo_PhoneNo2 depends on what has been set in configurator
StudentInfo_Email PrivateMail
StudentInfo_CprRegisterNavnebeskyttelse SecretAddress

Template criteria mapping

Employees
Admin system UMS Picture from admin system Remarks
Note 1 Employee_Note
Note 2 Employee_Note2
Note 3 Employee_Note3
Afdeling DepartmentCode
Afdeling Department
Students
Admin system UMS Picture from admin system Remarks
Stamklasse The homegroup calculated by UMS will be placed in Klassebetegnelse
Elevtype ElevAfdelingsKode
Årgang YearLevel UMS will add 11 to the number from Lectio if this number is between 1 and 4 otherwise UMS will set this to 16
Elevforløb ActivityDepartmentName
Elevforløb Skoleforlob
Elevforløb AfdelingsNavn Will only be placed in here if actual department from lectio is null
Afdeling AfdelingsNavn Will only be placed in here if actual department from lectio is not null
Uddannelsesgruppe Education
Uddannelse COSA_FORMAL
Retrieved from "https://wiki.inlogic.dk/index.php?title=AdminServers/Lectio&oldid=4213"