Information for the NcoaHistory
Columns
Id
(datatype: int) Required Primary Key
PersonAliasId
(datatype: int) Required Primary Key
FamilyId
(datatype: int) Required Primary Key
LocationId
(datatype: int) Required Primary Key
MoveType
(datatype: int) Required Primary Key
NcoaType
(datatype: int) Required Primary Key
AddressStatus
(datatype: int) Required Primary Key
AddressInvalidReason
(datatype: int) Required Primary Key
OriginalStreet1
(datatype: nvarchar(100)) Required Primary Key
OriginalStreet2
(datatype: nvarchar(100)) Required Primary Key
OriginalCity
(datatype: nvarchar(50)) Required Primary Key
OriginalState
(datatype: nvarchar(50)) Required Primary Key
OriginalPostalCode
(datatype: nvarchar(50)) Required Primary Key
UpdatedStreet1
(datatype: nvarchar(100)) Required Primary Key
UpdatedStreet2
(datatype: nvarchar(100)) Required Primary Key
UpdatedCity
(datatype: nvarchar(50)) Required Primary Key
UpdatedState
(datatype: nvarchar(50)) Required Primary Key
UpdatedPostalCode
(datatype: nvarchar(50)) Required Primary Key
UpdatedCountry
(datatype: nvarchar(50)) Required Primary Key
UpdatedBarcode
(datatype: nvarchar(40)) Required Primary Key
UpdatedAddressType
(datatype: int) Required Primary Key
MoveDate
(datatype: datetime) Required Primary Key
MoveDistance
(datatype: decimal(6, 2)) Required Primary Key
MatchFlag
(datatype: int) Required Primary Key
Processed
(datatype: int) Required Primary Key
NcoaRunDateTime
(datatype: datetime) Required Primary Key
NcoaNote
(datatype: nvarchar(max)) Required Primary Key
CreatedDateTime
(datatype: datetime) Required Primary Key
ModifiedDateTime
(datatype: datetime) Required Primary Key
CreatedByPersonAliasId
(datatype: int) Required Primary Key
ModifiedByPersonAliasId
(datatype: int) Required Primary Key
Guid
(datatype: uniqueidentifier) Required Primary Key
ForeignId
(datatype: int) Required Primary Key
ForeignGuid
(datatype: uniqueidentifier) Required Primary Key
ForeignKey
(datatype: nvarchar(100)) Required Primary Key