Placement Export File Phone Record

Latitude

Position

Column Name

Format

Comment

Record Type

1-4

record_type

String (4)

Value = CUPP

Debtor ID

5-13

debtor_number

Integer (9)

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

File Number

14-22

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

relationship

String (50)

Debtor's relationship to the account.

Phone Type ID

73

phone_type_id

Integer (1)

1 = Home
2 = Work
3 = Cell

4 = Fax
5 = Spouse home
6 = Spouse work

Phone Status ID

74

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

on_hold

Integer (1)

Indicates whether phone is on hold:

0 = Not on hold
1 = On hold

Phone Number

76-105

phone_number

String (30)

Debtor phone number.

Phone Extension

106-115

phone_ext

String (10)

Phone extension.

Phone Name

116-145

phone_name

String (30)

Name for phone record.

Source

146-175

source

String (30)

Source for phone information:

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

Consent to Call

176-176

AllowManualCall

String (1)

Indicates whether the party on the account granted permission to allow calls to the phone number.

Consent to Auto Dial

177-177

AllowAutoDialer

String (1)

Indicates whether the party on the account granted permission to allow calls to the phone number using a dialer campaign.

Consent to Fax

178-178

AllowFax

String (1)

Indicates whether the party on the account granted permission to allow sending faxes to the phone number.

Consent to SMS

179-179

AllowText

String (1)

Indicates whether the party on the account granted permission to allow sending texts to the phone number

Method

180-180

WrittenConsent

String (1)

Indicates whether the party on the account granted permission in writing.

Obtained From

181-280

ObtainedFrom

String (100)

Party on the account who granted or denied permission to contact the phone number.

Effective Date

281-288

EffectiveDate

DateTime (MMDDYYYY)

Date the party on the account granted or denied permission to contact the phone number.

Comment

289-408

Comment

String (120)

Details about permission to contact the phone number.

Monday Never Call

409-409

MondayNeverCall

String (1)

Y if no calls allowed this day

Monday Call Window Start

410-413

MondayCallWindowStart

Time (HHMM)

24 hour clock

Monday Call Window End

414-417

MondayCallWindowEnd

Time (HHMM)

24 hour clock

Monday No Call Window Start

418-421

MondayNoCallWindowStart

Time (HHMM)

24 hour clock

Monday No Call Window End

422-425

MondayNoCallWindowEnd

Time (HHMM)

24 hour clock

Tuesday Never Call

426-426

TuesdayNeverCall

String (1)

Y if no calls allowed this day

Tuesday Call Window Start

427-430

TuesdayCallWindowStart

Time (HHMM)

24 hour clock

Tuesday Call Window End

431-434

TuesdayCallWindowEnd

Time (HHMM)

24 hour clock

Tuesday No Call Window Start

435-438

TuesdayNoCallWindowStart

Time (HHMM)

24 hour clock

Tuesday No Call Window End

439-442

TuesdayNoCallWindowEnd

Time (HHMM)

24 hour clock

Wednesday Never Call

443-443

WednesdayNeverCall

String (1)

Y if no calls allowed this day

Wednesday Call Window Start

444-447

WednesdayCallWindowStart

Time (HHMM)

24 hour clock

Wednesday Call Window End

448-451

WednesdayCallWindowEnd

Time (HHMM)

24 hour clock

Wednesday No Call Window Start

452-455

WednesdayNoCallWindowStart

Time (HHMM)

24 hour clock

Wednesday No Call Window End

456-459

WednesdayNoCallWindowEnd

Time (HHMM)

24 hour clock

Thursday Never Call

460-460

ThursdayNeverCall

String (1)

Y if no calls allowed this day

Thursday Call Window Start

461-464

ThursdayCallWindowStart

Time (HHMM)

24 hour clock

Thursday Call Window End

465-468

ThursdayCallWindowEnd

Time (HHMM)

24 hour clock

Thursday No Call Window Start

469-472

ThursdayNoCallWindowStart

Time (HHMM)

24 hour clock

Thursday No Call Window End

473-476

ThursdayNoCallWindowEnd

Time (HHMM)

24 hour clock

Friday Never Call

477-477

FridayNeverCall

String (1)

Y if no calls allowed this day

Friday Call Window Start

478-481

FridayCallWindowStart

Time (HHMM)

24 hour clock

Friday Call Window End

482-485

FridayCallWindowEnd

Time (HHMM)

24 hour clock

Friday No Call Window Start

486-489

FridayNoCallWindowStart

Time (HHMM)

24 hour clock

Friday No Call Window End

490-493

FridayNoCallWindowEnd

Time (HHMM)

24 hour clock

Saturday Never Call

494-494

SaturdayNeverCall

String (1)

Y if no calls allowed this day

Saturday Call Window Start

495-498

SaturdayCallWindowStart

Time (HHMM)

24 hour clock

Saturday Call Window End

499-502

SaturdayCallWindowEnd

Time (HHMM)

24 hour clock

Saturday No Call Window Start

503-506

SaturdayNoCallWindowStart

Time (HHMM)

24 hour clock

Saturday No Call Window End

507-510

SaturdayNoCallWindowEnd

Time (HHMM)

24 hour clock

Sunday Never Call

511-511

SundayNeverCall

String (1)

Y if no calls allowed this day

Sunday Call Window Start

512-515

SundayCallWindowStart

Time (HHMM)

24 hour clock

Sunday Call Window End

516-519

SundayCallWindowEnd

Time (HHMM)

24 hour clock

Sunday No Call Window Start

520-523

SundayNoCallWindowStart

Time (HHMM)

24 hour clock

Sunday No Call Window End

524-527

SundayNoCallWindowEnd

Time (HHMM)

24 hour clock

Filler

528-3000

Filler

String (2473)

Filler for fixed file layout. Delimited expects reference.