TABLE OF CONTENTS
Overview
Grain: One row per applicant per application | Primary key: id | Foreign key: application_id → loan_applications.id
This table includes both primary applicants and co-applicants. Filter on role to separate them. The id of this table is referenced as participant_id in the decisions and tasks tables.
Delivery folders: las_participants-1-day and las_participants-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
- Personal information is point-in-time: it reflects the applicant's information as of the application, not later profile updates.
- No SSN data is included in this export.
e_consentis not currently sourced and is always null.member_nr,account_nr,secondary_scoreandsecondary_score_modelare 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 participant record identifier. Used as participant_id in decisions and tasks. | 9b2d5e12-3c4f-4a8b-9d6e-1f2a3b4c5d6e | 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 |
role | Enum: applicant role: PRIMARY or CO_APPLICANT | PRIMARY | Yes |
credit_score | Integer: credit score snapshot stored on the participant record. | 720 | No |
mla_status | Enum: Military Lending Act check status: ACTIVE_MILITARY / NOT_ACTIVE_MILITARY | NOT_ACTIVE_MILITARY | No |
ofac_status | Enum: OFAC screening status: NO_MATCH / POTENTIAL_MATCH / MATCH_FOUND / NO_RESULT / ERROR | NO_MATCH | No |
first_name | String: applicant first name. | Jane | No |
middle_name | String: applicant middle name. Null if not provided. | Q | No |
last_name | String: applicant last name. | Doe | No |
suffix | String: name suffix (JR, SR, III, and so on). Null if not provided. | JR | No |
date_of_birth | Date: applicant date of birth. | 1990-01-16 | No |
address_line_1 | String: primary mailing address street line. | 1 Main St | No |
address_line_2 | String: apartment, unit, or suite. Null if not provided. | Apt 4 | No |
city | String: mailing address city. | Austin | No |
state | String: mailing address 2-letter state code. | TX | No |
zip_code | String: mailing address ZIP code. | 78701 | No |
email | String: primary email address. | jane@example.com | No |
cell_phone | String: cell phone number. Null if not provided. | +15551234567 | No |
is_member | Boolean: whether the applicant was an existing member at application time. | true | No |
e_consent | Boolean: whether the applicant accepted electronic disclosures. Currently always null -- not sourced today. | null | No |
annual_income | Decimal: self-reported annual income in dollars. | 85000.00 | No |
employment_months | Integer: months at current employer. Null if not provided. | 24 | No |
created_on | Timestamp: when the participant record was created. | 2026-06-10T18:08:32Z | Yes |
updated_on | Timestamp: when the participant record was last modified. | 2026-06-15T14:32:00Z | Yes |
member_nr | String: member number of the applicant 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 |
secondary_score | Integer: a supplementary credit score for the applicant, delivered alongside credit_score when one is available. Null if there is none. | 735 | No |
secondary_score_model | String: the name of the scoring model behind secondary_score, as reported by the credit bureau. Null if there is no secondary score. | (model name as reported by the bureau) | No |
How This Table Joins to the Others
application_id→loan_applications.id.decisions.participant_idandtasks.participant_idboth point back to 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