Jump to content

AdminServers/Fguplaner: Difference between revisions

From UmsWiki
← Older edit
Kia@inlogic.dk (talk | contribs)
Bureaucrats, Interface administrators, Administrators
272 edits
VisualWikitext
No edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[File:Adminserver Fguplaner.png|none|thumb|765x765px]]
[[File:Adminserver Fguplaner.png|none|thumb|765x765px]]


===Server===
===Institution number===
DNS address of the Oracle server where the STADS database is stored.
Institution number assigned by the Danish government . This is 6 characters long.


===SID===
===Token===
STADS database name.
This is the access token used to authenticate to the webservices.


===Username===
You need to contact Fguplaner to get an access token.
Oracle Username to access database.
 
===Password===
Oracle Password to access database.


===[[AdminServers/Export Settings|Export settings]]===
===[[AdminServers/Export Settings|Export settings]]===
Line 23: Line 19:
!Remarks
!Remarks
|-
|-
|PERSON_ID
|ID
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|
|
|-
|-
|PERSON_ID
|ID
|IDFromAdministrativeSystem
|IDFromAdministrativeSystem
|
|
|-
|-
|STUDIENR
|ID
|STUDIENR
|STUDIENR
|
|
|-
|-
|first_nickname
|FORNAVNE
|FORNAVNE
|FORNAVNE
|
|Is only filled out if secret address = false
|-
|-
|last_nickname
|EFTERNAVN
|EFTERNAVN
|EFTERNAVN
|
|Is only filed out if secret address = false
|-
|-
|CPR
|CPR
Line 57: Line 53:
|CPR
|CPR
|BirthDay
|BirthDay
|First 6 characters if valid CPR
|First 6 characters
|-
|-
|P_Adresse1
|address
|Adresse
|Adresse
|
|
|-
|-
|P_PostNr
|postal_code
|PostNummer
|PostNummer
|
|
|-
|-
|P_PostDistrikt
|city
|Sted
|city
|
|
|-
|-
|vaerdi
|mobile
|PrivateMobilePhone
|
|-
|mobile
|MobilePhone
|MobilePhone
|from rag_personinfo where tlftype = 'Mobil'
|-
|vaerdi
|PrivateMail
|from rag_personinfo where type = 1
|-
|adr_beskyttet_ja_nej
|SecretAddress
|
|
|-
|-
|admenhed_id
|phone
|DepartmentID
|PhoneNumber
|
|
|-
|-
|kode
|email
|DepartmentCode
|PrivateMail
|
|
|-
|-
|admenhed
|address_protection
|Department
|SecretAddress
|
|
|-
|-
|fra_dato
|start_date
|StudyStart_Education
|StudyStart_Education
|Not extracted with rowtype goups
|Stays
|-
|-
|til_dato
|end_date_final
|StudyEnd_Education
|StudyEnd_Education
|Not extracted with rowtype goups
|Stays
|-
|expected_end_date
|Expected_EducationEndDate
|Stays
|-
|-
|uddannelses_id
|id
|EducationID
|EducationID
|Not extracted with rowtype goups
|Education
|-
|-
|kode
|version
|EducationCode
|EducationVersion
|Not extracted with rowtype goups
|Education
|-
|-
|navn
|name
|Education
|Education
|Education
|Not extracted with rowtype goups
|-
|-
|bekendtgoer_titel
|id
|EducationDescription
|ActivityDepartmentID
|Not extracted with rowtype goups
|Schools
|-
|-
|kortnavn
|institution_number
|EducationDescriptionShort
|ActivityDepartmentCode
|Not extracted with rowtype goups
|Schools
|-
|-
|uddannelsestype
|name
|EducationType
|ActivityDepartmentName
|Not extracted with rowtype goups
|Schools
|-
|-
|STATUS
|institution_number
|EducationStatus
|ActivityDepartmentNumber
|RAG_STUD_UDDRAMM
|Schools
Not extracted with rowtype goups
|-
|-
|aktgrp_kode
|start_date
|EducationGroupCode
|Aktiviteter_StartDato
|bes_aktivitetsgrp
|Stays
Not extracted with rowtype goups
|-
|-
|uddannelses_id
|end_date_final
|EducationDirection
|Aktiviteter_SlutDato
|Not extracted with rowtype goups
|Stays
If end_date_final is null then use expected_end_date
|-
|-
|studieretn_kode
|ID
|EducationDirectionShort
|AktivitetsID
|Not extracted with rowtype goups
|Teams
|-
|-
|studieretning
|abbreviation
|EducationDirectionDescription
|Aktivitet
|Not extracted with rowtype goups
|Teams
|-
|-
|uddannelses_id
|name
|EducationDirectionVersion
|ActivityDisplayName
|Not extracted with rowtype goups
|Teams
|-
|-
|udb_aarsag_kode
|name
|DepartureCauseCode
|ActivityDescription
|
|Teams
|-
|-
|tekst
|name
|DepartureCause_Description
|Kort_Betegnelse
|
|Teams
|-
|-
|forkortelse
|cpr
|DepartureCause_Short_Description
|Activity_Teacher_SSN
|
|Employee
|-
|NATIONALITET
|Nationality
|
|-
|KOEN
|Gender
|
|}
|}
{| class="wikitable"
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>UVA
|+Extra fields when extracting students with rowtype<br>HomeGroup
!Admin system
!Admin system
!UMS
!UMS
!Remarks
!Remarks
|-
|uddelement_id
|AktivitetsID
|
|-
|KODE
|Aktivitet
|
|-
|langtnavn
|ActivityDisplayName
|
|-
|langtnavn
|ActivityDescription
|
|-
|-
|navn
|navn
|Kort_Betegnelse
|HomeGroupName
|
|From stays
|-
|ELEMENTTYPE
|ActivityType
|
|-
|-
|
|
Line 207: Line 174:
|True
|True
|-
|-
|
|start_date
|Activity_LMS_AllowRoll
|True
|-
|fra_dato
|StartDato
|StartDato
|
|From stays
|-
|-
|til_dato
|end_date
|SlutDato
|SlutDato
|
|From stays
|-
|fra_dato
|Aktiviteter_StartDato
|
|-
|til_dato
|Aktiviteter_SlutDato
|
|}
|}
{| class="wikitable"
{| class="wikitable"
|+Extra fields when extracting students with rowtype<br>Groups
|+Extra fields when extracting students with rowtype<br>EducationModule
!Admin system
!Admin system
!UMS
!UMS
!Remarks
!Remarks
|-
|stud_gruppe_id
|AktivitetsID
|
|-
|KODE
|Aktivitet
|
|-
|KOMMENTAR
|ActivityDisplayName
|
|-
|KOMMENTAR
|ActivityDescription
|
|-
|KODE
|Kort_Betegnelse
|
|-
|
|ActivityType
|Class
|-
|-
|
|
Line 261: Line 192:
|True
|True
|-
|-
|
|start_date
|Activity_LMS_AllowRoll
|True
|-
|oprettelsesdato
|StartDato
|StartDato
|
|From Education module attendance
|-
|-
|add_months(sysdate, 1)
|end_date
|SlutDato
|SlutDato
|
|From Education module attendance
|-
|id
|Course_ID
|From Education Modules
|-
|name
|Skolefag
|From Education Modules
|-
|type
|CourseType
|From Education Modules
|-
|-
|oprettelsesdato
|name
|Aktiviteter_StartDato
|Skolefag_Betegnelse
|
|From Education Modules
|-
|-
|add_months(sysdate, 1)
|name
|Aktiviteter_SlutDato
|SkoleFag_Kort_Betegnelse
|
|From Education Modules
|}
|}


Line 290: Line 229:
!Remarks
!Remarks
|-
|-
|Education code
|institution_number
|EducationCode
|ActivityDepartmentCode
|
|
|-
|Education group code
|EducationGroupCode
|
|
|
|
|-
|-
|Department code
|School name
|DepartmentCode
|DepartmentCode
|
|
|
|
|-
|-
|Activity department code
|Education
|ActivityDepartmentCode
|Education
|
|
|
|-
|Group comment
|ActivityDisplayName
|
|
|Is only used when extracting groups (Rows with rowtype Groups)
|}
|}

Latest revision as of 12:39, 19 February 2026

Institution number

Institution number assigned by the Danish government . This is 6 characters long.

Token

This is the access token used to authenticate to the webservices.

You need to contact Fguplaner to get an access token.

Export settings

Data mapping

Students
Admin system UMS Remarks
ID UMS_IDFromAdministrativeSystem
ID IDFromAdministrativeSystem
ID STUDIENR
first_nickname FORNAVNE
last_nickname EFTERNAVN
CPR CPR
FORNAVNE PublicRegisteredFirstName
EFTERNAVN PublicRegisteredSurName
CPR BirthDay First 6 characters
address Adresse
postal_code PostNummer
city city
mobile PrivateMobilePhone
mobile MobilePhone
phone PhoneNumber
email PrivateMail
address_protection SecretAddress
start_date StudyStart_Education Stays
end_date_final StudyEnd_Education Stays
expected_end_date Expected_EducationEndDate Stays
id EducationID Education
version EducationVersion Education
name Education Education
id ActivityDepartmentID Schools
institution_number ActivityDepartmentCode Schools
name ActivityDepartmentName Schools
institution_number ActivityDepartmentNumber Schools
start_date Aktiviteter_StartDato Stays
end_date_final Aktiviteter_SlutDato Stays

If end_date_final is null then use expected_end_date

ID AktivitetsID Teams
abbreviation Aktivitet Teams
name ActivityDisplayName Teams
name ActivityDescription Teams
name Kort_Betegnelse Teams
cpr Activity_Teacher_SSN Employee
Extra fields when extracting students with rowtype
HomeGroup
Admin system UMS Remarks
navn HomeGroupName From stays
Aktivitet_LMS True
start_date StartDato From stays
end_date SlutDato From stays
Extra fields when extracting students with rowtype
EducationModule
Admin system UMS Remarks
Aktivitet_LMS True
start_date StartDato From Education module attendance
end_date SlutDato From Education module attendance
id Course_ID From Education Modules
name Skolefag From Education Modules
type CourseType From Education Modules
name Skolefag_Betegnelse From Education Modules
name SkoleFag_Kort_Betegnelse From Education Modules

Template criteria mapping

Students
Admin system UMS Picture from admin system Remarks
institution_number ActivityDepartmentCode
School name DepartmentCode
Education Education
Retrieved from "https://wiki.inlogic.dk/index.php?title=AdminServers/Fguplaner&oldid=5514"