int__micromasters__program_certificates doesn't include the new DEDP program under older requirement

[rachellougee]

Description/Context

There are 6 program certificates added to backfill learners who earned a certificate under older DEDP requirements. This new DEDP program is not live, but it should count for DEDP program certificate and added in int__micromasters__program_certificates.

To fix it, we need to adjust the code here for determining is_dedp_program andis_micromasters_program as currently its hardcoded as program_id= 1 and 2.

• For is_micromasters_program, we can use raw__mitxonline__app__postgres__courses_program.program_type
• For is_dedp_program, we probably can check DEDP string in program readable ID -program-v1:MITx+DEDP, program-v1:MITx+DEDP-Public-Policy and program-v1:MITx+DEDP+2T2023 but need to confirm

Plan

• Add program_type to stg__mitxonline__app__postgres__courses_program and intermediate models
• Update int__mitx__programs to make sure all the micromasters programs are in this table with the correct is_dedp_program and is_micromasters_program flags
• Make sure 6 certificates that Anna added for program-v1:MITx+DEDP+2T2023 are populated into int__micromasters__program_certificates

[rachellougee]

@collinpreston @jkachel program_type was added to Program model a few month ago but it was never added to our data platform. Now we have need for this data, could one of you add that to https://github.com/mitodl/ol-data-platform/blob/main/src/ol_dbt/models/staging/mitxonline/stg__mitxonline__app__postgres__courses_program.sql?