The Episodes table in OData provides information on all programmes and subprogrammes assigned to a learner – this includes current and historic Aptem programmes.
Filtering the Episodes table using: ProgramType=SubProgramme provides a list of all subprogrammes assigned to at least one learner.
To identify which programmes and subprogrammes a learner is currently assigned to involves the following steps:
- Use a lookup for the LearnerId against the Id on the Users table to add the UserProgram_ProgramId field (the learner’s current programme) to the Episodes table.
- Filter the Episodes table where either the Episodes[ProgramId] or the Episodes[ParentProgramId] matches the current program id from the Users table.