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. |