Reports
Default reports specification - Lending Core Admin
The reports are those that are generated by default and their intention is to provide a complete visibility of the lending core product operation. Below, you will find the list of reports and the fields they include.
Consideration: The following reports are generated via API and saved in a local bucket where, with secure integration, they can be consulted and exported.
1. Loans
Periodicity: daily
| Field name | Type | Length | Description |
|---|---|---|---|
| LOAN_ID | Unique ID for each loan. | ||
| CUSTOMER_ID | Unique ID for each customer. | ||
| OFFER_ID | Unique ID for the associated offer. | ||
| OFFER_NAME | Name of the credit offer. | ||
| LOAN_AMOUNT | Amount requested by the customer. | ||
| LOAN_STATUS | Current loan status: Active, Paid, Cancelled, Frozen, Lost, in dispute | ||
| NUMBER_INSTALLMENTS | Number of loan installments. | ||
| INSTALMENT_FRECUENCY | Installment frecuency. | ||
| INTEREST_RATE | Interest rate (APR). | ||
| ADMIN_COST | Administration cost amount. | ||
| TAKEN_AT | Loan request date. | ||
| DISBURSED_AT | Loan activation date. | ||
| MAXIMUM_PAYMENT_DATE | Maximum payment date. |
2. Payments
Periodicity: daily
| Field name | Type | Length | Description |
|---|---|---|---|
| PAYMENT_ID | Unique ID for payment. | ||
| LOAN_ID | Unique ID for each loan. | ||
| CUSTOMER_ID | Unique ID for each customer. | ||
| PAYMENT_TYPE | Type of payment: voluntary or automatic. | ||
| PAYMENT_STATUS | Current payment status: Successful, Processing, Rejected. | ||
| TOTAL_AMOUNT | Total payment amount. | ||
| CAPITAL_AMOUNT | Capital payment amount. | ||
| INTEREST_AMOUNT | Interest payment amount. | ||
| TAX_AMOUNT | Tax payment amount. | ||
| DEFAULT_INTEREST_AMOUNT | Default interest payment amount. | ||
| COLLECTION_COST_AMOUNT | Administration cost payment amount. | ||
| ADMIN_COST_AMOUNT | Collection cost payment amount. | ||
| LOAN_HEALTH_STATUS | Current loan health status: Up to-date, 1 overdue instalment, 1+ overdue installments, Over maximum payment date, Bad debt. | ||
| PAYMENT_DATE | Payment date. | ||
| TAKEN_AT | Loan request date. | ||
| DISBURSED_AT | Loan activation date. |
3. Balance
Periodicity: daily
| Field name | Type | Length | Description |
|---|---|---|---|
| LOAN_ID | Unique ID for each loan. | ||
| CUSTOMER_ID | Unique ID for each customer. | ||
| LOAN_STATUS | Current loan status: Active, Paid,Cancelled, Frozen, Lost | ||
| LOAN_TERM | Term of the loan | ||
| PAYMENT_FRECUENCY | How is the frecuency when a user have to paid their loan | ||
| NUMBER_INSTALLMENTS | Number of installments choosed by the user | ||
| LOAN_HEALTH_STATUS | Health status: Up to-date, 1 overdue instalment, 1+ overdue instalment, past due date, bad debt | ||
| LOAN_AMOUNT | Amount requested by the customer. | ||
| TOTAL_DEBT | Total debt amount. | ||
| CAPITAL_DEBT | Total amount owed in capital. | ||
| INTEREST_DEBT | Total amount owed in interests. | ||
| TAX_DEBT | Total amount owed in taxes. | ||
| DEFAULT_INTEREST_DEBT | Total amount owed in overdue interests. | ||
| COLLECTION_COST_DEBT | Total amount owed in collection costs. | ||
| ADMIN_COST_DEBT | Total amount owed in administration costs. | ||
| MAXIMUM_PAYMENT_DATE | Maximum payment date. | ||
| TAKEN_AT | Loan request date. | ||
| DISBURSED_AT | Loan activation date. |
4. Past due
Periodicity: daily
This report only includes loans that are currently overdue
| Field name | Type | Length | Description |
|---|---|---|---|
| LOAN_ID | Unique ID for each loan. | ||
| CUSTOMER_ID | Unique ID for each customer. | ||
| OFFER_ID | Unique ID for the associated offer | ||
| LOAN_AMOUNT | Amount requested by the customer | ||
| LOAN_STATUS | Current loan status: Active, Paid,Cancelled, Frozen, Lost | ||
| LOAN_TERM | Term of the loan | ||
| PAYMENT_FRECUENCY | How is the frecuency when a user have to paid their loan | ||
| NUMBER_INSTALLMENTS | Number of installments choosed by the user | ||
| LOAN_HEALTH_STATUS | Health status: Up to-date, 1 overdue instalment, 1+ overdue instalment, past due date, bad debt | ||
| TOTAL_DEBT | Total debt amount. | ||
| CAPITAL_DEBT | Total amount owed in capital. | ||
| INTEREST_DEBT | Total amount owed in interests. | ||
| TAX_DEBT | Total amount owed in taxes. | ||
| DEFAULT_INTEREST_DEBT | Total amount owed in overdue interests. | ||
| COLLECTION_COST_DEBT | Total amount owed in collection costs. | ||
| ADMIN_COST_DEBT | Total amount owed in administration costs. | ||
| LOAN_HEALTH_STATUS | Current loan health status: Up to-date, 1 overdue instalment, 1+ overdue installments, Over maximum payment date, Bad debt. | ||
| LAST_PAYMENT_DATE | Date of last payment. | ||
| MAXIMUM_PAYMENT_DATE | Maximum payment date. | ||
| TAKEN_AT | Loan request date. | ||
| DISBURSED_AT | Loan activation date. |
5. Score
Periodicity: daily
This report includes the Score or credit line assigned by the client to its customers.
| Field name | Type | Length | Description |
|---|---|---|---|
| CUSTOMER_ID | Unique ID for each customer. | ||
| PRE_APPROVED_AMOUNT | Scoring model result preapproved amount in local currency. | ||
| SCORE | Scoring model result assigned to customer. Value between 0 and 1. | ||
| PRODUCT_ID | Unique ID for the associated product. | ||
| PRODUCT_NAME | Name of the credit product. | ||
| SCORE_DATE | Scoring date. |
Updated 3 months ago