AdminServers/Fguplaner: Difference between revisions
| Line 170: | Line 170: | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|+Extra fields when extracting students with rowtype<br> | |+Extra fields when extracting students with rowtype<br>HomeGroup | ||
!Admin system | !Admin system | ||
!UMS | !UMS | ||
!Remarks | !Remarks | ||
|- | |- | ||
|navn | |navn | ||
| | |HomeGroupName | ||
|From stays | |||
| | |||
|- | |- | ||
| | | | ||
| Line 203: | Line 183: | ||
|True | |True | ||
|- | |- | ||
| | |start_date | ||
|StartDato | |StartDato | ||
| | |From stays | ||
|- | |- | ||
| | |end_date | ||
|SlutDato | |SlutDato | ||
| | |From stays | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|+Extra fields when extracting students with rowtype<br> | |+Extra fields when extracting students with rowtype<br>EducationModule | ||
!Admin system | !Admin system | ||
!UMS | !UMS | ||
!Remarks | !Remarks | ||
|- | |- | ||
| | | | ||
| Line 257: | Line 201: | ||
|True | |True | ||
|- | |- | ||
| | |start_date | ||
|StartDato | |StartDato | ||
| | |From Education module attendance | ||
|- | |- | ||
| | |end_date | ||
|SlutDato | |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 | ||
|} | |} | ||
Revision as of 12:31, 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.
Data mapping
| 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 |
| Admin system | UMS | Remarks |
|---|---|---|
| navn | HomeGroupName | From stays |
| Aktivitet_LMS | True | |
| start_date | StartDato | From stays |
| end_date | SlutDato | From stays |
| 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
| Admin system | UMS | Picture from admin system | Remarks |
|---|---|---|---|
| institution_number | ActivityDepartmentCode | ||
| School name | DepartmentCode | ||
| Education | Education |