Address Update Lookup Node
You can add an Address Update Lookup node to a data job to run the United States Postal Service (USPS) National Change of Address (NCOA) data through NCOALINK processing. NCOALINK is validated by the postal service in two steps for certification similar to Coding Accuracy Support System (CASS) certification. This node implements the necessary job step to do the processing.
Once you have added the node, you can double-click it to open its properties dialog. The properties dialog includes the following elements:
PAF ID - Specifies an 18-character identifier that contains the following elements:
- Characters 1-4 - USPS-assigned licensee ID
- Characters 5-10 - List Owner NACIS code, which specifies the type of business
- Characters 11-12 - Processing frequency
- Characters 13-18 - Licensee's internal List ID
Group ID - Used to group sub-lists that might be create to split a job for multi-threaded processing or processing on separate machines. Job summaries are grouped by the Group ID when monthly NCOALINK statistics are calculated.
MED Months Filter - Specifies the move effective date on which the address move is to go into effect. You can use this value to constrain the results to addresses that have changed within a specified number of months. For example, if MED_MONTHS_FILTER is set to 6, results will include only addresses that have changed in the last 6 months. The minimum value is 6.
Operator ID - Specifies the operator responsible for processing the list.
Lookup Method - Controls how the NCOALINK lookup treats names. The following values are available:
- 0 (Standard) - Uses individual, business, and family (last name only) matching logic
- 1 (Business Only) - Only uses business matching logic. No individual or family logic is used.
- 2 (Individual Only) - Only use individual matching logic. No business or family logic is used.
- 3 (Business And Individual Only) - Use individual and business matching logic. No family logic is used.
- 4 (Individual with Family) - Use individual and family matching logic
Mailing Zip - Specifies the ZIP code from which the mailing is to occur.
High Match Rate Desc - Provides a description for a match rate that exceeds 20 percent. The following values are available:
- A - ANK Extract File
- S - Stage 1,2 file
- R - Returned Mail
Additional Notes - Enables you to add a one-character note. The NCOALINK documentation states that the literal A in this field denotes that you have requested a longer processing period.
Process Category - Specifies a reason for running a job. The following values are available:
- 0 - Employee training
- 1 - Internal database testing
- 2 - Marketing test
- 3 - Normal
- 4 - Stage 1 Compliance
- 5 - Stage 2 Compliance
- 6 - System Test
Override PAF expiration - When selected, node ignores the PAF expiration date. If not selected, PAF IDs that refer to PAFs with PAF_SIGNED_DATEs more than 1 year from the current date causes an error. This setting provides a grace period for users to run jobs in situations where a PAF is being renewed but the paperwork might not have been processed.
Mail Class - Specifies the class of mail for the list that is being processed. The following values are available:
- A - First Class only
- B - Periodicals only
- C - Standard Mail only
- D - Package Services only
- E - First Class and Periodicals
- F - First Class and Standard Mail
- G - First Class and Package Services
- H - Periodicals and Standard Mail
- I - Periodicals and Package Services
- J - Standard Mail and Package Services
- K - First Class, Periodicals. and Standard Mail
- L - First Class, Periodicals, and Package Services
- M - First Class, Standard Mail, and Package Services
- N - Periodicals, Standard Mail, and Package Services
- O - First Class, Periodicals, Standard Mail, and Package Services
Internal DB - Specifies the use of an internal database. Set to I when the list or database is owned by the licensee.
List Received Date - Specifies the date on which the list was received. Uses the following format: YYYYMMDD.
Data Returned - Specifies the type of data returned. The following values are available:
- C - COA Data returned (including return codes and processing statistics)
- F - Return codes only
- S - Statistics only (no COA data or footnotes)
List Returned Date - Specifies the date on which the processed list was returned. Uses the following format: YYYYMMDD.
Pre-Processed - Specifies whether the data was pre-processed. The following values are available:
- N - None
- Y - Yes, but with data modifications
- D - Yes, with data modifications from sources other than postal data
- P - Yes, with data modifications from postal data only (LACS)
- B - Yes, with data modifications from postal and other sources
Concurrent Processes - Specifies whether concurrent processes are used. The following values are available:
- N - None
- Y - Yes, but with data modifications
- D - Yes, with data modifications from sources other than postal data
- P - Yes, with data modifications from postal data only (LACS)
- B - Yes, with data modifications from postal and other sources
Post-Processed - Specifies whether the data was post-processed. The following values are available:
- N - None
- Y - Yes, but with data modifications
- D - Yes, with data modifications from sources other than postal data
- P - Yes, with data modifications from postal data only (LACS)
- B - Yes, with data modifications from postal and other sources
Std Output Returned - Specifies one of the following one-character standard output identifiers:
- Y - All NCOALINK -required output returned to client
- N - Post-processes modified return information (for example, updates applied to the list)
- B - Post-process modified information; a separate file containing all required output also supplied
You can access the following advanced properties by right-clicking the Address Update Lookup node:
- ADDITIONAL_NOTES
- CONCURRENT_PROC
- DATA_RETURNED
- EXECROWID_VAR
- FIELD_MAP
- GROUP_ID
- HIGH_MATCH_RATE_DESC
- INPUTS
- INTERNAL_DB
- LIST_RECEIVED_DATE
- LIST_RETURNED_DATE
- LOOKUP_METHOD
- MAIL_CLASS
- MAILING_ZIP
- MED_MONTHS_FILTER
- OPERATOR_ID
- OUTPUTS
- OVERRIDE_PAF_EXPIRATION
- PAF_ID
- POSTPROCESSED
- PREPROCESSED
- PROCESS_CATEGORY
- STANDARD_OUTPUT_RETURNED