Jump to content

AdminServers/UDDATA: 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 126: Line 126:
|
|
|}
|}
===Data mapping===
{| class="wikitable"
|+Employees
!Admin system
!UMS
!Remarks
|-
|indi_id
|UMS_IDFromAdministrativeSystem
|
|-
|indi_id
|IDFromAdministrativeSystem
|
|-
|FirstName
|Fornavn
|
|-
|LastName
|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
|
|-
|Departments.PrimaerAfd
|PrimaryEmployment
|
|-
|unilogin
|UniLogin
|
|}
{| class="wikitable"
{| class="wikitable"
|+
|+
Line 278: Line 411:
|
|
|}
|}
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>Student
!Admin system
!UMS
!Remarks
|-
|esas_navn_dansk
|Klassebetegnelse
|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
|ActivityDepartmentStreet
|If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
|-
|esas_postnummer
|ActivityDepartmentPostalCode
|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
|AktivitetsID
|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
|-
|
|Aktivitet_LMS
|True if publication has been set
|-
|esas_publiceringsmulighed_institutionsspecifik
|Activity_PublicationCode
|From Hold
|-
|Label
|ActivityType
|Using Label from OptionSetValueString based on esas_holdtype
|-
|esas_startdato
|StartDato
|From table ImportFromDBesas_Hold
|-
|esas_slutdato
|SlutDato
|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
|Activity_Education
|
|-
|esas_betegnelse
|Activity_EducationDescription
|
|-
|FirstName
|Activity_Teacher_FirstName
|
|-
|LastName
|Activity_Teacher_LastName
|
|-
|esas_cpr_nummer_uden_formatering
|Activity_Teacher_SSN
|
|}
===Template criteria mapping===
===Template criteria mapping===
{| class="wikitable"
{| class="wikitable"

Revision as of 08:25, 24 September 2021

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

Contact information

Employees
Admin system UMS Remarks
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
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
Employees
Admin system UMS Remarks
indi_id UMS_IDFromAdministrativeSystem
indi_id IDFromAdministrativeSystem
FirstName Fornavn
LastName 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
Departments.PrimaerAfd PrimaryEmployment
unilogin UniLogin
Students
Admin system UMS Remarks
esas_personid UMS_IDFromAdministrativeSystem
ContactId IDFromAdministrativeSystem
FirstName + MiddleName Fornavn If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
LastName EFTERNAVN If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
esas_lokalt_studienummer StudieNr
esas_cpr_nummer_uden_formatering CPR
BirthDate BirthDay
FirstName + MiddleName PublicRegisteredFirstName
LastName PublicRegisteredSurName
esas_postnummer Postnummer
esas_by City
esas_kommune_id Sted
Address1_Line1 Adresse
esas_privatemail PrivateMail
esas_mobiltelefonnummer PrivateMobilePhone
esas_mobiltelefonnummer MobilePhone
esas_sso_id OtherInfo
esas_studieemail WorkMail
esas_navne_addressebeskyttet SecretAddress
esas_uddannelsesaktivitetId EducationID From table ImportFromDBesas_Uddannelsesaktivitet
esas_cosa_formaalskode COSA_FORMAL From table ImportFromDBesas_Uddannelsesaktivitet
esas_aktivitetsgruppekode Education From table ImportFromDBesas_Uddannelsesaktivitet
esas_betegnelse EducationDescriptionShort From table ImportFromDBesas_Uddannelsesaktivitet
esas_titel EducationDescription From table ImportFromDBesas_Uddannelsesaktivitet
esas_personoplysningerId ExtraField1
esas_studiestart StudyStart_Education
esas_afgangsdato StudyEnd_Education If null then use esas_forventet_afslutning
esas_forventet_afslutning Expected_EducationEndDate
esas_afdelingId DepartmentID
esas_navn Department
Address1_Line1 DepartmentStreet From table ImportFromDBesas_InstitutionVirksomhed
esas_postnummer DepartmentPostalCode
esas_by DepartmentCity
esas_institutionsnummer SkoleKode
esas_navn EducationVersion
esas_lokalt_studienummer AlternativID

Template criteria mapping

Employees
Admin system UMS Picture from admin system Remarks
Institutions kode Institution number
Afdeling Department
Ansvarsområde Responsibility area
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
Retrieved from "https://wiki.inlogic.dk/index.php?title=AdminServers/UDDATA&oldid=4066"