All the MicroMasters program data should flow into int__micromasters__* tables #916
Description
Description/Context
Currently, DEDP program data are in int__micromasters__* tables. But any non DEDP program will not be in these MicroMasters intermediate tables, so it would require code changes if any new MicroMasters program added to MITx Online database in the near future.
Since we've added program_type in raw__mitxonline__app__postgres__courses_program, which identify any MicroMasters program. We should be able to modify these subqueries to include all MicroMasters programs, not just DEDP.
Plan/Design
All MicroMasters program data should be in these tables
- int__micromasters__course_certificates
- int__micromasters__course_grades
- int__micromasters__program_certificates