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

[FEATURE] Allow Statewide Officer IDs to be recorded in the Index. #313

Closed
DMalone87 opened this issue Jan 3, 2024 · 0 comments · Fixed by #314
Closed

[FEATURE] Allow Statewide Officer IDs to be recorded in the Index. #313

DMalone87 opened this issue Jan 3, 2024 · 0 comments · Fixed by #314
Assignees
Labels
enhancement New feature or request

Comments

@DMalone87
Copy link
Collaborator

Is your feature request related to a problem? Please describe.
One critical function of the system is identifying officers even as they move between different agencies during their careers. While our current schema allows the tracking of badge numbers, these are not enough on their own. Badge numbers are unique within a single department at a particular time, but may be shared by multiple officers over time or when considering the nation as a whole.

To deal with this, some states employ a statewide ID system that allows for tracking individual officers within the state. For example, New York uses Tax ID numbers and the Texas Commission of Law Enforcement (TCOLE) assigns each officer a PID number. We should enable our database to properly track these numbers.

Describe the solution you'd like
We should add a field to the officer and perpetrator schemas that allow us to track Statewide officer IDs. We should consider that the same officer may have multiple state IDs if they have been employed in multiple states.

Additional context
The first set of counties we'll be releasing the Index for will be in Texas and New York. This needs to be completed before the web scraper micro service is implemented.

@DMalone87 DMalone87 added the enhancement New feature or request label Jan 3, 2024
@DMalone87 DMalone87 self-assigned this Jan 3, 2024
@DMalone87 DMalone87 linked a pull request Jan 4, 2024 that will close this issue
DMalone87 added a commit that referenced this issue Jan 7, 2024
* Adds a StateID model as a child of the officer table. This allow the index to track statewide Officer IDs such as Tax ID or TCOLE PID numbers.

* Add Enum for State Abbreviations
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant