AdminServers/UDDATA: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
← Older edit
VisualWikitext
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
 
(12 intermediate revisions by 3 users not shown)
Line 26: Line 26:
<br />
<br />
===Data mapping===
===Data mapping===
====Contact information====
{| class="wikitable"
{| class="wikitable"
|+
|+Employees
Employees
!Admin system
!Admin system
!UMS
!UMS
!Remarks
!Remarks
|-
|-
|PrimaryPhone (PRIT)
|indi_id
|PrivateMobilePhone
|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
|Employment_StartDate
|
|-
|Employments.gyldig_til
|Employment_EndDate
|
|-
|postnummer
|Postnummer
|
|-
|sted
|City
|
|-
|gade
|Adresse
|
|
|-
|-
|MT
|co
|PrivateMobilePhone
|COAddress
|Used if primary phone is empty
|
|-
|-
|MT
|Departments.afdel_id
|MobilePhone
|DepartmentID
|Used if primary phone is empty
|
|-
|-
|AT
|Departments.afdeling
|WorkPhoneNumber
|DepartmentCode
|
|
|-
|-
|PT
|Departments.afdeling
|PhoneNumber
|Department
|
|
|-
|-
|Primary mail (PRIM)
|Departments.beskrivelse
|PrivateMail
|DepartmentDescription
|
|
|-
|-
|PM
|Departments.kortnavn
|PrivateMail
|DepartmentShortName
|Used if primary mail is empty
|
|-
|-
|MA
|InstitutionNumber
|WorkMobilePhone
|Skolekode
|
|
|-
|-
|AM
|Employments.ansvarsomrade
|WorkMail
|Employee_ResponsibilityArea
|
|
|-
|-
|Ø
|medarbejdertype
|OtherInfo
|Employee_JobEmployment_Description
|
|
|-
|-
|Ø1
|Departments.PrimaerAfd
|ExtraField1
|PrimaryEmployment
|
|
|-
|-
|Ø2
|unilogin
|ExtraField2
|UniLogin
|
|
|}
{| class="wikitable"
|+
Students
!Admin system
!UMS
!Remarks
|-
|-
|PrimaryPhone (PRIT)
|PrimaryPhone (PRIT)
Line 101: Line 175:
|MobilePhone
|MobilePhone
|Used if primary phone is empty
|Used if primary phone is empty
|-
|AT
|WorkPhoneNumber
|
|-
|-
|PT
|PT
Line 113: Line 191:
|PrivateMail
|PrivateMail
|Used if primary mail is empty
|Used if primary mail is empty
|-
|MA
|WorkMobilePhone
|
|-
|AM
|WorkMail
|
|-
|-
|Ø
|Ø
Line 124: Line 210:
|Ø2
|Ø2
|ExtraField2
|ExtraField2
|
|-
|titel
|Employee Description
|
|
|}
|}
===Data mapping===
{| class="wikitable"
{| class="wikitable"
|+
|+
Line 134: Line 223:
!Remarks
!Remarks
|-
|-
|esas_personid
|indi_id
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|
|
|-
|-
|ContactId
|indi_id
|IDFromAdministrativeSystem
|IDFromAdministrativeSystem
|
|
|-
|-
|FirstName + MiddleName
|Fornavn
|Fornavn
|If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
|Fornavn
|
|-
|-
|LastName
|EFTERNAVN
|EFTERNAVN
|If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
|EFTERNAVN
|
|-
|-
|esas_lokalt_studienummer
|indi_id
|StudieNr
|StudieNr
|
|
|-
|-
|esas_cpr_nummer_uden_formatering
|cpr_nr
|CPR
|CPR
|
|
|-
|-
|BirthDate
|cpr_nr
|BirthDay
|BirthDay
|First 6 numbers
|-
|postnummer
|Postnummer
|
|-
|sted
|City
|
|-
|gade
|Adresse
|
|
|-
|-
|FirstName + MiddleName
|co
|PublicRegisteredFirstName
|COAddress
|
|
|-
|-
|LastName
|Activities.akti
|PublicRegisteredSurName
|AktivitetsID
|
|
|-
|-
|esas_postnummer
|Activities.aktivitet
|Postnummer
|Aktivitet
|
|
|-
|-
|esas_by
|Activities.aktivitet
|City
|ActivityDisplayName
|
|
|-
|-
|esas_kommune_id
|Activities.betegnelse
|Sted
|ActivityDescription
|
|
|-
|-
|Address1_Line1
|Activities.kort_betegnelse
|Adresse
|Kort_Betegnelse
|
|
|-
|-
|esas_privatemail
|Activities.lms
|PrivateMail
|Aktivitet_LMS
|
|
|-
|-
|esas_mobiltelefonnummer
|ActivityEnrollments.startdato
|PrivateMobilePhone
|StartDato
|
|
|-
|-
|esas_mobiltelefonnummer
|ActivityEnrollments.slutdato
|MobilePhone
|SlutDato
|Use Educations.afgangsdato if it lowest
 
Use ActivityEnrollments.slutdato if it lowest
 
Use Activities.slutdato if its lowest
|-
|Activities.startdato
|Aktiviteter_STARTDATO
|
|
|-
|-
|esas_sso_id
|Activities.slutdato
|OtherInfo
|Aktiviteter_SlutDato
|
|
|-
|-
|esas_studieemail
|Activities.ActivityDepartmentName
|WorkMail
|ActivityDepartmentName
|
|
|-
|-
|esas_navne_addressebeskyttet
|Activities.ActivityDepartmentNameShort
|SecretAddress
|ActivityDepartmentNameShort
|
|
|-
|-
|esas_uddannelsesaktivitetId
|unilogin
|EducationID
|UniLogin
|From table ImportFromDBesas_Uddannelsesaktivitet
|
|-
|-
|esas_cosa_formaalskode
|Educations.coesa
|COSA_FORMAL
|COSA_FORMAL
|From table ImportFromDBesas_Uddannelsesaktivitet
|
|-
|-
|esas_aktivitetsgruppekode
|Educations.coesa_betegnelse
|Education
|Education
|From table ImportFromDBesas_Uddannelsesaktivitet
|
|-
|-
|esas_betegnelse
|Educations.coesa_kort_betegnelse
|EducationDescriptionShort
|EducationDescriptionShort
|From table ImportFromDBesas_Uddannelsesaktivitet
|
|-
|-
|esas_titel
|Educations.betegnelse
|EducationDescription
|EducationDescription
|From table ImportFromDBesas_Uddannelsesaktivitet
|
|-
|Educations.uddannelse_id
|EducationID
|
|-
|-
|esas_personoplysningerId
|Educations.uddannelseversion
|ExtraField1
|EducationVersion
|
|
|-
|-
|esas_studiestart
|Students_Educations.studiestartDato
|StudyStart_Education
|StudyStart_Education
|
|
|-
|-
|esas_afgangsdato
|Students_Educations.afgangsdato
|StudyEnd_Education
|StudyEnd_Education
|If null then use esas_forventet_afslutning
|
|-
|-
|esas_forventet_afslutning
|Students_Educations.forventet_slutdato
|Expected_EducationEndDate
|Expected_EducationEndDate
|
|
|-
|-
|esas_afdelingId
|Stamhold.aktivitet
|DepartmentID
|HomeGroupName
|
|
|-
|-
|esas_navn
|Stamhold.aktivitet
|Department
|Klassebetegnelse
|
|
|-
|-
|Address1_Line1
|Departments.afdel_id
|DepartmentStreet
|DepartmentID
|From table ImportFromDBesas_InstitutionVirksomhed
|
|-
|-
|esas_postnummer
|Departments.afdeling
|DepartmentPostalCode
|DepartmentCode
|
|
|-
|-
|esas_by
|Departments.afdeling
|DepartmentCity
|Department
|
|
|-
|-
|esas_institutionsnummer
|Departments.beskrivelse
|SkoleKode
|DepartmentDescription
|
|
|-
|-
|esas_navn
|Departments.kortnavn
|EducationVersion
|DepartmentShortName
|
|
|-
|-
|esas_lokalt_studienummer
|InstitutionNumber
|AlternativID
|Skolekode
|
|
|}
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>Student
!Admin system
!UMS
!Remarks
|-
|-
|esas_navn_dansk
|SchoolCourse.skoleforloeb
|Klassebetegnelse
|SKOLEFORLOB
|This is based on esas_stamhold_id on Studieforloeb
|
esas_navn_dansk is from table ImportFromDBesas_Hold
|}
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>Undervisningshold, Stamhold, Skabelonhold and Semesterhold
!Admin system
!UMS
!Remarks
|-
|-
|Address1_Line1
|SchoolCourse.skoleperiode
|ActivityDepartmentStreet
|SKOLEPERIODE
|If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
|
|-
|-
|esas_postnummer
|SchoolCourse.startDato
|ActivityDepartmentPostalCode
|ELEV_I_SKOLEFORLOB_StartDato
|If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
|-
|esas_by
|ActivityDepartmentCity
|If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
|-
|esas_afdelingId
|ActivityDepartmentNumber
|If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
|-
|esas_navn
|ActivityDepartmentName
|If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
|-
|esas_institutionsnummer
|AktivitetsAfdeling
|If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
|-
|esas_uddannelseselement_planlaegningId
|ExtraField2
|
|
|-
|-
|esas_holdId
|SchoolCourse.slutdato
|AktivitetsID
|ELEV_I_SKOLEFORLOB_SlutDato
|From Hold
|-
|esas_navn_dansk
|Aktivitet
|From Hold
|-
|esas_navn_dansk
|ActivityDisplayName
|From Hold
|-
|esas_navn_dansk
|ActivityDescription
|From Hold
|-
|esas_navn_dansk
|Kort_Betegnelse
|From Hold
|-
|
|
|Activity_LMS_AllowRoll
|True if publication has been set
|-
|-
|PrimaryPhone (PRIT)
|PrivateMobilePhone
|
|
|Aktivitet_LMS
|True if publication has been set
|-
|-
|esas_publiceringsmulighed_institutionsspecifik
|MT
|Activity_PublicationCode
|PrivateMobilePhone
|From Hold
|Used if primary phone is empty
|-
|-
|Label
|MT
|ActivityType
|MobilePhone
|Using Label from OptionSetValueString based on esas_holdtype
|Used if primary phone is empty
|-
|-
|esas_startdato
|PT
|StartDato
|PhoneNumber
|From table ImportFromDBesas_Hold
|
|-
|-
|esas_slutdato
|Primary mail (PRIM)
|SlutDato
|PrivateMail
|Use Studieforloeb esas_afgangsdato if lower then ImportFromDBesas_Hold esas_slutdato
|-
|esas_startdato
|Aktiviteter_StartDato
|if null use PUE esas_startdato
|-
|esas_slutdato
|Aktiviteter_SlutDato
|if null use PUE esas_slutdato
|-
|esas_uddannelseselementId
|Course_ID
|From SUE
|-
|esas_uvm_fagkode
|Skolefag
|From SUE
|-
|esas_navn
|Skolefag_Betegnelse
|From SUE
|-
|esas_fagkode_niveau
|CourseLevel
|From SUE
|-
|Label
|CourseType
|Using Label from OptionSetValueString based on esas_fagtype
|-
|esas_uddannelsesaktivitetId
|Activity_EducationID
|
|
|-
|-
|esas_aktivitetsgruppekode
|PM
|Activity_Education
|PrivateMail
|
|Used if primary mail is empty
|-
|-
|esas_betegnelse
|Ø
|Activity_EducationDescription
|OtherInfo
|
|
|-
|-
|FirstName
|Ø1
|Activity_Teacher_FirstName
|ExtraField1
|
|
|-
|-
|LastName
|Ø2
|Activity_Teacher_LastName
|ExtraField2
|
|
|-
|-
|esas_cpr_nummer_uden_formatering
|titel
|Activity_Teacher_SSN
|Employee_Description
|
|
|}
|}
===Template criteria mapping===
===Template criteria mapping===
{| class="wikitable"
{| class="wikitable"
Line 440: Line 467:
|Ansvarsområde
|Ansvarsområde
|Responsibility area
|Responsibility area
|
|
|-
|medarbejdertype
|Job employment description
|
|
|
|
Line 490: Line 522:
|
|
|}
|}
===Requirements for extracting to UMS===
====Staff====
Must have a CPR
Employment start date must be entered
Employment end date if entered and lower than today + keep alive then he won't be extracted
====Student====
Must have a CPR
Education start date is used if entered otherwise it uses indmeldelsesdato
Educations end date if entered and lower than today + keep alive then he won't be extracted
===== Activity enrollment enabled =====
These are added if enabled:
Enrollment start date if entered and lower than today + keep alive then he won't be extracted
Enrollment end date if entered and lower than today + keep alive then he won't be extracted. (If Educations end date is lower then this is used)

Latest revision as of 11:50, 19 November 2024

Username

Username to access webservices.

This information in given by IST

Password

Password to access webservices.

This information in given by IST

Institution numbers

Enter a list of institution number to extract from.

Export settings

Data Extraction

Set User deactivation in Uddata+

If students are suddenly missing in data extraction from Uddata+, check the systemsettings in Uddata+.

Below setting in Uddata prevents user extraction in API 5 days after Activity_Enddate.


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 Employment_StartDate
Employments.gyldig_til Employment_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
titel Employee Description
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
Students_Educations.studiestartDato StudyStart_Education
Students_Educations.afgangsdato StudyEnd_Education
Students_Educations.forventet_slutdato Expected_EducationEndDate
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
titel Employee_Description

Template criteria mapping

Employees
Admin system UMS Picture from admin system Remarks
Institutions kode Institution number
Afdeling Department
Ansvarsområde Responsibility area
medarbejdertype Job employment description
Students
Admin system UMS Picture from admin system Remarks
Institutions kode Institution number
Cøsa (Uddannelses kode) Cosa Number
Afdeling Department
Stamhold Homegroup
Aktivitets afdeling Activity department
Aktivitets afdeling kort Activity department short
Skole forløb Skole forløb
Skole periode Skole periode

Requirements for extracting to UMS

Staff

Must have a CPR

Employment start date must be entered

Employment end date if entered and lower than today + keep alive then he won't be extracted

Student

Must have a CPR

Education start date is used if entered otherwise it uses indmeldelsesdato

Educations end date if entered and lower than today + keep alive then he won't be extracted

Activity enrollment enabled

These are added if enabled:

Enrollment start date if entered and lower than today + keep alive then he won't be extracted

Enrollment end date if entered and lower than today + keep alive then he won't be extracted. (If Educations end date is lower then this is used)

Retrieved from "http://wiki.inlogic.dk/index.php?title=AdminServers/UDDATA&oldid=4950"