📍 Rebase cog/over

[danswick]

This is a placeholder for tracking work related to rebasing our cognizant / oversight assignments.

Tasks

Tasks

Beta Give feedback

1. Confirm how we should be determining assignment outside of base years: Investigate cog/over outside base years #3903
2. Create public documentation describing how cog/over assignments are done
3. Analyze AY2024 cognizant assignments #4439
   eng +1
   

[gsa-suk]

Questions related to rebasing:
Added answers for 1 and 2 based on discussion with @danswick on 11/01/24

1. Current base year is 2019. When does the base year change to 2024? - 2024 audit year.
2. How far can re-submissions go? Do multiple base years have to be supported by FAC? - Yes (for now. Verify with OMB)
3. Base years are 2019, 2024 and every fifth year thereafter.
   For base year of 2019, cog assignment year range is 2021 - 2025, based on data in cogreflist.csv from Census.
   Is the cog assignment year correct?
   What does it mean?
   What is the cog assignment year range associated with base year 2024 and future base years?
4. What are the changes to the current algorithm / flowchart?
5. Will the cog_ref_list for 2024 base year and future base years be provided or calculated by GSAFAC?

[danswick]

Capturing some notes from discussion with @gsa-suk and @gsa-jrothacker:

1. Let's explore capturing all the business logic in code rather than in tables. If we can jettison both the assignment tables, let's do it and rely on the submission record itself.
2. If the above looks good, we should be able to write more complete unit tests for COG / OVER assignment.
3. The rest of the assignment logic should still be valid (the flowchart).
4. I think there was one more thing, but it's escaping me.

[gsa-suk]

The audit_year, baseline year mapping is as follows:
<style type="text/css"></style>

audit_year	base_year
2019	2019
2020	2019
2021	2019
2022	2019
2023	2019
2024	2024
2025	2024
2026	2024
2027	2024
2028	2024
2029	2029
2030	2029
2031	2029
2032	2029
2033	2029
2034	2034
2035	2034
2036	2034
2037	2034
2038	2034
2039	2039
2040	2039
2041	2039
2042	2039
2043	2039
....