Demographics Export File Phone Record

The CUPH records send a blank old number to indicate bad phone numbers.

Delimited/fixed = CUPH

Excel worksheet name = PhoneRecord

Latitude	Position	Col	Column Name	Format	Comment
Record Type	1-4	1	record_type	String (4)	Value = CUPH
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 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.
Phone Type	23	4	phone_type	String (1)	1 = Home 2 = Work
New Number	24–53	5	new_number	String (30)	New phone number. AIM sends bad phone numbers as a ‘blank' new number.
Old Number	54–83	6	old_number	String (30)	Old phone number.
Date Changed	84–91	7	date_changed	DateTime (CCYYMMDD)	Debtor phone number.
Filler	92–628	8	Filler	String (537)	Filler for fixed file layout.