EX24x7 Service Format Tutorial
EZ24x7 service returns the following CSV delimited-field file. Input address list record order is preserved. CASS/DPV with NCOALink provides fifteen fields, without NCOALink provides eleven fields.
Service results are written to C:\AES\EZ_out\ORDER_ID\a_list.csv where ORDER_ID is the order number appearing in the ‘List’ tab.
First Field - Address Key
If an address key was provided, it is written in the first field, otherwise the actual record number is used.
Second Field - Diagnostic
The field contains diagnostics and non-address label address elements. The actual contents depend on the address’s suitability code and the service options requested.
• Suitability Code
The diagnostic field always begins with a suitability code starting with a number "0" through "8" where "7" and "8" are ideal signifying reliable verified Automated-Mail addresses.
The first character expresses the postage discount where "n" means no discount, "p" presort and "a" automation discount.
The second character is a mnemonic extension of the discount code intended to help decipher the code. (i.e. 'pn' presort non-deliverable)
Mail preparation allows you to filter mail-pieces based on the suitability code.
o 0nz - No Discount - No ZIP Code
The address was not matched and the ZIP Code was either not provided or invalid. CASS requires dropping invalid ZIP codes as a result of CASS processing. Addresses do not qualify for any discount and are excluded from EZ24x7 presort support.
o 1ps - Presort Discount
The address was not matched. The ZIP Code is valid, but may or may not have any relationship with the city/state. The address is likely undeliverable. Addresses qualify for presort postage discounts and can be included in EZ24x7 presort, but delivery depends on the letter carrier recognizing the address or knowing the recipient.
o 2pn - Presort Discount - Not Deliverable
The address was matched to a special USPS ZIP+4 indicating that the address is not deliverable (e.g. park side of a street). Addresses qualify for presort discounts and can be included in EZ24x7 presort, but the address is not deliverable according to the USPS.
o 3ps - Presort Discount
The address was matched without DPV confirmation. The address cannot be confirmed and is likely undeliverable. Addresses qualify for presort discounts and can be included in EZ24x7 presort, but delivery depends on the letter carrier recognizing the address or knowing the recipient.
o 4av - Automation Discount - Vacant
The address was matched and DPV confirmed, but was confirmed vacant. Addresses qualify for automation rate discounts and can be included in EZ24x7 presort, but the USPS has this address listed as vacant.
o 5am - Automation Discount - Moved (no-forwarding-address)
The address was matched and DPV confirmed, but a positive NCOALink lookup occurred without returning a new forwarding address. Addresses qualify for automation rate discounts and can be included in EZ24x7 presort, but the USPS is reporting that the recipient has moved and there is no forwarding address.
o 6an - Automation Discount - "NoStat"
The address was matched and DPV confirmed, but confirmed "no-stat" meaning that mail to this address is being returned for non-specified reasons. Addresses qualify for automation rate discounts and can be included in EZ24x7 presort, but the USPS is reporting that the mail is being returned (e.g. dangerous animal, no mailbox, etc.).
o 7aa - Automation Discount
The address was matched and DPV confirmed. The address is deliverable and qualifies for automation rate discounts.
o 8au - Automation Discount (new forwarding-address)
The address was matched and DPV confirmed. Furthermore, a positive NCOALink lookup occurred returning a new forwarding address. The address is deliverable and qualifies for automation rate discounts.
• Address Status - "0nz" and "1ps"
If there was no CASS address match, the "Address Status" is returned describing what was wrong with the address. See Appendix A of the Mail*STAR document "Address Status" values. When there was no-match, suitability is either "0nz" or "1ps" depending on the existence of a valid ZIP code. No other diagnostic fields are included with "0nz" where there was no valid ZIP code.
In support of in-county discounts for non-automation periodical presort, suitability code "1ps" includes "C=SScounty_code" where "SS" is the two-character state-code followed by county code when the eLOT service option was selected
• Address Quality and DPV Footnote - "2pn" through "8au"
If there was a CASS address match, address quality information is returned.
o M=number
Match reliability expressed as a number. A value of 85 or higher is reliable. The number can exceed 100 because of match bonuses used to break multiple-match ties.
o Q=flags
Quality flags report edits required matching the address. Flags are documented in Appendix B of the Mail*STAR document.
o F=footnote
USPS Standardized footnotes can be seen in Appendix A of the Mail*DPVeLOT document.
• Carrier Route - "3ps" through "8au"
If there was a CASS address match and valid Carrier Route, the Carrier Route is returned.
o R=carrier_route
Four-digit USPS carrier route code of the matched address
• Delivery Point and Check Digit - "4av" through "8au"
Delivery point is only returned if the matched address is DPV confirmed.
o D=dpc
Delivery point, two-digits plus the check-digit
• Add-on Service Flags - "4av" through "8au"
Service options include NCOALink, RDI, eLOT and SuiteLink/LACSLink.
o RDI
RDI appears only with RDI service selected and the address is a residence.
o S=rc
Appears only with SuiteLink service and when a SuiteLink lookup attempted. Return codes:
00 - No Match
The input record COULD NOT BE matched to a record in the master file. Secondary information could not be furnished.
A - Record Match
The input record matched to a record in the master file. Lookup appended the CASS processed address with secondary information.
o L=rc
Appears only with LACSLink service and when a LACSLink lookup attempted. Return codes:
N00 - No Match
The input record COULD NOT BE matched to a record in the master file. A new address could not be furnished.
YA - Record Match
The input record matched to a record in the master file. A new address was furnished.
Y14 - Record Match - New Address Would Not Convert at Run Time
The input record matched to a record in the master file. The new address could not be converted to a deliverable address.
S92 - Record Match - Secondary Number Dropped from Input Address
The input record matched to a master file record, but the input address had a secondary number and the master file record did not. The record is a ZIP + 4® street level or high-rise match.
o E=sequence C=county_code
eLOT and county code appear only with eLOT service.
o N=rc
NCOALink return code appears only when
1) NCOALink service is requested
2) Address matching results in a DPV confirmed address
3) Input name(s) are present required for NCOALink lookup
USPS Standardized NCOALink footnotes are found in Appendix A of this document.
Third and Fourth Fields - Names
Up to two recipient names are supported. NCOALink is entered with one and only one name.
For this reason it is critical that if there are two names provided, that the first input name line be a person and the second input name line be the business.
This is the standard addressing convention, the way you would see names shown with an address.
NCOALink uses the last name found for a potential business match and the first name found for individual or family matches.
That does not mean that there has to be two input name lines used nor does it mean that if there are two input name lines used that both have to contain data. Let's take a look at how this works so there will be no misunderstanding.
Name1='JOHN DOE'
Name2='ABC Inc.'
'John Doe' is used for individual/family lookup while 'ABC Inc.' is used for business lookup.
Name1='JOHN DOE'
Name2=''
'John Doe' is used for individual, family and business lookup.
Name1=''
Name2='JOHN DOE'
'John Doe' is used for individual, family and business lookup.
Name1='ABC Inc.'
Name2=''
'ABC Inc.' is used for individual, family and business lookup.
Name1=''
Name2='ABC Inc.'
'ABC Inc.' is used for individual, family and business lookup.
Now let's look at the only case that is incorrect because of failing to follow the rule.
Name1='ABC Inc.'
Name2='JOHN DOE'
'ABC Inc.' is used for individual/family lookup while 'JOHN DOE' is used for business lookup. This is absolutely incorrect.
Fifth-Eighth Fields - Best Mailing Address (Addr_1, Addr_2, Last_Line, Routing Code)
The best mailing address and routing code depend on the suitability code.
• No Match - "0nz" and "1ps"
The best address is a normalized input address. The USPS requires elimination of invalid ZIP Code and unique ZIP codes that were not matched.
A Unique ZIP code is a ZIP assigned to a company or organization for their exclusive use.
With the exception of "normalizations", fields five through eight will contain the input address.
Field eight, routing code, will contain:
o No ZIP - "0nz"
nothing
o ZIP - "1ps"
5-digit routing code
• CASS Match - "2pn" through "7aa"
The best address is a CASS standardized address. The address may or may not be DPV confirmed.
Field eight, routing code, will contain:
o Not DPV confirmed - "2pn" and "3ps"
5-digit routing code
o DPV confirmed - "4av" through "7aa"
12-digit routing code
• NCOALink New Address - "8au"
The best address is the new NCOALink address.
Field eight, routing code, will contain 12-digits.
Ninth-Eleventh Fields - Input Address (Addr_1, Addr_2, Last_Line)
It is a USPS NCOALink requirement that the input address always be returned. This is useful when updating the database making certain the address did not change while being serviced.
This has been standard AES systems practice since 1994 believing that the untouched original input address data should always be included with the results.
Twelfth Field - Extended NCOALink Return Code
Remember the basic USPS NCOALink return code in the second diagnostic field reported as ‘N=rc’. An extended NCOALink return code is generated if the NCOALink lookup was matched.
NCOALink return codes indicating a match include N={A, 1, 2, 3, 5, 14, 19, 92, 93}.
New NCOALink addresses are returned for N={A, 92, 93} with a suitability code of ‘8au’.
No NCOALink address is available for N={1, 2, 3, 5, 14, 19} with a suitability code of ‘5am’.
The extended NCOALink return code includes move-type, move-affectivity-date, age and query name.
It is a USPS NCOALink requirement that the query name be returned. This is not the same as the input name. There are nine name presentation sequences prescribed by the USPS along with the business name.
Many of the name presentation sequences require consideration of nickname and last name variants meaning there can be hundreds of possibilities. The query name is the variant used for the NCOALink match.
Thirteenth-Fifteenth Fields - NCOALink Query Address (Addr_1, Addr_2, Last_Line)
It is a USPS NCOALink requirement that the query address be returned for NCOALink matches.
This is not necessarily the same as the CASS standardized input address because PMB, private mailbox is not included and NCOALink allows for dropping the input secondary information. See NCOALink return code "92".
Appendix A NCOALink Return codes
• A - COA Match
A new address is provided
• 00 - No COA Match
Match was not found with given input name, address and matching logic
• 01 - COA Match - Foreign Move
Match found, but new address outside USPS delivery area - a new address cannot be provided
• 02 - COA Match - Move Left NO Address
Match found, but new address was not provided to the USPS - a new address cannot be provided
• 03 - COA Match - PO BOX Closed NO Forwarding Address
Match found, but new address was not provided to the USPS - a new address cannot be provided
• 04 - Cannot Match COA - Street Address With Secondary
A COA was found utilizing the last name and address but the input did not contain a secondary number and the COA contained a secondary number
• 05 - COA Match - A New Address Cannot Be Provided
The DPBC represents more than one address - the new address cannot be provided
• 06 - Cannot Match COA - Middle Name Conflict
More than one COA and the middle names or initials on the COA's are different - new address cannot be provided due to unresolved conflict
•07 - Cannot Match COA - Gender Conflict
More than one COA exists and the genders on the COA's are different - new address cannot be provided due to unresolved conflict
• 08 - Cannot Match COA - Conflicting Instructions
More than one COA exists with differences in the new address - new address cannot be provided due to unresolved conflict
• 09 - Cannot Match COA - High-rise Default
Family COA with high-rise address ZIP+4 coded to building default - individual name information required for match missing or not match COA
• 10 - Cannot Match COA - Rural Default
Family COA with Rural Route or Highway Contract address ZIP+4 coded to a route default - individual name information required for match missing or not match COA
• 11 - Cannot Match COA - Insufficient COA Name
Individual name information on the COA is insufficient to allow a match
• 12 - Cannot Match COA - Middle Name Test Failed
Input middle name information does not match COA middle name information. - match not allowed - new address cannot be provided
• 13 - Cannot Match COA - Gender Test Failed
Input gender information does not match COA gender information - match not allowed - new address cannot be provided
• 14 - COA Match - New Address Would Not Convert
Address could not be converted to a deliverable address - the new address could not be provided
• 15 - Cannot Match COA - Individual Name Insufficient
The input does not contain a first name or contains initials only - the individual name information required to make match was missing from input
• 16 - Cannot Match COA - Secondary Number Discrepancy
Either there is conflicting secondary information or input had secondary information and matched to a family record without secondary information
• 17 - Cannot Match COA - Other Insufficient Name
Input name is different or not sufficient enough to produce a match
• 18 - Cannot Match COA - GENERAL DELIVERY
The input record matched to a family record from a GENERAL DELIVERY address - this address type requires an individual name matching to obtain a match
• 19 - Found COA - New Address Does Not ZIP+4 Or DPV Confirm
The new address not ZIP+4 coded or new address primary number not DPV confirmable - the new address could not be provided
• 20 - Cannot Match COA - Conflicting Directions
Conflicting directions after rechaining - multiple COA's exist but contain different new addresses
• 66 - Daily Delete
COA is pending deletion from the master file
• 91 - COA Match - Secondary Number Dropped From COA
Matched to an individual COA - the COA contained a secondary number and the input did not contain a secondary number - a new address is provided
• 92 - COA Match - Secondary Number Dropped From Input
Matched to an individual COA - the input contained a secondary number and the COA did not contain a secondary number - a new address is provided
Appendix B – Echo Input
Input address records are appended to Service File records by default. You can choose not to append the address list records. File->SiteSetup opens the Site Setup window where you will find the "Do Not Echo Input" checkbox. When checked, input address list fields are not appended to the Service File record.
Address list records always start in the 16th column. Without NCOALink, columns 12 through 15 will be empty so that the address record always begins in column 16 regardless of NCOALink.
If the address list is fixed-field, the entire fixed-field record will be found in column 16. If the fixed-field record contains either a comma or double-quote character, the field will have a double-quote added before and after the record. Double-quotes found in the input address record are doubled consistent with CSV format rules.
If the address list is delimited field, each field in the address list record will be appended. The first address field will be column 16 the second column 17 and so on. The echoed address list fields will be in CSV format even if the input address list was <TAB> delimited.