Deceased Import File Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = ADEC

Debtor ID

5-13

2

debtor_number

Integer (9)

Unique number assigned to each debtor record.

File Number

14-22

3

file_number

Integer (9)

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

SSN

23-31

4

ssn

String (9)

Deceased debtor's SSN.

First Name

32-61

5

first_name

String (30)

Deceased debtor's first name.

Last Name

62-91

6

last_name

String (30)

Deceased debtor's last name.

State

92-94

7

state

String (3)

Deceased debtor's state.

Postal Code

95-104

8

postal_code

String (10)

Deceased debtor's postal code.

Date of Birth

105-112

9

date_of_birth

DateTime (CCYYMMDD)

Deceased debtor's date of birth.

Date of Death

113-120

10

date_of_death

DateTime (CCYYMMDD)

Deceased debtor's date of death.

Match Code

121-125

11

match_code

String (5)

Match code.

Transmit Date

126-133

12

transmit_date

DateTime (CCYYMMDD)

Date you transmitted the information. For Excel file, use date/time format (for example, 6/20/2008  10:30:00 AM).

Claim Deadline

134-141

13

claim_deadline_date

DateTime (CCYYMMDD)

Deadline for filing a claim against the customer's estate.

Date Filed

142-149

14

filed_date

DateTime (CCYYMMDD)

Date the client filed a claim against the customer's estate.

Case Number

150-169

15

case_number

String (20)

Claim case number.

Executor

170-219

16

executor

String (50)

Name of the executor of the customer's estate.

Executor Phone

220-269

17

executor_phone

String (50)

Executor's phone number.

Executor Fax

270-319

18

executor_fax

String (50)

Executor's fax number.

Executor Street 1

320-447

19

executor_street1

String (128)

Executor's street address line 1.

Executor Street 2

448-575

20

executor_street2

String (128)

Executor's street address line 2.

Executor State

576-578

21

executor_state

String (3)

Executor's state.

Executor City

579-678

22

executor_city

String (100)

Executor's city.

Executor Postal Code

679-688

23

executor_zipcode

String (10)

Executor's postal code.

Court City

689-738

24

court_city

String (50)

Court's city.

Court District

739-938

25

court_district

String (200)

Court district handling the customer's estate.

Court Division

939-1038

26

court_division

String (100)

Court division handling the customer's estate.

Court Phone

1039-1088

27

court_phone

String (50)

Court's phone number.

Court Street 1

1089-1216

28

court_street1

String (128)

Court's street address line 1.

Court Street 2

1217-1344

29

court_street2

String (128)

Court's street address line 2.

Court State

1345-1347

30

court_state

String (3)

Court's state.

Court Postal Code

1348-1362

31

court_zipcode

String (15)

Court's postal code.

Country

1363-1490

32

country

String (128)

Executor's country.

County

1491-1618

33

county

String (128)

Executor's county.