edu_wh v0.4.0

Migration guide

• In your stadium repo, add contacts and student_contact_associations to dbt/models/staging/src_edfi_3.yml
  • example snippets:

 - name: contacts
    description: > 
      This entity represents a contact of a student, such as a parent, guardian or caretaker.
    enabled: true
    columns: *column_defaults

  - name: student_contact_associations
    description: >
      This association relates students to their parents, guardians, or caretakers.
    enabled: true
    columns: *column_defaults

• Snowflake admin, run this DDL to create the new raw tables:

use role sysadmin;

-- FIRST, confirm ods_verson and data_model_version are included in your _template tables (should have been updated on previous upgrade migration)
-- alter table dev_raw.edfi3._template_table
-- add ods_version varchar, data_model_version varchar;

-- alter table raw.edfi3._template_table
-- add ods_version varchar, data_model_version varchar;

create or replace table dev_raw.edfi3.contacts 
like dev_raw.edfi3._template_table;

create or replace table dev_raw.edfi3.student_contact_associations 
like dev_raw.edfi3._template_table;

create or replace table raw.edfi3.contacts 
like raw.edfi3._template_table;

create or replace table raw.edfi3.student_contact_associations 
like raw.edfi3._template_table;

• Search your stadium repo for any uses of dbt_utils.surrogate_key() - these must be updated to dbt_utils.generate_surrogate_key() to be compatible with new version of dbt_utils that is now installed by edu_edfi_source
• Search your stadium repo for any references to stg_ef3__staff__races and replace with stg_ef3__staffs__races to be compatible with change in edu_edfi_source
• Bump the versions of the following in packages.yml (the ext packages in these versions are needed for the dbt utils upgrade):

 - package: edanalytics/edu_wh
   version: [ ">=0.4.0", "<0.5.0" ]

 - package: edanalytics/edu_ext_one_roster
   revision: 0.2.0

 - package: edanalytics/edu_ext_podium
   revision: 0.5.0

What's Changed

• add missing fk declarations by @ejoranlienea in #123
• fix model name in grad plan docs by @ejoranlienea in #140
• Feature/Include Contacts and Parents data in parent tables due to Ed-Fi rename by @sleblanc23 in #142
• fix stu-school-att unique test by @rlittle08 in #144
• Feature/new DS5 optional fields on staff by @sleblanc23 in #147
• New DS5 optional fields for dim_course_section by @johncmerfeld in #150
• Feature/dim course section custom fields by @rlittle08 in #149
• add cohort year in dim_student by @keenzarate213 in #141
• fix missing commas in constraints by @rlittle08 in #153
• Update staff__races to staffs__races by @tomreitz in #151
• Update to dbt_utils 1.0+ (1.3.0) by @gnguyen87 in #143
• Add PR template by @rlittle08 in #127
• Bump/0.4.0 by @rlittle08 in #154

New Contributors

• @gnguyen87 made their first contribution in #143

Full Changelog: 0.3.4...0.4.0

edu_wh v0.3.4

What's Changed

• fix annualized grouping in wide sch networks by @rlittle08 in #146

Full Changelog: 0.3.3...0.3.4

edu_wh v0.3.3

What's Changed

• Fix: Add 'Unknown' race to bld_ef3__stu_race_ethnicity by @johncmerfeld in #128
• rework pivot macro by @ejoranlienea in #124
• docs note on special education program by @rlittle08 in #133
• docs for stu-section by @rlittle08 in #136
• add fks to dim_course by @rlittle08 in #135
• Feature/dim graduation plan by @rlittle08 in #134
• add earned_additional_credits in fct_course_transcript by @keenzarate213 in #131
• create fct_student_diploma by @keenzarate213 in #130
• feature/fct_table_extensions by @rlittle08 in #132
• Fix source of k_student in bld_ef3__stu_race_ethnicity by @johncmerfeld in #138
• Bugfix/combine gpas by @rlittle08 in #137
• Bump/0.3.3 by @rlittle08 in #139

New Contributors

• @johncmerfeld made their first contribution in #128
• @keenzarate213 made their first contribution in #131

Full Changelog: 0.3.2...0.3.3

edu_wh v0.3.2

What's Changed

• Add has_hispanic_latino_ethnicity to dim_student by @ryanaguilar in #117
• docs/daily_att_grain_update by @rlittle08 in #114
• remove is_latest_record from dim_subgroup by @rlittle08 in #116
• measure attendance freshness by school by @ejoranlienea in #110
• Feature/custom override grade level by @jayckaiser in #113
• make stu display name sql configurable by @rlittle08 in #119
• Feature/assessment sy by @jalvord1 in #118
• bugfix/group_by_snowflake_bug by @rlittle08 in #122
• changelog and dbt project version bump - 0.3.2 by @rlittle08 in #121

Full Changelog: 0.3.1...0.3.2

edu_wh v0.3.1

What's Changed

• staff race_ethnicity by @rlittle08 in #108

Full Changelog: 0.3.0...0.3.1

edu_wh v0.3.0

What's Changed

• standardize esc naming by @ejoranlienea in #86
• Add integer grade level column by @susanxiong in #77
• Student academic records - k_student updates by @sleblanc23 in #95
• Bugfix/attendance unique key by @rlittle08 in #91
• fix/historic assessments by @rlittle08 in #100
• Feature/discipline updates by @jalvord1 in #75
• comments in value tests by @rlittle08 in #101
• add feature to remove xyear enrollments by @ejoranlienea in #102
• add historic rule for for stu obj assess by @rlittle08 in #103

Full Changelog: 0.2.10...0.3.0

edu_wh v0.2.10

What's Changed

• Hotfix/0.2.9 by @jayckaiser in #99

Full Changelog: 0.2.9...0.2.10

edu_wh v0.2.9

What's Changed

• choose latest entry date rather than longest by @ejoranlienea in #94
• add most recent indicator by @ejoranlienea in #98
• add extensibility to course and class period by @ejoranlienea in #97
• docs/fct_student_assessment by @sleblanc23 in #96
• deprecate rls schema in favor of extensions by @ejoranlienea in #90

Full Changelog: 0.2.8...0.2.9

edu_wh v0.2.8

What's Changed

• Allow custom source for student daily attendance by @susanxiong in #84
• Build/Learning standards Models by @AngelicaLastra in #76
• Feature/add warehouse models for cohorts by @sleblanc23 in #78

New Contributors

• @AngelicaLastra made their first contribution in #76

Full Changelog: 0.2.7...0.2.8

edu_wh v0.2.7

What's Changed

• add configurable stu-program-agg columns by @rlittle08 in #73
• Add incident_time to dim_discipline_incidents. by @jayckaiser in #74
• feature/multiple_calendar_event_codes by @jayckaiser in #80
• immutable student demographics by @ejoranlienea in #64
• Feature/optional filter early exits by @rlittle08 in #79
• Enable/disable sped primary disability model based on sped program flag by @susanxiong in #82
• Update _edfi_3__students.yml by @ejoranlienea in #85
• version bump by @ejoranlienea in #87

Full Changelog: 0.2.6...0.2.7