A list of known errors in HIFIS_ClientHistoryChanges for Last Known City

• No record is created for the first city record

• When you add a backdated Housing History record, for example, one that says the client moved in last week, the date of change is today

• If you edit a current/most recent Housing History record and change the city, the previous city's value remains in the history of changes and a new record is created (this may be intentional)

• If you edit an older Housing History record (not the most current) and change the city, the record in HIFIS_ClientHistoryChanges does not update

• If you delete a Housing History record, the record of the client living there stays

• If you add a Housing History record with a city, it adds a record. If you edit the Housing History record and remove the city, the record stays AND a new record gets added for the previous city