Demographics Import File Phone Panel Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = AUPP

Debtor ID

5–13

2

debtor

Integer (9)

Unique number assigned to each debtor record. Use this value for all data sent to AIM to identify the debtor.

File Number

14–22

3

file_number

Integer (9)

Unique number assigned to each account placed (zero padded). Use this value for all data sent to AIM.

Relationship

23-72

4

relationship

String (50)

Debtor's relationship to the account.

Phone Type

73

5

phone_type

Integer (1)

1 = Home
2 = Work
3 = Cell
4 = Fax
5 = Spouse Home
6 = Spouse Work

Phone Status ID

74

6

phone_status_id

Integer (1)

1 = Bad
2 = Good

On Hold

75

7

on_hold

Boolean (1)

0 = Not on hold
1 = On hold

Phone Number

76-105

8

phone_number

String (30)

Debtor's phone number.

Phone Extension

106-115

9

phone_ext

String (10)

Debtor's phone extension.

Phone Name

116-145

10

phone_name

String (30)

Name for phone record.

Source

146-175

11

source

String (30)

Method for adding phone information:

USER = User added manually

CONVERSION = Converted from old system

SYNC = Matched from a linked account

Filler

176-628

12

Filler

String (453)

Filler for fixed file layout. Delimited expects reference.