A4.3 - US NCOA Inputs and outputs and Reports in matchIT SQL

Name

Description

FullName or

Fullname field. Optional if an organization is specified

FirstNames and LastName

If FullName is not used, then both these fields are required.

Organization

Optional. Can be used to specify the company name.

Address1

Sets the “Street” field of the lookup record. Use this field type to pass all information relating to the primary street address, including the street name, house number, directional’s, and street suffix. You can also use this field type to pass all other acceptable forms of primary address information, such as PO Box numbers, rural route numbers, and highway contract numbers. In addition, suite and apartment information can be passed with primary address information through the “Street” field. For example, “123 Main St” and “123 Main St, Apt A” are both acceptable.

Address2

Optional. Can be used to specify any suite and apartment information, if these are in a separate column from the street part of the lookup address (see Address1 above).

Town

Specifies the city.

Region

Specifies the state.

Postcode or

Specifies the 9-digit ZIP code.

PostOut and PostIn

Specifies the 5-digit ZIP code and the ZIP+4, if these are in separate columns.

Name

Description

ncoaFullName or

Only if the fullname was specified on input.

ncoaFirstName and ncoaLastName

Only if the fullname was not specified on input.

ncoaCompany

Optional. Retrieves the company name. This is only output if Organization was passed in via the input fields, or if this optional field is enabled (see Optional Output Fields below).

ncoaStreet

Retrieves the street part of the output address.

ncoaSuite

Optional. Retrieves the suite or apartment information of the output address. This is only output if Address2 was passed in via the input fields, or if this optional field is enabled (see Optional Output Fields below).

ncoaCity

Retrieves the city from the output address.

ncoaState

Retrieves the output state abbreviation.

ncoaZip

Retrieves the output ZIP Code.

Name

Description

ncoaCOACode

This field will be populated with the return codes, see Return Code article for the description of codes returned.

ncoaCoaFound

This field is a True/False flag that tells whether an address change was found.

ncoaMoveEffectiveDate

Date of move. mm/yyyy

ncoaCompany

Retrieves the company name that was entered through the input “ncoaCompany” field, if any. AccuMail Move™ will also verify company moves based off this the company field.

ncoaSuite

Retrieves output secondary street information, such as suite and apartment information, if such information was entered through the input “ncoaSuite” field.

ncoaPlus4

Retrieves the output ZIP+4 Code. The ZIP+4 Code is the 4-digit extension only. You can retrieve the 5-digit ZIP Code using the ncoaZIP field type described earlier in this table.

ncoaUrbanization

Retrieves output urbanization information for Puerto Rican addresses.

ncoaDP

This string consists of a 2-byte delivery point code

ncoaCRRT

Retrieves the output carrier route code. This is a 4-digit code assigned to each address on a mail carrier’s route.

ncoaLotCode

Retrieves the output Line of Travel identifier consisting of a 4-digit number, plus a 1-character sequence code (either "A" for Ascending or "D" for Descending). The 4-digit number indicates the order in which delivery will be made within a given ZIP+4. The 1-character sequence code indicates whether delivery will be made in ascending or descending order. Once a LOT code is appended to your data file records, you can use it to presort your mailings so that they qualify for Enhanced Carrier Route rates.

ncoaLotDir

The order in which the mail carrier delivers mail within a given carrier route. When you include the Line of Travel information, your mail may be eligible for the USPS Standard Mail Non-Automation Basic Enhanced Carrier Route Presort Rate.

ncoaCountyNumber

Retrieves the output county number. This is the 3-digit USPS code for the county in which the address resides.

ncoaCountyName

Retrieves the output county name.

ncoaCongDistrict

Retrieves the output congressional district code. This is a 2-digit identifier for the United States congressional district to which the input address belongs.

ncoaLACS

A 1-character Locatable Address Conversion Service (LACS) code to identify records that have been converted to the LACS system. The LACS system is being used for many rural route addresses and city addresses that are being modified to city style addresses so that emergency vehicles, such as police cars and ambulances, can more easily find these locations.

ncoaAcsKeyline

Retrieves the output Address Change Service (ACS) keyline. The ACS keyline is a code the USPS uses to uniquely identify any address in the United States. You can use the ACS keyline to match the records in your mailing list with the list of ACS notifications in the USPS’s ACS fulfillment files.

ncoaHouseNumber

Retrieves the house number for the output street address. For example, if the output street address is “123 Main St,” the house number is “123.”

ncoaPreDirectional

Retrieves the pre-directional for the output street address. For example, if the output street address is “123 E Main St,” the predirectional designator is “E.”

ncoaStreetName

Retrieves the street name for the output street address. For example, if the output street address is “123 Main St,” the street name is “Main.”

ncoaStreetSuffix

Retrieves the street suffix for the output street address. For example, if the output street address is “123 Main St,” the street suffix is “St.”

ncoaPostDir

Retrieves the post-directional for the output street address. For example, if the output street address is “123 Main St N,” the postdirectional is “N.”

ncoaSUD

Retrieves the secondary unit designator (SUD) for the output street address. For example, if the output street address is “123 Main St Apt 12,” the SUD is “Apt.”

ncoaUnitNum

Retrieves the unit number for the output street address. For example, if the output street address is “123 Main St Apt 12,” the unit number is “12.”

ncoaLeftovers

Retrieves any leftover information that was part of the input street address string, but was not used for obtaining a match. Leftover information is input data that Accumail had to discard to correct the address. For example, if the input street address is “123 Main St Rubbish Here,” the output leftover information is “Rubbish Here.”

ncoaPMB

Retrieves the output Public Mailbox address

ncoaDPV

Retrieves the 3-byte DVP (Delivery Point Verification) match codes. The match codes indicate whether or not the address is valid (and if not, why not), whether or not the address is within a Commercial Mail Receiving Agency (CMRA), and whether or not the address was flagged as a False Positive. The “DPV” field returns a separate code in each position of the 3-byte result string, as follows:

BYTE 1

blank – The address was not coded by AccuMail and therefore no DPV processing was performed.

Y – All delivery point components of the address were DPV validated.

D – The address’s building number was DPV validated, but required unit-level information is missing.

S – The address’s building number was DPV validated, but the unit number is invalid.

N – The address’s building number is invalid.

BYTE 2

blank – The address was not coded by AccuMail and therefore no DPV processing was performed.

Y – The address was found in the CMRA (Commercial Mail Receiving Agency) table.

N – The address was not found in the CMRA (Commercial Mail Receiving Agency) table.

BYTE 3

blank – The address was not coded by AccuMail and therefore no DPV processing was performed.

Y – The address was found in the False Positive table.

N – The address was not found in the False Positive table.

ncoaDPVAnswer

blank – The address was not coded by AccuMail and therefore no DPV processing was performed.

Y – All delivery point components of the address were DPV validated.

D – The address’s building number was DPV validated, but required unit-level information is missing.

S – The address’s building number was DPV validated, but the unit number is invalid.

N – The address’s building number is invalid.

ncoaDpvCMRA

Commercial Mail Receiving Agency

ncoaDpvFalsePositive

This is a seed table used by the Delivery Point Verification Service (DPV). It is used by the service to guard against the possibility of mailers manufacturing artificial mailing lists from the data in the DPV database of every valid delivery point in the U.S.

ncoaDpvFootnotes

Retrieves the 8-byte DPV (Delivery Point Verification) Footnotes string. This field returns up to four 2-character codes that supplement the DVP field codes (described above) providing additional information about the DPV match/mismatch. Up to four of the following 2-character codes will be returned:

AA – The address was successfully coded by AccuMail.

A1 – The address was not successfully coded by AccuMail.

BB – All components of the address were DPV validated.

CC – The address’s building number was DPV validated, but the unit number is invalid.

N1 – The address’s building number was DPV validated, but required unit -level information is missing.

M1 – A building number is missing for the input address.

M3 – The address’s building number is invalid.

P1 – The input address is missing a required PO, RR, or HC Box number.

RR – The input address was identified by DPV as a Commercial Mail Receiving Agency (CMRA).

R1 – The input address was identified by DPV as a Commercial Mail Receiving Agency (CMRA), but required unit-level information is missing.

ncoaLastLine

Retrieves the output ‘last line’ string. This output ‘last line’ string is a formatted city/state/ZIP string that includes the correct ZIP+4 Code. For example, the ‘last line’ information for Datatech SmartSoft is “Agoura Hills, CA 91301-4301.”

ncoaMoveType

Indicates the move as Family, Business, or Residential.

ncoaResult

Retrieves the output error code. AccuMail assigns an error code if the input record could not be found in the USPS National Database. This is a 2-byte code that identifies what was wrong with the input address and why AccuMail could not match it. If AccuMail matched the input address successfully, then this field returns a blank string.

ncoaCorrections

Retrieves the output correction codes string. This string consists of single character codes that indicate the corrections AccuMail had to make to the input record.

ncoaErrorMessage

Retrieves the message text associated with the error code that AccuMail assigned if the input address could not be matched. This is a descriptive sentence or paragraph that describes the reason AccuMail could not correct the input record. If AccuMail matched the input address successfully, then this field returns a blank string.

ncoaWasDigitCoded

Returns a 1 for addresses that successfully coded with a plus4. Returns a 0 for uncoded addresses.

ncoaWasCRRTCoded

Returns a 1 for addresses that has returned with a Carrier Route or a 0 if no Carrier Route was returned.

ncoaWasPlusCoded

Returns a 1 for addresses that successfully coded with a plus4. Returns a 0 for uncoded addresses.

ncoaWasDPBCoded

Retrieves the output delivery point barcode string. This string consists of a 2-byte delivery point code plus a 1-byte checksum digit. These constitute the values required for producing a Delivery Point Barcode.

ncoaWasDPVCoded

Returns a 1 for addresses that were successfully DPV coded or a 0 for addresses that did not pass DPV validation.