Input, Output & Reporting

Read from files or databases, select exactly the records you want, write results in the shape you need, and document every job with a full suite of reports.

Data sources

A job reads from a file or a database table. Input can be laid out as discrete fields or as free-form multiline blocks, so Address IQ fits into existing data structures without reshaping them first.

Selecting records

You don't have to process an entire source every time. Address IQ can:

  • Filter on input - process only the records that meet criteria you define.
  • Filter on results - route records to different outputs based on how they were assigned (for example, deliverable vs. undeliverable, or by result code).
  • Process a range - start and stop at specific record numbers, which is handy for testing or splitting large runs.

Output options

Address IQ gives you control over what to write and where. You can create a new output file or table, copy selected input fields through to the output, and choose exactly which standardized components and codes to include.

  • Write to a new file or database table.
  • Produce standardized whole addresses, discrete components, or both.
  • Split results across multiple outputs using result-based filters.
Tip: The four broad output forms - standardized, raw components, standardized components, and generated codes - are described in How It Works.

Reports

Every job can produce reports that document what happened and satisfy USPS requirements. The most commonly used include:

  • USPS Form 3553 (CASS) - the certification report required to claim automation postage discounts.
  • Job Summary - throughput, assignment rates, and detailed statistics across the run.
  • Executive Summary - a high-level snapshot of the job's results.
  • Standardization & Error reports - record-level listings of what was changed and why records could not be assigned.
  • Mover IQ Summary - results of NCOALink move processing.
  • Delivery Sequence Invoice - required when claiming DSF2 walk-sequence discounts.
  • GeoCensus report - a summary of geographic and census coding results.

Report formats

Reports can be generated as PDF for human-readable documents, or as XML and JSON when you want to consume job statistics programmatically - for example, to feed dashboards or automated quality checks. Address IQ also produces machine-readable statistics files that summarize processing at the job and file level.

PreviousGeocoding