The U.S. Postal Service's National Change of Address (NCOA) program makes change-of-address (COA) information available to help reduce the amount of undeliverable mail. Address records in your IQ People database can be updated by the Mailing Services office, using the USPS FASTforward system, which contains up-to-date COA records and address-matching software.
The FASTforward system standardizes addresses to conform to USPS requirements, including the ZIP+4 Code. It then attempts to match the address against the NCOA file, which contains address change information derived from the Change-of-Address Order filed by relocating postal customers. If an exact match is made with the old address information in the NCOA file, HIR is permitted to return the new address information. Included with the new address information is a deliverability code indicating why the address has changed.
You can work with your Leidos IT Consultant or Technical Support to send your IQ People address records to the Mailing Services office (under the Chief Administrative Officer of the House of Representatives) for NCOA updating. They will update the addresses of people who have filed a Change of Address (COA) card with the U.S. Postal Service. The addresses in your IQ database will be updated to a new address based on National Change of Address (NCOA) records for the last 18 months. NCOA will also flag addresses of people who have moved between 19-48 months ago, however, no new addresses are available.
Because NCOA updating alters records in your database, you should work closely with your IT Consultant when using this process. This function is restricted to those users with security access rights to it.
The NCOA export can include your entire database or a subset (select list) for address updating. HIR limits you to two database updates per calendar year. Most offices prefer to export the entire database for updating. Leidos will contact HIR to let them know the NCOA export for your office is ready for updating. HIR then performs the NCOA updates and contacts Leidos when it is completed.
Note: If you plan to run this process on the same night as your weekly backup, contact your IT Consultant to reschedule the backup. Because the weekly backup shuts down Oracle, the export process will be interrupted if the backup starts before the export finishes.
To export records for NCOA updating:
Click the People module tab and select the NCOA submenu link.
Select the Add NCOA action.
Complete the fields on the Export NCOA Data dialog.
Click the Export button. IQ creates a background job for the scheduled date and time.
Click the Close button to close the Export NCOA Data dialog.
Note: IQ will send the user who initiated the export an alert message when the export is completed.
Schedule
Date and Time
Vendor
State and District
Address Type
Select List
HIR will notify Leidos when your records have been updated. Leidos will then import the updated records back into your IQ database and contact you so that you can review the People records that were updated (or not updated) based on the following possible NCOA Deliverability Codes. Note: IQ adds an affiliation code for each deliverability code that exists in the imported address records. For example, if an address in the import contains a deliverablity code of M, then IQ will add the affiliation code NCOA_M to the People record. The affiliation code remains in the People records until the next NCOA Import.
A
C
F
G
K
M
P
S
W
Note: Address updates are made to the People records in IQ that are coded with A or M. No updates are made to the People records that are coded with C, F, G, K, P, however, you may want to create and assign an Affiliation Code to indicate mail should no longer be sent to these People records.