You can use the Episodes table in OData. Please note, you can filter by ProgramType=SubProgramme, IsActive=True (if you want active subprogrammes only) and order by ProgramName.

You can also then join this to the Users table should you need the learner names linked to these sub-programmes.