| ADDRESSBLOCK |
nvarchar(150) |
|
Default = '' |
Submitted address. |
| CITY |
nvarchar(50) |
|
Default = '' |
Submitted city. |
| POSTCODE |
nvarchar(12) |
|
Default = '' |
Submitted post code. |
| STDADDRESSBLOCK |
nvarchar(150) |
|
Default = '' |
Standardized address. |
| STDCITY |
nvarchar(50) |
|
Default = '' |
Standardized city. |
| STDPOSTCODE |
nvarchar(12) |
|
Default = '' |
Standardized post code. |
| STDDPC |
nvarchar(8) |
|
Default = '' |
Standardized delivery point code. |
| STDCART |
nvarchar(10) |
|
Default = '' |
Standardized address carrier route. |
| STDLOT |
nvarchar(5) |
|
Default = '' |
Standardized address LOT. |
| COAADDRESSBLOCK |
nvarchar(150) |
|
Default = '' |
Standardized address. |
| COACITY |
nvarchar(50) |
|
Default = '' |
Standardized city. |
| COAPOSTCODE |
nvarchar(12) |
|
Default = '' |
Standardized post code. |
| COADPC |
nvarchar(8) |
|
Default = '' |
Standardized delivery point code. |
| COACART |
nvarchar(10) |
|
Default = '' |
Standardized address carrier route. |
| COALOT |
nvarchar(5) |
|
Default = '' |
Standardized address LOT. |
| NCOARETURNCODE |
tinyint |
|
Default = 0 |
The NCOA return code. |
| NCOAFOOTNOTECODE |
tinyint |
|
Default = 0 |
The NCOA footnote code. |
| NCOADPVFOOTNOTECODE |
tinyint |
|
Default = 0 |
Contains the DPV footnote code. |
| NCOADMASUPPRESSION |
bit |
|
Default = 0 |
Contains the DMA suppression returned by NCOA. The DMA suppression flag notifies a mailer that the input record is a consumer who has indicated that they do not prefer to receive advertising mail at home |
| NCOAMAILGRADECODE |
tinyint |
|
Default = 0 |
The NCOA mail grade code. |
| ADDRESSCHANGED |
bit |
|
Default = 0 |
Indicates if the address has changed from the validation or change of address result file. |
| SEQUENCE |
int |
|
Default = 0 |
|
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| NCOAMOVEDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
The NCOA move date. |
| MOVETYPECODE |
tinyint |
|
Default = 0 |
Indicates the type of move. |
| MOVETYPE |
nvarchar(10) (Computed) |
yes |
CASE [MOVETYPECODE] WHEN 0 THEN N'None' WHEN 1 THEN N'Individual' WHEN 2 THEN N'Household' WHEN 3 THEN N'Business' END |
Provides a translation for the 'MOVETYPECODE' field. |