Funding Transaction

Funding Transaction

Report type: funding_transaction

About this export

• 1 row per funding transaction
• 0 to many rows per loan
• Every ACH funding attempt will have its own row
  • ACH re-attempts will have the same loan_uuid_value and loan_funding_attempt_number incremented by 1
• Direct debt (Intellidebt) cash disbursements will have is_liability_payoff_cash_disbursement set to true
  • A Direct debt cash disbursement makes the borrower whole in the event of a lower-than-reported liability balance (e.g., payoff amount was $10,000 but the actual balance at funding time was $9,500, so a $500 cash disbursement is made to the borrower)

---

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	funding_transaction_id	STRING	NON-NULLABLE	2023-09-14
2	loan_uuid_value	STRING	NON-NULLABLE	2023-06-23
3	loan_short_id	STRING	NON-NULLABLE	2023-06-23
4	organization	STRING	NON-NULLABLE	2023-06-23
5	funding_amount	FLOAT	NON-NULLABLE	2023-06-23
6	funding_initiated_timestamp	TIMESTAMP	NULLABLE	2023-06-23
7	funding_initiated_datetime_pst	DATETIME (Pacific Time)	NULLABLE	2023-06-23
8	nacha_message_uuid	STRING	NULLABLE	2023-06-23
9	loan_funding_attempt_number	INTEGER	NULLABLE	2023-06-23
10	batching_status	STRING	NON-NULLABLE	2023-06-23		PENDING BATCHING RETURNED SENT - REATTEMPT SENT
11	nacha_sent_timestamp	TIMESTAMP (UTC)	NULLABLE	2023-06-23
12	nacha_sent_datetime_pst	DATETIME (Pacific Time)	NULLABLE	2023-06-23
13	batch_effective_date	DATE	NULLABLE	2023-06-23
14	daily_batch_category	STRING	NULLABLE	2023-06-23		SAME DAY BATCH 1 SAME DAY BATCH 2 NEXT FUNDING DAY BATCH		ignore; vestigial field
15	is_liability_payoff_cash_disbursement	BOOLEAN	NULLABLE	2025-06-06