Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add STT_CODE (or location information) to tanf/tribal t1-t7 and m1-m7 records in the django admin #2796

Closed
3 tasks
ADPennington opened this issue Dec 29, 2023 · 1 comment
Assignees
Labels
dev DUPE possible duplicate Parity Work associated with TDP Parity Refined Ticket has been refined at the backlog refinement

Comments

@ADPennington
Copy link
Collaborator

ADPennington commented Dec 29, 2023

Description

TDRS stores the state_fips (for states and territories) and tribe_code (for tribes) from the header record with each data record (T1,...T7,M1,...,M7) in the db. This helps OFA analysts understand which STT is associated with each record. See example below of the T6 db table from TDRS.

T6_sttcode

This is currently not happening in TDP. This ticket was created in response to the comment below:

@ADPennington I updated based on your review. I think all the validator changes should live in those tickets you called out. That way we can update all sections for programs in one go. I would also like to make the fips_code/tribe_code addition to the models/documents it's own ticket. Adding those to the models that are missing them will create a new migration. The migration generated will be a big one since it will have to impute a new column and value for the DB tables that don't have it. Those tables are pretty big which will cause a reasonably long running migration.

Originally posted by @ADPennington in #2742 (comment)

Acceptance Criteria

  • perform a category 1 (pre-check) to ensure the submitted file location (STT_CODE) matches what is provided in the file header
  • work with @ADPennington to design a query pulling most recent submissions in a given section for all stts

Tasks

  • tbd

Notes

  • relevant to all sections of TANF, SSP, and Tribal TANF.
  • file pre-check error if the submission stt_code (in the file header) does match the stt code for the location in the db
    • then a db association can be made between the record and the stt, avoiding having to store header data alongside each record
      • association already exists between datafile and record, datafile and stt. can use existing relationship to perform stt lookup
        - if storing the data alongside each record is necessary, would require more parser/model changes
        - migrations? how to fill data for previous submissions
  • doubly nested field queries in elastic?

Supporting documentation

@jtimpe jtimpe changed the title Add STT_CODE to T1--T7 and M1--M7 records Add STT_CODE (or location information) to tanf/tribal t1-t7 and m1-m7 records in the django admin Jan 2, 2024
@jtimpe jtimpe added the Refined Ticket has been refined at the backlog refinement label Jan 9, 2024
@robgendron robgendron added the Parity Work associated with TDP Parity label Mar 26, 2024
@atrimpe atrimpe self-assigned this Apr 3, 2024
@robgendron robgendron added the DUPE possible duplicate label Apr 12, 2024
@ADPennington
Copy link
Collaborator Author

captured in #2915

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
dev DUPE possible duplicate Parity Work associated with TDP Parity Refined Ticket has been refined at the backlog refinement
Projects
None yet
Development

No branches or pull requests

4 participants