Jump to content

AdminServers/Lectio: Difference between revisions

From UmsWiki
← Older edit
VisualWikitext
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
 
(14 intermediate revisions by one other user not shown)
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
|
|
|}
|}
{| class="wikitable"
{| class="wikitable"
|+
|+
Students
Students<br>Used by all rowtypes
!Admin system
!Admin system
!UMS
!UMS
!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
|PhoneNumber
|1099_1 = Male else female
|StudentInfo_PhoneNo or StudentInfo_PhoneNo2 depends on what has been set in configurator
|-
|StudentInfo_Email
|PrivateMail
|
|-
|StudentInfo_CprRegisterNavnebeskyttelse
|SecretAddress
|
|-
|StudentInfo_AddrStreetName
|Adresse
|
|-
|StudentInfo_AddrAreaName
|Sted
|
|-
|StudentInfo_AddrZipcode
|PostNummer
|
|-
|StudentInfo_AddrBy
|City
|
|-
|StudentInfo_AddCoName
|COAddress
|
|-
|
|Klassebetegnelse
|Calculated by UMS from these fields
 
StudentInfo_Stamclass and StudentInfo_StamclassNameAktuel
|-
|StudentInfo_Aargang
|Klassetrin
|
|-
|StudentInfo_StudentForloeb
|ActivityDepartmentName
|
|-
|StudentInfo_StudentForloeb
|Skoleforlob
|
|-
|StudentInfo_StudentType
|ElevAfdelingsKode
|
|-
|-
|ASV.SVP_SCHULE_STAMM.SCHULNUMMER
|Skolekode
|
|
|YearLevel
|StudentInfo_Aargang + 11
If blank then 16
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|
|PrivateMail
|HomeGroupName
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|Calculated by UMS based on
 
StudentInfo_Aargang, StudentInfo_Stamclass, StudentInfo_StamclassNameAktuel and StudentInfo_StamclassTermName
|-
|Guard1Cpr
|Guardian1SSN
|
|-
|Guard1Name
|Guardian1Name
|Text before last space
|-
|Guard1Name
|Guardian1SurName
|Text after last space
|-
|Guard1Phone
|Guardian1PhoneNumber
|
|-
|Guard1Address
|Guardian1Address
|
|-
|Guard1Email
|Guardian1Mail
|
|-
|Guard1Phone2
|Guardian1MobilePhoneNumber
|
|-
|Guard2Cpr
|Guardian2SSN
|
|-
|Guard2Name
|Guardian2Name
|Text before last space
|-
|Guard2Name
|Guardian2SurName
|Text after last space
|-
|Guard2Phone
|Guardian2PhoneNumber
|
|-
|Guard2Address
|Guardian2Address
|
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Guard2Email
|PhoneNumber
|Guardian2Mail
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Guard2Phone2
|PrivateMobilePhone
|Guardian2MobilePhoneNumber
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|
|MobilePhone
|MobilePhone
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|Telefon1 or Telefon2 depends on what has been set in configurator
|-
|-
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|StudentInfo_StartDate
|Adresse
|EnrollmentDate
|
|-
|StudentInfo_EndDate
|AFGANGSDATO
|
|-
|StudentInfo_PNr
|AlternativID
|
|-
|StudentInfo_AfdelingStudentAktuel
|AfdelingsNavn
|IF empty use StudentInfo_StudentForloeb
|-
|StudentInfo_Uddannelsesgruppe
|Education
|
|-
|StudentInfo_XprsUddannelseAktuel
|COSA_FORMAL
|
|-
|StudentInfo_StudyCardId
|CardID
|
|-
|StudentInfo_AfdelingNrStudent
|SkoleKode
|
|-
|StudentInfo_StudieRetningName
|Betegnelse
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|StudentInfo_StudieRetningName
|postnummer
|EducationDescription
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|StudentInfo_ElevId
|City
|ExtraField1
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.ORTSTEIL
|StudentInfo_StartDate
|Sted
|ELEV_I_SKOLEFORLOB_StartDato
|IF empty use StudentInfo_StartDateCalc
|-
|StudentInfo_EndDate
|ELEV_I_SKOLEFORLOB_SlutDato
|IF empty use StudentInfo_EndDateCalc
|-
|
|
|SchoolCommunityHome
|True if current date is within BookingInfo_PeriodeStart and BookingInfo_PeriodeEnd
|-
|-
|ASV.SVP_SCHUELER_STAMM.SCHUELERNUMMER
|PladsInfo_SkhAfdelingName
|AlternativID
|SchoolCommunityHomeDepartment
|Based on currently active pladsinfo within BookingInfo_PeriodeStart and BookingInfo_PeriodeEnd
|-
|PladsInfo_VaerelseKode
|SchoolCommunityHomeRoomNumber
|Based on currently active pladsinfo within BookingInfo_PeriodeStart and BookingInfo_PeriodeEnd
|-
|BookingInfo_PeriodeStart
|SchoolCommunityHomeStartDate
|
|
|-
|-
|ASV.SVP_WL_JAHRGANGSSTUFE.KURZFORM
|BookingInfo_PeriodeEnd
|YearLevel
|SchoolCommunityHomeEndDate
|
|
|}
{| class="wikitable"
|+
Students<br>Rowtype = LectioCourses
!Admin system
!UMS
!Remarks
|-
|-
|ASV.SVP_KLASSENGRUPPE.ID
|Holdtilknytninger.Startdate
|AktivitetsID
|STARTDATO
|
|
|-
|-
|ASV.SVP_KLASSE.KLASSENNAME
|Holdtilknytninger.Enddate
|SLUTDATO
|Use StudentInfo_EndDateCalc if lower
|-
|Holdtilknytninger.Startdate
|Aktiviteter_STARTDATO
|First startdate
|-
|Holdtilknytninger.Enddate
|Aktiviteter_SlutDato
|Last Enddate
|-
|HoldelementInfo_HeNavn
|Aktivitet
|Aktivitet
|Adds '_' + ASV.SVP_KLASSENGRUPPE.KENNUNG if it's not 1
|
|-
|-
|ASV.SVP_KLASSE.KLASSENNAME
|HoldelementInfo_HeNavn
|ActivityDisplayName
|ActivityDisplayName
|Adds '_' + ASV.SVP_KLASSENGRUPPE.KENNUNG if it's not 1
|
|-
|-
|ASV.SVP_KLASSE.KLASSENNAME_LANG
|HoldInfo_HoldBetegnelse
|ActivityDescription
|ActivityDescription
|If empty use HoldInfo_HoldFag
|-
|HoldInfo_HoldKortBetegnelse
|Kort_Betegnelse
|If empty use HoldelementInfo_HeNavn
|-
|HoldInfo_HoldId
|AktivitetsID
|
|-
|False
|Activity_AsExternalGroup
|
|-
|False
|Aktivitet_LMS
|
|
|-
|-
|ASV.SVP_WL_SCHULJAHR.BEGINN
|False
|Aktiviteter_StartDato
|Activity_LMS_AllowRoll
|
|
|-
|-
|ASV.SVP_WL_SCHULJAHR.Ende
|False
|Skolefag_LMS
|
|-
|False
|Course_LMS_AllowRoll
|
|-
|TeacherInfo_FirstName
|Activity_Teacher_FirstName
|
|-
|TeacherInfo_LastName
|Activity_Teacher_LastName
|
|-
|TeacherInfo_CprNo
|Activity_Teacher_SSN
|
|-
|TeacherInfo_Initials
|Activity_Teacher_Initials
|
|-
|HoldInfo_XprsFagNummer
|Course_ID
|
|-
|HoldInfo_HoldNiveau
|CourseLevel
|
|-
|HoldInfo_HoldFag
|Skolefag
|
|-
|HoldInfo_HoldFag
|Skolefag_Betegnelse
|
|-
|HoldInfo_HoldKortBetegnelse
|Skolefag_Kort_Betegnelse
|
|-
|HoldelementInfo_HeElementkode
|ExtraField2
|
|}
{| class="wikitable"
|+
Students<br>Rowtype = LectioCoursesLMS
!Admin system
!UMS
!Remarks
|-
|Holdtilknytninger.Startdate
|STARTDATO
|
|-
|Holdtilknytninger.Enddate
|SLUTDATO
|Use StudentInfo_EndDateCalc if lower
|-
|Holdtilknytninger.Startdate
|Aktiviteter_STARTDATO
|First startdate
|-
|Holdtilknytninger.Enddate
|Aktiviteter_SlutDato
|Aktiviteter_SlutDato
|Last Enddate
|-
|HoldInfo_HoldName
|Aktivitet
|
|
|-
|-
|ASV.SVP_KOPPEL.ID
|HoldelementInfo_HeNavn
|ExtraField1
|ActivityDisplayName
|
|
|-
|-
|ASV.SVP_WL_SCHULJAHR.BEGINN
|HoldInfo_HoldBetegnelse
|StartDato
|ActivityDescription
|Uses ASV.SVP_SCHUELER_STAMM.EINTRITTSDATUM if this is after ASV.SVP_WL_SCHULJAHR.BEGINN
|If empty use HoldInfo_HoldFag
|-
|HoldInfo_HoldKortBetegnelse
|Kort_Betegnelse
|If empty use HoldelementInfo_HeNavn
|-
|-
|ASV.SVP_WL_SCHULJAHR.Ende
|HoldInfo_HoldId
|SlutDato
|AktivitetsID
|Uses ASV.SVP_SCHUELER_STAMM.AUSTRITTSDATUM if it is before ASV.SVP_WL_SCHULJAHR.Ende
|
|-
|-
|ASV.SVP_SCHUELERFACH.ID
|True
|Course_ID
|Activity_AsExternalGroup
|
|
|-
|-
|ASV.SVP_SCHUELERFACH.Kurzform
|True
|SkoleFag
|Aktivitet_LMS
|Adds '_' + ASV.SVP_FACHGRUPPE.Nummer if it's not 1
|False if StudentInfo_StudentForloeb = 'Inaktivt'
|-
|-
|IsNull(ASV.SVP_SCHUELERFACH.LANGFORM, ASV.SVP_SCHUELERFACH.ANZEIGEFORM)
|False
|SkoleFag_betegnelse
|Activity_LMS_AllowRoll
|
|
|-
|-
|ASV.SVP_SCHUELERFACH.Kurzform
|False
|SkoleFag_Kort_Betegnelse
|Skolefag_LMS
|Adds '_' + ASV.SVP_FACHGRUPPE.Nummer if it's not 1
|
|-
|-
|'E' + ASV.SVP_LEHRER_STAMM.ID
|False
|Activity_Teacher_SSN
|Course_LMS_AllowRoll
|
|
|-
|-
|ASV.SVP_LEHRER_STAMM.VORNAMEN
|TeacherInfo_FirstName
|Activity_Teacher_FirstName
|Activity_Teacher_FirstName
|
|
|-
|-
|ASV.SVP_LEHRER_STAMM.FAMILIENNAME
|TeacherInfo_LastName
|Activity_Teacher_LastName
|Activity_Teacher_LastName
|
|
|-
|-
|ASV.SVP_PERSON.ID
|TeacherInfo_CprNo
|Guardian1SSN
|Activity_Teacher_SSN
|AUSKUNFTSBERECHTIGT = 1 And REITER_NR = 1
|
|-
|TeacherInfo_Initials
|Activity_Teacher_Initials
|
|-
|HoldInfo_XprsFagNummer
|Course_ID
|
|-
|HoldInfo_HoldNiveau
|CourseLevel
|
|-
|HoldInfo_HoldFag
|Skolefag
|
|-
|HoldInfo_HoldFag
|Skolefag_Betegnelse
|
|-
|HoldInfo_HoldKortBetegnelse
|Skolefag_Kort_Betegnelse
|
|-
|-
|ASV.SVP_PERSON.VORNAMEN
|HoldelementInfo_HeElementkode
|Guardian1Name
|ExtraField2
|
|
|}
{| class="wikitable"
|+
Students<br>Rowtype = LectioStamKlasser
!Admin system
!UMS
!Remarks
|-
|StartDato
|STARTDATO
|Use StudentInfo_StartDate if higher
|-
|-
|ASV.SVP_PERSON.FAMILIENNAME
|SlutDato
|Guardian1SurName
|SLUTDATO
|Use StudentInfo_EndDateCalc if lower
|-
|StartDato
|Aktiviteter_STARTDATO
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|SlutDato
|Guardian1Address
|Aktiviteter_SlutDato
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|Stamklasse
|Guardian1City
|Aktivitet
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|Stamklasse
|Guardian1PostalCode
|ActivityDisplayName
|
|
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Stamklasse
|Guardian1PhoneNumber
|ActivityDescription
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Stamklasse
|Guardian1Mail
|Kort_Betegnelse
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|GroupId
|Guardian1MobilePhoneNumber
|AktivitetsID
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|
|-
|-
|ASV.SVP_PERSON.ID
|True
|Guardian2SSN
|Activity_AsExternalGroup
|AUSKUNFTSBERECHTIGT = 1 And REITER_NR = 12
|
|-
|-
|ASV.SVP_PERSON.VORNAMEN
|False
|Guardian2Name
|Aktivitet_LMS
|
|
|-
|-
|ASV.SVP_PERSON.FAMILIENNAME
|False
|Guardian2SurName
|Activity_LMS_AllowRoll
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|False
|Guardian2Address
|Skolefag_LMS
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|False
|Guardian2City
|Course_LMS_AllowRoll
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|TeacherInfo_FirstName
|Guardian2PostalCode
|Activity_Teacher_FirstName
|
|
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|TeacherInfo_LastName
|Guardian2PhoneNumber
|Activity_Teacher_LastName
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|TeacherInfo_CprNo
|Guardian2Mail
|Activity_Teacher_SSN
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|TeacherInfo_Initials
|Guardian2MobilePhoneNumber
|Activity_Teacher_Initials
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|
|}
|}
{| class="wikitable"
{| class="wikitable"
|+
|+
Parents
Students<br>Rowtype = LectioStamKlasser Årsnavn
!Admin system
!Admin system
!UMS
!UMS
!Remarks
!Remarks
|-
|-
|ASV.SVP_PERSON.ID
|StartDato
|IDFromAdministrativeSystem
|STARTDATO
|Use StudentInfo_StartDate if higher
|-
|SlutDato
|SLUTDATO
|Use StudentInfo_EndDateCalc if lower
|-
|StartDato
|Aktiviteter_STARTDATO
|
|-
|SlutDato
|Aktiviteter_SlutDato
|
|-
|HoldelementInfo_HeNavn
|Aktivitet
|Calculated by UMS based on
 
StudentInfo_Aargang, StudentInfo_Stamclass, StudentInfo_StamclassNameAktuel and StudentInfo_StamclassTermName
|-
|HoldelementInfo_HeNavn
|ActivityDisplayName
|Calculated by UMS based on
 
StudentInfo_Aargang, StudentInfo_Stamclass, StudentInfo_StamclassNameAktuel and StudentInfo_StamclassTermName
|-
|HoldInfo_HoldKortBetegnelse
|Kort_Betegnelse
|Calculated by UMS based on
StudentInfo_Aargang, StudentInfo_Stamclass, StudentInfo_StamclassNameAktuel and StudentInfo_StamclassTermName
|-
|False
|Activity_AsExternalGroup
|
|
|-
|-
|'P' + ASV.SVP_PERSON.ID
|False
|UMS_IDFromAdministrativeSystem
|Aktivitet_LMS
|Prefixed with increase identifier + '_' if used
|
|-
|-
|ASV.SVP_PERSON.ID
|False
|StudieNr
|Activity_LMS_AllowRoll
|
|
|-
|-
|'P' + ASV.SVP_PERSON.ID
|False
|CPR
|Skolefag_LMS
|Prefixed with increase identifier + '_' if used
|
|-
|-
|ASV.SVP_PERSON.GEBURTSDATUM
|False
|BirthDay
|Course_LMS_AllowRoll
|
|
|-
|-
|ASV.SVP_PERSON.VORNAMEN
|TeacherInfo_FirstName
|Fornavne
|Activity_Teacher_FirstName
|
|
|-
|-
|ASV.SVP_PERSON.FAMILIENNAME
|TeacherInfo_LastName
|Efternavn
|Activity_Teacher_LastName
|
|
|-
|-
|ASV.SVP_PERSON.VORNAMEN
|TeacherInfo_CprNo
|PublicRegisteredFirstName
|Activity_Teacher_SSN
|
|
|-
|-
|ASV.SVP_PERSON.FAMILIENNAME
|TeacherInfo_Initials
|PublicRegisteredSurName
|Activity_Teacher_Initials
|
|
|}
{| class="wikitable"
|+
Students<br>Rowtype = Lectio Groups
!Admin system
!UMS
!Remarks
|-
|StartDato
|STARTDATO
|Use StudentInfo_StartDate if higher
|-
|-
|ASV.SVP_PERSON.WL_GESCHLECHT_ID
|SlutDato
|Gender
|SLUTDATO
|1099_1 = Male else female
|Use StudentInfo_EndDateCalc if lower
|-
|-
|ASV.SVP_SCHULE_STAMM.SCHULNUMMER
|StartDato
|Skolekode
|Aktiviteter_STARTDATO
|
|-
|SlutDato
|Aktiviteter_SlutDato
|
|
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|AarsNavn
|PrivateMail
|Aktivitet
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|If empty use Navn
|-
|HoldelementInfo_HeNavn
|ActivityDisplayName
|If empty use Navn
|-
|HoldInfo_HoldBetegnelse
|ActivityDescription
|If empty use Navn
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|HoldInfo_HoldKortBetegnelse
|PhoneNumber
|Kort_Betegnelse
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|If empty use Navn
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|HoldInfo_HoldId
|PrivateMobilePhone
|AktivitetsID
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|Id
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|True
|MobilePhone
|Activity_AsExternalGroup
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|
|-
|-
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|False
|Adresse
|Aktivitet_LMS
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|False
|postnummer
|Activity_LMS_AllowRoll
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|False
|City
|Skolefag_LMS
|
|
|-
|-
|ASV.SVP_ANSCHRIFT.ORTSTEIL
|False
|Sted
|Course_LMS_AllowRoll
|
|
|}
|}

Latest revision as of 10:44, 18 February 2025


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
Used by all rowtypes
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
StudentInfo_AddrStreetName Adresse
StudentInfo_AddrAreaName Sted
StudentInfo_AddrZipcode PostNummer
StudentInfo_AddrBy City
StudentInfo_AddCoName COAddress
Klassebetegnelse Calculated by UMS from these fields

StudentInfo_Stamclass and StudentInfo_StamclassNameAktuel

StudentInfo_Aargang Klassetrin
StudentInfo_StudentForloeb ActivityDepartmentName
StudentInfo_StudentForloeb Skoleforlob
StudentInfo_StudentType ElevAfdelingsKode
YearLevel StudentInfo_Aargang + 11

If blank then 16

HomeGroupName Calculated by UMS based on

StudentInfo_Aargang, StudentInfo_Stamclass, StudentInfo_StamclassNameAktuel and StudentInfo_StamclassTermName

Guard1Cpr Guardian1SSN
Guard1Name Guardian1Name Text before last space
Guard1Name Guardian1SurName Text after last space
Guard1Phone Guardian1PhoneNumber
Guard1Address Guardian1Address
Guard1Email Guardian1Mail
Guard1Phone2 Guardian1MobilePhoneNumber
Guard2Cpr Guardian2SSN
Guard2Name Guardian2Name Text before last space
Guard2Name Guardian2SurName Text after last space
Guard2Phone Guardian2PhoneNumber
Guard2Address Guardian2Address
Guard2Email Guardian2Mail
Guard2Phone2 Guardian2MobilePhoneNumber
MobilePhone Telefon1 or Telefon2 depends on what has been set in configurator
StudentInfo_StartDate EnrollmentDate
StudentInfo_EndDate AFGANGSDATO
StudentInfo_PNr AlternativID
StudentInfo_AfdelingStudentAktuel AfdelingsNavn IF empty use StudentInfo_StudentForloeb
StudentInfo_Uddannelsesgruppe Education
StudentInfo_XprsUddannelseAktuel COSA_FORMAL
StudentInfo_StudyCardId CardID
StudentInfo_AfdelingNrStudent SkoleKode
StudentInfo_StudieRetningName Betegnelse
StudentInfo_StudieRetningName EducationDescription
StudentInfo_ElevId ExtraField1
StudentInfo_StartDate ELEV_I_SKOLEFORLOB_StartDato IF empty use StudentInfo_StartDateCalc
StudentInfo_EndDate ELEV_I_SKOLEFORLOB_SlutDato IF empty use StudentInfo_EndDateCalc
SchoolCommunityHome True if current date is within BookingInfo_PeriodeStart and BookingInfo_PeriodeEnd
PladsInfo_SkhAfdelingName SchoolCommunityHomeDepartment Based on currently active pladsinfo within BookingInfo_PeriodeStart and BookingInfo_PeriodeEnd
PladsInfo_VaerelseKode SchoolCommunityHomeRoomNumber Based on currently active pladsinfo within BookingInfo_PeriodeStart and BookingInfo_PeriodeEnd
BookingInfo_PeriodeStart SchoolCommunityHomeStartDate
BookingInfo_PeriodeEnd SchoolCommunityHomeEndDate
Students
Rowtype = LectioCourses
Admin system UMS Remarks
Holdtilknytninger.Startdate STARTDATO
Holdtilknytninger.Enddate SLUTDATO Use StudentInfo_EndDateCalc if lower
Holdtilknytninger.Startdate Aktiviteter_STARTDATO First startdate
Holdtilknytninger.Enddate Aktiviteter_SlutDato Last Enddate
HoldelementInfo_HeNavn Aktivitet
HoldelementInfo_HeNavn ActivityDisplayName
HoldInfo_HoldBetegnelse ActivityDescription If empty use HoldInfo_HoldFag
HoldInfo_HoldKortBetegnelse Kort_Betegnelse If empty use HoldelementInfo_HeNavn
HoldInfo_HoldId AktivitetsID
False Activity_AsExternalGroup
False Aktivitet_LMS
False Activity_LMS_AllowRoll
False Skolefag_LMS
False Course_LMS_AllowRoll
TeacherInfo_FirstName Activity_Teacher_FirstName
TeacherInfo_LastName Activity_Teacher_LastName
TeacherInfo_CprNo Activity_Teacher_SSN
TeacherInfo_Initials Activity_Teacher_Initials
HoldInfo_XprsFagNummer Course_ID
HoldInfo_HoldNiveau CourseLevel
HoldInfo_HoldFag Skolefag
HoldInfo_HoldFag Skolefag_Betegnelse
HoldInfo_HoldKortBetegnelse Skolefag_Kort_Betegnelse
HoldelementInfo_HeElementkode ExtraField2
Students
Rowtype = LectioCoursesLMS
Admin system UMS Remarks
Holdtilknytninger.Startdate STARTDATO
Holdtilknytninger.Enddate SLUTDATO Use StudentInfo_EndDateCalc if lower
Holdtilknytninger.Startdate Aktiviteter_STARTDATO First startdate
Holdtilknytninger.Enddate Aktiviteter_SlutDato Last Enddate
HoldInfo_HoldName Aktivitet
HoldelementInfo_HeNavn ActivityDisplayName
HoldInfo_HoldBetegnelse ActivityDescription If empty use HoldInfo_HoldFag
HoldInfo_HoldKortBetegnelse Kort_Betegnelse If empty use HoldelementInfo_HeNavn
HoldInfo_HoldId AktivitetsID
True Activity_AsExternalGroup
True Aktivitet_LMS False if StudentInfo_StudentForloeb = 'Inaktivt'
False Activity_LMS_AllowRoll
False Skolefag_LMS
False Course_LMS_AllowRoll
TeacherInfo_FirstName Activity_Teacher_FirstName
TeacherInfo_LastName Activity_Teacher_LastName
TeacherInfo_CprNo Activity_Teacher_SSN
TeacherInfo_Initials Activity_Teacher_Initials
HoldInfo_XprsFagNummer Course_ID
HoldInfo_HoldNiveau CourseLevel
HoldInfo_HoldFag Skolefag
HoldInfo_HoldFag Skolefag_Betegnelse
HoldInfo_HoldKortBetegnelse Skolefag_Kort_Betegnelse
HoldelementInfo_HeElementkode ExtraField2
Students
Rowtype = LectioStamKlasser
Admin system UMS Remarks
StartDato STARTDATO Use StudentInfo_StartDate if higher
SlutDato SLUTDATO Use StudentInfo_EndDateCalc if lower
StartDato Aktiviteter_STARTDATO
SlutDato Aktiviteter_SlutDato
Stamklasse Aktivitet
Stamklasse ActivityDisplayName
Stamklasse ActivityDescription
Stamklasse Kort_Betegnelse
GroupId AktivitetsID
True Activity_AsExternalGroup
False Aktivitet_LMS
False Activity_LMS_AllowRoll
False Skolefag_LMS
False Course_LMS_AllowRoll
TeacherInfo_FirstName Activity_Teacher_FirstName
TeacherInfo_LastName Activity_Teacher_LastName
TeacherInfo_CprNo Activity_Teacher_SSN
TeacherInfo_Initials Activity_Teacher_Initials
Students
Rowtype = LectioStamKlasser Årsnavn
Admin system UMS Remarks
StartDato STARTDATO Use StudentInfo_StartDate if higher
SlutDato SLUTDATO Use StudentInfo_EndDateCalc if lower
StartDato Aktiviteter_STARTDATO
SlutDato Aktiviteter_SlutDato
HoldelementInfo_HeNavn Aktivitet Calculated by UMS based on

StudentInfo_Aargang, StudentInfo_Stamclass, StudentInfo_StamclassNameAktuel and StudentInfo_StamclassTermName

HoldelementInfo_HeNavn ActivityDisplayName Calculated by UMS based on

StudentInfo_Aargang, StudentInfo_Stamclass, StudentInfo_StamclassNameAktuel and StudentInfo_StamclassTermName

HoldInfo_HoldKortBetegnelse Kort_Betegnelse Calculated by UMS based on

StudentInfo_Aargang, StudentInfo_Stamclass, StudentInfo_StamclassNameAktuel and StudentInfo_StamclassTermName

False Activity_AsExternalGroup
False Aktivitet_LMS
False Activity_LMS_AllowRoll
False Skolefag_LMS
False Course_LMS_AllowRoll
TeacherInfo_FirstName Activity_Teacher_FirstName
TeacherInfo_LastName Activity_Teacher_LastName
TeacherInfo_CprNo Activity_Teacher_SSN
TeacherInfo_Initials Activity_Teacher_Initials
Students
Rowtype = Lectio Groups
Admin system UMS Remarks
StartDato STARTDATO Use StudentInfo_StartDate if higher
SlutDato SLUTDATO Use StudentInfo_EndDateCalc if lower
StartDato Aktiviteter_STARTDATO
SlutDato Aktiviteter_SlutDato
AarsNavn Aktivitet If empty use Navn
HoldelementInfo_HeNavn ActivityDisplayName If empty use Navn
HoldInfo_HoldBetegnelse ActivityDescription If empty use Navn
HoldInfo_HoldKortBetegnelse Kort_Betegnelse If empty use Navn
HoldInfo_HoldId AktivitetsID Id
True Activity_AsExternalGroup
False Aktivitet_LMS
False Activity_LMS_AllowRoll
False Skolefag_LMS
False Course_LMS_AllowRoll

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=5103"