Import NCOA

Collect! Credit and Collection Software™

Page Table of Contents

Related 'How To' Tutorials

Create An Import Map - Delimited Separation Create A Fixed Length Import Map Tag Records With An Import Use Scanf Import Import Maps Export Import Maps Create A New Import Library Delete An Import Library

The Import NCOA option allows you to import National Change Of Address information into your database from a Letter Service *.coa file.

Useful Note This requires that you have previously requested an NCOA Check in your Report Options when using Collect!'s Letter Service feature to outsource your letters. When you do this, Collect! attaches the Debtor [D] or Cosigner [C] identifier so that the Import NCOA feature can find the correct record to update. Please refer to Help topic, How to Use Letter Service for details.

When you select the Import NCOA option, the Open NCOA File dialog will display so that you may select the *.coa file you wish to import.

Select the OPEN button when you have highlighted the *.coa file or double-click on the filename. Collect! will read the NCOA file contents and attempt to update your Debtor records with the Change of Address information. A prompt will display a summary of updated accounts.

After the Import NCOA has run, any records that were updated will be tagged. You can use Edit, View Tags from the top menu bar to examine the records.

Please examine your accounts to make sure you are satisfied with the updated information.

Useful Note You can also schedule your NCOA updates through Collect!'s Scheduler.

NCOA File Format

The NCOA file that Collect! is expecting to receive from your letter service vendor is a fixed-length file. Please see below for the expected field positions.

Start	End	Len	Description
NCOA Requested Output File Format Appended Output Record Length 542 NCOA Output File
1	26	26	NIXIE footnotes	If there is a Nixie Code "A" match, Collect! will update fields
27	27	1	NCOA Deliverability Code
28	75	48	NCOA Address
76	103	28	NCOA City
104	105	2	NCOA State
106	110	5	NCOA 5-Digit ZIP Code
111	114	4	NCOA 4-Digit Add-on Code
115	117	3	NCOA Delivery Point Barcode
118	118	1	NCOA Move Type
119	122	4	NCOA - Move Effective Date --- Format YYMM
123	132	4	Inquiry Address ZIP+4 Footnotes	Parsed Data
133	163	31	Inquiry Optional Address
164	211	48	Inquiry Delivery Address
212	239	28	Inquiry City
240	241	2	Inquiry State
242	246	5	Inquiry 5-Digit Zip Code
247	250	4	Inquiry 4-Digit Add-on Code
251	253	3	Inquiry Delivery Point Barcode
254	273	20	Filler
274	283	10	NCOA Phone Number
284	291	8	Filler
292	292	1	NCOA Phone Number Level of Match A - Match on Address	Optional
293	341	49	Filler
342	345	4	Input Letter Code field	Report Options - Letter Number
346	385	40	Input Full Name field	Debtor Form - Name
386	425	40	Input Address1 field	Debtor Form - Address
426	465	40	Input Address2 field	Debtor Form - Address 1
466	493	28	Input City State Zip field	Debtor Form - City, State, Zip
494	495	2	Service Requested 02 - NCOA (Currently available option)
496	540	45	Input NCOA Control field Client Input Reference Field(s) Dfilenumber for Debtor Cfilenumber for Cosigner	File - Debtor Form
541	541	1	Line Feed Character

NIXIE Footnotes Positions 1-26	This field contains the NIXIE Footnotes A - NCOA Match. The input record matched to an NCOA master file record using current NCOA Rules. A new address could be furnished.
NCOA Deliverability Code Positions 27	This field contains the NCOA deliverability code.
NCOA Address Positions 28 - 75	This field contains the NCOA address.
NCOA City Positions 76 - 103	This field contains the NCOA city.
NCOA State Positions 104 - 105	This field contains the NCOA state abbreviation.
NCOA 5-Digit Zip Code Positions 106 - 110	This field contains the response five-digit NCOA Zip Code Information.
NCOA 4-digit Add-On Code Positions 111 - 114	This field contains the response four-digit add-on code.
NCOA Delivery Point Barcode Positions 115 - 117	This field contains the NCOA state abbreviation.
NCOA Move Type Positions 118	This field contains the type of NCOA move.
NCOA Move Effective Date Positions 119 - 122	This field contains the date the change of address becomes effective. Format YYMM
Inquiry Address Zip+4 Footnotes Positions 123 - 132	This field contains the Zip+4 Footnotes. A - Zip Code Corrected - Position 124 B - City/State Spelling Corrected - Position 125 F - No Zip+4 Available - Position 126 I - Insufficient/Incorrect Date - Position 130 T - Street Address line Corrected - Position 131
Inquiry Optional Address Positions 133 - 163	This field contains the optional input address
Inquiry Delivery Address Positions 164 - 211	This field contains the delivery input address
Inquiry City Positions 212 - 239	This field contains the input city
Inquiry State Positions 240 - 241	This field contains the input state
Inquiry 5-Digit Zip Code Positions 242 - 246	This field contains the input five-digit ZIP Code
Inquiry 4-Digit Zip Add-On Code Positions 247 - 250	This field contains the input four-digit ZIP Code
Inquiry Delivery Point Barcode Positions 251 - 253	This field contains the input delivery point barcode
Filler Positions 254 - 273
NCOA Phone Number Positions 274 - 283	This field contains the phone number match for the new move-to NCOA address (if present)
Filler Positions 284 - 291
NCOA Phone Number Level of Match Position 292	This field contains the match level indicator for the new move-to NCOA phone number (if present) S - Surname level match A - Address level match
Filler Positions 293 - 341	This field is reserve for future use
Input Letter Code Positions 342 - 345	This field contains the Input Letter Code
Input Full Name Positions 346 - 385	This field contains the Input Full Name
Input Address1 Positions 386 - 425	This field contains the Input Address1
Input Address2 Positions 426 - 465	This field contains the Input Address2
Input City State Zip Positions 466 - 493	This field contains the Input City State Zip
Service Requested Positions 494 - 495	This field contains the service code
NCOA Control Field Positions 496 - 540	This field contains the client Reference Field(s)
Line Feed Character Position 541	This is the end of record indicator

Click here to view a sample file

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org