TABLE OF CONTENTS
Overview
Grain: One row per comment per application | Primary key: id | Foreign key: application_id → loan_applications.id
Comments are staff notes attached to applications, tasks, or other entities.
Delivery folders: las_comments-1-day and las_comments-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
- Use
entity_typeandentity_idtogether to identify what a comment is attached to (polymorphic reference). - Use
comment_typeto distinguish automated system comments (for example ACTION_BASED) from staff-authored notes. history_idlinks a comment to its corresponding audit_history event.
Data Dictionary
| Field Name | Description | Example | Required? |
|---|---|---|---|
id | UUID: unique comment record identifier. | 4e3d2c1b-0a99-4887-b766-554433221100 | 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 |
author_id | String: user ID of the staff member who wrote the comment. | usr_8f2a91 | No |
person_type | Enum: role of the commenter (for example STAFF). | STAFF | No |
content | String: full text of the comment. | Verified income documents, ready for review. | Yes |
comment_type | Enum: comment classification (for example ACTION_BASED). Use to distinguish automated system comments from staff-authored notes. | ACTION_BASED | No |
entity_id | UUID: ID of the entity this comment is attached to (for example a task). Use together with entity_type to resolve the linked record. | 6f5e4d3c-2b1a-4099-8877-665544332211 | No |
entity_type | String: type of entity this comment is attached to. Use together with entity_id. | TASK | No |
history_id | UUID: links this comment to a corresponding audit history event. Null if no audit event is associated. | 7a8b9c0d-1e2f-4344-9556-677889900aab | No |
created_on | Timestamp: when the comment was created. | 2026-06-12T14:05:00Z | Yes |
updated_on | Timestamp: when the comment was last modified. | 2026-06-12T14:05:00Z | Yes |
How This Table Joins to the Others
application_id→loan_applications.id.entity_idplusentity_type→ the task or other record the comment is attached to. Always checkentity_typebefore joining.history_id→audit_history.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