Placement Export File Phone Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = CUPP

Debtor ID

5-13

2

debtor_number

Integer (9)

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

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 ID

73

5

phone_type_id

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)

0 = Unknown (blank for Excel)
1 = Bad
2 = Good

AIM sends the initial status with the placement or new phone record. If only the phone status changes, AIM doesn't send the status in a demographic update. AIM sends bad phone numbers as a ‘blank' new number in the CUPH record.

On Hold

75

7

on_hold

Integer (1)

Indicates whether phone is on hold:

0 = Not on hold
1 = On hold

Phone Number

76-105

8

phone_number

String (30)

Debtor phone number.

Phone Extension

106-115

9

phone_ext

String (10)

Phone extension.

Phone Name

116-145

10

phone_name

String (30)

Name for phone record.

Source

146-175

11

source

String (30)

Source for phone information:

USER = User added manually
CONVERSION = Converted from old system
SYNC = Matched from another linked account

Filler

176-3000

12

filler

String (2825)

Filler for fixed file layout. Delimited expects reference.