- Contents
AIM Help
Deceased Import File Record
Delimited/fixed record type = ADEC
Excel worksheet name = DeceasedRecord
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. |