blank program_num_required_courses in int__mitxonline__program_requirements for new series program

[rachellougee]

A few Series programs are recently added to MITx Online https://mitxonline.mit.edu/admin/courses/program/. These programs contain only required courses, which should reflect as program_num_required_courses in int__mitxonline__program_requirements.

However, program_num_required_courses are all blank where program_id in (4,5,6,7,8,9) in int__mitxonline__program_requirements, which failed dbt test. These programs should not have blank required courses.

Failure in test not_null_int__mitxonline__program_requirements_program_num_required_courses (models/intermediate/mitxonline/_int_mitxonline__models.yml)
  Got 27 results, configured to fail if >10

Expected Behavior

All programs should have program_num_required_courses in int__mitxonline__program_requirements

Current Behavior

Blanks program_num_required_courses in int__mitxonline__program_requirements for new Series programs

select program_num_required_courses 
from ol_warehouse_production_intermediate.int__mitxonline__program_requirements
where program_id in (4,5,6,7,8,9)

[rachellougee]

This bug has blocked some downstream models from being updated e.g. int__mitxonline__courserunenrollments hasn't had new rows since 2023-12-22, so I will work on fixing it