Describe the bug
The employment module fails running on year 2025.
To Reproduce
Run the employment module for year 2025. The error is related to the sql/employment/xref_block_to_mgra.sql not returning data after the read_sql_query_fallback() function looks for EDD point level data in 2025 and 2024.
Expected behavior
The EDD point level data is on a similar release and update schedule as the LEHD LODES data, requiring max_lookback=2 parameter to be set in read_sql_query_fallback() as opposed to using the default behavior of a single lookback year. This will allow data from 2023 to be used in year 2025.
Potential resolution
Update all read_sql_query_fallback() uses that reference EDD point level data to pass max_lookback=2.
Describe the bug
The employment module fails running on year 2025.
To Reproduce
Run the employment module for year 2025. The error is related to the
sql/employment/xref_block_to_mgra.sqlnot returning data after theread_sql_query_fallback()function looks for EDD point level data in 2025 and 2024.Expected behavior
The EDD point level data is on a similar release and update schedule as the LEHD LODES data, requiring
max_lookback=2parameter to be set inread_sql_query_fallback()as opposed to using the default behavior of a single lookback year. This will allow data from 2023 to be used in year 2025.Potential resolution
Update all
read_sql_query_fallback()uses that reference EDD point level data to passmax_lookback=2.