As part of PointPredictive best practices, customers provide performance information in a performance file every month. The field data and format expected in this performance file is provided below. Please schedule a consistent—automated, if possible—upload of this information using your SFTP credentials. If you do not have SFTP credentials, please contact us so we can assist in setting this up.
Please provide one CSV file each month with the following file naming standard customername_performance_YYYYMMDD.csv.
| File Name | Description | Data Type |
|---|---|---|
| application_id | Unique Application ID number | string |
| loan_id | Unique Loan ID or Contract ID | string |
| application_status | Status of Application (Approved, Declined, etc.) | string |
| decline_reason | Decline Reason (Fraud, Credit, Negative File, etc.) [optional] | string |
| is_funded | Funded Applications | boolean |
| is_fraud | Material Misrepresentation on Application | boolean |
| funded_date | Date Loan funded | string |
| loan_status | Serious Default, Repo, Chargeoff | string |
| status_date | Status As-of-Date | int (YYYYMMDD) |
| last_payment_date | Date of Last Payment | int (YYYYMMDD) |
| gross_loss | Gross Loss | int |
| net_loss | Net Loss | int |
| chargeoff_date | Date of Loan Chargeoff (if applicable) | string |
| stip_details | Stipulations Requested (optional) | string |
| borr_verified_gross_annual_income | Verified Annual Gross Income Amount for Primary Borrower | float |
| coborr_verified_gross_annual_income | Verified Annual Gross Income Amount for Co-borrower | float |