Tip: volg de korte online training "het gebruik van een technische koppeling" in de Provider Academy voor alle informatie omtrent het gebruik van een Edu-dex koppeling.
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.
| Table | Fields | EDU-DEX node(s) | Notes |
| classroom_trainings | external_id | programClassification/programId* | Each /program must have a unique /programId |
| classroom_trainings | title | programDescriptions/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 | program | programDescriptions/subjectText/descriptionHtml | Subjects: program guide, curriculum, course schedule, program start |
| programDescriptions/subjectText/descriptionText | |||
| classroom_trainings | duration | programClassification/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_units | programClassification/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 | price | programSchedule/(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 | vat | programSchedule/(generic)ProgramRun/cost:tuition_fee/amountVAT | VAT amount (amountVat / amount * 100) must correspond with one of the following percentages: 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 | certificate | programClassification/degree | If value of this node equals "certificate", set to true, otherwise false. |
| classroom_trainings | language | programCurriculum/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_level | programAdmission/requiredLevel | Mapping: 'bachelor' => 'HBO', 'academic bachelor' => 'WO', 'mbo' => 'MBO' |
| classroom_trainings | min_participants | programAdmission/minNumberOfParticipants | Must be greater or equal to 0. must be less than maxNumberOfParticipants |
| classroom_trainings | max_participants | programAdmission/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_type | programClassification/programType | Default: other |
| programClassification/programForm | |||
| programCurriculum/instructionMode | |||
| classroom_trainings | read_only | True for all imported trainings | |
| classroom_trainings | origin | EDU-DEX for all imported trainings | |
| classroom_trainings | training_provider_category_id | programClassification/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