Jump to content

AdminServers/Stads: Difference between revisions

From UmsWiki
← Older editNewer edit →
VisualWikitext
(5 intermediate revisions by the same user not shown)
Line 23: Line 23:
!Remarks
!Remarks
|-
|-
|Students ID
|PERSON_ID
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|
|
|-
|-
|Students ID
|PERSON_ID
|IDFromAdministrativeSystem
|IDFromAdministrativeSystem
|
|
|-
|-
|GivenName
|STUDIENR
|Fornavn
|STUDIENR
|
|
|-
|-
|Surname
|FORNAVNE
|FORNAVNE
|Is only filled out if secret address = false
|-
|EFTERNAVN
|EFTERNAVN
|
|EFTERNAVN
|Is only filed out if secret address = false
|-
|-
|CivilRegistrationNumber
|CPR
|CPR
|CPR
|
|
|-
|-
|AdUsername
|FORNAVNE
|StudieNr
|
|-
|ProtectedGivenName
|PublicRegisteredFirstName
|PublicRegisteredFirstName
|
|
|-
|-
|ProtectedSurname
|EFTERNAVN
|PublicRegisteredSurName
|PublicRegisteredSurName
|
|
|-
|-
|Email
|CPR
|PrivateMail
|BirthDay
|First 6 characters if valid CPR
|-
|P_Adresse1
|Adresse
|
|
|-
|-
|PhoneNumber
|P_PostNr
|PrivateMobilePhone
|PostNummer
|
|
|-
|-
|PhoneNumber
|P_PostDistrikt
|MobilePhone
|Sted
|
|
|-
|-
|StudyStartDate
|vaerdi
|StudyStart_Education
|MobilePhone
|
|from rag_personinfo where tlftype = 'Mobil'
|-
|-
|StudyEndDate
|vaerdi
|StudyEnd_Education
|PrivateMail
|
|from rag_personinfo where type = 1
|-
|-
|StudyExpectedCompletionDate
|adr_beskyttet_ja_nej
|Expected_EducationEndDate
|SecretAddress
|
|
|-
|-
|Department ID
|admenhed_id
|DepartmentID
|DepartmentID
|
|
|-
|-
|Department Name
|kode
|Department
|DepartmentCode
|
|
|-
|-
|AddressLine
|admenhed
|Adresse
|Department
|
|
|-
|-
|PostalCode
|fra_dato
|PostNummer
|StudyStart_Education
|
|Not extracted with rowtype goups
|-
|-
|Place
|til_dato
|Sted
|StudyEnd_Education
|
|Not extracted with rowtype goups
|-
|-
|CareOfAddressLine
|uddannelses_id
|COAddress
|EducationID
|
|Not extracted with rowtype goups
|-
|-
|ProtectedNameAndAddress
|kode
|SecretAddress
|EducationCode
|
|Not extracted with rowtype goups
|-
|-
|DepartmentEducation ID
|navn
|EducationDepartmentID
|
|-
|DepartmentEducation Name
|EducationDepartmentname
|
|-
|Student Studies EducationId
|EducationID
|
|-
|Student Studies EducationName
|Education
|Education
|
|Not extracted with rowtype goups
|-
|-
|Student Studies EducationVersion
|bekendtgoer_titel
|EducationVersion
|EducationDescription
|
|Not extracted with rowtype goups
|-
|-
|Student Studies Coesa
|kortnavn
|EcucationCode
|EducationDescriptionShort
|
|Not extracted with rowtype goups
|-
|-
|Student Studies DsDepartmentNumber
|uddannelsestype
|Skolekode
|EducationType
|
|Not extracted with rowtype goups
|-
|Student Studies Type Name
|EducationStudentStudyType
|
|-
|Guardian information
|Guardian information
|This is copied to the guardian fields in UMS
|-
|-
|EducationId
|STATUS
|Activity_EducationID
|EducationStatus
|From education on EducationalProgrammes
|RAG_STUD_UDDRAMM
Not extracted with rowtype goups
|-
|-
|EducationCoesaNumber
|aktgrp_kode
|Activity_Education
|EducationGroupCode
|From education on EducationalProgrammes
|bes_aktivitetsgrp
Not extracted with rowtype goups
|-
|-
|EducationVersion
|uddannelses_id
|Activity_EducationVersion
|EducationDirection
|From education on EducationalProgrammes
|Not extracted with rowtype goups
|-
|-
|EducationName
|studieretn_kode
|Activity_EducationDescription
|EducationDirectionShort
|From education on EducationalProgrammes
|Not extracted with rowtype goups
|-
|-
|Name
|studieretning
|Activity_EducationDescriptionShort
|EducationDirectionDescription
|From education on EducationalProgrammes
|Not extracted with rowtype goups
|-
|-
|School code
|uddannelses_id
|ExtraField1
|EducationDirectionVersion
|
|Not extracted with rowtype goups
|-
|-
|studyEndCauseCode
|udb_aarsag_kode
|DepartureCauseCode
|DepartureCauseCode
|
|
|-
|-
|studyEndCause
|tekst
|DepartureCause_Description
|DepartureCause_Description
|
|
|-
|-
|studyCancellationCauseCode
|forkortelse
|DepartureCause_Short_Description
|DepartureCause_Short_Description
|
|
|}
|}
{| class="wikitable"
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>Student
|+Extra fields when extracting students with rowtype<br>UVA
!Admin system
!Admin system
!UMS
!UMS
!Remarks
!Remarks
|-
|-
|SubjectCourse ID
|uddelement_id
|AktivitetsID
|AktivitetsID
|
|
|-
|-
|SubjectCourse Designation
|KODE
|Aktivitet
|Aktivitet
|
|
|-
|-
|SubjectCourse Designation
|langtnavn
|ActivityDisplayName
|ActivityDisplayName
|
|
|-
|-
|SubjectCourse Name
|langtnavn
|ActivityDescription
|ActivityDescription
|
|
|-
|-
|SubjectCourse Designation
|navn
|Kort_Betegnelse
|Kort_Betegnelse
|
|
|-
|-
|SubjectCourse LmsIndicator
|ELEMENTTYPE
|ActivityType
|
|-
|
|Aktivitet_LMS
|Aktivitet_LMS
|True
|-
|
|
|Activity_LMS_AllowRoll
|True
|-
|-
|Subject Course Enrollment StartDate
|fra_dato
|StartDato
|StartDato
|
|
|-
|-
|Subject Course Enrollment EndDate
|til_dato
|SlutDato
|SlutDato
|
|
|-
|-
|SubjectCourse StartDate
|fra_dato
|Aktiviteter_StartDato
|Aktiviteter_StartDato
|
|
|-
|-
|SubjectCourse EndDate
|til_dato
|Aktiviteter_SlutDato
|Aktiviteter_SlutDato
|
|
|-
|UVM Course ID
|Course_ID
|
|-
|UVM Course Subject
|Skolefag
|
|-
|UVM Course Description
|Skolefag_Betegnelse
|
|-
|UVM Course Level
|CourseLevel
|If Level is a - then Null is written to UMS
|-
|
|SkoleFag_LMS
|Is set to true if there is a UVM course connected
|}
|}
{| class="wikitable"
{| class="wikitable"
Line 251: Line 225:
!Remarks
!Remarks
|-
|-
|EducationalProgrammes ID
|stud_gruppe_id
|AktivitetsID
|AktivitetsID
|
|
|-
|-
|EducationalProgrammes Designation
|KODE
|Aktivitet
|Aktivitet
|
|
|-
|-
|EducationalProgrammes Designation
|KOMMENTAR
|ActivityDisplayName
|ActivityDisplayName
|
|
|-
|-
|EducationalProgrammes Name
|KOMMENTAR
|ActivityDescription
|ActivityDescription
|
|
|-
|-
|EducationalProgrammes Designation
|KODE
|Kort_Betegnelse
|Kort_Betegnelse
|
|
|-
|
|ActivityType
|Class
|-
|-
|
|
Line 275: Line 253:
|True
|True
|-
|-
|EducationalProgrammes StartDate
|
|Activity_LMS_AllowRoll
|True
|-
|oprettelsesdato
|StartDato
|StartDato
|
|
|-
|-
|EducationalProgrammes EndDate
|add_months(sysdate, 1)
|SlutDato
|SlutDato
|
|
|-
|-
|EducationalProgrammes StartDate
|oprettelsesdato
|Aktiviteter_StartDato
|Aktiviteter_StartDato
|
|
|-
|-
|EducationalProgrammes EndDate
|add_months(sysdate, 1)
|Aktiviteter_SlutDato
|Aktiviteter_SlutDato
|
|

Revision as of 12:48, 14 February 2025

Server

DNS address of the Oracle server where the STADS database is stored.

SID

STADS database name.

Username

Oracle Username to access database.

Password

Oracle Password to access database.

Export settings

Data mapping

Students
Admin system UMS Remarks
PERSON_ID UMS_IDFromAdministrativeSystem
PERSON_ID IDFromAdministrativeSystem
STUDIENR STUDIENR
FORNAVNE FORNAVNE Is only filled out if secret address = false
EFTERNAVN EFTERNAVN Is only filed out if secret address = false
CPR CPR
FORNAVNE PublicRegisteredFirstName
EFTERNAVN PublicRegisteredSurName
CPR BirthDay First 6 characters if valid CPR
P_Adresse1 Adresse
P_PostNr PostNummer
P_PostDistrikt Sted
vaerdi MobilePhone from rag_personinfo where tlftype = 'Mobil'
vaerdi PrivateMail from rag_personinfo where type = 1
adr_beskyttet_ja_nej SecretAddress
admenhed_id DepartmentID
kode DepartmentCode
admenhed Department
fra_dato StudyStart_Education Not extracted with rowtype goups
til_dato StudyEnd_Education Not extracted with rowtype goups
uddannelses_id EducationID Not extracted with rowtype goups
kode EducationCode Not extracted with rowtype goups
navn Education Not extracted with rowtype goups
bekendtgoer_titel EducationDescription Not extracted with rowtype goups
kortnavn EducationDescriptionShort Not extracted with rowtype goups
uddannelsestype EducationType Not extracted with rowtype goups
STATUS EducationStatus RAG_STUD_UDDRAMM

Not extracted with rowtype goups

aktgrp_kode EducationGroupCode bes_aktivitetsgrp

Not extracted with rowtype goups

uddannelses_id EducationDirection Not extracted with rowtype goups
studieretn_kode EducationDirectionShort Not extracted with rowtype goups
studieretning EducationDirectionDescription Not extracted with rowtype goups
uddannelses_id EducationDirectionVersion Not extracted with rowtype goups
udb_aarsag_kode DepartureCauseCode
tekst DepartureCause_Description
forkortelse DepartureCause_Short_Description
Extra fields when extracting students with rowtype
UVA
Admin system UMS Remarks
uddelement_id AktivitetsID
KODE Aktivitet
langtnavn ActivityDisplayName
langtnavn ActivityDescription
navn Kort_Betegnelse
ELEMENTTYPE ActivityType
Aktivitet_LMS True
Activity_LMS_AllowRoll True
fra_dato StartDato
til_dato SlutDato
fra_dato Aktiviteter_StartDato
til_dato Aktiviteter_SlutDato
Extra fields when extracting students with rowtype
Groups
Admin system UMS Remarks
stud_gruppe_id AktivitetsID
KODE Aktivitet
KOMMENTAR ActivityDisplayName
KOMMENTAR ActivityDescription
KODE Kort_Betegnelse
ActivityType Class
Aktivitet_LMS True
Activity_LMS_AllowRoll True
oprettelsesdato StartDato
add_months(sysdate, 1) SlutDato
oprettelsesdato Aktiviteter_StartDato
add_months(sysdate, 1) Aktiviteter_SlutDato

Template criteria mapping

Students
Admin system UMS Picture from admin system Remarks
Education code EducationCode
Education group code EducationGroupCode
Department code DepartmentCode
Activity department code ActivityDepartmentCode
Group comment ActivityDisplayName Is only used when extracting groups (Rows with rowtype Groups)
Retrieved from "https://wiki.inlogic.dk/index.php?title=AdminServers/Stads&oldid=5093"