Jump to content

AdminServers/Stads: Difference between revisions

From UmsWiki
← Older edit
VisualWikitext
 
(8 intermediate revisions by the same user not shown)
Line 18: Line 18:
{| class="wikitable"
{| class="wikitable"
|+
|+
Employees
Students
!Admin system
!Admin system
!UMS
!UMS
!Remarks
!Remarks
|-
|-
|Employee ID
|PERSON_ID
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|
|
|-
|-
|Employee 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
|-
|-
|Initials
|CPR
|StudieNr
|
|-
|CivilRegistrationNumber
|CPR
|CPR
|
|
|-
|-
|AdUsername
|FORNAVNE
|AlternativID
|
|-
|ProtectedGivenName
|PublicRegisteredFirstName
|PublicRegisteredFirstName
|
|
|-
|-
|ProtectedSurname
|EFTERNAVN
|PublicRegisteredSurName
|PublicRegisteredSurName
|
|
|-
|-
|Email
|CPR
|WorkMail
|BirthDay
|
|First 6 characters if valid CPR
|-
|PhoneNumber
|WorkPhoneNumber
|
|-
|MobileNumber
|MobilePhone
|
|-
|MobileNumber
|WorkMobilePhone
|
|-
|PrivatePhoneNumber
|PrivateMobilePhone
|
|-
|JobTitle
|Employee_Description
|
|-
|-
|Department ID
|P_Adresse1
|DepartmentID
|
|-
|Department Name
|Department
|
|-
|AddressLine
|Adresse
|Adresse
|
|
|-
|-
|PostalCode
|P_PostNr
|PostNummer
|PostNummer
|
|
|-
|-
|Place
|P_PostDistrikt
|Sted
|Sted
|
|
|-
|-
|CareOfAddressLine
|vaerdi
|COAddress
|MobilePhone
|
|from rag_personinfo where tlftype = 'Mobil'
|-
|vaerdi
|PrivateMail
|from rag_personinfo where type = 1
|-
|-
|ProtectedNameAndAddress
|adr_beskyttet_ja_nej
|SecretAddress
|SecretAddress
|
|
|-
|-
|Department ID
|admenhed_id
|AktivitetsID
|DepartmentID
|
|
|-
|-
|Department Name
|kode
|Aktivitet
|DepartmentCode
|
|
|-
|-
|Department Name
|admenhed
|ActivityDisplayName
|Department
|
|-
|Department Name
|ActivityDescription
|
|
|-
|-
|Department Name
|fra_dato
|Kort_Betegnelse
|
|-
|EmploymentStartDate
|StartDato
|If department start date is after employment start date then department start date is used if not then employment start date is used
|-
|EmploymentResignationDate
|SlutDato
|If department end date is before employment resignation date then department end date is used if not then employment resignation date is used
|-
|Department ValidFrom
|Aktiviteter_StartDato
|
|-
|Department ValidTo
|Aktiviteter_SlutDato
|
|-
|EmploymentStartDate
|Employement_StartDate
|
|-
|EmploymentResignationDate
|Employement_EndDate
|
|-
|AreasOfResponsibility.Name
|Education_ResponsibilityAreaName
|Used by EducationalProgrammes
|-
|School code
|ExtraField1
|
|}
{| class="wikitable"
|+
Students
!Admin system
!UMS
!Remarks
|-
|Students ID
|UMS_IDFromAdministrativeSystem
|
|-
|Students ID
|IDFromAdministrativeSystem
|
|-
|GivenName
|Fornavn
|
|-
|Surname
|EFTERNAVN
|
|-
|CivilRegistrationNumber
|CPR
|
|-
|AdUsername
|StudieNr
|
|-
|ProtectedGivenName
|PublicRegisteredFirstName
|
|-
|ProtectedSurname
|PublicRegisteredSurName
|
|-
|Email
|PrivateMail
|
|-
|PhoneNumber
|PrivateMobilePhone
|
|-
|PhoneNumber
|MobilePhone
|
|-
|StudyStartDate
|StudyStart_Education
|StudyStart_Education
|
|Not extracted with rowtype goups
|-
|-
|StudyEndDate
|til_dato
|StudyEnd_Education
|StudyEnd_Education
|
|Not extracted with rowtype goups
|-
|-
|StudyExpectedCompletionDate
|uddannelses_id
|Expected_EducationEndDate
|EducationID
|
|Not extracted with rowtype goups
|-
|-
|Department ID
|kode
|DepartmentID
|EducationCode
|
|Not extracted with rowtype goups
|-
|-
|Department Name
|navn
|Department
|Education
|
|Not extracted with rowtype goups
|-
|AddressLine
|Adresse
|
|-
|-
|PostalCode
|bekendtgoer_titel
|PostNummer
|EducationDescription
|
|Not extracted with rowtype goups
|-
|Place
|Sted
|
|-
|CareOfAddressLine
|COAddress
|
|-
|-
|ProtectedNameAndAddress
|kortnavn
|SecretAddress
|EducationDescriptionShort
|
|Not extracted with rowtype goups
|-
|-
|DepartmentEducation ID
|uddannelsestype
|EducationDepartmentID
|EducationType
|
|Not extracted with rowtype goups
|-
|-
|DepartmentEducation Name
|STATUS
|EducationDepartmentname
|EducationStatus
|
|RAG_STUD_UDDRAMM
Not extracted with rowtype goups
|-
|-
|Student Studies EducationId
|aktgrp_kode
|EducationID
|EducationGroupCode
|
|bes_aktivitetsgrp
Not extracted with rowtype goups
|-
|-
|Student Studies EducationName
|uddannelses_id
|Education
|EducationDirection
|
|Not extracted with rowtype goups
|-
|-
|Student Studies EducationVersion
|studieretn_kode
|EducationVersion
|EducationDirectionShort
|
|Not extracted with rowtype goups
|-
|-
|Student Studies Coesa
|studieretning
|EcucationCode
|EducationDirectionDescription
|
|Not extracted with rowtype goups
|-
|-
|Student Studies DsDepartmentNumber
|uddannelses_id
|Skolekode
|EducationDirectionVersion
|
|Not extracted with rowtype goups
|-
|-
|Student Studies Type Name
|udb_aarsag_kode
|EducationStudentStudyType
|DepartureCauseCode
|
|
|-
|-
|Guardian information
|tekst
|Guardian information
|DepartureCause_Description
|This is copied to the guardian fields in UMS
|-
|EducationId
|Activity_EducationID
|From education on EducationalProgrammes
|-
|EducationCoesaNumber
|Activity_Education
|From education on EducationalProgrammes
|-
|EducationVersion
|Activity_EducationVersion
|From education on EducationalProgrammes
|-
|EducationName
|Activity_EducationDescription
|From education on EducationalProgrammes
|-
|Name
|Activity_EducationDescriptionShort
|From education on EducationalProgrammes
|-
|School code
|ExtraField1
|
|
|-
|-
|studyEndCauseCode
|forkortelse
|DepartureCauseCode
|DepartureCause_Short_Description
|
|
|-
|-
|studyEndCause
|NATIONALITET
|DepartureCause_Description
|Nationality
|
|
|-
|-
|studyCancellationCauseCode
|KOEN
|DepartureCause_Short_Description
|Gender
|
|
|}
|}
{| 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"
|+Extra fields when extracting students with rowtype<br>EducationProgram
|+Extra fields when extracting students with rowtype<br>Groups
!Admin system
!Admin system
!UMS
!UMS
!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 422: Line 261:
|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
|
|
Line 441: Line 284:
===Template criteria mapping===
===Template criteria mapping===
{| class="wikitable"
{| class="wikitable"
|+Employees
|+Students
!Admin system
!Admin system
!UMS
!UMS
Line 447: Line 290:
!Remarks
!Remarks
|-
|-
|Institutions kode
|Education code
|School Code
|EducationCode
|
|
|-
|Afdelings navn
|Department
|
|
|
|
|-
|-
|Ansvarsområde
|Education group code
|Responsibility area
|EducationGroupCode
|
|
|
|
|}
{| class="wikitable"
|+Students
!Admin system
!UMS
!Picture from admin system
!Remarks
|-
|-
|Institutions kode
|Department code
|SchoolCode
|DepartmentCode
|
|
|
|
|-
|-
|Afdelings navn
|Activity department code
|Department
|ActivityDepartmentCode
|
|
|
|
|-
|-
|Uddannelses kode
|Group comment
|COSA_FORMAL
|
|
|-
|Uddannelsesforløbs kode
|ActivityDisplayName
|ActivityDisplayName
|
|
|
|Is only used when extracting groups (Rows with rowtype Groups)
|-
|Ansvarsområde
|Education_ResponsibilityAreaName
|
|
|-
|Uddannelsesområde (udennalsesforløb)
|Activity_Education
|
|
|-
|Uddannelses navn
|Education
|
|Student and Bridging student differs
|}
|}

Latest revision as of 06:52, 3 September 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
NATIONALITET Nationality
KOEN Gender
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=5329"