Data Export

Use Cases

Figure provides a set of data export files that our loan originator partners can use to access application data in bulk. These are database snapshots captured, packaged, and made available on a regular schedule.

These exports are designed to be ingested into a data warehouse. Our partners have used these files to enable integrations with their own loan origination systems, customer relationship management systems, or business intelligence reporting systems.

The report files can be used as-is, however it is recommended to ingest these files into a data warehouse.

Figure can deliver these files to a secure storage solution hosted by your organization, or they can be downloaded manually from Lead Portal. See File Exchange for more information.

All Data Export files are encrypted with your organization's PGP key and must be decrypted before use. See Data Encryption for more information.

Best Practices for Data Warehouse Ingestion

Datatypes of date & time fields

Some exports mix DATETIME and TIMESTAMP datatypes. Unless noted otherwise, assume UTC as the timezone.

Create field-name-specific ingestion logic

When creating your process to ingest these files, write field-name specific logic (not field-position specific logic) to pull fields into your data warehouse.

Figure does add fields as necessary (like when releasing new product features), and will add fields to the position we identify as most appropriate, often not at the right-most position or end of the file schema.

This approach ensures stability of your ingestion process, and allows your organization to reduce overhead by only ingesting and processing the fields they need.

File Naming Conventions

The convention is: [partner_name]_[report_type]_[yyyymmddhhmmss].[extension]

For example if your company is named ‘ACME Loans’, the report is funding_transaction, and the UTC timestamp is January 1, 2025 at 10:45:00 the file name would be: acme_loans_funding_transaction_20250101104500.csv

If in the test environment, the file would be: test_acme_loans_funding_transaction_20250101104500.csv

Delivery Schedules and Data Freshness

Data provided in these exports may be up to 8 hours old.

All delivery schedules can be modified upon request.

The recommended schedule is:

Report Type	Delivery Schedule
lkup_application_event funding_transaction	02:45 06:45 10:45 14:45 18:45 22:45 UTC (daily)
user_identity loan_officer_license originator_broker liability_payoff_reconciliation	10:45 UTC (daily)
hmda mcr_v2 complaint waitlist	10:45 UTC on the 3rd of the month

The warehouse_funding_queue report will be delivered on a partner-specific basis and timeline. warehouse_funding_queue is not subject to the 8-hour data freshness limitation.

HMDA and MCR files are not necessary to be delivered every day. We’ll generate these on the 3rd of the month at 10:45 UTC by default.

There may be a delay of a few minutes between report generation (based upon the schedule chosen) and report delivery. Any standard unix-cron schedule can be utilized for report generation (where intervals are at least 4 hours apart).

DSCR Exports

DSCR (Debt Service Coverage Ratio) exports provide data for DSCR loan applications and funding transactions. These exports follow the same delivery and formatting standards as other data exports.

• DSCR Application: Contains application data for DSCR loans
• DSCR Funding Transaction: Contains funding transaction data for DSCR loans

Delivery schedules for DSCR exports can be configured upon request and follow the same 4-hour snapshot refresh schedule as other exports.

---

Export Contents FAQ

Will Figure deliver full exports or delta-files?

Figure will only deliver full exports. These are database snapshots as of when the report is generated.

What will the file type/extension be?

Figure can send comma-separated , (.csv) or pipe-delimited | (.txt) files. .csv is the default.

Only flat files are supported. Other formats like .json, .xml, .xlsx, or MISMO (also known as “3.4” files) are not supported.

We will apply field value quoting where necessary to escape delimiting characters.

Can my reports be encrypted?

We require PGP encryption, please send us the public key you’d like us to encrypt with.

Does my organization really need to ingest all the information provided?

Your organization likely does not need to ingest all the information provided in these files. For example, broker information is only applicable to companies using a wholesale/broker model.

Review the datapoints and socialize them internally to ensure all departments (sales, compliance, business intelligence, accounting, finance, etcetera) have their needs met.

What delivery methods are supported?

These reports can be downloaded from the Lead Portal system.

At your request, we can also deliver a copy of the reports to a secure storage solution hosted by your organization. See File Exchange for more information.

How will test / production environments be reflected in the exports?

All files from our test environment will have a prefix test_. Production files will have no prefix. Export files will never mix test and production data.

See File Naming Conventions for more detail.

---

Entity Relationship Diagram (ERD)

View on Lucidchart

Guide to Export Schemas

This section provides a field-level reference for each export schema: what each row represents, and what to expect for each column.

Tip: Use your browser's Find feature (Cmd+F on Mac | Ctrl+F on Windows) to search for a field name.

• Application Event
• Funding Transaction
• User Identity
• Loan Officer License
• Originator Broker
• Liability Payoff Reconciliation
• HMDA
• MCR
• Complaint
• Waitlist
• Warehouse Funding Queue
• Task Outcome
• DSCR Application
• DSCR Funding Transaction

Application Event

Report type: lkup_application_event

About this export

• This can be considered the "base" export file.
• Contains information about:
  • Loan application
  • Loan applicant
  • Subject property
  • Underwriting and approval
  • Application progress and status
• 1 row per application

Download schema CSV

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	application_uuid_value	STRING	NON-NULLABLE	2022-09-01			UUID, 36 character
2	application_short_id	STRING	NON-NULLABLE	2022-09-01			Short ID, example 1-111-1111 2 dashes Length of characters between dashes may vary
3	application_start_date	TIMESTAMP	NON-NULLABLE	2022-09-01	Application Start Date
4	application_stage	STRING	NON-NULLABLE	2022-09-01	Current Application Stage	App Start Lien Validation No Credit Hit Frozen Locked OFAC Flagged Fraud Flagged Property Not Found Multiple Property Matches UW Review Product Select SSN Consent HMDA Connect Accounts Variance Disbursement Account ID Upload Sign Prom Note Additional Signers Notary Rescission Funding Decision Funded Recording Complete Cancelled Declined
5	application_stage_num	FLOAT	NON-NULLABLE	2022-09-01	Current Application Stage Num	1 1.1 1.25 1.5 1.55 1.6 1.7 1.75 1.76 1.77 2 3 3.5 4 5.28 5.5 6 6.25 6.5 7 9 9.5 10.1 10.5 11 98 99
6	app_status	STRING	NON-NULLABLE	2022-09-01	ACTIVE: most recent application for applicant (not cancelled or expired) CANCELLED: most application cancelled EXPIRED: application expired	ACTIVE CANCELLED EXPIRED
7	status	STRING	NON-NULLABLE	2022-09-01	Figure Application Checklist status	ACTIVE APP_SUBMISSION ASSETS_PREQUAL ATTORNEY_REVIEW AUTOPAY_ACCOUNT BPO_ORDER_REQUEST CANCELLED CLTV_LIEN_POSITION_REQUALIFY COLLECT_ADDITIONAL_INFO COMPLETE CO_DEED_REQ CREDIT_ERROR CREDIT_NO_MATCH CREDIT_NO_MATCH_SSN DECLINED DEED_SIGNING DIRECT_DEBT_PAYOFF DISBURSEMENT_ACCOUNT FACTA_REVIEW FINAL_OFFER FINAL_TITLE_PULL FUNDING_DECISION GEN_CLOSING_DISCLOSURE GEN_DEED_SIGNING GEN_NOTARY_DISCLOSURE GEN_NOTE_SIGNING GEN_RESCISSION_DISCLOSURE HARD_CREDIT_LOCKED_OR_FROZEN HARD_CREDIT_PULL HMDA IDENTITY_VERIFICATION INCOME_VERIFICATION LIABILITY_PAYOFF_UPDATE MANUAL_DEED_SIGNING MULTIPLE_PROPERTIES NAV_BPO_ESTIMATE NAV_BPO_ORDER_ESTIMATE_NO_AVM NAV_BPO_PROCESSING NAV_RESI_EVAL_ESTIMATE_NO_AVM NAV_RESI_EVAL_PROCESSING NOTARY_WAITING_PERIOD NOTE_SIGNING NO_PROPERTY_FOUND OFFER_SELECTION ONSITE_APPRAISAL_BORROWER_PAYMENT PAYOFF_REQUEST_PENDING RECORDING RESCISSION REVISED_OFFER_SELECTION SOFT_CREDIT_LOCKED_OR_FROZEN UNKNOWN_ENUM_VALUE_Status_104 WAITING_FOR_APPLICATION_DISCLOSURE WAITING_FOR_ID_VERIFICATION WAITING_FOR_LIEN_DATA WAITING_FOR_SOFT_CREDIT
8	started_as_inquiry	BOOLEAN	NON-NULLABLE	2026-03-31	True when the application was converted from a pre-qualification inquiry
9	borrower_1_uid	STRING	NON-NULLABLE	2022-09-01	Primary Borrower UUID
10	borrower_1_email	STRING	NULLABLE	2022-09-01	Primary Borrower Email
11	borrower_1_first_name	STRING	NULLABLE	2022-09-01	Primary Borrower First Name
12	borrower_1_middle_name	STRING	NULLABLE	2022-09-01	Primary Borrower Middle Name
13	borrower_1_last_name	STRING	NULLABLE	2022-09-01	Primary Borrower Last Name
14	borrower_1_dob	DATE	NULLABLE	2022-09-01	Primary Borrower DOB
15	borrower_1_ssn	STRING	NULLABLE	2022-09-01	Primary Borrower SSN
16	borrower_1_mailing_address	STRING	NULLABLE	2022-09-01	Primary Borrower Mailing Address
17	borrower_1_street1	STRING	NULLABLE	2022-09-01	Primary Borrower Mailing Address Street 1
18	borrower_1_street2	STRING	NULLABLE	2022-09-01	Primary Borrower Mailing Address Street 2
19	borrower_1_city	STRING	NULLABLE	2022-09-01	Primary Borrower Mailing City
20	borrower_1_state	STRING	NULLABLE	2022-09-01	Primary Borrower Mailing State
21	borrower_1_zip	STRING	NULLABLE	2022-09-01	Primary Borrower Mailing Zip
22	borrower_2_first_name	STRING	NULLABLE	2022-09-01	Secondary Signer First Name
23	borrower_2_middle_name	STRING	NULLABLE	2022-09-01	Secondary Signer Middle Name
24	borrower_2_last_name	STRING	NULLABLE	2022-09-01	Secondary Signer Last Name
25	borrower_2_dob	DATE	NULLABLE	2022-09-01	Secondary Signer DOB
26	borrower_2_uid	STRING	NULLABLE	2022-09-01	Secondary Signer UUID
27	borrower_2_email	STRING	NULLABLE	2022-09-01	Secondary Signer Email
28	borrower_2_mailing_address	STRING	NULLABLE	2022-09-01	Secondary Signer Mailing Address
29	borrower_2_street1	STRING	NULLABLE	2022-09-01	Secondary Signer Mailing Address Street 1
30	borrower_2_street2	STRING	NULLABLE	2022-09-01	Secondary Signer Mailing Address Street 2
31	borrower_2_city	STRING	NULLABLE	2022-09-01	Secondary Signer Mailing Address City
32	borrower_2_state	STRING	NULLABLE	2022-09-01	Secondary Signer Mailing Address State
33	borrower_2_zip	STRING	NULLABLE	2022-09-01	Secondary Borrower Mailing Address Zip
34	app_amount	FLOAT	NULLABLE	2022-09-01	Application Amount, total borrowed, inclusive of fees
35	total_disbursement_amount	FLOAT	NULLABLE	2026-03-31	Total dollar amount of funds being delivered to the customer through all mediums
36	origination_fee	FLOAT	NULLABLE	2022-09-01	Origination fee expressed as a percentage
37	borrower_paid_origination_fee_dollar_amount	FLOAT	NULLABLE	2024-01-29	Origination fee expressed in dollars
38	borrower_paid_manual_notary_fee	FLOAT	NULLABLE	2023-10-18	Manual notary fee paid by the borrower (included in loan amount, not out of pocket)
39	borrower_paid_broker_price_opinion_fee	FLOAT	NULLABLE	2024-01-29	Broker price opinion (BPO) fee paid by the borrower (included in loan amount, not out of pocket)
40	borrower_paid_recording_tax_local_transfer_tax	FLOAT	NULLABLE	2023-10-18	Recording tax pass through for local transfer tax (included in loan amount, not out of pocket)
41	borrower_paid_recording_tax_mortgage_tax	FLOAT	NULLABLE	2023-10-18	Recording tax pass through for mortgage tax (included in loan amount, not out of pocket)
42	borrower_paid_recording_tax_recordation_transfer_stamp_tax	FLOAT	NULLABLE	2023-10-18	Recording tax pass through for recordation transfer stamp tax (included in loan amount, not out of pocket)
43	borrower_paid_recording_tax_state_transfer_tax	FLOAT	NULLABLE	2023-10-18	Recording tax pass through for state transfer tax (included in loan amount, not out of pocket)
44	borrower_paid_recording_tax_intangible_tax	FLOAT	NULLABLE	2023-10-18	Recording tax pass through for intangible tax (included in loan amount, not out of pocket)
45	borrower_paid_drive_by_valuation_fee	FLOAT	NULLABLE	2024-05-28	Drive by valuation fee paid by the borrower (included in loan amount, not out of pocket)
46	borrower_paid_full_property_report_fee	FLOAT	NULLABLE	2024-05-28	Full property report fee paid by the borrower (included in loan amount, not out of pocket)
47	borrower_paid_instant_title_fee	FLOAT	NULLABLE	2024-05-28	Instant title fee paid by the borrower (included in loan amount, not out of pocket)
48	draw_amount	FLOAT	NULLABLE	2022-09-01	Draw Amount -- amount to be sent to applicant's account in cash (does not include liability payoff amount)
49	liability_payoff_available	BOOLEAN	NULLABLE	2025-01-14	True if direct debt payoff was available to the borrower to select
50	liability_payoff_allocated_amount	FLOAT	NULLABLE	2024-08-22	Amount of application allocated to paying off debt liabilities
51	liability_payoff_allocated_amount_dti_impacting	FLOAT	NULLABLE	2024-08-22	Amount of application allocated to paying off underwriting-DTI impacting liabilities (i.e., most personal loans)
52	liability_payoff_allocated_amount_non_dti_impacting	FLOAT	NULLABLE	2024-08-22	Amount of application allocated to paying off non-DTI impacting liabilities (i.e., most credit cards)
53	liability_payoff_paid_amount_dti_impacting	FLOAT	NULLABLE	2024-08-22	Actual amount used to pay down DTI impacting liabilities
54	liability_payoff_paid_amount_non_dti_impacting	FLOAT	NULLABLE	2024-08-22	Actual amount used to pay down non-DTI impacting liabilities
55	liability_payoff_dti_impacting_status	STRING	NULLABLE	2024-08-22	Status of DTI impacting liability payoff transaction	PENDING COMPLETE
56	liability_payoff_non_dti_impacting_status	STRING	NULLABLE	2024-08-22	Status of non-DTI impacting liability payoff transaction	PENDING COMPLETE
57	liability_payoff_amount_credited_to_line	FLOAT	NULLABLE	2024-08-22	Amount of liability_payoff_allocated_amount credited to the borrower's loan amount (in limited cases where the allocated amount exceeds the current liability balance)
58	selected_offer_term	INTEGER	NULLABLE	2022-09-01	Offer term in years
59	pay_type	STRING	NON-NULLABLE	2022-09-01	Payment type selected	Autopay Manual Unknown
60	phone_number	STRING	NULLABLE	2022-09-01	Primary borrower phone number
61	property_uuid_value	STRING	NULLABLE	2022-09-01
62	corelogic_property_id	STRING	NULLABLE	2022-09-01
63	property_county	STRING	NULLABLE	2022-09-01
64	property_type	STRING	NULLABLE	2022-09-01		HOME INVESTMENT SECONDARY
65	address_type	STRING	NULLABLE	2022-09-01		HOME INVESTMENT SECONDARY		Ignore, vestigial field
66	prop_street_address	STRING	NULLABLE	2022-09-01
67	prop_city	STRING	NULLABLE	2022-09-01
68	prop_state	STRING	NULLABLE	2022-09-01
69	prop_zip	STRING	NULLABLE	2022-09-01
70	lot_square_feet	INTEGER	NULLABLE	2022-09-01
71	property_number_of_units	INTEGER	NULLABLE	2026-07-14	Number of dwelling units on the subject property
72	property_flood_zone	STRING	NULLABLE	2022-09-01		A A1 A10 A11 A12 A13 A16 A2 A21 A3 A4 A5 A6 A7 A8 A99 AE AE* AH AO B B* BL C C* D D* N NONE V15 VE X X* X500 X500* X500L
73	prequal_source_type	STRING	NULLABLE	2022-09-01		API UNKNOWN		Ignore, vestigial field
74	prequal_avm_amount	FLOAT	NULLABLE	2022-09-01	Automated Valuation Model (home value) amount used during prequalification
75	prequal_avm_fsd	FLOAT	NULLABLE	2022-09-01	FSD: Forecast standard deviation value for the automated valuation model used during prequalification
76	final_source_type	STRING	NULLABLE	2022-09-01				Ignore, vestigial field
77	property_valuation_source_category	STRING	NULLABLE	2026-03-31	Category of property valuation method used for most recent offers	AVM BPO/RE APPRAISAL STATED_VALUE OTHER
78	avm_value_amount	FLOAT	NULLABLE	2022-09-01	Value of subject property
79	avm_fsd	FLOAT	NULLABLE	2022-09-01	Forecast standard deviation value for the automated valuation model used for final offer
80	avm_high_value	FLOAT	NULLABLE	2022-09-01	High property value provided by automated valuation model
81	avm_low_value	FLOAT	NULLABLE	2022-09-01	Low property value provided by automated valuation model
82	avm_run_date	STRING	NON-NULLABLE	2022-09-01	Run date of the automated valuation model used during final underwriting
83	bpo_type	STRING	NULLABLE	2024-01-29	Broker price opinion (BPO) type	BPO_EXTERIOR
84	prequal_frozen_avm_flag	STRING	NON-NULLABLE	2022-09-01	Frozen AVM value used to prequalify	Y N
85	frozen_avm_flag	STRING	NULLABLE	2022-09-01	(Deprecated) Frozen AVM value used for final offer.	Y N
86	adjusted_home_amount	FLOAT	NULLABLE	2022-09-13	(Deprecated) Value of subject property used in underwriting. Adjusted given the FSD value.
87	ownership	STRING	NON-NULLABLE	2022-09-01		JOINT SOLE TRUST UNKNOWN
88	application_reason	STRING	NON-NULLABLE	2022-09-01	Reason for Application	CARING_FOR_FAMILY DEBT_CONSOLIDATION EDUCATION HEALTH_MEDICAL HOME_IMPROVEMENT HOME_IMPROVEMENT_SMALL_BUSINESS MAJOR_PURCHASE OTHER RETIREMENT SMALL_BUSINESS SOLAR_ENERGY_EFFICIENT_INSTALLATION TRAVEL UNKNOWN
89	credit_union_opt_in_out	STRING	NULLABLE	2022-09-01	OPT_IN: Applicant opted into credit union membership OPT_OUT: Applicant opted out of credit union membership	OPT_IN OPT_OUT
90	rate_type	STRING	NON-NULLABLE	2022-09-01	Rate Type	FIXED VARIABLE UNKNOWN
91	app_rate	FLOAT	NON-NULLABLE	2022-09-01	Interest rate selected
92	app_term	INTEGER	NULLABLE	2022-09-01	Loan term selected in years
93	app_term_months	INTEGER	NULLABLE	2022-09-01	Loan term selected in months
94	selected_offer_estimated_monthly_payment	NUMERIC	NULLABLE	2022-09-01	Estimated monthly payment of selected offer
95	first_payment_due_date	TIMESTAMP	NULLABLE	2025-01-14	First Payment Due Date (available only for loans originally serviced by Figure)
96	expected_payoff_date	DATE	NULLABLE	2025-01-14	Expected payoff date at origination (available only for loans originally serviced by Figure)
97	original_draw_period	INTEGER	NULLABLE	2022-09-01	HELOC Draw Period in years
98	original_draw_period_months	INTEGER	NULLABLE	2022-09-01	HELOC Draw Period in months
99	credit_as_of_date	DATE	NULLABLE	2022-09-01	Credit Pulled as of Date
100	credit_as_of_timestamp	TIMESTAMP	NULLABLE	2026-07-14	Timestamp that credit was pulled for underwriting
101	pricing_as_of_date	DATE	NULLABLE	2022-09-01	Pricing as of Date
102	pricing_as_of_timestamp	TIMESTAMP	NULLABLE	2026-07-14	Timestamp that pricing was determined for underwriting
103	pre_loan_cltv	FLOAT	NULLABLE	2022-09-01	CLTV of property based on unadjusted AVM, not taking into account selected offer
104	pre_loan_adj_cltv	FLOAT	NULLABLE	2022-09-01	CLTV of property based on adjusted AVM, not taking into account selected offer
105	pre_loan_dti	FLOAT	NULLABLE	2022-09-01	DTI of borrower, not taking into account selected offer
106	stated_dti	FLOAT	NULLABLE	2022-09-01	DTI of borrower based on stated income
107	post_loan_cltv	FLOAT	NULLABLE	2022-09-01	CLTV of property based on unadjusted AVM, taking into account selected offer
108	post_loan_adj_cltv	FLOAT	NULLABLE	2022-09-01	CLTV of property based on adjusted AVM, taking into account selected offer
109	post_loan_adj_min_cltv	FLOAT	NULLABLE	2022-09-01	CLTV of property basd on adjusted AVM, taking into account the minimum loan amount qualified
110	post_loan_dti	FLOAT	NULLABLE	2022-09-01	DTI of borrower, taking into account monthly payment of selected offer
111	credit_soft_provider	STRING	NULLABLE	2022-09-01		EXPERIAN
112	credit_soft_fico	INTEGER	NULLABLE	2022-09-01	Soft FICO			Values outside of the expected 300 - 850 range are error codes
113	credit_soft_timestamp	TIMESTAMP	NULLABLE	2024-05-28
114	credit_soft_secs	INTEGER	NULLABLE	2022-09-01	!Vestigial field Timestamp of soft credit pull in seconds since epoch			Ignore, vestigial field
115	credit_soft_complete	BOOLEAN	NULLABLE	2022-09-01
116	credit_hard_provider	STRING	NULLABLE	2022-09-01		EXPERIAN
117	credit_hard_fico	INTEGER	NULLABLE	2022-09-01				Values outside of the expected 300 - 850 range are error codes
118	credit_hard_timestamp	TIMESTAMP	NULLABLE	2024-05-28
119	credit_hard_secs	INTEGER	NULLABLE	2022-09-01	!Vestigial field Timestamp of hard credit pull in seconds since epoch
120	credit_hard_complete	BOOLEAN	NULLABLE	2022-09-01
121	monthly_income	FLOAT	NULLABLE	2022-09-01	Verified monthly income
122	stated_monthly_income	FLOAT	NULLABLE	2022-09-01	Verified monthly income
123	co_deed_status	STRING	NULLABLE	2022-09-01	Status of additional signer (also known as co-deeder) required work	INITIAL COMPLETE
124	flood_insured	BOOLEAN	NULLABLE	2022-09-01
125	homeowners_insured	BOOLEAN	NULLABLE	2022-09-01
126	entered_figure_select	BOOLEAN	NULLABLE	2026-07-14	True if the application entered the Figure Select expanded underwriting guidelines logic
127	uw_guidelines_version	STRING	NULLABLE	2026-07-14	Figure underwriting guidelines edition
128	uw_decision_decision	STRING	NULLABLE	2022-09-01	Current underwriting decision: ASSET_DEPLETION: The applicant can state the value of their assets (if applicable) to re-run underwriting DEBT_SELECTION: The applicant can select the debts they want to pay off (using the direct debt payoff feature) to qualify for a loan DECLINE: The applicant was declined FINAL: The applicant was approved and underwriting is complete (this does mean the loan has funded) INITIAL: The applicant received initial offers and selected one SELECT: The applicant received initials offers but has not selected one	ASSET_DEPLETION DEBT_SELECTION DECLINE FINAL INITIAL SELECT
129	uw_decision_sub_decision	STRING	NULLABLE	2022-09-01	Underwriting Sub-Decision BPO_PENDING: Underwriting is pending the results of a BPO FINAL_OFFER: The borrower is approved and underwriting is complete INSTANT_TITLE_PENDING: Underwriting is pending the results of an instant title pull RATE_CAP_LIMITED SUBDECISION_NO_AVM_FOUND: No property value was found, underwriting is awaiting borrower choices UNKNOWN_SUBDECISION: Not applicable to uw_decision_decision value UNVERIFIED_CLTV_LIEN_POSITION_LIMITED: Borrower has been pre-approved but the CLTV and Lien position have not been verified UNVERIFIED_DTI_LIMITED: The borrower is pre-approved but the DTI has not been verified or fully verified UNVERIFIED_OFFER: The borrower is pre-approved but other verifications need to take place VERIFIED_DTI_LIMITED: The borrower received offers but they were limited compared to pre-qualification given limited verified income VERIFIED_INCOME_MATCHED_OFFER: Borrwer received all applicable offers during pre-qualification VERIFIED_OFFER: Borrower can confirm their offer selected during pre-qualification	BPO_PENDING FINAL_OFFER INSTANT_TITLE_PENDING RATE_CAP_LIMITED SUBDECISION_NO_AVM_FOUND UNKNOWN_SUBDECISION UNVERIFIED_CLTV_LIEN_POSITION_LIMITED UNVERIFIED_DTI_LIMITED UNVERIFIED_OFFER VERIFIED_DTI_LIMITED VERIFIED_INCOME_MATCHED_OFFER VERIFIED_OFFER
130	total_liens	INTEGER	NULLABLE	2022-09-01
131	liens_w_balance	INTEGER	NON-NULLABLE	2022-09-01
132	figure_new_lien_position	INTEGER	NON-NULLABLE	2022-09-01	Position of new HELOC lien
133	lien_position_1_lender	STRING	NULLABLE	2024-08-22	Lender of property lien in first position
134	lien_position_1_origination_date	DATE	NULLABLE	2024-08-22	Origination date of lien in first position
135	lien_position_1_original_balance	FLOAT	NULLABLE	2024-08-22	Original balance of lien in first position
136	lien_position_1_current_balance	FLOAT	NULLABLE	2024-08-22	Current balance of lien in first position (as of application start date)
137	lien_position_2_lender	STRING	NULLABLE	2024-08-22	Lender of property lien in second position
138	lien_position_2_origination_date	DATE	NULLABLE	2024-08-22	Origination date of lien in second position
139	lien_position_2_original_balance	FLOAT	NULLABLE	2024-08-22	Original balance of lien in second position
140	lien_position_2_current_balance	FLOAT	NULLABLE	2024-08-22	Current balance of lien in second position (as of application start date)
141	organization	STRING	NON-NULLABLE	2022-09-01	Organization
142	wholesale_originator_dba_name	STRING	NULLABLE	2024-03-18	Broker LO selected doing-business-as-name
143	bridge_loan_flag	BOOLEAN	NULLABLE	2022-09-01	Bridge Loan Flag (TRUE if either home_for_sale_borrower_attested or home_for_sale_mls_response)
144	home_for_sale_borrower_attested	BOOLEAN	NULLABLE	2022-10-18	Borrower attested the home is for sale
145	home_for_sale_mls_response	BOOLEAN	NULLABLE	2022-10-18	MLS data noted home is for sale
146	manual_notary_flag	BOOLEAN	NULLABLE	2022-09-01	True if the applicant is not eligible for remote online notarization
147	notary_type	STRING	NULLABLE	2025-04-01	Type of notarization required: E_NOTARY: remote online notary MANUAL_NOTARY: in person signing MANUAL_NOTARY_OVERRIDE: lives in a jurisdiction where remote online notary is allowable, but circumstances (such as requiring a translator) required an in-person appointment	E_NOTARY MANUAL_NOTARY MANUAL_NOTARY_OVERRIDE
148	in_person_notary_appointment_timestamp	TIMESTAMP	NULLABLE	2025-04-01	Timestamp of scheduled notary appointment
149	enotary_completed_timestamp	TIMESTAMP	NULLABLE	2025-04-01	Timestamp that all e-signings were complete
150	heloc_agreement_e_signed_timestamp	TIMESTAMP	NULLABLE	2025-04-01	Timestamp e-signature applied to HELOC agreement (not a notarized document)
151	hispanic_or_latino_ethnicity_type	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
152	ethnicity_refusal	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
153	other_ethnicity_description	STRING	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
154	gender_refusal	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
155	race_refusal	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
156	race_asian_additional_description	STRING	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
157	race_pacific_islander_additional_description	STRING	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
158	ethnicity_collected_based_on_visual_observation_or_surname	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions	False
159	gender_collected_based_on_visual_observation_or_name	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions	False
160	race_collected_based_on_visual_observation_or_surname	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions	False
161	tribe_name	STRING	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
162	not_hispanic_or_latino	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
163	ethnicity_origin_types	STRING	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions, List, separated by ","			Any combination of values can be in this delimited list
164	gender_types	STRING	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions List, separated by ","	FEMALE MALE
165	race_types	STRING	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions List, separated by ","	AMERICAN_INDIAN_OR_ALASKA_NATIVE ASIAN BLACK_OR_AFRICAN_AMERICAN NATIVE_HAWAIIAN_OR_OTHER_ISLANDER WHITE		Any combination of values can be in this delimited list
166	race_desgination_types	STRING	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions List, separated by ","	ASIAN_INDIAN CHINESE FILIPINO GUAMANIAN_OR_CHAMORRO JAPANESE KOREAN NATIVE_HAWAIIAN OTHER_ASIAN OTHER_PACIFIC_ISLANDER SAMOAN VIETNAMESE		Any combination of values can be in this delimited list
167	application_time_zone	STRING	NON-NULLABLE	2022-09-01	Applicant Time Zone	IANA time zone names
168	expiration_date	TIMESTAMP	NON-NULLABLE	2022-09-01	Expiration Date
169	decline_type	STRING	NON-NULLABLE	2022-09-01	Pre-Qualification process decline type.	Approved Bankrupcy CLTV CLTV LIEN WF CLTV Other Property "CLTV, liens >= 3" Credit Incomplete - Prequal Credit Score Credit Utilization DTI Delinquent past or present credit obligations with others Fraud Income Verification Involuntary Lien Land Use Lien Position Live App - Has not passed Prequal yet No AVM Other PCRA Condition Plaid Risky Flags Property >40 acres Purchased in last 90 days Recent Inquiries Severe Property Condition Too many inquiries last 3 mos Trade >=60 days delinquent or 12-mo derogatory Tradeline in Collections Unable to verify identity Unable to verify property ownership
170	decline_codes	STRING	NULLABLE	2022-09-01	List of decline codes, each code separated by ";"	ACTIVE_MLS_LISTING ACTIVE_MLS_LISTING_OFEE APPLICANT_VERIFIED_NOT_EMPLOYED AVM_DRIFT AVM_FSD BANKRUPTCY CLTV CLTV_ELIGIBILITY_MATRIX CLTV_LIEN_POSITION CLTV_LIEN_WF COLLECTION CREDITSCORE CREDIT_UTILIZATION DELQ60_12 DTI_ELIGIBILITY_MATRIX FACTA_HIT FORECLOSURE FRAUD F_DELQ_CURRENT F_DELQ_MAX F_TRANSFERRED ID_VERIFICATION INCOME_VERIFICATION INDEPENDENT_FRAUD_REVIEW INQ3MONTHS INVALIDFICO1 INVALIDFICO2 INV_TAXLIEN LANDUSE LAST_SALE_DATE LIEN_POSITION LIEN_TYPE LIEN_VERIFICATION MAXPRODUCT_CREDIT MORT_TRADES_DELQ NAV_LANDUSE NAV_NO_PROPERTY_VALUE NOAVMRETURNED NO_OFFERS OCCUPANCY_STATUS PLAID_RSK_NSF_LNST_FICOLT700 PLAID_RSK_NSF_LNST_NEGBALN_FICOGTE700 PLAID_RSK_NSF_RISKYFI PLAID_RSK_RISKYFI_INQ PLAID_RSK_RISKYFI_NEGBALN PRODUCT_ELIGIBILITY_MATRIX PROPERTYOWNERSHIP PROPERTY_ACRES PROPERTY_TYPE PROPERTY_VESTING PTI RATE_CAP RECENT_INQUIRIES SENIOR_REVERSE_MORTGAGE SENTILINK_SCORE TITLE_TRANSFER_RECENCY UNITS ACTIVE_MLS_LISTING ACTIVE_MLS_LISTING_OFEE APPLICANT_VERIFIED_NOT_EMPLOYED AVM_DRIFT AVM_FSD BANKRUPTCY CLTV CLTV_ELIGIBILITY_MATRIX CLTV_LIEN_POSITION CLTV_LIEN_WF COLLECTION CREDITINCOMPLETE CREDITSCORE CREDIT_UTILIZATION DELQ60_12 DNDB_BLACKLIST DTI DTI_DRIFT DTI_ELIGIBILITY_MATRIX EMPLOYEMENT_VERIFICATION ENUM_425 ENUM_426 FACTA_HIT FICO_DRIFT FORECLOSURE FRAUD F_FORBEARANCE F_TRANSFERRED GIACT_EMAIL_VERIFICATION ID_VERIFICATION INCOME_VERIFICATION INDEPENDENT_FRAUD_REVIEW INQ3MONTHS INVALIDFICO1 INVALIDFICO2 INV_TAXLIEN ITIN LANDUSE LAST_SALE_DATE LIEN_POSITION LIEN_TYPE LIEN_VERIFICATION MAXPRODUCT MAXPRODUCT_CREDIT MORT_TRADES_DELQ NAV_LANDUSE NAV_NO_PROPERTY_VALUE NOAVMRETURNED NO_OFFERS OCCUPANCY_STATUS OFAC PCRA_CONDITION PLAID_RSK_NSF_LNST_FICOLT700 PLAID_RSK_NSF_LNST_NEGBALN_FICOGTE700 PLAID_RSK_NSF_RISKYFI PLAID_RSK_RISKYFI_INQ PLAID_RSK_RISKYFI_NEGBALN PRODUCT_ELIGIBILITY_MATRIX PROPERTYOWNERSHIP PROPERTY_ACRES PROPERTY_CONDITION PROPERTY_TYPE PROPERTY_VESTING PTI RATE_CAP RECENT_INQUIRIES SENIOR_REVERSE_MORTGAGE SENTILINK_SCORE UNITS		Any combination of values can be in this delimited list
171	decline_details	STRING	NULLABLE	2022-09-01	Text description of decline_codes
172	cancellation_status	STRING	NULLABLE	2024-03-28	Type of application cancellation	WITHDRAWN EXPIRED REJECTED
173	cancellation_reasons	STRING	NULLABLE	2024-03-28	List of reasons selected for cancellation separated by ";"	APPLICANT_DOES_NOT_WISH_TO_PROCEED COBORROWER_NO_SIGN CREDIT_FROZEN_LOCKED CR_ADDRESS_UPDATE CR_DIFFERENT_OFFER_AMOUNT CR_DOB_UPDATE CR_INCORRECT_SSN CR_INTERNAL_MISTAKE CR_NAME_UPDATE CR_OWNERSHIP_TYPE DISLIKED_OFFER_LOAN_AMOUNT DISLIKED_OFFER_OFEE DISLIKED_OFFER_RATE DISLIKED_PRODUCT DISLIKED_WEBSITE_PROCESS DOES_NOT_WANT_FULL_INITIAL_DRAW DUPLICATE_APPLICATION FEES_TOO_HIGH NO_DATA_TREE OTHER OTHER_REQUIRED_USER_ENTRY PROP_OWNERSHIP_DISCREPANCY RATE_TOO_HIGH RECEIVED_BETTER_OFFER RESCINDED_APP STATED_INCOME_DISCREPANCY		Any combination of values can be in this delimited list
174	employment_type	STRING	NULLABLE	2022-09-13	Employment type of the applicant (also referred as source of income)	FULL_TIME PART_TIME RETIRED SELF_EMPLOYED SEPARATE_MAINTENANCE_PAYMENTS UNEMPLOYED
175	land_use_description	STRING	NULLABLE	2022-09-01	Description of land use code.	Dependent on provider, such as BPO, examples include: SFR CONDOMINIUM TOWNHOUSE/ROWHOUSE RESIDENTIAL (NEC) DUPLEX Unknown MOBILE HOME MANUFACTURED HOME TRIPLEX APARTMENT
176	land_use_code	INTEGER	NULLABLE	2024-08-22	Land Use Code	Dependent on provider, such as BPO, examples include: 163 112 102 100 115 137 138 0 165 106
177	building_gross_area	STRING	NULLABLE	2022-09-01	Livable Square Footage
178	query_params	STRING	NULLABLE	2022-09-01	UTM parameters. Provided without warranty.
179	signing_date	DATE	NULLABLE	2022-09-01	Right to Cancel Signing Date
180	Rescission_Start_Date	DATE	NULLABLE	2022-09-01	Rescission Start Date
181	Rescission_Exit_Date	DATE	NULLABLE	2022-09-01	Rescission Exit Date
182	Funding_Date	DATE	NULLABLE	2022-09-01	When Figure's Loan Origination System sent the loan to be queued for funding. This is not necessarily the same day that the funds transfer took place.
183	Transfer_Date	DATE	NULLABLE	2022-09-01	Date the funded loan was transferred ownership from it's originator
184	estimated_ach_funding_date	DATE	NULLABLE	2025-01-14	Estimated date that the ACH funding transaction will take place
185	origination_timestamp	TIMESTAMP	NULLABLE	2026-07-14	Timestamp that the loan was originated. This timestamp is when the asset is created on the Provenance blockchain.
186	application_summary_disclosure_signed_date	TIMESTAMP	NULLABLE	2024-05-28	Application Summary Disclosure signed date
187	external_partner_application_id	STRING	NULLABLE	2026-03-31	Application identifier from the external partner or channel that submitted the application.
188	external_partner_reference_id	STRING	NULLABLE	2026-03-31	Reference or tracking identifier provided by the external partner for the application.
189	referring_loan_officer_identity_uuid_value	STRING	NULLABLE	2024-05-28	UUID of Loan Officer (referral_id in loan_officer)
190	assigned_assistant_emails	STRING	NULLABLE	2026-03-31	Semicolon (;) delimited list of emails for assigned assistants
191	assigned_assistant_identity_uuids	STRING	NULLABLE	2026-03-31	Semicolon (;) delimited list of Figure identity UUIDs for assigned assistants
192	nmls_mlo_id	STRING	NULLABLE	2022-09-01	NMLS MLO ID
193	mlo_full_name	STRING	NULLABLE	2022-09-01	MLO Full Name
194	mlo_employee_id	STRING	NULLABLE	2022-09-01	External ID provided by partner
195	company_id	STRING	NULLABLE	2023-03-07	Broker ID of referring MLO
196	company_name	STRING	NULLABLE	2023-03-07	Broker name of referring MLO
197	company_nmls	STRING	NULLABLE	2023-03-07	NMLS number of referring MLO's broker
198	referring_mlo_name	STRING	NULLABLE	2022-09-01	Referring MLO Name
199	referring_mlo_nmls_no	STRING	NULLABLE	2022-09-01	Referring MLO NMLS ID
200	docs_mlo_name	STRING	NULLABLE	2022-09-01	MLO Name on Application Summary
201	docs_mlo_nmls	STRING	NULLABLE	2022-09-01	NMLS number of loan officer on Application Summary
202	deed_loan_officer_identity_uuid_value	STRING	NULLABLE	2025-08-11	Figure identity UUID of loan officer listed on Deed
203	deed_loan_officer_nmls_number	STRING	NULLABLE	2025-08-11	NMLS number of loan officer listed on Deed
204	deed_loan_officer_name	STRING	NULLABLE	2025-08-11	Name of loan officer listed on Deed
205	deed_date	DATE	NULLABLE	2025-08-11	Date listed on Deed
206	broker_compensation_percentage	FLOAT	NULLABLE	2025-10-07	Broker compensation percentage (the amount listed on the broker agreement). This amount is not part of the loan fees.
207	broker_compensation_amount	FLOAT	NULLABLE	2025-10-07	Broker compensation amount calculated using the broker compensation percentage. This amount is not part of the loan fees. This amount is calculated using the entire loan amount less all fees.
208	app_start_flag	STRING	NON-NULLABLE	2022-09-01	App Start Flag, application started	Y
209	lien_validation_flag	STRING	NON-NULLABLE	2022-09-01	Lien Validation Flag, applicant asked to validate Liens	Y N
210	no_credit_hit_flag	STRING	NON-NULLABLE	2022-09-01	No Credit returned by UW, asked to provide ssn	Y N
211	frozen_flag	STRING	NON-NULLABLE	2022-09-01	Frozen Flag, Credit Frozen	Y N
212	locked_flag	STRING	NON-NULLABLE	2022-09-01	Locked Flag, Credit Locked	Y N
213	ofac_flagged_flag	STRING	NON-NULLABLE	2022-09-01	OFAC Flagged	Y N
214	fraud_flagged_flag	STRING	NON-NULLABLE	2022-09-01	Fraud Flagged	Y N
215	property_not_found_flag	STRING	NON-NULLABLE	2022-09-01	Property not found Flag	Y N
216	multiple_property_matches_flag	STRING	NON-NULLABLE	2022-09-01	Multiple Property Search Flag	Y N
217	uw_review_flag	STRING	NON-NULLABLE	2022-09-01	Application under further review Flag	Y N
218	product_select_flag	STRING	NON-NULLABLE	2022-09-01	Applicant Passed Pre-UW, presented Offers	Y N
219	ssn_consent_flag	STRING	NON-NULLABLE	2022-09-01	Applicant Selected Offer, asked to provide SSN	Y N
220	hmda_flag	STRING	NON-NULLABLE	2022-09-01	Applicant provided SSN, asked to provide race/ethnicity/gender information	Y N
221	id_upload_flag	STRING	NON-NULLABLE	2022-09-01	Applicant asked to provide identification	Y N
222	connect_accounts_flag	STRING	NON-NULLABLE	2022-09-01	Applicant asked to connect income sources	Y N
223	variance_flag	STRING	NON-NULLABLE	2022-09-01	Variance found, applicant asked to correct	Y N
224	disbursement_account_flag	STRING	NON-NULLABLE	2022-09-01	Applicant asked to enter disbursement account	Y N
225	sign_prom_note_flag	STRING	NON-NULLABLE	2022-09-01	Applicant asked to Sign Prom Note	Y N
226	additional_signers_flag	STRING	NON-NULLABLE	2022-09-01	Applicant told additional signer is needed	Y N
227	notary_flag	STRING	NON-NULLABLE	2022-09-01	Notary scheduling available	Y N
228	rescission_flag	STRING	NON-NULLABLE	2022-09-01	Applicant enters Rescission	Y N
229	funded_flag	STRING	NON-NULLABLE	2022-09-01	Applicant Loan Funded	Y N
230	recording_flag	STRING	NON-NULLABLE	2022-09-01	Applicant Loan entered county recording	Y N
231	complete_flag	STRING	NON-NULLABLE	2022-09-01	Applicant Loan Recorded	Y N
232	cancelled_flag	STRING	NON-NULLABLE	2022-09-01	Applicant application cancelled	Y N
233	declined_flag	STRING	NON-NULLABLE	2022-09-01	Applicant application declined	Y N
234	app_start_ts	DATETIME	NON-NULLABLE	2022-09-01	Time Applicant has started the Application
235	lien_validation_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Lien Validation			Optional stage: Applicant enters stage if applicant must validate the liens on their property
236	no_credit_hit_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered No Credit Hit			Optional stage: Applicant enters stage if no soft credit is returned
237	frozen_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Frozen Credit			Optional stage: Applicant enters stage if applicant must unfreeze credit
238	locked_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Locked Credit			Optional stage: Applicant enters stage if applicant must unlock credit
239	ofac_flagged_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered OFAC			Optional stage: Applicant enters stage if Figure must perform additional OFAC checks
240	fraud_flagged_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Fraud Flagged			Optional stage: Applicant enters stage if Figure must perform fraud checks
241	property_not_found_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Property not Found			Optional stage: Applicant enters stage if Figure cannot find the subject property.
242	multiple_property_matches_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Multiple Property Matches			Optional stage: Applicant enters stage if Figure must review the property address entered for correctness.
243	uw_review_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered further Pre-UW review			Optional stage: Applicant enters stage if UW information must be reviewed before offers are presented. Deprecated.
244	product_select_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Offer selection			Applicant enters stage when offers are returned
245	ssn_consent_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered SSN Consent			Applicant enters stage to sign documents and agree to hard credit pull
246	hmda_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered HMDA information collection			Applicant enters stage to fill out HMDA information
247	id_upload_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered ID Upload			Applicant enters stage to upload their ID document
248	connect_accounts_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Connect Accounts			Applicant enters stage to verify their stated income
249	variance_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Variance			Optional stage: Applicant enters stage if they must reselect offers given income or other underwriting information changes.
250	disbursement_account_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Disbursement Accounts			Applicant enters stage where they confirm or enter their disbursement account data
251	sign_prom_note_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Sign Prom Note			Applicant needs to sign promisory note
252	additional_signers_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Additional Signers			Optional stage: Applicant needs to add additional signers
253	notary_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Notary			Applicant needs to perform notarization
254	rescission_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Rescission			Not applicable for non-owner-occupied properties; Applicant must wait for recission period to end
255	funded_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Funding			Application enters funding queue
256	recording_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Recording			Application begins Deed recording process
257	complete_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Complete			Application has had deed recorded
258	cancelled_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Cancellation			Application was cancelled
259	declined_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Decline			Application was declined
260	app_start_duration	NUMERIC	NON-NULLABLE	2022-09-01	Time Applicant spent in App Start in seconds
261	lien_validation_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Lien Validation in seconds
262	no_credit_hit_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in No Credit Hit in seconds
263	frozen_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Frozen Credit in seconds
264	locked_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Locked Credit in seconds
265	ofac_flagged_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in OFAC in seconds
266	fraud_flagged_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Fraud Flagged in seconds
267	property_not_found_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Property not found in seconds
268	multiple_property_matches_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Multiple Property Matches in seconds
269	uw_review_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in UW Review in seconds
270	product_select_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Product Select in seconds
271	ssn_consent_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in SSN Consent in seconds
272	hmda_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in HMDA in seconds
273	id_upload_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in ID Upload in seconds
274	connect_accounts_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Connect Accounts in seconds
275	variance_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Variance in seconds
276	disbursement_account_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Disbursement Account in seconds
277	sign_prom_note_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Sign Prom Note in seconds
278	additional_signers_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Additional Signers in seconds
279	notary_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Notary in seconds
280	rescission_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Rescission in seconds
281	funded_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Funded in seconds
282	recording_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Recording in seconds
283	complete_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Complete in seconds
284	cancelled_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Cancelled in seconds
285	declined_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Declined in seconds

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)

Download schema CSV

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	True if the transaction is an additional cash disbursement due to an over-allocation of direct debt payoff funds. See the 'About this export' above.

User Identity

Report type: user_identity

About this export

• Contains all Lead Portal users and accounts associated with your organization.
• 1 row per user identity.

Download schema CSV

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	loan_officer_identity_uuid_value	STRING	NON_NULLABLE	2025-08-25	Figure assigned loan officer referral identity UUID. One UUID per organization code.
2	identity_uuid_value	STRING	NON_NULLABLE	2025-08-25	Figure assigned identity UUID. One UUID across all organization codes.
3	organization	STRING	NON_NULLABLE	2025-08-25	Organization code
4	loan_officer_email	STRING	NON_NULLABLE	2025-08-25
5	external_id	STRING	NULLABLE	2025-08-25	Partner-assigned external ID, such as employee ID
6	broker_id_value	STRING	NULLABLE	2025-08-25	Figure provided broker ID
7	officer_nmls_no	STRING	NULLABLE	2025-08-25	Loan officer NMLS number
8	first_name	STRING	NULLABLE	2025-08-25
9	last_name	STRING	NULLABLE	2025-08-25
10	full_name	STRING	NULLABLE	2025-08-25	Concatenation of first_name + " " + last_name
11	lead_portal_user_type	STRING	NULLABLE	2025-08-25
12	active	BOOLEAN	NON_NULLABLE	2025-08-25	TRUE if user can access Lead Portal

Loan Officer License

Report type: loan_officer_license

About this export

• Contains all loan officer licenses
• 1 row per license
• 0 to many rows per user identity

Download schema CSV

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	loan_officer_identity_uuid_value	STRING	NON_NULLABLE	2025-08-25	Figure assigned loan officer referral identity UUID. One UUID per loan officer per organization code.
2	identity_uuid_value	STRING	NON_NULLABLE	2025-08-25	Figure assigned identity UUID. One UUID across all organization codes.
3	loan_officer_license_number	STRING	NON_NULLABLE	2025-08-25
4	loan_officer_license_state	STRING	NON_NULLABLE	2025-08-25
5	loan_officer_license_name	STRING	NULLABLE	2025-08-25
6	loan_officer_license_type	STRING	NULLABLE	2025-08-25
7	organization	STRING	NULLABLE	2025-08-25
8	broker_id_value	STRING	NULLABLE	2025-08-25

Originator Broker

Report type: originator_broker

About this export

• Only applicable to third party originator organization setups.
• Export of broker information.
• 1 row per broker UUID.

Download schema CSV

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	broker_id_value	STRING	NON_NULLABLE	NaT	Figure assigned UUID of broker
2	organization	STRING	NON_NULLABLE	NaT
3	broker_name	STRING	NON_NULLABLE	NaT
4	broker_nmls_no	STRING	NON_NULLABLE	NaT
5	address_street_1	STRING	NULLABLE	NaT
6	address_street_2	STRING	NULLABLE	2025-08-25
7	address_street_3	STRING	NULLABLE	2025-08-25
8	address_city	STRING	NULLABLE	2025-08-25
9	address_state	STRING	NULLABLE	2025-08-25
10	address_zip	STRING	NULLABLE	2025-08-25
11	address_type	STRING	NULLABLE	2025-08-25
12	broker_phone_number	STRING	NULLABLE	2025-08-25
13	broker_fax	STRING	NULLABLE	2025-08-25
14	broker_email	STRING	NULLABLE	2025-08-25
15	broker_website_url	STRING	NULLABLE	2025-08-25
16	primary_contact_full_name	STRING	NULLABLE	2025-08-25
17	primary_contact_email	STRING	NULLABLE	2025-08-25
18	primary_contact_phone_number	STRING	NULLABLE	2025-08-25
19	is_active	BOOLEAN	NULLABLE	2025-08-25	TRUE if broker is enabled in Lead Portal
20	updated_at_ts	TIMESTAMP	NULLABLE	2025-08-25
21	created_at_ts	TIMESTAMP	NULLABLE	2025-08-25

Liability Payoff Reconciliation

Report type: liability_payoff_reconciliation

About this export

• Requires opt-in to Intellidebt product feature
• Contains information about Intellidebt (direct debt payoff) transactions
• The source_trace_id indicates what group of payoffs were initiated as part of a single transaction
• 1 row per applicable liability
• 0 to many rows per application

Download schema CSV

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	organization	STRING	NON-NULLABLE	2023-09-14
2	application_uuid_value	STRING	NON-NULLABLE	2023-06-23
3	source_trace_id	STRING	NON-NULLABLE	2023-06-23
4	payoff_id	STRING	NULLABLE	2023-06-23
5	payoff_amount	FLOAT	NON-NULLABLE	2023-06-23
6	creditor_name	STRING	NON-NULLABLE	2023-06-23
7	payoff_status	STRING	NON-NULLABLE	2023-06-23		PAYMENT_SENT PAYMENT_PROCESSING PAYMENT_REVERSED WIRE_SENT
8	reversal_id	STRING	NULLABLE	2023-06-23	Populated if a reversal was processed
9	payoff_payment_sent_timestamp	TIMESTAMP	NULLABLE	2023-06-23

HMDA

Report type: hmda

About this export

• HMDA required gender, race, and ethnicity questions
• Denial reasons
• Other information that may be helpful in your HMDA filing process
• 1 row per application

caution

• Your organization is responsible for ensuring that your HMDA submission is complete and accurate.
• This report is provided as a convenience to assist with your HMDA filing process.
• Your organization should review the report and make any necessary adjustments before submitting to the appropriate regulatory agency.

Download schema CSV

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	application_uuid_value	STRING	NON-NULLABLE	2022-09-21				Not part of required HMDA fields
2	RecordID	STRING	NON-NULLABLE	2022-09-21				Not part of required HMDA fields
3	LEI	STRING	NULLABLE	2022-09-21	Legal entity identifier
4	ULI	STRING	NULLABLE	2022-09-21	Universal loan identifier
5	ApplDate	STRING	NON-NULLABLE	2022-09-21	The date the applicant signed the application summary document		YYYYMMDD
6	LoanType	STRING	NULLABLE	2022-09-21	Loan type 1. Conventional (not insured or guaranteed by FHA VA RHS or FSA)	1
7	Purpose	STRING	NULLABLE	2022-09-21	Loan purpose 2. Home improvement 4. Other purpose	2 4
8	Preapproval	STRING	NON-NULLABLE	2022-09-21	Preapproval type 1. Preapproval requested 2. Preapproval not requested	2
9	ConstructionMethod	STRING	NON-NULLABLE	2022-09-21	Construction method: 1. Site-built 2. Manufactured Home	1
10	OccupancyType	STRING	NON-NULLABLE	2022-09-21	Occupancy type 1. Principal residence 2. Second residence 3. Investment property	1 2 3
11	LoanAmountInDollars	FLOAT	NON-NULLABLE	2022-09-21	Loan amount The midpoint for the $10000 interval into which the reported value falls (e.g. for a reported value of $117834 disclose $115000 as the midpoint between values = $110000 and < $120000)
12	Action	STRING	NON-NULLABLE	2022-09-21	Action Taken 1. Loan originated 2. Application approved but not accepted 3. Application denied 4. Application withdrawn by applicant	1 2 3 4
13	ActionDate	STRING	NON-NULLABLE	2022-09-21	Action taken date		YYYYMMDD
14	Address	STRING	NON-NULLABLE	2022-09-21	Full property address
15	City	STRING	NON-NULLABLE	2022-09-21	Property city
16	State_Abrv	STRING	NON-NULLABLE	2022-09-21	Property state
17	Zip	STRING	NON-NULLABLE	2022-09-21	Property Zipcode
18	County_5	STRING	NON-NULLABLE	2022-09-21	Property county
19	Tract_11	STRING	NULLABLE	2022-09-21	Property tract
20	Ethnicity_1	STRING	NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions: 1.Hispanic or Latino 11. Mexican 12. Puerto Rican 13. Cuban 14. Other Hispanic or Latino 2. Not Hispanic or Latino 3. Information not provided by applicant in mail internet or telephone application 4. Not applicable. If the Applicant or Borrower did not select any ethnicity(ies) and only provided ethnicity(ies) in the Ethnicity of Applicant or Borrower: Free Form Text Field for Other Hispanic or Latino, this data field may be left blank.	1 11 12 13 14 2 3 4
21	Ethnicity_2	STRING	NULLABLE	2022-09-21	^^	^^
22	Ethnicity_3	STRING	NULLABLE	2022-09-21	^^	^^
23	Ethnicity_4	STRING	NULLABLE	2022-09-21	^^	^^
24	Ethnicity_5	STRING	NULLABLE	2022-09-21	^^	^^
25	EthnicityOther	STRING	NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions
26	Coa_Ethnicity_1	STRING	NON-NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions 5. No co-applicant.	5		Always "5" for HELOCs. Figure does not accept co-borrowers. Figure does require additional signers in situations that require it, but these additional signers are not part of the approval or underwriting process.
27	Coa_Ethnicity_2	STRING	NULLABLE	2022-09-21	Always blank because no co applicant
28	Coa_Ethnicity_3	STRING	NULLABLE	2022-09-21	Always blank because no co applicant
29	Coa_Ethnicity_4	STRING	NULLABLE	2022-09-21	Always blank because no co applicant
30	Coa_Ethnicity_5	STRING	NULLABLE	2022-09-21	Always blank because no co applicant
31	Coa_EthnicityOther	STRING	NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions
32	Ethnicity_Determinant	STRING	NON-NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions Descriptions: 1. Collected on the basis of visual observation or surname 2. Not collected on the basis of visual observation or surname 3. Not applicable	1 2 3		Never 1
33	Coa_Ethnicity_Determinant	STRING	NON-NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions Descriptions: 1. Collected on the basis of visual observation or surname 2. Not collected on the basis of visual observation or surname 3. Not applicable 4. No co-applicant	1 2 3 4		Always 4
34	Race_1	STRING	NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions: Descriptions: 1. American Indian or Alaska Native 2. Asian 21. Asian Indian 22. Chinese 23. Filipino 24. Japanese 25. Korean 26. Vietnamese 27. Other Asian 3. Black or African American 4. Native Hawaiian or Other Pacific Islander 41. Native Hawaiian 42. Guamanian or Chamorro 43. Samoan 44. Other Pacific Islander 5. White 6. Information not provided by applicant in mail internet or telephone application 7. Not applicable. If the Applicant or Borrower did not select any race(s) and only provided race(s) in the Race of Applicant or Borrower: Free Form Text Field for American Indian or Alaska Native Enrolled or Principal Tribe, Race of Applicant or Borrower: Free Form Text Field for Other Asian, and/or Race of Applicant or Borrower: Free Form Text Field for Other Pacific Islander, either leave this data field blank or enter, as appropriate, Code 1, 27, or 44.	1 2 21 22 23 24 25 26 27 3 4 41 42 43 44 5 6 7
35	Race_2	STRING	NULLABLE	2022-09-21	^^	^^
36	Race_3	STRING	NULLABLE	2022-09-21	^^	^^
37	Race_4	STRING	NULLABLE	2022-09-21	^^	^^
38	Race_5	STRING	NULLABLE	2022-09-21	^^	^^
39	Race1_other	STRING	NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions: Populated if race code 1 is selected AND the borrower chose to enter an additional designation in the freeform text field
40	Race27_other	STRING	NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions: Populated if race code 27 is selected AND the borrower chose to enter an additional designation in the freeform text field
41	Race44_other	STRING	NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions: Populated if race code 44 is selected AND the borrower chose to enter an additional designation in the freeform text field
42	CoaRace_1	STRING	NON-NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions: 8. No co-applicant.	8		Always 8 for no co-applicant
43	CoaRace_2	STRING	NULLABLE	2022-09-21	Always blank because no co applicant
44	CoaRace_3	STRING	NULLABLE	2022-09-21	Always blank because no co applicant
45	CoaRace_4	STRING	NULLABLE	2022-09-21	Always blank because no co applicant
46	CoaRace_5	STRING	NULLABLE	2022-09-21	Always blank because no co applicant
47	CoaRace1_Other	STRING	NULLABLE	2022-09-21	Always blank because no co applicant
48	CoaRace27_Other	STRING	NULLABLE	2022-09-21	Always blank because no co applicant
49	CoaRace44_Other	STRING	NULLABLE	2022-09-21	Always blank because no co applicant
50	Race_Determinant	STRING	NON-NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions: Descriptions: 1. Collected on the basis of visual observation or surname 2. Not collected on the basis of visual observation or surname 3. Not applicable	1 2 3		Never 1
51	Coa_Race_Determinant	STRING	NON-NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions: 4. No co-applicant	4		Always 4
52	Sex	STRING	NON-NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions 1. Male 2. Female 3. Information not provided by applicant in mail internet or telephone application 4. Not applicable 6. Applicant selected both male and female	1 2 3 4 6	Comma-separated list.
53	CoaSex	STRING	NON-NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions 5. No co-applicant	5		Always 5
54	Sex_Determinant	STRING	NON-NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions 1. Collected on the basis of visual observation or surname 2. Not collected on the basis of visual observation or surname 3. Not applicable	1 2 3		Never 1
55	CoaSex_Determinant	STRING	NON-NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions 4. No co-applicant	4		Always 4
56	Age	STRING	NON-NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions			8888 if Age is not available.
57	Coa_Age	STRING	NON-NULLABLE	2022-09-21	HMDA Ethnicity/Race/Gender questions 9999 if No-Co-Applicant	9999
58	Income	FLOAT	NON-NULLABLE	2022-09-21	Borrower income
59	Purchaser	INTEGER	NON-NULLABLE	2022-09-21	Purchaser 9. Other type of purchaser	9
60	Rate_spread	STRING	NON-NULLABLE	2022-09-21	Rate spread	(-99) - 99
61	HOEPA_Status	STRING	NON-NULLABLE	2022-09-21	Home Ownership and Equity Protection Act status 1. High-cost mortgage 2. Not a high-cost mortgage 3. Not applicable	1 2 3		Never 1
62	Lien_Status	STRING	NON-NULLABLE	2022-09-21	Lien status position 1. Secured by a first lien 2. Secured by a subordinate lien	1 2		Never 1
63	CreditScore	STRING	NON-NULLABLE	2022-09-21	Credit score of borrower
64	Coa_CreditScore	STRING	NON-NULLABLE	2022-09-21
65	CreditModel	STRING	NON-NULLABLE	2022-09-21	Credit model	0-10
66	CreditModelOther	STRING	NULLABLE	2022-09-21	Credit model name
67	Coa_CreditModel	STRING	NON-NULLABLE	2022-09-21	COA Credit model 10. No co-applicant	10		Always 10
68	Coa_CreditModelOther	STRING	NULLABLE	2022-09-21	Credit model name
69	DENIAL1	STRING	NULLABLE	2022-09-21	Denial code 1 Descriptions: 1. Debt-to-income ratio 2. Employment history 3. Credit history 4. Collateral 5. Insufficient cash (downpayment closing costs) 6. Unverifiable information 7. Credit application incomplete 8. Mortgage insurance denied 9. Other 10. Not applicable	1 2 3 4 5 6 7 8 9 10
70	DENIAL2	STRING	NULLABLE	2022-09-21	^^	^^
71	DENIAL3	STRING	NULLABLE	2022-09-21	^^	^^
72	DENIAL4	STRING	NULLABLE	2022-09-21	^^	^^
73	DenialOther	STRING	NULLABLE	2022-09-21	Other denial reasons	Other denail reasons
74	TotalLoanCosts	STRING	NULLABLE	2022-09-21	Total loan costs
75	TotalPtsAndFees	STRING	NULLABLE	2022-09-21	Total points and fees
76	OrigFees	STRING	NULLABLE	2022-09-21	Origination fees
77	DiscountPts	STRING	NULLABLE	2022-09-21	Discount points
78	LenderCredts	STRING	NULLABLE	2022-09-21	Lender credits
79	InterestRate	STRING	NULLABLE	2022-09-21	Interest rate
80	PPPTerm	STRING	NULLABLE	2022-09-21	PPP Term
81	DTIRatio	STRING	NULLABLE	2022-09-21	Debt to income ratio	0-999999999
82	CLTV	STRING	NULLABLE	2022-09-21	Cash loan to value	0-999999999
83	Loan_Term_Months	INTEGER	NULLABLE	2022-09-21	Loan term months
84	IntroRatePeiod	STRING	NULLABLE	2022-09-21	Intoductory rate period
85	BalloonPMT	STRING	NON-NULLABLE	2022-09-21	Balloon payment 1. Balloon payment 2. No balloon payment	1 2
86	IOPMT	STRING	NON-NULLABLE	2022-09-21	Interest Only Payments 1. Interest-only payments 2. No interest-only payments	1 2
87	NegAM	STRING	NON-NULLABLE	2022-09-21	Negative Amortization 2. No negative amortization	2
88	NonAMortz	STRING	NON-NULLABLE	2022-09-21	Other Non-amortizing Features: 2. No other non-fully amortizing features	2
89	PropertyValue	STRING	NON-NULLABLE	2022-09-21	Property value	0-999999999
90	MHSecPropType	STRING	NULLABLE	2022-09-21	MH secondary property type 3. Not applicable	3
91	MHLandPropInt	STRING	NON-NULLABLE	2022-09-21	MHLandPropInt: 5. Not applicable	5
92	TotalUnits	STRING	NON-NULLABLE	2022-09-21	Total units	1 2 3 4
93	MFAHU	STRING	NON-NULLABLE	2022-09-21	Multifamily Affordable Units
94	APPMethod	STRING	NON-NULLABLE	2022-09-21	Application method 1. Submitted directly to your institution	1
95	PayableInst	STRING	NON-NULLABLE	2022-09-21	Payable instrument 1. Initially payable to your institution	1
96	AUSystem1	STRING	NON-NULLABLE	2022-09-21	Automated Underwriting System: 1 6. Not applicable	6
97	AUSystem2	STRING	NULLABLE	2022-09-21	Automated Underwriting System: 2			Always blank
98	AUSystem3	STRING	NULLABLE	2022-09-21	Automated Underwriting System: 3			Always blank
99	AUSystem4	STRING	NULLABLE	2022-09-21	Automated Underwriting System: 4			Always blank
100	AUSystem5	STRING	NULLABLE	2022-09-21	Automated Underwriting System: 5			Always blank
101	AUSystemOther	STRING	NULLABLE	2022-09-21	Automated Underwriting System: Other			Always blank
102	AUResult1	STRING	NON-NULLABLE	2022-09-21	Automated Underwriting System 1: Result	17
103	AUResult2	STRING	NULLABLE	2022-09-21	Automated Underwriting System 2: Result			Always blank
104	AUResult3	STRING	NULLABLE	2022-09-21	Automated Underwriting System 3: Result			Always blank
105	AUResult4	STRING	NULLABLE	2022-09-21	Automated Underwriting System 4: Result			Always blank
106	AUResult5	STRING	NULLABLE	2022-09-21	Automated Underwriting System 5: Result			Always blank
107	AUResultOther	STRING	NULLABLE	2022-09-21	Automated Underwriting System Other: Result			Always blank
108	REVMTG	STRING	NON-NULLABLE	2022-09-21	Reverse Mortgage: 2. Not a reverse mortgage	2
109	OpenLOC	STRING	NON-NULLABLE	2022-09-21	Open line of credit: 1. Open-end line of credit	1
110	BUSCML	STRING	NON-NULLABLE	2022-09-21	BUSCML: 2. Not primarily for a business or commercial purpose	2
111	organization	STRING	NON-NULLABLE	2022-09-21	Organization name			Not part of required HMDA fields
112	nmls_mlo_id	STRING	NULLABLE	2022-09-21	NLMS MLO ID
113	full_name	STRING	NULLABLE	2022-09-21	MLO full name
114	mlo_employee_id	STRING	NULLABLE	2022-09-21	MLO employee ID
115	referring_mlo_name	STRING	NULLABLE	2022-09-21	Referring MLO name
116	referring_mlo_nmls_no	STRING	NULLABLE	2022-09-21	Referring MLO NMLS number
117	action_taken_timestamp	TIMESTAMP	NULLABLE	2025-11-17
118	action_taken_local_datetime	DATETIME	NULLABLE	2025-11-17
119	application_timestamp	TIMESTAMP	NULLABLE	2025-11-17
120	application_local_datetime	DATETIME	NULLABLE	2025-11-17

MCR

Report type: mcr_v2

About this export

• Assists with Mortgage Call Report (MCR) regulatory reporting.
• Contains information about:
  • Quarterly actions
  • Application amount changes
• The export has rows for each application, and for each quarter the application was in progress. A loan application that is in progress during two quarters will have two rows, one for each quarter.

caution

• Your organization is responsible for ensuring that your regulatory report submissions are complete and accurate.
• This report is provided as a convenience to assist with your Mortgage Call Report (MCR) process,
• Your organization should review the report and make any necessary adjustments before submitting to the appropriate regulatory agency.

Download schema CSV

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	report_quarter	STRING	NON-NULLABLE	2023-03-25			Q# YYYY
2	report_quarter_start_datetime	DATETIME	NON-NULLABLE	2023-03-25	Start datetime of reporting quarter (inclusive)
3	report_quarter_end_datetime	DATETIME	NON-NULLABLE	2023-03-25	Start datetime of reporting quarter (exclusive)
4	application_uuid_value	STRING	NON-NULLABLE	2022-08-01
5	application_short_id	STRING	NON-NULLABLE	2022-08-01
6	application_start_date	DATE	NON-NULLABLE	2022-08-01
7	expiration_date	DATE	NON-NULLABLE	2022-08-01	Application expiration date if left incomplete
8	rescission_start_date	DATE	NULLABLE	2022-08-01
9	rescission_exit_date	DATE	NULLABLE	2022-08-01
10	funding_date	DATE	NULLABLE	2022-08-01
11	approved_not_accepted_date	DATETIME	NULLABLE	2022-08-01
12	withdrawn_date	DATETIME	NULLABLE	2022-08-01
13	denied_date	DATETIME	NULLABLE	2022-08-01
14	transfer_date	DATE	NULLABLE	2022-08-01	Date of loan ownership transfer
15	amount	FLOAT	NON-NULLABLE	2022-08-01	Application amount
16	profile_state	STRING	NON-NULLABLE	2022-08-01	Residential U.S. state of primary applicant. NOT subject property state.
17	nmls_mlo_id	STRING	NULLABLE	2022-08-01	NMLS MLO ID used on Application Summary document
18	mlo_full_name	STRING	NULLABLE	2022-08-01	MLO full name used on Application Summary document
19	mlo_employee_id	STRING	NULLABLE	2022-08-01	MLO employee ID
20	referring_mlo_name	STRING	NULLABLE	2022-08-01	Referring MLO name
21	referring_mlo_nmls_no	STRING	NULLABLE	2022-08-01	Referring MLO NMLS number
22	fico_score	STRING	NON-NULLABLE	2022-08-01	Primary applicant FICO score			codes beyond the 300-850 range are error codes
23	post_loan_cltv	FLOAT	NULLABLE	2022-08-01	Cash loan to value ratio post loan
24	organization	STRING	NULLABLE	2022-08-01	Originating organization
25	AC010	STRING	NULLABLE	2022-08-01	Application in process at beginning of quarter flag	x
26	AC020	STRING	NULLABLE	2022-08-01	Application received during quarter flag	x
27	AC030	STRING	NULLABLE	2022-08-01	Application approved but not accepted during quarter flag	x
28	AC040	STRING	NULLABLE	2022-08-01	Application denied during quarter flag	x
29	AC050	STRING	NULLABLE	2022-08-01	Application withdrawn during quarter flag	x
30	AC062	STRING	NULLABLE	2022-08-01	Pre-approval request denied during quarter flag	x
31	AC064	STRING	NULLABLE	2022-08-01	Pre-approval request approved but not accepted during quarter	x
32	AC065	INTEGER	NULLABLE	2022-08-01	Net change in application amount			Net change in application amount during the report quarter
33	AC070	STRING	NULLABLE	2022-08-01	Closed and funded during report quarter flag	x
34	AC080	STRING	NULLABLE	2022-08-01	Application in process at end of period	x
35	AC100	STRING	NULLABLE	2022-08-01	Conventional loan flag, Any loan other than FHA, VA, FSA or RHS loans	x
36	AC200	STRING	NULLABLE	2022-08-01	One to four family dwelling flag	x
37	AC310	STRING	NULLABLE	2022-08-01	Home improvement flag -- Any dwelling-secured loan to be used, at least in part, for repairing, rehabilitating, remodeling, or improving a dwelling (or the real property on which the dwelling is located) OR any loan not secured by a lien on a dwelling to be used, at least in part, for one or more of those purposes that is classified as a home improvement loan by the institution	x
38	AC500	STRING	NULLABLE	2022-08-01	First lien flag -- secured by first lien	x
39	AC510	STRING	NULLABLE	2022-08-01	Subordinate lien flag	x
40	AC610	INTEGER	NULLABLE	2022-08-01	Lender Fees Collected-Forward Mortgages. The gross total amount of lender fees, examples include but are not limited to application fee, doc prep fee, administrative fee, you collected on forward mortgages during the period. Do not include pass through fees.
41	AC910	STRING	NULLABLE	2022-08-01	Flag - total loans funded	x
42	AC940	STRING	NULLABLE	2022-08-01	Not Subject to QM flag	x
43	AC1000	STRING	NULLABLE	2022-08-01	Flag - Loans Made and Assigned but Required to Repurchase in Period	x
44	AC1100	INTEGER	NULLABLE	2022-08-01	Gross Revenue from Operations
45	AC1200	INTEGER	NULLABLE	2022-08-01	Flag - Closed Loan with Servicing Retained During the Quarter
46	AC1210	STRING	NULLABLE	2022-08-01	Flag - Closed Loans with Servicing Released During the Quarter	x
47	I120_count	STRING	NULLABLE	2022-08-01	Closed and funded during quarter flag	x
48	I120_amount	INTEGER	NULLABLE	2022-08-01	Closed and funded amount

Complaint

Report type: complaint

About this export

• This report is aimed at assisting in regulatory reporting.
• 1 row per complaint

Download schema CSV

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	complaint_uuid_value	STRING	NON-NULLABLE	2023-01-11
2	application_uuid_value	STRING	NULLABLE	2023-01-11
3	identity_uuid_value	STRING	NULLABLE	2023-01-11
4	created_by_csr_uuid_value	STRING	NON-NULLABLE	2023-01-11
5	contact_first_name	STRING	NULLABLE	2023-01-11
6	contact_last_name	STRING	NULLABLE	2023-01-11
7	contact_phone	STRING	NULLABLE	2023-01-11
8	contact_email	STRING	NULLABLE	2023-01-11
9	contact_state	STRING	NULLABLE	2023-01-11
10	created_timestamp	TIMESTAMP	NON-NULLABLE	2023-01-11
11	resolved_timestamp	TIMESTAMP	NULLABLE	2023-01-11
12	product	STRING	NON-NULLABLE	2023-01-11
13	category	STRING	NON-NULLABLE	2023-01-11
14	channel	STRING	NON-NULLABLE	2023-01-11
15	status	STRING	NON-NULLABLE	2023-01-11
16	complaint_tier	STRING	NON-NULLABLE	2023-01-11		ESCALATED NON_ESCALATED
17	action_required	STRING	NON-NULLABLE	2023-01-11		CALL_BACK NONE WRITTEN_RESPONSE
18	compliance_or_legal_approval_required	BOOL	NON-NULLABLE	2023-01-11
19	organization	STRING	NON-NULLABLE	2023-01-11
20	complaint_summary_comments	STRING	NON-NULLABLE	2023-01-11			Max length: 10,000 characters
21	root_cause_analysis_comments	STRING	NULLABLE	2023-01-11			Max length: 10,000 characters
22	resolution_comments	STRING	NULLABLE	2023-01-11			Max length: 10,000 characters

Waitlist

Report type: waitlist

About this export

• If your organization is not live in all 50 states, applicants can join your waitlist.
• Your organization can use this report to gauge interest and notify applicants when your organization is live in the relevant state.
• 1 row per waitlist entry.

Download schema CSV

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	waitlist_position_uuid	STRING	NON-NULLABLE	2023-03-06	UUID of waitlist record
2	waitlist_join_timestamp	TIMESTAMP	NON-NULLABLE	2023-03-06	Timestamp of waitlist join
3	first_name	STRING	NON-NULLABLE	2023-03-06	Primary Borrower First Name
4	last_name	STRING	NON-NULLABLE	2023-03-06	Primary Borrower Last Name
5	property_address_street_1	STRING	NON-NULLABLE	2023-03-06	Property Address Line 1
6	property_address_street_2	STRING	NULLABLE	2023-03-06	Property Address Line 2
7	property_address_street_3	STRING	NULLABLE	2023-03-06	Property Address Line 3
8	property_address_city	STRING	NON-NULLABLE	2023-03-06	Property City
9	property_address_state	STRING	NON-NULLABLE	2023-03-06	Property State
10	property_address_zip	STRING	NON-NULLABLE	2023-03-06	Property 5-digit Zip
11	email_address	STRING	NON-NULLABLE	2023-03-06	Email address of primary applicant
12	organization	STRING	NON-NULLABLE	2023-03-06	Organization

Warehouse Funding Queue

Report type: warehouse_funding_queue

About this export

• Delivered on a partner-specific basis and timeline.
• Provides limited information about loans funding today.
• 1 row per loan, loans will not be sent across multiple days.

Download schema CSV

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	transaction_status	STRING	NON_NULLABLE	2025-08-18	Current funding status	NEW NACHA_SENT
2	status_entry_datetime_pacific	DATETIME	NON_NULLABLE	2025-08-18
3	status_entry_datetime_eastern	DATETIME	NON_NULLABLE	2025-08-18
4	originating_organization	STRING	NON_NULLABLE	2025-08-18
5	application_uuid_value	STRING	NON_NULLABLE	2025-08-18
6	application_short_id	STRING	NON_NULLABLE	2025-08-18
7	avm_type	STRING	NON_NULLABLE	2025-08-18	Method / Vendor used to evaluate property value
8	borrower_date_of_birth	STRING	NON_NULLABLE	2025-08-18
9	borrower_first_name	STRING	NON_NULLABLE	2025-08-18
10	borrower_last_name	STRING	NON_NULLABLE	2025-08-18
11	borrower_ssn	STRING	NON_NULLABLE	2025-08-18
12	draw_amount	NUMERIC	NON_NULLABLE	2025-08-18	Cash amount that will be drawn from the partner's account to fund the customers' account(s). This is the total amount of cash needed to fund the loan. This is inclusive of cash and, if applicable, debt payoffs and/or lien payoffs.
13	credit_hard_fico	INTEGER	NON_NULLABLE	2025-08-18
14	monthly_payment	NUMERIC	NON_NULLABLE	2025-08-18
15	heloc_agreement_signed_date	DATE	NON_NULLABLE	2025-08-18
16	lien_position	INTEGER	NON_NULLABLE	2025-08-18	Position of new HELOC lien
17	rate_type	STRING	NON_NULLABLE	2025-08-18
18	application_amount	FLOAT	NON_NULLABLE	2025-08-18	Total amount financed inclusive of all fees
19	funds_transfer_effective_date	DATE	NULLABLE	2025-08-18	Effective date listed on NACHA file.
20	interest_rate	NUMERIC	NON_NULLABLE	2025-08-18
21	loan_term	INTEGER	NON_NULLABLE	2025-08-18	Listed in years
22	occupancy_type	STRING	NON_NULLABLE	2025-08-18	HOME INVESTMENT SECONDARY
23	origination_fee_percent	NUMERIC	NON_NULLABLE	2025-08-18
24	property_adjusted_value	NUMERIC	NON_NULLABLE	2025-08-18
25	property_street_address	STRING	NON_NULLABLE	2025-08-18
26	prop_city	STRING	NON_NULLABLE	2025-08-18
27	prop_state	STRING	NON_NULLABLE	2025-08-18
28	prop_zipcode	STRING	NON_NULLABLE	2025-08-18
29	property_land_use	STRING	NON_NULLABLE	2025-08-18
30	verified_income_amount	INTEGER	NON_NULLABLE	2025-08-18
31	previous_total_mortgage_balance	NUMERIC	NON_NULLABLE	2025-08-18
32	post_loan_dti	NUMERIC	NON_NULLABLE	2025-08-18
33	application_reason	STRING	NON_NULLABLE	2025-08-18
34	pre_loan_non_adjusted_cltv	FLOAT	NON_NULLABLE	2025-08-18
35	pre_loan_adjusted_cltv	FLOAT	NON_NULLABLE	2025-08-18
36	property_flood_zone	STRING	NON_NULLABLE	2025-08-18
37	avm_run_date	DATE	NON_NULLABLE	2025-08-18
38	draw_term	INTEGER	NON_NULLABLE	2025-08-18

Task Outcome

Report type: task_outcome

About this export

• Optional, delivered upon request.
• This report provides details about the outcomes of some subtask types, as needed, for compliance needs (cancel application tasks only at this time).
• 1 row per subtask_uuid

Download schema CSV

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	application_uuid_value	STRING	NON-NULLABLE	2026-01-23	UUID of application
2	fulfillment_organization	STRING	NON-NULLABLE	2026-01-23	Organization handling the task
3	organization	STRING	NON-NULLABLE	2026-01-23	Originating organization
4	broker_id_value	STRING	NULLABLE	2026-01-23
5	task_type	STRING	NON-NULLABLE	2026-01-23		CANCEL_APPLICATION
6	subtask_type	STRING	NON-NULLABLE	2026-01-23		CANCEL_APPLICATION
7	task_uuid	STRING	NON-NULLABLE	2026-01-23
8	subtask_uuid	STRING	NON-NULLABLE	2026-01-23
9	subtask_outcome	STRING	NON-NULLABLE	2026-01-23
10	subtask_completed_timestamp	TIMESTAMP	NON-NULLABLE
11	comment	STRING	NULLABLE	2026-01-23	Comment entered by agent completing the task

DSCR Application

Report type: dscr_application

About this export

• Contains DSCR (Debt Service Coverage Ratio) loan application data
• 1 row per DSCR application

Download schema CSV

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	application_uuid_value	STRING	NON-NULLABLE	2025-01-15
2	app_short_id	STRING	NON-NULLABLE	2025-01-15
3	primary_borrower_id_uuid	STRING	NON-NULLABLE	2025-01-15
4	app_start_timestamp	TIMESTAMP	NON-NULLABLE	2025-01-15
5	application_submitted_timestamp	TIMESTAMP	NULLABLE	2025-01-15
6	rate_locked_timestamp	TIMESTAMP	NULLABLE	2025-01-15
7	rate_lock_expiration_timestamp	TIMESTAMP	NULLABLE	2025-01-15
8	final_offers_received_timestamp	TIMESTAMP	NULLABLE	2025-01-15
9	confirm_final_offer_submitted_timestamp	TIMESTAMP	NULLABLE	2025-01-15
10	property_valuation_confirmed_timestamp	TIMESTAMP	NULLABLE	2025-01-15
11	liens_reviewed_submitted_timestamp	TIMESTAMP	NULLABLE	2025-01-15
12	manual_notary_docs_signed_timestamp	TIMESTAMP	NULLABLE	2025-01-15
13	completed_timestamp	TIMESTAMP	NULLABLE	2025-01-15
14	application_declined_timestamp	TIMESTAMP	NULLABLE	2025-01-15
15	application_cancelled_timestamp	TIMESTAMP	NULLABLE	2025-01-15
16	organization	STRING	NULLABLE	2025-01-15	Organization code of the originating company
17	broker_id_value	STRING	NULLABLE	2025-01-15	UUID of the broker
18	broker_nmls	STRING	NULLABLE	2025-01-15	NMLS of the broker
19	broker_organization	STRING	NULLABLE	2025-01-15	Organization the broker belongs to or is operating under
20	broker_name	STRING	NULLABLE	2025-01-15	Name of the broker
21	uli	STRING	NULLABLE	2025-01-15
22	notary_status	STRING	NULLABLE	2025-01-15		MANUAL_NOTARY
23	ownership_type	STRING	NULLABLE	2025-01-15		SOLE JOINT LLC
24	property_street1	STRING	NULLABLE	2025-01-15
25	property_city	STRING	NULLABLE	2025-01-15
26	property_state	STRING	NULLABLE	2025-01-15
27	property_zip	STRING	NULLABLE	2025-01-15
28	property_use	STRING	NULLABLE	2025-01-15
29	property_address_type	STRING	NULLABLE	2025-01-15		INVESTMENT
30	application_amount	FLOAT	NULLABLE	2025-01-15
31	pre_discounts_interest_rate	FLOAT	NULLABLE	2025-01-15
32	interest_rate_discount	FLOAT	NULLABLE	2025-01-15
33	effective_interest_rate	FLOAT	NULLABLE	2025-01-15
34	term	INTEGER	NULLABLE	2025-01-15
35	origination_fee_percent	FLOAT	NULLABLE	2025-01-15
36	origination_fee_amount	FLOAT	NULLABLE	2025-01-15
37	pre_payment_penalty_term	INTEGER	NULLABLE	2025-01-15
38	pre_loan_cltv	FLOAT	NULLABLE	2025-01-15
39	post_loan_cltv	FLOAT	NULLABLE	2025-01-15
40	dscr_type	STRING	NULLABLE	2025-01-15
41	dscr_ratio	FLOAT	NULLABLE	2025-01-15
42	lien_payoff_amount	FLOAT	NULLABLE	2025-01-15
43	financing_purpose	STRING	NULLABLE	2025-01-15		BUSINESS UNKNOWN
44	occupancy_type	STRING	NULLABLE	2025-01-15		OCCUPIED PROPERTY_VALUATION_OCCUPANCY_TYPE_UNKNOWN TENNANT_OCCUPIED VACANT OWNER_OCCUPIED
45	avm	FLOAT	NULLABLE	2025-01-15
46	land_use_description	STRING	NULLABLE	2025-01-15
47	appraised_value_amount	FLOAT	NULLABLE	2025-01-15
48	property_condition	STRING	NULLABLE	2025-01-15		AVERAGE PROPERTY_VALUATION_PROPERTY_CONDITION_UNKNOWN GOOD EXCELLENT
49	property_avm_type	STRING	NULLABLE	2025-01-15
50	product_type	STRING	NULLABLE	2025-01-15
51	borrower_entered_property_value	FLOAT	NULLABLE	2025-01-15
52	primary_borrower_email	STRING	NULLABLE	2025-01-15
53	primary_borrower_first_name	STRING	NULLABLE	2025-01-15
54	primary_borrower_last_name	STRING	NULLABLE	2025-01-15
55	name_suffix	STRING	NULLABLE	2025-01-15
56	primary_borrower_home_street1	STRING	NULLABLE	2025-01-15
57	primary_borrower_home_city	STRING	NULLABLE	2025-01-15
58	primary_borrower_home_state	STRING	NULLABLE	2025-01-15
59	primary_borrower_home_zip	STRING	NULLABLE	2025-01-15
60	primary_borrower_phone_number	STRING	NULLABLE	2025-01-15
61	notary_appointment_timestamp	TIMESTAMP	NULLABLE	2025-01-15
62	lease_agreement_monthly_rent_amount	FLOAT	NULLABLE	2025-01-15
63	lease_agreement_is_lease_currently_active	BOOLEAN	NULLABLE	2025-01-15
64	application_expiration_ts	TIMESTAMP	NULLABLE	2025-01-15
65	current_stage	STRING	NULLABLE	2025-01-15
66	decline_code	STRING	NULLABLE	2025-01-15
67	decline_reason	STRING	NULLABLE	2025-01-15
68	decline_decision_type	STRING	NULLABLE	2025-01-15
69	decline_type	STRING	NULLABLE	2025-01-15

DSCR Funding Transaction

Report type: dscr_funding_transaction

About this export

• Contains DSCR (Debt Service Coverage Ratio) loan funding transaction data
• 1 row per DSCR funding transaction
• 1 to many rows per DSCR loan

Download schema CSV

Position	Field Name	Datatype	Mode	Date Added	Definition	Categorical Values	Format Notes	Misc. Notes
1	transaction_uuid_value	STRING	NON-NULLABLE	2025-01-15
2	loan_uuid_value	STRING	NON-NULLABLE	2025-01-15
3	loan_type	STRING	NON-NULLABLE	2025-01-15		DSCR
4	is_wire	BOOLEAN	NON-NULLABLE	2025-01-15
5	current_status	STRING	NON-NULLABLE	2025-01-15
6	transaction_amount	FLOAT	NON-NULLABLE	2025-01-15
7	entered_funding_queue_timestamp	TIMESTAMP	NON-NULLABLE	2025-01-15
8	funds_sent_timestamp	TIMESTAMP	NULLABLE	2025-01-15
9	returned_timestamp	TIMESTAMP	NULLABLE	2025-01-15
10	organization	STRING	NON-NULLABLE	2025-01-15