Demographics Import File Layout

The demographics import file contains updated phone number and address information that you received from the agencies and attorneys holding the accounts. Agencies and attorneys can send multiple phone and address records for an individual account, as AIM tracks this information using the debtor ID.

Delimited or fixed file record types

Delimited and fixed files contain the following record types:

• AUAD: Address update records

• AUPP: Phone panel update records.

• AEML: Email update records.

• ATRL: Trailer record that indicates the total number of records in the file.

• AUVN: Validation Notice update records.

Microsoft Excel file

Excel files contain a separate worksheet for each record type included. Excel formats the columns using the general format type. The worksheets include:

• AddressRecord: Address update records.

• PhonePanelRecord: Phone panel update records. This worksheet lists all newly added numbers.

• Email: Email update records.

 

Related Topics

Demographics Import File Naming Convention

Demographics Import File Address Record

Demographics Import File Phone Panel Record

Demographics Import File Email Record

Demographics Import File Trailer Record

Demographics Import File Validation Notice Record

Import File Layouts