Data Imput Options

Data Input Options

One of the first steps in getting set up for online batch processing is to determine the data input method. Many options are available. One common option is to input your data into our Suggested Input Template Excel spreadsheet, then save it per the special instructions in the corresponding PDF to send to TransUnion. Alternatively, customers can program for, and send in, fixed format inquiry (FFI) strings via the standard TransUnion inquiry input method (TU4.0/TU4.1).

IMPORTANT: If you are using a vendor they may require a unique input layout. Please contact them first before using one of the below templates.

For online batch processing, it is critical that the data be sent in a standard, consistent format for every submission. Use these tools to help create your file.

Some of these documents may require Adobe® Acrobat® Reader®. You can download the free Adobe Acrobat Reader software from the Adobe website.

Suggested Input Templates

Insert your data into the Excel 97-2003 or Excel 2007 spreadsheet template below. Except for the headers, the columns in these blank Excel files are the exact length required for a successful online batch transmission. After you create the spreadsheet, save it as the PDF instructions describe and submit it to TransUnion.

Note: TransUnion cannot accept Excel files as input; you must follow the PDF instructions to save your file.

Common Suggested Input Template

This space delimited template can be used for all versions of CPE, all versions of Credit Report, ID Report, ID Search, Individual Monitoring and Model Report.
Content only available to logged-in subscribersOnline Batch Custom Layout Specifications and Rules - PRN (. pdf )
Last Updated: 10/15/2012
Content only available to logged-in subscribersOLB Suggested Input Template 1997-2003 (. xlt )
Last Updated: 10/15/2012
Content only available to logged-in subscribersOLB Suggested Input Template 2007 (. zip )
Last Updated: 10/15/2012
Print Text
Click to print page
Page Tools Divider
Font Text
Click to reduce font size
Click to increase font size
Content only available to subscribers
CONTACT US
Business
Online
Client Technical Support
Phone
800-985-4208
Hours: 9am - 6pm EST

Billing Inquiries
Phone
866-810-2636
Hours: 8am - 5pm EST
Personal
Phone
800-916-8800
Hours: 8am – 8 pm EST
This comma delimited template can be used for all versions of CPE, all versions of Credit Report, ID Report, ID Search, Individual Monitoring and Model Report.
Content only available to logged-in subscribersOnline Batch Custom Layout Specifications and Rules - CSV (. pdf )
Last Updated: 10/15/2012
Content only available to logged-in subscribersOLB Comma Suggested Input Template (. zip )
Last Updated: 10/15/2012
Templates for TREC 3 PLUS models. For all TREC 3 PLUS model requests, in which customers must submit additional data on input, these specific templates must be used.

CIS Services Suggested Input Template

This space delimited template can be used for Contact Locator, Contact Verification, and Contact Verification Plus.
Content only available to logged-in subscribersContact Identity Services via Online Batch (OLB) (. pdf )
Last Updated: 10/15/2012
Content only available to logged-in subscribersCIS Services Input Template 1997-2003 (. xlt )
Last Updated: 10/15/2012
Content only available to logged-in subscribersCIS Services Input Template 2007 (. zip )
Last Updated: 10/15/2012

Portfolio Valuation 2 Templates

The Portfolio Valuation 2 service is unique in that the data submitted to us must be exactly in one of the below formats, depending on if a TREC 3 PLUS model is used.
Content only available to logged-in subscribersLayout Instructions (. pdf )
Last Updated: 10/15/2012
Content only available to logged-in subscribersSuggested Input Template 1997-2003 (. xlt )
Last Updated: 10/15/2012
Content only available to logged-in subscribersSuggested Input Template 2007 (. zip )
Last Updated: 10/15/2012
Content only available to logged-in subscribersTREC3 All Industry Layout Instructions (. pdf )
Last Updated: 10/15/2012
Content only available to logged-in subscribersTREC3 All Industry Suggested Input Template 1997-2003 (. xlt )
Last Updated: 10/15/2012
Content only available to logged-in subscribersTREC3 All Industry Suggested Input Template 2007 (. zip )
Last Updated: 10/15/2012
Content only available to logged-in subscribersTREC3 Bankcard Layout Instructions (. pdf )
Last Updated: 10/15/2012
Content only available to logged-in subscribersTREC3 Bankcard Suggested Input Template 1997-2003 (. xlt )
Last Updated: 10/15/2012
Content only available to logged-in subscribersTREC3 Bankcard Suggested Input Template 2007 (. zip )
Last Updated: 10/15/2012
NEXT STEPS: