Institution number
Enter the institution number (STIL) of your SIS database
Username
Lectio Username to access Lectio.
Password
Lectio Password to access Lectio.
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
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
|