Tables [dbo].[Person_Address_History]
Address History for a person
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Person_Address_History_ID_AddressType_ChangeDTTM: ID\AddressType\ChangeDTTMForeign Keys FK_Person_Address_History_ID_Person_ID: [dbo].[Person].IDIDnumeric(16,0)9NOT NULLPerson. Link to Person.ID.
Cluster Primary Key PK_Person_Address_History_ID_AddressType_ChangeDTTM: ID\AddressType\ChangeDTTMAddressTypevarchar(10)10NOT NULLAddress type - Mailing/Work/Home
AddressLine1varchar(40)40NOT NULLFirst street address line
AddressLine2varchar(40)40NOT NULLSecond street address line
Cityvarchar(35)35NOT NULLCity
Statevarchar(15)15NOT NULLState 2 digit Abbreviation
ZipCodechar(10)10NOT NULLZip Code
ZipCodeInternationalvarchar(14)14NOT NULLInternational Zip Code
Countryvarchar(30)30NOT NULLCountry
Countyvarchar(35)35NOT NULLCounty
SupplementalAddressvarchar(255)255NULL allowedSupplemental Address ( Ex. Post Box Number)
StartDatedatetime8NULL allowedAddress Start date
EndDatedatetime8NULL allowedAddress End date
Cluster Primary Key PK_Person_Address_History_ID_AddressType_ChangeDTTM: ID\AddressType\ChangeDTTMChangeDTTMdatetime8NOT NULLAddress History Added Date and time (Address Changed Date time )