AdminServers/Fguplaner
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 |