| NCOALASTSUBMITDATE |
datetime |
yes |
|
Contains the last date that this address was submitted to NCOA. |
| NCOARETURNCODE |
tinyint |
|
Default = 0 |
Contains the NCOA return code. |
| NCOAFOOTNOTECODE |
tinyint |
|
Default = 0 |
Contains the footnote returned by NCOA. |
| NCOADPVFOOTNOTECODE |
tinyint |
|
Default = 0 |
Contains the DPV footnote returned by NCOA. |
| NCOAMOVEDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
Contains the move date returned by NCOA. |
| 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 |
Contains the mail grade code returned by NCOA. |
| OMITFROMVALIDATION |
bit |
|
Default = 0 |
Indicates this address should be omitted from validation. |
| LASTVALIDATIONATTEMPTDATE |
datetime |
yes |
|
Contains the date that this address was last validated. |
| VALIDATIONMESSAGE |
nvarchar(200) |
|
Default = '' |
Stores the validation message. |
| CERTIFICATIONDATA |
int |
|
Default = 0 |
Contains the certification data which shows with which release of the Postal Datafiles this address was last validated. |
| 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. |
| NCOARETURN |
nvarchar(72) (Computed) |
yes |
CASE [NCOARETURNCODE] WHEN 0 THEN N'' WHEN 1 THEN N'A - COA Match' WHEN 2 THEN N'00 - No match' WHEN 3 THEN N'01 - Match to undeliverable: Foreign move' WHEN 4 THEN N'02 - Match to undeliverable: Moved left no address (MLNA)' WHEN 5 THEN N'03 - Match to undeliverable: Box closed no order (BCNO)' WHEN 6 THEN N'05 - Found COA: New 11-digit DPBC is ambiguous' WHEN 7 THEN N'14 - Found COA: New address would not convert at run time' WHEN 8 THEN N'19 - Found COA: New address not ZIP + 4 coded' WHEN 9 THEN N'91 - COA match: Secondary number ignored on COA' WHEN 10 THEN N'92 - COA match: Secondary number ignored on input address' WHEN 11 THEN N'04 - Cannot match COA: Street address with secondary' WHEN 12 THEN N'06 - Cannot match COA: Multiple matches: Middle name related' WHEN 13 THEN N'07 - Cannot match COA: Multiple matches: Gender related' WHEN 14 THEN N'08 - Cannot match COA: Multiple matches: Address related' WHEN 15 THEN N'09 - Cannot match COA: Highrise default' WHEN 16 THEN N'10 - Cannot match COA: Rural default' WHEN 17 THEN N'11 - Cannot match COA: Individual match: Insufficient COA name for match' WHEN 18 THEN N'12 - Cannot match COA: Middle name test failed' WHEN 19 THEN N'13 - Cannot match COA: Gender test failed' WHEN 20 THEN N'15 - Cannot match COA: Individual name insufficient' WHEN 21 THEN N'16 - Cannot match COA: Secondary number discrepancy' WHEN 22 THEN N'17 - Cannot match COA: Other insufficient name' WHEN 23 THEN N'18 - Cannot match COA: General delivery' WHEN 24 THEN N'20 - Cannot match COA: Conflicting directions after re-chaining' WHEN 25 THEN N'66 - Daily delete' END |
Provides a translation for the 'NCOARETURNCODE' field. |
| NCOAFOOTNOTE |
nvarchar(69) (Computed) |
yes |
CASE [NCOAFOOTNOTECODE] WHEN 0 THEN N'' WHEN 1 THEN N'M - Forwardable move' WHEN 2 THEN N'K - Moved, no forwarding address' WHEN 3 THEN N'G - PO box closed' WHEN 4 THEN N'F - Move to foreign address' WHEN 5 THEN N'S - Forwardable move, but secondary address cannot be verified' WHEN 6 THEN N'P - Change of address form filed, but new address not in USPS records' WHEN 7 THEN N'L - Temporary address has lapsed' END |
Provides a translation for the 'NCOAFOOTNOTECODE' field. |
| NCOADPVFOOTNOTE |
nvarchar(145) (Computed) |
yes |
CASE [NCOADPVFOOTNOTECODE] WHEN 0 THEN N'' WHEN 1 THEN N'AA - Input address matched to the ZIP + 4 file' WHEN 2 THEN N'A1 - Input address not matched to the ZIP + 4 file' WHEN 3 THEN N'BB - Input address matched to DPV (all components)' WHEN 4 THEN N'CC - Input address primary number matched to DPV but secondary number present but not valid' WHEN 5 THEN N'F1 - Military' WHEN 6 THEN N'G1 - General Delivery' WHEN 7 THEN N'N1 - Input address primary number matched to DPV but high-rise address missing secondary number' WHEN 8 THEN N'M1 - Input address primary number missing' WHEN 9 THEN N'M3 - Input address primary number invalid' WHEN 10 THEN N'NL - NCOALink move address cannot be DPV confirmed (occurs because the NCOAlink directories are updated more frequently than the DPV directories)' WHEN 11 THEN N'P1 - Input address missing PO, RR or HC box number' WHEN 12 THEN N'P3 - Input address is invalid PO, RR, or HC number' WHEN 13 THEN N'RR - Input address matched to CMRA' WHEN 14 THEN N'R1 - Input address matched to CMRA but secondary number not present' WHEN 15 THEN N'U1 - Unique' END |
Provides a translation for the 'NCOADPVFOOTNOTECODE' field. |
| NCOAMAILGRADE |
nvarchar(44) (Computed) |
yes |
CASE [NCOAMAILGRADECODE] WHEN 0 THEN N'' WHEN 1 THEN N'A - This is an accurate, mail-able address' WHEN 2 THEN N'B - Record is probably deliverable' WHEN 3 THEN N'C - The record may or may not be deliverable' WHEN 4 THEN N'F - The record is undeliverable. Do not mail' END |
Provides a translation for the 'NCOAMAILGRADECODE' field. |
| INFOSOURCECOMMENTS |
nvarchar(256) |
|
Default = '' |
Contains additional comments about the information source. |
| ORIGINCODE |
tinyint |
|
Default = 0 |
Defines where the address originated. |
| ORIGIN |
nvarchar(9) (Computed) |
yes |
CASE [ORIGINCODE] WHEN 0 THEN N'User' WHEN 1 THEN N'Web Forms' END |
Provides a translation for the 'ORIGINCODE' field. |