...
AVS stores the street number suffix in a char(1) - therefore the change notification messaging has a bug.
This is potentially a difficult issue because a number legacy systems and reports rely on this char(1) field.
http://sfgovdt.jira.com/browse/MAD-122
Unit
Let's go right to an example.
"100 Main St. Apartment A"
In this example "Apartment" is the unit type and "A" is the Unit Number.
Other examples include:
"100 Main St. Suite 100"
"100 Main St. Basement"
"100 Main St. #3"
...
The problem we will run into is, again, in the change notification, where AVS and EAS store the data differently as shown above.
At the moment, I suspect AVS will stack trace when it tries to take an EAS unit_num (char) and put it into its unit number (numeric) field.
http://sfgovdt.jira.com/browse/MAD-171
See the issue and the attachment for all the details.
In summary EAS has unit_nums such as:
- 1
- A1
- 1A
- A
Summary
We'll have to look at each integration issue as it comes up and study the legacy system(s) carefully before we even propose solutions.
I guess that part is obvious.
...