edu_edfi_source v0.5.2

What's Changed

Note, this release was originally made on 10/24/25, then was removed and re-added on 11/3/25 to include this fix to previously released breaking change

New features

• Add stg_ef3__student_academic_records__academic_honors to capture academic honors from student academic records
• Updated extract_extension.sql macro to allow for extensions to be defined in the edu_edfi_source dbt_project.yml and enabled per project.
  • And added the tpdm/epdm predefined extension to dbt_project.yml

Fixes

• To fix keys that were triggering faulty dbt test failures:
  • Updated gen_skey.sql macro. Changed the order of k_survey_section column list. Changed survey_section_title from snake case to camel case.
  • Corrected stg_ef3__survey_section_responses.sql model k_survey_section_response variable. previously missing survey_response_id variable.
• • fix for extract_extensions macro bug by @ryanaguilar in #158

New Contributors

• @clairehollisreynolds made their first contribution in #155

Full Changelog: 0.5.1...0.5.2

Context-Specific Release Notes

For Engineers:

• If your implementation uses the TPDM/EPDM Ed-Fi model, you can now bring forward TPDM extensions on core resources (e.g. credentials.credential_status_date) by adding to your project vars: 'src:predefined_extensions:tpdm:enabled': True
• You may see fewer dbt test failures for survey related models

For Data Consumers::

• stg_ef3__student_academic_records__academic_honors is now available

edu_edfi_source v0.5.1

What's Changed

New features

• Add base/stage models base_ef3__student_school_food_service_program_association, stg_ef3__student_school_food_service_program_association, stg_ef3__stu_school_food_service__program_services
• Add base/stage models base_ef3__student_migrant_education_program_associations, stg_ef3__student_migrant_education_program_associations, stg_ef3__stu_migrant_edu__program_services
• Add stg_ef3__students__other_names

Under the hood

• Add k_assessment to stg_ef3__student_assessments__score_results and stg_ef3__student_assessments__performance_levels for use downstream

Fixes

• Fix deduplication logic of stg_ef3__course_transcripts to remove duplicates from across ODS years, by replacing k_course (tied to api_year) with course_code, course_ed_org_id in the deduplication key

New Contributors

• @theokaufman made their first contribution in #152

Full Changelog: 0.5.0...0.5.1

Context-Specific Release Notes

For Data Consumers:

• The fix to stg_ef3__course_transcripts means that once upgraded, you will likely notice fewer records in fct_course_transcripts, as bad duplicates have been removed. You may be able to remove workarounds from downstream processes.
  Additionally, See edu_wh v0.5.1 release notes

edu_edfi_source v0.5.0

What's Changed

New features

• Add Databricks platform compatibility
  • The only potentially breaking change: base_ef3__discipline_incidents.v:incidentTime datatype switched from time to string.
• Add new optional fields in student_education_organization_associations and student_school_associations from Ed-Fi Data Standard v5:
  • stuEdOrg: gender_identity, supporter_military_connection
  • stuSchAssoc: is_school_choice, school_choice_basis, enrollment_type, next_year_school_id, next_year_grade_level

Full Changelog: 0.4.10...0.5.0

Context-Specific Release Notes

For Engineers:

• Make sure to test your Stadium project locally, as this is a minor version bump with potential breaking changes
• Going forward, contributions to edu_edfi_source will need to follow these guidelines for databricks compatibiliity

For Data Consumers:

• Check out the new columns listed above (though, they're likely not yet populated by most Ed-Fi implementations)

edu_edfi_source v0.4.10

Overview

What's Changed

• Fix/Support multiple subjects per course in DS 5.0 by @alchenist in #139
• feature/model_creation_stu_cte_prog_assoc by @mberrien-fitzsimons in #140
• Bump/0.4.10 by @rlittle08 in #141

New Contributors

• @alchenist made their first contribution in #139
• @mberrien-fitzsimons made their first contribution in #140

Copied Changelog

Full Changelog: 0.4.9...0.4.10

New features

• Add base/stage model for StudentCTEProgramAssociation
• Add stage model stg_ef3__stu_cte__program_services to flatten program services list for StudentCTEProgramAssociation

Fixes

• Add handling of multiple academic subjects per course for DS 5.0 compatibility; new stg_ef3__courses__academic_subjects model and new v_academic_subjects columns in base_ef3__courses and stg_ef3__courses models.
• Correctly cast minimum and maximum credits for courses to float instead of int.

Context-Specific Release Notes

For Engineers:

• Check that you don't have duplicate models for StudentCTEProgramAssociation already existing in your Stadium repo
• Check that minimum & maximum credits are not in use with a hard dependency on int data type
• If your project is on DS 5.0+, let data consumers know that new subjects data may be available

For Data Consumers:

• You may have new student CTE program data available in stg_ef3__student_cte_program_associations (warehouse models coming soon)
• If your project is on DS 5.0+, check the output of stg_ef3__courses__academic_subjects (and more importantly, dim_course) for potentially new subjects data

edu_edfi_source 0.4.9

What's Changed

• fix staff sec key for 5.0 and later by @ejoranlienea in #137
• Update CHANGELOG.md by @ejoranlienea in #138

Full Changelog: 0.4.8...0.4.9

edu_edfi_source v0.4.8

What's Changed

• Hotfix/k obj assess key consistency by @rlittle08 in #135
• Bump/0.4.8 by @rlittle08 in #136

Full Changelog: 0.4.7...0.4.8

edu_edfi_source v0.4.7

What's Changed

• Bugfix/extract descriptor skey by @rlittle08 in #132
• Feature/incremental large stg by @rlittle08 in #131
• Feature/Staff Contact Associations Base/Stage by @AngelicaLastra in #127
• k_student_assess needs to include stu unique id by @rlittle08 in #89
• Bugfix/obj assess k assess by @rlittle08 in #130
• Bump/0.4.7 by @rlittle08 in #134

Full Changelog: 0.4.6...0.4.7

edu_edfi_source v0.4.6

What's Changed

• Bugfix/student objective assessment key by @sleblanc23 in #124
• Feature/delete dedupe order by @sleblanc23 in #123
• Bump/046 by @rlittle08 in #125

Full Changelog: 0.4.5...0.4.6

edu_edfi_source v0.4.5

What's Changed

• feature/add stage retraint events models by @AngelicaLastra in #121
• TPDM models by @ejoranlienea in #113
• Update CHANGELOG.md by @ejoranlienea in #122

Full Changelog: 0.4.4...0.4.5

edu_edfi_source v0.4.4

What's Changed

• version bump 0.4.3 by @rlittle08 in #115
• Fix/coalesce obj assess subjects by @rlittle08 in #117
• Bugfix/stu assess timestamp handling by @ejoranlienea in #116
• version bump: 0.4.4 by @rlittle08 in #119

Full Changelog: 0.4.3...0.4.4