TABLE OF CONTENTS
Overview
Grain: One row per application (1:1) | Primary key: id | Foreign key: application_id → loan_applications.id
Contains all loan calculation outputs (TILA disclosure fields) and the funding status.
Delivery folders: las_closing_information-1-day and las_closing_information-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
- Loan calculation (
calc_*) fields are null until a loan officer completes the closing worksheet. funding_detailsis a raw JSON payload whose content varies by funding method.
Data Dictionary
| Field Name | Description | Example | Required? |
|---|---|---|---|
id | UUID: unique closing record identifier. | 5d4c3b2a-1908-4756-a3b2-c1d0e9f8a7b6 | 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 |
repayment_frequency | Enum: payment frequency: MONTHLY / BI_WEEKLY / WEEKLY / SEMI_MONTHLY / QUARTERLY | MONTHLY | No |
first_repayment_due | Date: date of the first scheduled payment. | 2026-08-01 | No |
calc_apr | Decimal: final calculated annual percentage rate. | 0.0550 | No |
calc_monthly_payment | Decimal: calculated monthly payment amount in dollars. | 477.53 | No |
calc_total_interest | Decimal: total interest paid over the life of the loan. | 3651.80 | No |
calc_total_payments | Decimal: total of all payments (principal plus interest). | 28651.80 | No |
calc_amount_financed | Decimal: net amount financed. TILA disclosure field. | 25000.00 | No |
calc_finance_charge | Decimal: total finance charge. TILA disclosure field. | 3651.80 | No |
calc_recurring_repayment | Decimal: standard recurring repayment amount in dollars. | 477.53 | No |
calc_last_repayment_due | String: due date of the final repayment. | 2031-07-01 | No |
calc_last_repayment | Decimal: amount of the final repayment (may differ from the standard payment). | 477.33 | No |
calc_number_of_payments | Integer: total number of scheduled payments. | 60 | No |
calc_total_of_repayments | Decimal: sum of all scheduled repayments. | 28651.80 | No |
calc_first_payment_date | String: scheduled first payment date. | 2026-08-01 | No |
funding_status | Enum: disbursement status: PENDING / IN_PROGRESS / COMPLETED / FAILED / CANCELLED | COMPLETED | No |
funding_details | JSON: raw funding response payload. | {"status": "COMPLETED"} | No |
created_on | Timestamp: when the closing record was created. | 2026-06-20T16:00:00Z | Yes |
updated_on | Timestamp: when the closing record was last modified. | 2026-06-25T11:30:00Z | Yes |
How This Table Joins to the Others
application_id→loan_applications.id.- The disbursements table hangs off this closing record and joins on the same
application_id.
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