Database - Bankruptcy Entity (bankruptcy_entity)

Description

This table holds the information for loan bankruptcies.

Common Uses

This table is commonly used to find:

  • Bankruptcy Status
  • Bankruptcy Court Information

Table Fields

Column

Data Type

Column Info

Value Notes

Other

id

INT(11)

This is the ID or the identifier of the bankruptcy.

loan_id

INT(11)

This is the ID of the loan the bankruptcy is associated with.

chapter

VARCHAR(100)

This specifies the specific chapter of bankruptcy.

loan.bankruptcyChapter.chapter7, loan.bankruptcyChapter.chapter9, loan.bankruptcyChapter.chapter11, loan.bankruptcyChapter.chapter12, loan.bankruptcyChapter.chapter13, loan.bankruptcyChapter.chapter128

petition_status

VARCHAR(100)

The status of the bankruptcy petition.

loan.bankruptcyPetitionStatus.discharged, loan.bankruptcyPetitionStatus.dismissed, loan.bankruptcyPetitionStatus.petitionFiled, loan.bankruptcyPetitionStatus.planConfirmed, loan.bankruptcyPetitionStatus.reaffirmed

process_status

VARCHAR(100)

The status of the bankruptcy process.

loan.bankruptcyProcessStatus.claimFiled, loan.bankruptcyProcessStatus.discharged, loan.bankruptcyProcessStatus.dismissed, loan.bankruptcyProcessStatus.noticeReceived, loan.bankruptcyProcessStatus.petitionFiledVerified, loan.bankruptcyProcessStatus.planConfirmed, loan.bankruptcyProcessStatus.reaffirmed

case_number

VARCHAR(255)

The bankruptcy case number.

filing_date

DATE

The date the bankruptcy was filed.

notice_received_date

DATE

The date the bankruptcy notice was received. 

automatic_stay_status

VARCHAR(100)

This refers to a court-ordered stay regarding the bankruptcy.

loan.bankruptcyAutomaticStayStatus.courtApproved, loan.bankruptcyAutomaticStayStatus.enforced, loan.bankruptcyAutomaticStayStatus.pending

customer_id

INT(11)

The identifier of the customer associated with the loan.

petition_type

VARCHAR(100)

Specifies whether the bankruptcy is filed singly or jointly.

loan.bankruptcyPetitionType.joint, loan.bankruptcyPetitionType.single

bankruptcy_district

VARCHAR(255)

The district that the bankruptcy was filed in.

city

VARCHAR(100)

The city that the bankruptcy was filed in.

state

VARCHAR(100)

The state that the bankruptcy was filed in.

proof_of_claim_deadline_date

DATE

A date specifying proof of claim.

meeting_of_creditors_date

DATE

Date specifying the meeting of creditors.

1 - yes, 0 - no

objection_deadline_date

DATE

Date of the objection deadline.

1 - yes, 0 - no

objection_status

VARCHAR(100)

Status of the objection related to the bankruptcy.

loan.bankruptcyObjectionStatus.claimFiled, loan.bankruptcyObjectionStatus.dischargeFiled, loan.bankruptcyObjectionStatus.dischargeOfDebtFiled, loan.bankruptcyObjectionStatus.notAvailable

liened_property_status

VARCHAR(100)

This refers to any liened property associated with the bankruptcy.

1 - yes, 0 - no

proof_of_claim_filed_status

VARCHAR(100)

The status of the proof of claim.

loan.bankruptcyProofOfClaimFiledStatus.filed, loan.bankruptcyProofOfClaimFiledStatus.pending

proof_of_claim_filed_date

DATE

The deadline date for the proof of claim. 

dismissed_date

DATE

The reason the bankruptcy was dismissed.

1 - yes, 0 - no

closed_reason

VARCHAR(255)

The reason the bankruptcy was closed.

created

DATETIME

This is the date the bankruptcy was created.

1 - yes, 0 - no

lastUpdated

TIMESTAMP

This is the date the bankruptcy was last updated.

active

TINYINT(1)

This specifies whether the bankruptcy is active.

1 - yes, 0 - no

deleted

TINYINT(1)

This specifies whether the bankruptcy has been deleted.


How did we do?


Powered by HelpDocs (opens in a new tab)