- Contents
AIM Help
Bankruptcy Import File Record
Delimited/fixed record type = ABKP
Excel worksheet name = BankruptcyRecord
Latitude |
Position |
Col |
Column Name |
Format |
Comment |
Record Type |
1-4 |
1 |
record_type |
String (4) |
Value = ABKP |
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. Use this value for all data sent to AIM. |
Chapter |
23-24 |
4 |
chapter |
Integer (2) |
Bankruptcy Chapter 7, 11, or 13. |
Date Filed |
25-32 |
5 |
date_filed |
DateTime (CCYYMMDD) |
Date the debtor filed bankruptcy. |
Case Number |
33-52 |
6 |
case_number |
String (20) |
Court case number. |
Court District |
53-132 |
7 |
court_district |
String (80) |
Court district where the debtor filed bankruptcy. |
Court Division |
133-212 |
8 |
court_division |
String (80) |
Division of the court where the debtor filed bankruptcy. |
Court Phone |
213-242 |
9 |
court_phone |
String (30) |
Court clerk's phone number. |
Court Street1 |
243-370 |
10 |
court_street1 |
String (128) |
Court's address line 1. |
Court Street2 |
371-498 |
11 |
court_street2 |
String (128) |
Court's address line 2. |
Court City |
499-548 |
12 |
court_city |
String (50) |
Court's city. |
Court State |
549-551 |
13 |
court_state |
String (3) |
Court's state. |
Court ZIP Code |
552-561 |
14 |
court_zipcode |
String (10) |
Court's postal code. |
Trustee |
562-611 |
15 |
trustee |
String (50) |
Trustee's name. |
Trustee Street1 |
612-739 |
16 |
trustee_street1 |
String (128) |
Trustee's address line 1. |
Trustee Street2 |
740-867 |
17 |
trustee_street2 |
String (128) |
Trustee's address line 2. |
Trustee City |
868-917 |
18 |
trustee_city |
String (50) |
Trustee's city. |
Trustee State |
918-920 |
19 |
trustee_state |
String (3) |
Trustee's state. |
Trustee ZIP Code |
921-930 |
20 |
trustee_zipcode |
String (10) |
Trustee's postal code. |
Trustee Phone |
931-960 |
21 |
trustee_phone |
String (30) |
Trustee's phone number. |
Has 341 Info |
961 |
22 |
three_forty_one_info_flag |
Boolean (1) |
341 indicator (90 or 1). |
Date Time 341 |
962-969 |
23 |
three_forty_one_date |
Date (CCYYMMDD) |
341 date. |
Location 341 |
970-1049 |
24 |
three_forty_one_location |
String (80) |
341 location. |
Comments |
1050-1349 |
25 |
comments |
String (300) |
Bankruptcy comments. |
Status |
1350-1449 |
26 |
status |
String (100) |
Description of the account status. |
Transmitted Date |
1450-1457 |
27 |
transmit_date |
DateTime (CCYYMMDD) |
Date you received the information. |
Notice Received |
1458-1465 |
28 |
notice_date |
DateTime (CCYYMMDD) |
Date the client received a notice that the customer filed for bankruptcy. |
Proof of Claim |
1466-1473 |
29 |
proof_filed_date |
DateTime (CCYYMMDD) |
Date the client sent a proof of claim to the court. |
Discharge Date |
1474-1481 |
30 |
discharge_date |
DateTime (CCYYMMDD) |
Date the court discharged the bankruptcy. |
Dismissal Date |
1482-1489 |
31 |
dismissal_date |
DateTime (CCYYMMDD) |
Date the court dismissed the bankruptcy. |
Confirm Hearing |
1490-1497 |
32 |
confirmation_hearing_date |
DateTime (CCYYMMDD) |
Date the court set the confirmation hearing. |
Reaffirmation Filed Date |
1498-1505 |
33 |
reaffirm_filed_date |
DateTime (CCYYMMDD) |
Date the customer filed the reaffirmation with the court. |
Voluntary Date |
1506-1513 |
34 |
voluntary_date |
DateTime (CCYYMMDD) |
Date the customer volunteered to pay off the debt. |
Surrender Date |
1514-1521 |
35 |
surrender_date |
DateTime (CCYYMMDD) |
Date the customer surrendered the item. |
Auction Date |
1522-1529 |
36 |
auction_date |
DateTime (CCYYMMDD) |
Date the auction house auctioned the surrendered item. |
Reaffirmation Amount |
1530-1541 |
37 |
reaffirm_amount |
Decimal (12) |
Amount that the customer reaffirmed to pay. |
Voluntary Amount |
1542-1553 |
38 |
voluntary_amount |
Decimal (12) |
Amount the customer volunteered to pay. |
Auction Amount |
1554-1565 |
39 |
auction_amount |
Decimal (12) |
Amount the auction house received for the surrendered item. |
Auction Fee Amount |
1566-1577 |
40 |
auction_fee_amount |
Decimal (12) |
Fee the auction house charged for auctioning the surrendered item. |
Auction Amount Applied |
1578-1589 |
41 |
auction_applied_amount |
Decimal (12) |
Amount of the auction funds applied to the account. |
Secured Amount |
1590-1601 |
42 |
secured_amount |
Decimal (12) |
Amount of the debt that is secured. Chapters 11, 12, and 13 only. |
Secured Plan Percent |
1602-1613 |
43 |
secured_percentage |
Decimal (12) |
Percentage of the secured amount for which the customer remains responsible. Chapters 11, 12, and 13 only. |
Unsecured Amount |
1614-1625 |
44 |
unsecured_amount |
Decimal (12) |
Amount of the debt that is unsecured. Chapters 11, 12, and 13 only. |
Unsecured Plan Percent |
1626-1637 |
45 |
unsecured_percentage |
Decimal (12) |
Percentage of the unsecured amount for which the customer remains responsible. Chapters 11, 12, and 13 only. |
Converted Chapter |
1638-1639 |
46 |
converted_from_chapter |
Integer (2) |
Original bankruptcy chapter number. |
Has Asset |
1640 |
47 |
has_asset |
String (1) |
Customer has assets to secure the debt. Chapter 7 only. |
Reaffirmation |
1641 |
48 |
reaffirm_flag |
String (1) |
Indicates whether the customer reaffirmed the debt under new terms. |
Reaffirmation Terms |
1642-1691 |
49 |
reaffirm_terms |
String (50) |
Agreed upon terms of the reaffirmation. |
Terms |
1692-1741 |
50 |
voluntary_terms |
String (50) |
Terms of payment. |
Surrender Method |
1742-1791 |
51 |
surrender_method |
String (50) |
How the customer surrendered the item (for example, shipped or picked up). |
Auction House |
1792-1841 |
52 |
auction_house |
String (50) |
Name of the auction house that auctioned the surrendered item. |
Country |
1842-1969 |
53 |
country |
String (128) |
Country where the customer filed bankruptcy. |
County |
1970-2097 |
54 |
county |
String (128) |
County where the customer filed bankruptcy. |