Feedback

  • Contents
 

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.

Related Topics

Bankruptcy Import File Layout

Import File Layouts