Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Person_Address_History
Touchworks 25.2
[dbo].[Person_Address_History]
MS_Description
Address History for a person
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
ID
numeric(16,0)
9
NOT NULL
Person. Link to Person.ID.
AddressType
varchar(10)
10
NOT NULL
Address type - Mailing/Work/Home
AddressLine1
varchar(40)
40
NOT NULL
First street address line
AddressLine2
varchar(40)
40
NOT NULL
Second street address line
City
varchar(35)
35
NOT NULL
City
State
varchar(15)
15
NOT NULL
State 2 digit Abbreviation
ZipCode
char(10)
10
NOT NULL
Zip Code
ZipCodeInternational
varchar(14)
14
NOT NULL
International Zip Code
Country
varchar(30)
30
NOT NULL
Country
County
varchar(35)
35
NOT NULL
County
SupplementalAddress
varchar(255)
255
NULL allowed
Supplemental Address ( Ex. Post Box Number)
StartDate
datetime
8
NULL allowed
Address Start date
EndDate
datetime
8
NULL allowed
Address End date
ChangeDTTM
datetime
8
NOT NULL
Address History Added Date and time (Address Changed Date time )