SW - License type design/implementation to support both single and multi-state licenses

[landonshumway-ia]

The Social Work compact needs to support both single and multi-state license types. There are three types of licenses:

licensed clinical social worker
licensed master social worker
licensed bachelor social worker

We have several options for distinguishing single and multi-state licenses.

The first option is to define a single and mutli-state license type for each of the three listed above, so for example, under the licenseType field, a state would enter something like the following:
licensed clinical social worker single state
licensed clinical social worker multi-state

Alternatively, we can add another required field that would need to be included when uploading licenses such as licenseScope which can be either single state or multi-state (these values are just examples. They can be set to whatever SW finds best fitting).

There are other options as well that can be considered. This ticket involves defining the final solution for tracking the different single and multi-state license types.

Notes

Questions

Assumptions

Estimate

Tasks

• TODO
• Automated tests
• API Docs
• Postman collection
• PR opened with labels / reviewers / assignee / linked-issue

Implementation Notes

[landonshumway-ia]

We have determined to move forward with adding a new required field, licenseScope, which will have a value of either single-state or multi-state. This will needed to be added to all of our schemas, tests, and OpenSearch index mapping.

[landonshumway-ia]

This change will require updating the DynamoDB sort keys for our license, investigation, and adverse action records to now include the license scope to distinguish single state licenses from multi-state records in the DB.