Version 1: Daily Loan Status file for Installment Loans
Galileo currently offers two versions of the Daily Loan Status file for installment loans. This file covers details such as current loans, subproducts, statuses, and installment due dates.
The following documents the list of fields included in version 1.0. For version 2.0, see Reports of Installment Loans.
Daily Loan Status file (v1.0)
This table contains details about the fields included in the Daily Loan Status file. The reports are loan ID specific, meaning there could be multiple active loan_ID
s associated with the same Customer_Prn
in a daily report.
The fields in the daily file are presented in this order.
Field Name | Type | Length | Description |
---|---|---|---|
Loan_Id | string | 30 | Galileo-generated identifier for the loan. |
Customer_Prn | string | 12 | The PRN for the customer’s primary account. |
Subproduct_Code | string | 15 | Galileo-generated identifier for the loan subproduct assigned to the simulation or loan, as configured for the program. For programs with multiple subproducts, the choice would be determined by underwriting. |
Loan_Status_Description | string | 13 | Current status of the loan. See the Loan Payment Status and Loan Status Table for detailed descriptions of each status. |
Loan_Payment_Status | string | 4 | Current loan payment status code. See the Loan Payment Status and Loan Status Table for detailed descriptions of each status. |
Loan_Apr | float | 16(2) | Annual percentage rate for interest charged on the loan. Calculated from the interest defined by the subproduct, the length of the loan, and the origination fee (if applicable). |
Loan_Start_Date | date | 8 | Date the funds are disbursed and interest, if configured, begins to accrue. Format: YYYYMMDD |
Loan_Start_Today_Flag | string | 5 | Returns TRUE if the loan started today; otherwise, returns FALSE . |
Interest_Rate | float | 16(2) | Interest rate applied to the loan, as defined by the subproduct. |
Per_Diem | float | 16(2) | Daily interest charged on the loan. This amount will update as installments are paid. |
Scheduled_Installment_Amount | float | 16(2) | Payment due at each installment. |
Loan_Term | integer | 9 | Total count of installments, as defined by the subproduct. |
Original_Loan_Amount | float | 16(2) | Total loan amount borrowed by the customer. |
Principal_Balance | float | 16(2) | Current principal balance remaining on the loan. |
Principal_Paid_To_Date | float | 16(2) | Principal amount of the loan that is paid off. |
Interest_Paid_To_Date | float | 16(2) | Interest amount of the loan that is paid off. |
Fees_Paid_To_Date | float | 16(2) | The fee amount the customer has paid to date. |
Total_Payoff_Amount | float | 16(2) | Total amount to pay off the remaining loan if the customer paid it off today. Includes the remaining principal amount, interest, and fees. |
Maturity_Date | date | 8 | The projected date the loan can be paid off by. This is a dynamic value that is based on the customer's actual payment activity. Format: YYYYMMDD |
Closed_Date | date | 8 | Date that the loan was closed. Value returned if the loan is paid off or charged off. Otherwise, it returns null. Format: YYYYMMDD |
Paid_Installments | integer | 2 | Number of installment payments that the customer has made on the loan. |
Remaining_Installments | integer | 2 | Number of installment payments remaining on the loan. |
Non_Accrual_Flag | string | 5 | Returns TRUE if interest is not accruing on the loan. Otherwise, returns FALSE . |
Delinquency_Date | date | 8 | Date when the oldest unpaid installment became past due. Format: YYYYMMDD |
Past_Due_Amount | float | 16(2) | The installment amount that is past due for the loan. |
Days_Past_Due | integer | 9 | The number of days that the loan is delinquent. When the loan is charged off, this value resets to 0 because the loan is officially closed. |
Loan_Status_Reason_Code | string | 32 | The reason provided for charging off the loan, as provided in the API request. |
Total_Charge_Off_Amount | float | 16(2) | The total amount of the loan that was charged off. |
Installment_Due_Date | date | 8 | Dates when the installments are due. Includes up to 24 columns up to 24 installments. Format: YYYYMMDD |