You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
* 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
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.
The text was updated successfully, but these errors were encountered: