Skip to content

Increase emp_address field to allow 100 characters and remove the code work-around to truncate #196

Open
@nathankota

Description

For background/context:

Our import of the offender data for the Field Map failed due to a record in the data set with an employer_address value that is larger than the max length schema value that was provided when we built our database. Specifically, it failed on:
4568 HIGHLAND DRIVE SUITE #150, MILLCREEK (SALT LAKE UT 8411

From UDC-BOPP Software CP

70 characters would be enough for what we can currently send (there's a bit of concatenation, which I believe is where the issue came from - it looks like our maximum we could send is 63), but because of how the data in our database is truncated due to this field width, it's probably best to build in a bit of padding. 100 characters should ensure future updates / fixes on our side wouldn't cause you issues, without a major change to our systems.

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    • Status

      On Deck

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions