AdminServers/Ludus: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
Kia (talk | contribs)
Line 35: Line 35:


===[[AdminServers/Export Settings|Export settings]]===
===[[AdminServers/Export Settings|Export settings]]===
===Data mapping===
{| class="wikitable"
|+Employees
!Admin system
!UMS
!Remarks
|-
|indi_id
|UMS_IDFromAdministrativeSystem
|
|-
|indi_id
|IDFromAdministrativeSystem
|
|-
|Fornavn
|Fornavn
|
|-
|EFTERNAVN
|EFTERNAVN
|
|-
|initialer
|StudieNr
|
|-
|cpr_nr
|CPR
|
|-
|cpr_nr
|BirthDay
|First 6 numbers
|-
|initialer
|AlternateAdminSystem_ID
|
|-
|afdel_id
|AktivitetsID
|
|-
|afdeling
|Aktivitet
|
|-
|Departments.beskrivelse
|ActivityDisplayName
|If null then use Departments.afdeling
|-
|Departments.beskrivelse
|ActivityDescription
|
|-
|Departments.kortnavn
|Kort_Betegnelse
|
|-
|Departments.startDato
|StartDato
|
|-
|Departments.slutDato
|SlutDato
|
|-
|Departments.startDato
|Aktiviteter_STARTDATO
|
|-
|Departments.slutDato
|Aktiviteter_SlutDato
|
|-
|Employments.gyldig_fra
|Employement_StartDate
|
|-
|Employments.gyldig_til
|Employement_EndDate
|
|-
|postnummer
|Postnummer
|
|-
|sted
|City
|
|-
|gade
|Adresse
|
|-
|co
|COAddress
|
|-
|Departments.afdel_id
|DepartmentID
|
|-
|Departments.afdeling
|DepartmentCode
|
|-
|Departments.afdeling
|Department
|
|-
|Departments.beskrivelse
|DepartmentDescription
|
|-
|Departments.kortnavn
|DepartmentShortName
|
|-
|InstitutionNumber
|Skolekode
|
|-
|Employments.ansvarsomrade
|Employee_ResponsibilityArea
|
|-
|medarbejdertype
|Employee_JobEmployment_Description
|
|-
|Departments.PrimaerAfd
|PrimaryEmployment
|
|-
|unilogin
|UniLogin
|
|-
|PrimaryPhone (PRIT)
|PrivateMobilePhone
|
|-
|MT
|PrivateMobilePhone
|Used if primary phone is empty
|-
|MT
|MobilePhone
|Used if primary phone is empty
|-
|AT
|WorkPhoneNumber
|
|-
|PT
|PhoneNumber
|
|-
|Primary mail (PRIM)
|PrivateMail
|
|-
|PM
|PrivateMail
|Used if primary mail is empty
|-
|MA
|WorkMobilePhone
|
|-
|AM
|WorkMail
|
|-
|OtherInfo
|
|-
|Ø1
|ExtraField1
|
|-
|Ø2
|ExtraField2
|
|}
{| class="wikitable"
|+
Students
!Admin system
!UMS
!Remarks
|-
|indi_id
|UMS_IDFromAdministrativeSystem
|
|-
|indi_id
|IDFromAdministrativeSystem
|
|-
|Fornavn
|Fornavn
|
|-
|EFTERNAVN
|EFTERNAVN
|
|-
|indi_id
|StudieNr
|
|-
|cpr_nr
|CPR
|
|-
|cpr_nr
|BirthDay
|First 6 numbers
|-
|postnummer
|Postnummer
|
|-
|sted
|City
|
|-
|gade
|Adresse
|
|-
|co
|COAddress
|
|-
|Activities.akti
|AktivitetsID
|
|-
|Activities.aktivitet
|Aktivitet
|
|-
|Activities.aktivitet
|ActivityDisplayName
|
|-
|Activities.betegnelse
|ActivityDescription
|
|-
|Activities.kort_betegnelse
|Kort_Betegnelse
|
|-
|Activities.lms
|Aktivitet_LMS
|
|-
|ActivityEnrollments.startdato
|StartDato
|
|-
|ActivityEnrollments.slutdato
|SlutDato
|Use Educations.afgangsdato if it lowest
Use ActivityEnrollments.slutdato if it lowest
Use Activities.slutdato if its lowest
|-
|Activities.startdato
|Aktiviteter_STARTDATO
|
|-
|Activities.slutdato
|Aktiviteter_SlutDato
|
|-
|Activities.ActivityDepartmentName
|ActivityDepartmentName
|
|-
|Activities.ActivityDepartmentNameShort
|ActivityDepartmentNameShort
|
|-
|unilogin
|UniLogin
|
|-
|Educations.coesa
|COSA_FORMAL
|
|-
|Educations.coesa_betegnelse
|Education
|
|-
|Educations.coesa_kort_betegnelse
|EducationDescriptionShort
|
|-
|Educations.betegnelse
|EducationDescription
|
|-
|Educations.uddannelse_id
|EducationID
|
|-
|Educations.uddannelseversion
|EducationVersion
|
|-
|Educations.studiestartDato
|StudyStart_Education
|
|-
|Educations.afgangsdato
|StudyEnd_Education
|
|-
|Stamhold.aktivitet
|HomeGroupName
|
|-
|Stamhold.aktivitet
|Klassebetegnelse
|
|-
|Departments.afdel_id
|DepartmentID
|
|-
|Departments.afdeling
|DepartmentCode
|
|-
|Departments.afdeling
|Department
|
|-
|Departments.beskrivelse
|DepartmentDescription
|
|-
|Departments.kortnavn
|DepartmentShortName
|
|-
|InstitutionNumber
|Skolekode
|
|-
|SchoolCourse.skoleforloeb
|SKOLEFORLOB
|
|-
|SchoolCourse.skoleperiode
|SKOLEPERIODE
|
|-
|SchoolCourse.startDato
|ELEV_I_SKOLEFORLOB_StartDato
|
|-
|SchoolCourse.slutdato
|ELEV_I_SKOLEFORLOB_SlutDato
|
|-
|PrimaryPhone (PRIT)
|PrivateMobilePhone
|
|-
|MT
|PrivateMobilePhone
|Used if primary phone is empty
|-
|MT
|MobilePhone
|Used if primary phone is empty
|-
|PT
|PhoneNumber
|
|-
|Primary mail (PRIM)
|PrivateMail
|
|-
|PM
|PrivateMail
|Used if primary mail is empty
|-
|OtherInfo
|
|-
|Ø1
|ExtraField1
|
|-
|Ø2
|ExtraField2
|
|}
===Template criteria mapping===
===Template criteria mapping===
This is somewhat found in the column '''RowType''' in Students table.
This is somewhat found in the column '''RowType''' in Students table.

Revision as of 09:46, 28 June 2022

Server

DNS or IP address for the Sybase database server

Database

Name of the LUDUS database - Usually this is "VUC"

Port number

The port number of the Sybase database server

Username

Sybase Username to access the database.

Password

Sybase to access the database.

Webservice connection

This is used for the new webservices in Ludus

URL

URL of the LUDUS web service

Username

Username to access the webservice.

Password

Password to access the webservice.

Activity = HoldID + Holdstart

Hold vil blive få holdstart sat ind som en del af holdnavnet. Dette er et krav hvis man genbruger sine hold i LUDUS. Ellers kan man få hold der er sammensat af det nye og det tidligere hold.

Insert an underscore between HoldID + Holdstart. E.g. HoldID + _ + Holdstart

This puts an underscore between HoldID + _ + Holdstart

Export settings

Data mapping

Employees
Admin system UMS Remarks
indi_id UMS_IDFromAdministrativeSystem
indi_id IDFromAdministrativeSystem
Fornavn Fornavn
EFTERNAVN EFTERNAVN
initialer StudieNr
cpr_nr CPR
cpr_nr BirthDay First 6 numbers
initialer AlternateAdminSystem_ID
afdel_id AktivitetsID
afdeling Aktivitet
Departments.beskrivelse ActivityDisplayName If null then use Departments.afdeling
Departments.beskrivelse ActivityDescription
Departments.kortnavn Kort_Betegnelse
Departments.startDato StartDato
Departments.slutDato SlutDato
Departments.startDato Aktiviteter_STARTDATO
Departments.slutDato Aktiviteter_SlutDato
Employments.gyldig_fra Employement_StartDate
Employments.gyldig_til Employement_EndDate
postnummer Postnummer
sted City
gade Adresse
co COAddress
Departments.afdel_id DepartmentID
Departments.afdeling DepartmentCode
Departments.afdeling Department
Departments.beskrivelse DepartmentDescription
Departments.kortnavn DepartmentShortName
InstitutionNumber Skolekode
Employments.ansvarsomrade Employee_ResponsibilityArea
medarbejdertype Employee_JobEmployment_Description
Departments.PrimaerAfd PrimaryEmployment
unilogin UniLogin
PrimaryPhone (PRIT) PrivateMobilePhone
MT PrivateMobilePhone Used if primary phone is empty
MT MobilePhone Used if primary phone is empty
AT WorkPhoneNumber
PT PhoneNumber
Primary mail (PRIM) PrivateMail
PM PrivateMail Used if primary mail is empty
MA WorkMobilePhone
AM WorkMail
Ø OtherInfo
Ø1 ExtraField1
Ø2 ExtraField2
Students
Admin system UMS Remarks
indi_id UMS_IDFromAdministrativeSystem
indi_id IDFromAdministrativeSystem
Fornavn Fornavn
EFTERNAVN EFTERNAVN
indi_id StudieNr
cpr_nr CPR
cpr_nr BirthDay First 6 numbers
postnummer Postnummer
sted City
gade Adresse
co COAddress
Activities.akti AktivitetsID
Activities.aktivitet Aktivitet
Activities.aktivitet ActivityDisplayName
Activities.betegnelse ActivityDescription
Activities.kort_betegnelse Kort_Betegnelse
Activities.lms Aktivitet_LMS
ActivityEnrollments.startdato StartDato
ActivityEnrollments.slutdato SlutDato Use Educations.afgangsdato if it lowest

Use ActivityEnrollments.slutdato if it lowest

Use Activities.slutdato if its lowest

Activities.startdato Aktiviteter_STARTDATO
Activities.slutdato Aktiviteter_SlutDato
Activities.ActivityDepartmentName ActivityDepartmentName
Activities.ActivityDepartmentNameShort ActivityDepartmentNameShort
unilogin UniLogin
Educations.coesa COSA_FORMAL
Educations.coesa_betegnelse Education
Educations.coesa_kort_betegnelse EducationDescriptionShort
Educations.betegnelse EducationDescription
Educations.uddannelse_id EducationID
Educations.uddannelseversion EducationVersion
Educations.studiestartDato StudyStart_Education
Educations.afgangsdato StudyEnd_Education
Stamhold.aktivitet HomeGroupName
Stamhold.aktivitet Klassebetegnelse
Departments.afdel_id DepartmentID
Departments.afdeling DepartmentCode
Departments.afdeling Department
Departments.beskrivelse DepartmentDescription
Departments.kortnavn DepartmentShortName
InstitutionNumber Skolekode
SchoolCourse.skoleforloeb SKOLEFORLOB
SchoolCourse.skoleperiode SKOLEPERIODE
SchoolCourse.startDato ELEV_I_SKOLEFORLOB_StartDato
SchoolCourse.slutdato ELEV_I_SKOLEFORLOB_SlutDato
PrimaryPhone (PRIT) PrivateMobilePhone
MT PrivateMobilePhone Used if primary phone is empty
MT MobilePhone Used if primary phone is empty
PT PhoneNumber
Primary mail (PRIM) PrivateMail
PM PrivateMail Used if primary mail is empty
Ø OtherInfo
Ø1 ExtraField1
Ø2 ExtraField2

Template criteria mapping

This is somewhat found in the column RowType in Students table.

Students

Other (Ludus Kerne)
Admin system UMS Picture from admin system Remarks
Activity name Aktivitet
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type ActivityType
CØSA Number COSA_FORMAL
Henvisnings kategori kode Internship_CategoryCode
Undervisningssted navn AktivitetsAfdeling

AfdelingsNavn

Ludus web -> FKB Number EducationDirection Not used
Ludus web -> Elevorløb Institution code Not used
Ludus web -> Activity type ActivityType Not used
OBU - FVU - DU - Kursist
Admin system UMS Picture from admin system Remarks
Activity name Aktivitet Holdstart is appended
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type This is used from table WebHoldHoldType in Ludus DB
CØSA Number COSA_FORMAL
Henvisnings kategori kode Internship_CategoryCode
Undervisningssted navn AktivitetsAfdeling

AfdelingsNavn

Ludus web -> FKB Number EducationDirection
Ludus web -> Elevorløb Institution code Not used
Ludus web -> Activity type ActivityType
Exam
Admin system UMS Picture from admin system Remarks
Activity name ActivityDescription
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type ActivityType
CØSA Number COSA_FORMAL
Henvisnings kategori kode Internship_CategoryCode
Undervisningssted navn AktivitetsAfdeling

AfdelingsNavn

Ludus web -> FKB Number EducationDirection Not used
Ludus web -> Elevorløb Institution code Not used
Ludus web -> Activity type ActivityType Not used


UddannelsesAftaler
Admin system UMS Picture from admin system Remarks
Activity name Not used
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type Not used
CØSA Number COSA_FORMAL
Henvisnings kategori kode Not used
Undervisningssted navn Not stored in UMS DB
Ludus web -> FKB Number Not used
Ludus web -> Elevorløb Institution code ElevAfdelingsKode
Ludus web -> Activity type Not used
IDV
Admin system UMS Picture from admin system Remarks
Activity name Aktivitet Holdstart is appended
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type Not used
CØSA Number Not used
Henvisnings kategori kode Not used
Undervisningssted navn AktivitetsAfdeling

AfdelingsNavn

Ludus web -> FKB Number COSA_FORMAL

EducationDirection

Ludus web -> Elevorløb Institution code Not used
Ludus web -> Activity type ActivityType
AMU
Admin system UMS Picture from admin system Remarks
Activity name Aktivitet Holdstart is appended if chosen in configurator
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type Not used
CØSA Number COSA_FORMAL

Activity_Education

Henvisnings kategori kode Not used
Undervisningssted navn AktivitetsAfdeling

AfdelingsNavn

Ludus web -> FKB Number EducationDirection
Ludus web -> Elevorløb Institution code Not used
Ludus web -> Activity type ActivityType
UM - Kursus
Admin system UMS Picture from admin system Remarks
Activity name Aktivitet Holdstart is appended if chosen in configurator
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type Not used
CØSA Number COSA_FORMAL
Henvisnings kategori kode Not used
Undervisningssted navn AktivitetsAfdeling

AfdelingsNavn

Ludus web -> FKB Number EducationDirection
Ludus web -> Elevorløb Institution code Not stored in UMS DB
Ludus web -> Activity type ActivityType Not stored in UMS DB
UddannelsesForloeb
Admin system UMS Picture from admin system Remarks
Activity name Not stored in UMS DB
Hold Institution code Not stored in UMS DB
Ludus kerne -> Activity type Not used
CØSA Number COSA_FORMAL
Henvisnings kategori kode Not used
Undervisningssted navn Not stored in UMS DB
Ludus web -> FKB Number EducationDirection
Ludus web -> Elevorløb Institution code Not stored in UMS DB
Ludus web -> Activity type ActivityType
ProeveHold
Admin system UMS Picture from admin system Remarks
Activity name Aktivitet
Hold Institution code ElevAfdelingsKode
Ludus kerne -> Activity type Not used
CØSA Number COSA_FORMAL
Henvisnings kategori kode Internship_CategoryCode
Undervisningssted navn AfdelingsNavn

AktivitetsAfdeling

Ludus web -> FKB Number Not used
Ludus web -> Elevorløb Institution code Not used
Ludus web -> Activity type Not used