How to create an output file to send to Data Enrichment Services for PhoneFinder, DeceasedRecordFinder, AgeFinder or GenderFinder (Team Approach)

This Knowledgebase solution covers how to use Team Approach to create an input file for Data Enrichment Services including PhoneFinder, DeceasedRecordFinder, AgeFinder or GenderFinder.  Any file submitted should have the same format shown below.  The files returned for each individual service will each have a different format.

Note: This is not for NCOA. See How to submit data for NCOA (a.k.a AddressFinder or EDQ Starter) 
Use Query Entry to write a query identifying the accounts you want to submit for analytics processing.  Use Output Entry to create an output with Output Format of Fixed width and these exact output fields and lengths in order.  Click the Schedule button from Output Entry to bring you to Query and Output Schedule where you can schedule and run the query and output to create the output file:

Team Approach Standard Input
Fixed Width Input

 
 Output FieldLengthStartEnd
TA Output FieldsAccount ID         818
First Name         20928
Last Name          402968
Suffix4069108
Title8109116
Name ID            2117118
Account Type2119120
Address Line       50121170
Extra Line 1       50171220
Extra Line 2       50221270
City               30271300
State              2301302
Zip                8303310
Plus 4             8311318
Country4319322
Address ID         2323324
Address Type       2325326
Preferred Address  1327327
Date Updated       9328336
Name Line          50337386
Area Code5387391
Telephone Number   20392411
Telephone Extension6412417
TelephoneID        2418419
County Code8420427
County40428467
PAF Number5468472

Steps to Duplicate


Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.