Demographics Export File Address Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = CUAD

Debtor ID

5–13

2

debtor_number

Integer (9)

Unique number assigned to each debtor record.

Account ID

14–22

3

file_number

Integer (9)

Unique number assigned to each account placed in Latitude. Use this value for all data sent to AIM.

New Street1

23-150

4

new_street1

String (128)

Debtor's new street address line 1.

New Street2

151-278

5

new_street2

String (128)

Debtor's new street address line 2.

New City

279-308

6

new_city

String (30)

Debtor's new city.

New State

309-311

7

new_state

String (3)

Debtor's new state.

New ZIP Code

312-321

8

new_zipcode

String (10)

Debtor's new postal code.

Old Street1

322-449

9

old_street1

String (128)

Debtor's previous street address line 1.

Old Street2

450-577

10

old_street2

String (128)

Debtor's previous street address line 2.

Old City

578-607

11

old_city

String (30)

Debtor's previous city.

Old State

608-610

12

old_state

String (3)

Debtor's previous state.

Old ZIP Code

611-620

13

old_zipcode

String (10)

Debtor's previous postal code.

Date Changed

621-628

14

date_updated

DateTime (CCYYMMDD)

Date the address changed.