addressassess

Table: addressassess

Purpose: Keeps track of addresses by changing the states.  

Key columns:

• Ident (big 20) AI PK
• UID (bigin 20) 
• dte (datetime)
• type (varchar 50)
• status (varchar 20)

Notes:

UID looks to be the Employee ID, so this makes sense if staff is making alterations to keep track of a revision history.  Records are never deleted.

status

• active
• Update
• Deletion

type

• PRIMARY
• LORTON CHANGED
• PRIMARY NEW
• RETURNED NEWSLETTER
• RETURNED NEWSLETTER LORTON CHANGED NEW
• BAD
• PRIMARY LORTON CHANGED NEW
• LORTON CHANGED NEW
• LORTON
• SUBJECT REPORTED
• BAD LORTON CHANGED NEW
• NULL
• deletenow
• NEW PRIMARY
• NEWSLETTER RETURNED
• PRIMARY DUPLICATE
• LORTON CHANGED LORTON CHANGED NEW
• PRIMARY1
• TRACING UPDATE
• SECONDARY
• BAD ARHS
• SECONDARY LORTON CHANGED NEW
• "Blank"