TABLE OF CONTENTS
Overview
Grain: One row per task per application | Primary key: id | Foreign key: application_id → loan_applications.id
Tasks represent required actions or document requests tied to an application. System-generated tasks are created automatically by workflow rules; user-created tasks are added manually by staff.
Delivery folders: las_tasks-1-day and las_tasks-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
participant_idlinks a task to a specific applicant; it is null for application-level tasks.metadatais a JSON payload whose schema varies bytask_type.
Data Dictionary
| Field Name | Description | Example | Required? |
|---|---|---|---|
id | UUID: unique task record identifier. | 6f5e4d3c-2b1a-4099-8877-665544332211 | 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 |
participant_id | UUID: applicant this task is associated with. Null for application-level tasks. | 9b2d5e12-3c4f-4a8b-9d6e-1f2a3b4c5d6e | No |
condition_id | UUID: links to an approval condition if applicable. Null for unconditional tasks. | 8a7b6c5d-4e3f-4211-a099-887766554433 | No |
title | String: human-readable task title as shown in the Clutch platform. | Upload proof of income | Yes |
description | String: optional detailed instructions or context for the task. | Most recent pay stub covering 30 days | No |
task_type | Enum: task category: NEEDS_PROOF_OF_INCOME / NEEDS_DRIVER_LICENSE / NEEDS_FRAUD_CHECK / MANUAL_TASK / and others | NEEDS_PROOF_OF_INCOME | Yes |
stage | Enum: workflow stage the task belongs to: ALERT / DECISION / CLOSING / POST_CLOSING / REVIEW | DECISION | Yes |
status | Enum: current status: PENDING / COMPLETED / CANCELLED | COMPLETED | Yes |
origin | Enum: how the task was created: SYSTEM (automated) or USER (staff-created) | SYSTEM | Yes |
created_by | String: user ID of the staff member who created the task. Null for SYSTEM tasks. | usr_3c7d22 | No |
completed_at | Timestamp: when the task was completed. Null if PENDING or CANCELLED. | 2026-06-12T15:45:00Z | No |
completed_by | String: user ID of whoever completed the task. | usr_8f2a91 | No |
reopened_at | Timestamp: when the task was most recently reopened. Null if never reopened. | 2026-06-13T09:20:00Z | No |
reopened_by | String: user ID of the staff member who reopened the task. | usr_3c7d22 | No |
reopened_comment_id | UUID: reference to the comment that explains why the task was reopened. | 1c2d3e4f-5a6b-4788-9900-aabbccddeeff | No |
metadata | JSON: task-type-specific supplementary data. Schema varies by task_type. | {"documentType": "PAY_STUB"} | No |
created_on | Timestamp: when the task was created. | 2026-06-11T10:20:00Z | Yes |
updated_on | Timestamp: when the task record was last modified. | 2026-06-12T15:45:00Z | Yes |
How This Table Joins to the Others
application_id→loan_applications.id.participant_id→participants.id(nullable).comments.entity_idpoints to this table'sidwhencomments.entity_typeis TASK.
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