In de EDU-DEX feed kunnen veel verschillende velden worden gebruikt om informatie door te zetten naar het opleidersportaal van Studytube. In deze FAQ geven we een overzicht van alle velden die wij ophalen uit EDU-DEX. Hierbij wordt aangegeven welke velden verplicht zijn en in de notities vind je extra informatie over het veld.


TableFields
EDU-DEX node(s)Notes
classroom_trainings
external_idprogramClassification/programId*Each /program must have a unique /programId
classroom_trainings
titleprogramDescriptions/programName
Max. 99 characters
classroom_trainings
description
programDescriptions/programDescriptionHtml
Subjects: description, student profile, objectives, characteristics, graduation, admission, library
programDescriptions/programDescriptionText
programDescriptions/subjectText/descriptionHtml
programDescriptions/subjectText/descriptionText
classroom_trainings
programprogramDescriptions/subjectText/descriptionHtml
Subjects: program guide, curriculum, course schedule, program start
programDescriptions/subjectText/descriptionText
classroom_trainings
durationprogramClassification/programDuration

You can only use either both of these fields or none of them.

having one filled and another one empty is not allowed

classroom_trainings
duration_unitsprogramClassification/programDuration@unit

Sets to 'flexible' if there is no live sessions data ('//programRun') or if provider configured to import only flexible trainings

otherwise sets to 'scheduled'

classroom_trainings
schedule_type
Sets to 'flexible' if there is no live sessions data ('//programRun') or if provider configured to import only flexible trainings
otherwise sets to 'scheduled'
classroom_trainings
priceprogramSchedule/(generic)programRun/cost:tuition_fee/amount*

For each training, there must be a cost node with costType "tuition fee"!

VATExemptAmount is used if provider is configured as vat_free

programSchedule/(generic)programRun/cost:tuition_fee/VATExemptAmount*
classroom_trainings
vatprogramSchedule/(generic)ProgramRun/cost:tuition_fee/amountVAT

VAT percent (amountVat / amount * 100) must be one of the following: 0, 9, 21.


If this node is empty, vat value defaults to 0


VATExemptAmountVAT is used if provider is configured as vat_free

programSchedule/(generic)ProgramRun/cost:tuition_fee/VATExemptAmountVAT
classroom_trainings
certificateprogramClassification/degree
If value of this node equals "certificate", set to true, otherwise false.
classroom_trainings
languageprogramCurriculum/instructionLanguage/languageCode

Must be one of: nl, en, fi, pl, ru, fy, de, es, fr, sv, tr, pt, ro, ar, it, sk, hu, be, el, da, no, zh, ja

default: nl

classroom_trainings
target_education_levelprogramAdmission/requiredLevelMapping: 'bachelor' => 'HBO', 'academic bachelor' => 'WO', 'mbo' => 'MBO'
classroom_trainings
min_participantsprogramAdmission/minNumberOfParticipants
Must be greater or equal to 0. must be less than maxNumberOfParticipants
classroom_trainings
max_participantsprogramAdmission/maxNumberOfParticipants
Must be greater or equal to 0 and must be greater than maxNumberOfParticipants
classroom_trainings
required_user_fields
Default: phone_number, date_of_birth, address, house_number, city
classroom_trainings
training_typeprogramClassification/programType
Default: other
programClassification/programForm
programCurriculum/instructionMode
classroom_trainingsread_only
True for all imported trainings
classroom_trainingsorigin
EDU-DEX for all imported trainings
classroom_trainings
training_provider_category_idprogramClassification/theme
Must be one of the values accepted by the system, default: other
classroom_training_extra_costs
name
programSchedule/(generic)ProgramRun/cost/summaryText**
Max. 255 characters

Must be positive;
VATExemptAmount is used if provider is configured as vat_free;
must be divertable to 0%, 9% or 21%

VATExemptAmountVAT is used if provider is configured as vat_free;
must be divertable to 0%, 9% or 21%
programSchedule/programSchedule/(generic)ProgramRun/cost/costType
classroom_training_extra_costs
amount
programSchedule/(generic)ProgramRun/cost/amount**
programSchedule/(generic)ProgramRun/cost/VATExemptAmount
classroom_training_extra_costs
vat
programSchedule/(generic)ProgramRun/cost/amountVAT**
programSchedule/(generic)ProgramRun/cost/VATExemptAmountVA
classroom_training_live_sessions
external_id
programSchedule/programRun/id*
each /programRun must have a unique /id
classroom_training_live_sessions
unconcluded

set to true if location cannot be determined
classroom_training_live_sessions
city
programSchedule/(generic)programRun/(generic)courseDay/location/
programSchedule/(generic)programRun/(generic)module/location/
programSchedule/(generic)programRun/location/
programClassification/programLocation/city


The first node from this list (except /programClassification/programLocation/city) that is not empty is used to extract location data. Inside this node, we parse the following subnodes:

/city
/address
/locationName
/id
/country
/zipcode

Next, the mapping is:
* city: value of /city
* location_adress: value of /address if present, otherwise /city
* name: contatenated value from all fields mentioned above (location name, address, zip, city, country)

If all nodes from this list are empty, we use /programClassification/programLocation/city to identify live sessions location. In this case address information inside our database will only contain city.
classroom_training_live_sessions
location_address
classroom_training_live_sessions
name
classroom_training_live_sessions
latitude

Uses Google Maps API to find geographical coordinates based on city value
classroom_training_live_sessions
longitude

Uses Google Maps API to find geographical coordinates based on city value
classroom_training_live_sessions
location_place_id

A unique identifier used by Google Maps API
classroom_training_live_sessions
min_participants
programAdmission/minNumberOfParticipants
Must be greater or equal to 0. must be less than maxNumberOfParticipants
classroom_training_live_sessions
max_participants
programAdmission/maxNumberOfParticipants
Must be greater or equal to 0. must be greater than maxNumberOfParticipants
classroom_training_live_sessions
closed
programSchedule/programRun/status
If "canceled" or "application closed" then false
live_session_dates
date
programSchedule/programRun/courseDay/date*


programSchedule/programRun/startDate*

live_session_dates
start_time
programSchedule/programRun/courseDay/startTime
You can only use either both of these fields or none of them. Having one filled and another one empty is not allowed.
live_session_dates
end_time
programSchedule/programRun/courseDay/endTime


* this field is required

** this field is required if extra costs are present