TABLE OF CONTENTS
Overview
Grain: One row per loan application | Primary key: id
This is the hub table of the export: every other table joins to it via application_id. It carries the application lifecycle state and the origination context (channel, branch, staff).
Delivery folders: las_loan_applications-1-day and las_loan_applications-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
stateis the current lifecycle state. Cancelled fields (cancelled_*) are null unless state = CANCELLED.origin_*branch and MSR fields are populated for branch-originated applications (origin_platform=staff_portal) and null for self-service digital applications (applicant_portal).- Use
application_numberas the customer-friendly reference in reports and communications. stp_off_board_*fields are populated only if the application was routed off the straight-through-processing path to manual handling; both are null otherwise.application_fee_outcomereflects the current fee-collection state and is null until a fee record exists.member_nrandaccount_nrare delivered afterupdated_on, at the end of each row.account_nris null until the loan has been booked to your core.
Data Dictionary
| Field Name | Description | Example | Required? |
|---|---|---|---|
id | UUID: unique application identifier. Primary key, used as the join key (application_id) across all related tables. | a1b2c3d4-e5f6-7890-abcd-ef1234567890 | Yes |
application_number | Integer: human-readable sequential application number. Use this as the customer-friendly reference number. | 1042 | Yes |
partner_id | UUID: your credit union identifier. All exported records are scoped to this value. | 550e8400-e29b-41d4-a716-446655440000 | Yes |
state | Enum: current lifecycle state. Values: PENDING_REVIEW / APPROVED_WITH_CONDITIONS / DOC_PREP / NEEDS_BOOKING / PENDING_AAN / CANCELLED / DECLINED / FUNDED | FUNDED | Yes |
origination_ip | String: IP address captured at application submission. | 203.0.113.42 | No |
cancelled_at | Timestamp: timestamp of cancellation. Null unless state = CANCELLED. | 2026-06-15T14:32:00Z | No |
cancelled_by_type | Enum: who initiated cancellation: MANUAL (staff) or SYSTEM (automated). Null unless state = CANCELLED. | MANUAL | No |
cancelled_by_user_id | String: staff user ID who cancelled the application. Null for SYSTEM cancellations. | usr_8f2a91 | No |
origin_platform | Enum: submission channel: staff_portal (branch-submitted) or applicant_portal (self-service digital). | staff_portal | Yes |
origin_module | Enum: product module. Currently always lending. | lending | Yes |
origin_branch_id | String: branch identifier for branch-originated applications. Null for digital applications. | br_001 | No |
origin_branch_name | String: human-readable branch name. Null for digital applications. | Main Street Branch | No |
origin_user_id | String: staff user ID who submitted on behalf of the borrower. Null for digital applications. | usr_8f2a91 | No |
origin_msr_name | String: display name of the Member Service Representative. Null for digital applications. | Jane Smith | No |
origin_msr_id | String: MSR identifier in your core system. Null for digital applications. | 12345 | No |
origin_branch_los_id | String: branch identifier in your core system. Null for digital applications. | 001 | No |
stp_off_board_stage | Enum: stage the application failed out of before being routed off the straight-through-processing path to manual handling: underwriting / closing. Null if it never left. | underwriting | No |
stp_off_board_reason | String: free-text reason the application was routed off the straight-through-processing path. Null if it never left. | Manual income verification required | No |
application_fee_outcome | Enum: outcome of the application fee: collected / waived_mla / failed / not_applicable. Null if no fee record exists yet. | collected | No |
created_on | Timestamp: when the application was submitted. | 2026-06-10T18:08:32Z | Yes |
updated_on | Timestamp: when the application record was last modified. Use it to keep the latest version of each record when ingesting. | 2026-06-15T14:32:00Z | Yes |
member_nr | String: member number at your credit union. | 1234567 | No |
account_nr | String: the loan/account number in your core system, assigned when the loan is booked. Null until the loan has been booked. | 0042 | No |
How This Table Joins to the Others
- Every other table in this export joins back to this one: their
application_idmatches this table'sid.
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