Skip to content

Updating Contention Classification Lookup Tables

Luke Short edited this page Jul 3, 2024 · 3 revisions

Getting the lookup table updated

What?

  • Lookup tables are created in Python to convert user inputs to classifications
  • these classifications are included downstream for use by VSRs/RVSRs to aid in exam selection for veterans' claims.
  • Design folks update these mappings in google sheets and when ready-for-release, the appropriate .csv file is exported for use in the API

Submitting Updates

  • Please make updates to the lookup table in a separate PR without any additional changes to application logic!
  • Ensure the title of the PR indicates that the lookup table is being updated and include the version number
  • this will make sure that users can see the lookup table updates from the releases section on github!

Spreadsheet Versioning

  • There are three sheets used for tracking coverage of VA.gov 526 claims
    • Suggested Conditions HERE
    • Contention Text Lookup HERE
    • DC Lookup HERE
  • version # for which version of mappings are in use is in table_versions.py
  • Mappings were previously recorded HERE (retired).
  • There are different sheets available for different versions.

Locking

Make sure the latest version intended for release has been "locked" so no further edits can be made to the sheet. Screenshot 2023-06-15 at 2 25 06 PM

Export the desired sheet as .csv

Github

Make sure the .csv filename follows the file format

"Contention Classification Diagnostic Codes Lookup table master sheet - DC Lookup {{ TABLE_VERSION }}.csv"

Add the new .csv file to domain-cc/cc-app/src/python_src/util/data

Update table_version.py to include the updated version number

If the CI passes, you should be good-to-go! Have a great day 💫

Clone this wiki locally