TABLE OF CONTENTS
Overview
Grain: One row per product per application (1:1) | Primary key: id | Foreign key: application_id → loan_applications.id
The product requested on each application: category, structure, amount, term, and rate.
Delivery folders: las_loan_products-1-day and las_loan_products-30-day
This article covers one table. For delivery options, ingestion guidance, the full table relationship diagram, and the export FAQ, see Data Exports: Clutch Lending LOS (LAS).
Things to Know About This Table
credit_limitis populated only for revolving products (for example credit cards);termapplies to installment products.apris a decimal string:0.0550means 5.50%.eligibility_amount_minandeligibility_amount_maxare currently populated only for credit card products.
Data Dictionary
| Field Name | Description | Example | Required? |
|---|---|---|---|
id | UUID: unique product record identifier. | 7c9e6679-7425-40de-944b-e07fc1f90ae7 | Yes |
application_id | UUID: foreign key to loan_applications. | a1b2c3d4-e5f6-7890-abcd-ef1234567890 | Yes |
partner_id | UUID: your credit union identifier. | 550e8400-e29b-41d4-a716-446655440000 | Yes |
domain | Enum: high-level product domain. Currently always LENDING. | LENDING | Yes |
category | Enum: product category: VEHICLE / PERSONAL / CREDIT_CARD / HOME_EQUITY | VEHICLE | Yes |
security | Enum: collateral classification: SECURED or UNSECURED | SECURED | Yes |
structure | Enum: repayment structure: INSTALLMENT / REVOLVING / MORTGAGE / DEPOSIT | INSTALLMENT | Yes |
type | Enum: specific product type: AUTOMOBILE / PERSONAL_LOAN / CREDIT_CARD / HOME_EQUITY / and others | AUTOMOBILE | Yes |
amount | Decimal: requested or approved loan amount in dollars. | 25000.00 | No |
term | Integer: loan term in months. | 60 | No |
apr | String: annual percentage rate as a decimal string (0.0550 = 5.50%). | 0.0550 | No |
credit_limit | Decimal: credit limit for revolving products (for example credit cards). Null for installment loans. | 10000.00 | No |
purpose | String: loan purpose as stated by the applicant. | Vehicle purchase | No |
eligibility_approval_type | Enum: pre-screening outcome: PRE_APPROVED / PRE_QUALIFIED / SKIPPED / QUALIFIED / NOT_QUALIFIED | PRE_APPROVED | No |
eligibility_amount_min | Decimal: minimum pre-approved amount. Currently only populated for credit card products. | 1000.00 | No |
eligibility_amount_max | Decimal: maximum pre-approved amount. Currently only populated for credit card products. | 15000.00 | No |
created_on | Timestamp: when the product record was created. | 2026-06-10T18:08:32Z | Yes |
updated_on | Timestamp: when the product record was last modified. | 2026-06-15T14:32:00Z | Yes |
How This Table Joins to the Others
application_id→loan_applications.id(one product row per application).
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article