STP Export: decisions

TABLE OF CONTENTS

• Overview
• Things to Know About This Table
• Data Dictionary
• How This Table Joins to the Others

Overview

Grain: One row per participant (latest final decision)  |  Primary key: id

The latest final decision for each participant on an application. Joins to loan_applications via application_id and to participants via participant_id.

Delivery folders: stp_decisions-1-day and stp_decisions-30-day

This article covers one table. For delivery details, ingestion guidance, the full table relationship diagram, and the export FAQ, see Data Exports: Clutch Lending STP.

Things to Know About This Table

• An application with a co-applicant has one decision row per participant, not one per application. Join through participant_id to know whom each decision applies to.
• Only the latest final decision is exported; intermediate decisions are not.
• This table delivers created_on (the decision date) but not updated_on. The 1-day and 30-day windows still select records by when they were last modified, so a record can reappear in a later file when it is updated. Always upsert on id.

Data Dictionary

How This Table Joins to the Others

• Joins to loan_applications: application_id matches loan_applications.id. One row per participant, not per application.
• participant_id matches participants.id, which links each decision to its applicant.