Application Event

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

---

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_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
72	prequal_source_type	STRING	NULLABLE	2022-09-01		API UNKNOWN		Ignore, vestigial field
73	prequal_avm_amount	FLOAT	NULLABLE	2022-09-01	Automated Valuation Model (home value) amount used during prequalification
74	prequal_avm_fsd	FLOAT	NULLABLE	2022-09-01	FSD: Forecast standard deviation value for the automated valuation model used during prequalification
75	final_source_type	STRING	NULLABLE	2022-09-01				Ignore, vestigial field
76	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
77	avm_value_amount	FLOAT	NULLABLE	2022-09-01	Value of subject property
78	avm_fsd	FLOAT	NULLABLE	2022-09-01	Forecast standard deviation value for the automated valuation model used for final offer
79	avm_high_value	FLOAT	NULLABLE	2022-09-01	High property value provided by automated valuation model
80	avm_low_value	FLOAT	NULLABLE	2022-09-01	Low property value provided by automated valuation model
81	avm_run_date	STRING	NON-NULLABLE	2022-09-01	Run date of the automated valuation model used during final underwriting
82	bpo_type	STRING	NULLABLE	2024-01-29	Broker price opinion (BPO) type	BPO_EXTERIOR
83	prequal_frozen_avm_flag	STRING	NON-NULLABLE	2022-09-01	Frozen AVM value used to prequalify	Y N
84	frozen_avm_flag	STRING	NULLABLE	2022-09-01	(Deprecated) Frozen AVM value used for final offer.	Y N
85	adjusted_home_amount	FLOAT	NULLABLE	2022-09-13	(Deprecated) Value of subject property used in underwriting. Adjusted given the FSD value.
86	ownership	STRING	NON-NULLABLE	2022-09-01		JOINT SOLE TRUST UNKNOWN
87	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
88	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
89	rate_type	STRING	NON-NULLABLE	2022-09-01	Rate Type	FIXED VARIABLE UNKNOWN
90	app_rate	FLOAT	NON-NULLABLE	2022-09-01	Interest rate selected
91	app_term	INTEGER	NULLABLE	2022-09-01	Loan term selected in years
92	app_term_months	INTEGER	NULLABLE	2022-09-01	Loan term selected in months
93	selected_offer_estimated_monthly_payment	NUMERIC	NULLABLE	2022-09-01	Estimated monthly payment of selected offer
94	first_payment_due_date	TIMESTAMP	NULLABLE	2025-01-14	First Payment Due Date (available only for loans originally serviced by Figure)
95	expected_payoff_date	DATE	NULLABLE	2025-01-14	Expected payoff date at origination (available only for loans originally serviced by Figure)
96	original_draw_period	INTEGER	NULLABLE	2022-09-01	HELOC Draw Period in years
97	original_draw_period_months	INTEGER	NULLABLE	2022-09-01	HELOC Draw Period in months
98	credit_as_of_date	DATE	NULLABLE	2022-09-01	Credit Pulled as of Date
99	pricing_as_of_date	DATE	NULLABLE	2022-09-01	Pricing as of Date
100	pre_loan_cltv	FLOAT	NULLABLE	2022-09-01	CLTV of property based on unadjusted AVM, not taking into account selected offer
101	pre_loan_adj_cltv	FLOAT	NULLABLE	2022-09-01	CLTV of property based on adjusted AVM, not taking into account selected offer
102	pre_loan_dti	FLOAT	NULLABLE	2022-09-01	DTI of borrower, not taking into account selected offer
103	stated_dti	FLOAT	NULLABLE	2022-09-01	DTI of borrower based on stated income
104	post_loan_cltv	FLOAT	NULLABLE	2022-09-01	CLTV of property based on unadjusted AVM, taking into account selected offer
105	post_loan_adj_cltv	FLOAT	NULLABLE	2022-09-01	CLTV of property based on adjusted AVM, taking into account selected offer
106	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
107	post_loan_dti	FLOAT	NULLABLE	2022-09-01	DTI of borrower, taking into account monthly payment of selected offer
108	credit_soft_provider	STRING	NULLABLE	2022-09-01		EXPERIAN
109	credit_soft_fico	INTEGER	NULLABLE	2022-09-01	Soft FICO			Values outside of the expected 300 - 850 range are error codes
110	credit_soft_timestamp	TIMESTAMP	NULLABLE	2024-05-28
111	credit_soft_secs	INTEGER	NULLABLE	2022-09-01	!Vestigial field Timestamp of soft credit pull in seconds since epoch			Ignore, vestigial field
112	credit_soft_complete	BOOLEAN	NULLABLE	2022-09-01
113	credit_hard_provider	STRING	NULLABLE	2022-09-01		EXPERIAN
114	credit_hard_fico	INTEGER	NULLABLE	2022-09-01				Values outside of the expected 300 - 850 range are error codes
115	credit_hard_timestamp	TIMESTAMP	NULLABLE	2024-05-28
116	credit_hard_secs	INTEGER	NULLABLE	2022-09-01	!Vestigial field Timestamp of hard credit pull in seconds since epoch
117	credit_hard_complete	BOOLEAN	NULLABLE	2022-09-01
118	monthly_income	FLOAT	NULLABLE	2022-09-01	Verified monthly income
119	stated_monthly_income	FLOAT	NULLABLE	2022-09-01	Verified monthly income
120	co_deed_status	STRING	NULLABLE	2022-09-01	Status of additional signer (also known as co-deeder) required work	INITIAL COMPLETE
121	flood_insured	BOOLEAN	NULLABLE	2022-09-01
122	homeowners_insured	BOOLEAN	NULLABLE	2022-09-01
123	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
124	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
125	total_liens	INTEGER	NULLABLE	2022-09-01
126	liens_w_balance	INTEGER	NON-NULLABLE	2022-09-01
127	figure_new_lien_position	INTEGER	NON-NULLABLE	2022-09-01	Position of new HELOC lien
128	lien_position_1_lender	STRING	NULLABLE	2024-08-22	Lender of property lien in first position
129	lien_position_1_origination_date	DATE	NULLABLE	2024-08-22	Origination date of lien in first position
130	lien_position_1_original_balance	FLOAT	NULLABLE	2024-08-22	Original balance of lien in first position
131	lien_position_1_current_balance	FLOAT	NULLABLE	2024-08-22	Current balance of lien in first position (as of application start date)
132	lien_position_2_lender	STRING	NULLABLE	2024-08-22	Lender of property lien in second position
133	lien_position_2_origination_date	DATE	NULLABLE	2024-08-22	Origination date of lien in second position
134	lien_position_2_original_balance	FLOAT	NULLABLE	2024-08-22	Original balance of lien in second position
135	lien_position_2_current_balance	FLOAT	NULLABLE	2024-08-22	Current balance of lien in second position (as of application start date)
136	organization	STRING	NON-NULLABLE	2022-09-01	Organization
137	wholesale_originator_dba_name	STRING	NULLABLE	2024-03-18	Broker LO selected doing-business-as-name
138	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)
139	home_for_sale_borrower_attested	BOOLEAN	NULLABLE	2022-10-18	Borrower attested the home is for sale
140	home_for_sale_mls_response	BOOLEAN	NULLABLE	2022-10-18	MLS data noted home is for sale
141	manual_notary_flag	BOOLEAN	NULLABLE	2022-09-01	True if the applicant is not eligible for remote online notarization
142	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
143	in_person_notary_appointment_timestamp	TIMESTAMP	NULLABLE	2025-04-01	Timestamp of scheduled notary appointment
144	enotary_completed_timestamp	TIMESTAMP	NULLABLE	2025-04-01	Timestamp that all e-signings were complete
145	heloc_agreement_e_signed_timestamp	TIMESTAMP	NULLABLE	2025-04-01	Timestamp e-signature applied to HELOC agreement (not a notarized document)
146	hispanic_or_latino_ethnicity_type	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
147	ethnicity_refusal	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
148	other_ethnicity_description	STRING	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
149	gender_refusal	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
150	race_refusal	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
151	race_asian_additional_description	STRING	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
152	race_pacific_islander_additional_description	STRING	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
153	ethnicity_collected_based_on_visual_observation_or_surname	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions	False
154	gender_collected_based_on_visual_observation_or_name	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions	False
155	race_collected_based_on_visual_observation_or_surname	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions	False
156	tribe_name	STRING	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
157	not_hispanic_or_latino	BOOLEAN	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions
158	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
159	gender_types	STRING	NULLABLE	2022-09-01	HMDA Ethnicity/Race/Gender questions List, separated by ","	FEMALE MALE
160	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
161	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
162	application_time_zone	STRING	NON-NULLABLE	2022-09-01	Applicant Time Zone	IANA time zone names
163	expiration_date	TIMESTAMP	NON-NULLABLE	2022-09-01	Expiration Date
164	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
165	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
166	decline_details	STRING	NULLABLE	2022-09-01	Text description of decline_codes
167	cancellation_status	STRING	NULLABLE	2024-03-28	Type of application cancellation	WITHDRAWN EXPIRED REJECTED
168	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
169	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
170	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
171	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
172	building_gross_area	STRING	NULLABLE	2022-09-01	Livable Square Footage
173	query_params	STRING	NULLABLE	2022-09-01	UTM parameters. Provided without warranty.
174	signing_date	DATE	NULLABLE	2022-09-01	Right to Cancel Signing Date
175	Rescission_Start_Date	DATE	NULLABLE	2022-09-01	Rescission Start Date
176	Rescission_Exit_Date	DATE	NULLABLE	2022-09-01	Rescission Exit Date
177	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.
178	Transfer_Date	DATE	NULLABLE	2022-09-01	Date the funded loan was transferred ownership from it's originator
179	estimated_ach_funding_date	DATE	NULLABLE	2025-01-14	Estimated date that the ACH funding transaction will take place
180	application_summary_disclosure_signed_date	TIMESTAMP	NULLABLE	2024-05-28	Application Summary Disclosure signed date
181	external_partner_application_id	STRING	NULLABLE	2026-03-31	Application identifier from the external partner or channel that submitted the application.
182	external_partner_reference_id	STRING	NULLABLE	2026-03-31	Reference or tracking identifier provided by the external partner for the application.
183	referring_loan_officer_identity_uuid_value	STRING	NULLABLE	2024-05-28	UUID of Loan Officer (referral_id in loan_officer)
184	assigned_assistant_emails	STRING	NULLABLE	2023-03-31	Semicolon (;) delimited list of emails for assigned assistants
185	assigned_assistant_identity_uuids	STRING	NULLABLE	2023-03-31	Semicolon (;) delimited list of Figure identity UUIDs for assigned assistants
186	nmls_mlo_id	STRING	NULLABLE	2022-09-01	NMLS MLO ID
187	mlo_full_name	STRING	NULLABLE	2022-09-01	MLO Full Name
188	mlo_employee_id	STRING	NULLABLE	2022-09-01	External ID provided by partner
189	company_id	STRING	NULLABLE	2023-03-07	Broker ID of referring MLO
190	company_name	STRING	NULLABLE	2023-03-07	Broker name of referring MLO
191	company_nmls	STRING	NULLABLE	2023-03-07	NMLS number of referring MLO's broker
192	referring_mlo_name	STRING	NULLABLE	2022-09-01	Referring MLO Name
193	referring_mlo_nmls_no	STRING	NULLABLE	2022-09-01	Referring MLO NMLS ID
194	docs_mlo_name	STRING	NULLABLE	2022-09-01	MLO Name on Application Summary
195	docs_mlo_nmls	STRING	NULLABLE	2022-09-01	NMLS number of loan officer on Application Summary
196	deed_loan_officer_identity_uuid_value	STRING	NULLABLE	2025-08-11	Figure identity UUID of loan officer listed on Deed
197	deed_loan_officer_nmls_number	STRING	NULLABLE	2025-08-11	NMLS number of loan officer listed on Deed
198	deed_loan_officer_name	STRING	NULLABLE	2025-08-11	Name of loan officer listed on Deed
199	deed_date	DATE	NULLABLE	2025-08-11	Date listed on Deed
200	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.
201	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.
202	app_start_flag	STRING	NON-NULLABLE	2022-09-01	App Start Flag, application started	Y
203	lien_validation_flag	STRING	NON-NULLABLE	2022-09-01	Lien Validation Flag, applicant asked to validate Liens	Y N
204	no_credit_hit_flag	STRING	NON-NULLABLE	2022-09-01	No Credit returned by UW, asked to provide ssn	Y N
205	frozen_flag	STRING	NON-NULLABLE	2022-09-01	Frozen Flag, Credit Frozen	Y N
206	locked_flag	STRING	NON-NULLABLE	2022-09-01	Locked Flag, Credit Locked	Y N
207	ofac_flagged_flag	STRING	NON-NULLABLE	2022-09-01	OFAC Flagged	Y N
208	fraud_flagged_flag	STRING	NON-NULLABLE	2022-09-01	Fraud Flagged	Y N
209	property_not_found_flag	STRING	NON-NULLABLE	2022-09-01	Property not found Flag	Y N
210	multiple_property_matches_flag	STRING	NON-NULLABLE	2022-09-01	Multiple Property Search Flag	Y N
211	uw_review_flag	STRING	NON-NULLABLE	2022-09-01	Application under further review Flag	Y N
212	product_select_flag	STRING	NON-NULLABLE	2022-09-01	Applicant Passed Pre-UW, presented Offers	Y N
213	ssn_consent_flag	STRING	NON-NULLABLE	2022-09-01	Applicant Selected Offer, asked to provide SSN	Y N
214	hmda_flag	STRING	NON-NULLABLE	2022-09-01	Applicant provided SSN, asked to provide race/ethnicity/gender information	Y N
215	id_upload_flag	STRING	NON-NULLABLE	2022-09-01	Applicant asked to provide identification	Y N
216	connect_accounts_flag	STRING	NON-NULLABLE	2022-09-01	Applicant asked to connect income sources	Y N
217	variance_flag	STRING	NON-NULLABLE	2022-09-01	Variance found, applicant asked to correct	Y N
218	disbursement_account_flag	STRING	NON-NULLABLE	2022-09-01	Applicant asked to enter disbursement account	Y N
219	sign_prom_note_flag	STRING	NON-NULLABLE	2022-09-01	Applicant asked to Sign Prom Note	Y N
220	additional_signers_flag	STRING	NON-NULLABLE	2022-09-01	Applicant told additional signer is needed	Y N
221	notary_flag	STRING	NON-NULLABLE	2022-09-01	Notary scheduling available	Y N
222	rescission_flag	STRING	NON-NULLABLE	2022-09-01	Applicant enters Rescission	Y N
223	funded_flag	STRING	NON-NULLABLE	2022-09-01	Applicant Loan Funded	Y N
224	recording_flag	STRING	NON-NULLABLE	2022-09-01	Applicant Loan entered county recording	Y N
225	complete_flag	STRING	NON-NULLABLE	2022-09-01	Applicant Loan Recorded	Y N
226	cancelled_flag	STRING	NON-NULLABLE	2022-09-01	Applicant application cancelled	Y N
227	declined_flag	STRING	NON-NULLABLE	2022-09-01	Applicant application declined	Y N
228	app_start_ts	DATETIME	NON-NULLABLE	2022-09-01	Time Applicant has started the Application
229	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
230	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
231	frozen_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Frozen Credit			Optional stage: Applicant enters stage if applicant must unfreeze credit
232	locked_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Locked Credit			Optional stage: Applicant enters stage if applicant must unlock credit
233	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
234	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
235	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.
236	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.
237	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.
238	product_select_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Offer selection			Applicant enters stage when offers are returned
239	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
240	hmda_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered HMDA information collection			Applicant enters stage to fill out HMDA information
241	id_upload_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered ID Upload			Applicant enters stage to upload their ID document
242	connect_accounts_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Connect Accounts			Applicant enters stage to verify their stated income
243	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.
244	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
245	sign_prom_note_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Sign Prom Note			Applicant needs to sign promisory note
246	additional_signers_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Additional Signers			Optional stage: Applicant needs to add additional signers
247	notary_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Notary			Applicant needs to perform notarization
248	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
249	funded_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Funding			Application enters funding queue
250	recording_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Recording			Application begins Deed recording process
251	complete_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Complete			Application has had deed recorded
252	cancelled_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Cancellation			Application was cancelled
253	declined_ts	DATETIME	NULLABLE	2022-09-01	Time Applicant has entered Decline			Application was declined
254	app_start_duration	NUMERIC	NON-NULLABLE	2022-09-01	Time Applicant spent in App Start in seconds
255	lien_validation_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Lien Validation in seconds
256	no_credit_hit_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in No Credit Hit in seconds
257	frozen_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Frozen Credit in seconds
258	locked_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Locked Credit in seconds
259	ofac_flagged_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in OFAC in seconds
260	fraud_flagged_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Fraud Flagged in seconds
261	property_not_found_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Property not found in seconds
262	multiple_property_matches_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Multiple Property Matches in seconds
263	uw_review_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in UW Review in seconds
264	product_select_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Product Select in seconds
265	ssn_consent_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in SSN Consent in seconds
266	hmda_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in HMDA in seconds
267	id_upload_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in ID Upload in seconds
268	connect_accounts_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Connect Accounts in seconds
269	variance_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Variance in seconds
270	disbursement_account_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Disbursement Account in seconds
271	sign_prom_note_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Sign Prom Note in seconds
272	additional_signers_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Additional Signers in seconds
273	notary_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Notary in seconds
274	rescission_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Rescission in seconds
275	funded_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Funded in seconds
276	recording_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Recording in seconds
277	complete_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Complete in seconds
278	cancelled_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Cancelled in seconds
279	declined_duration	NUMERIC	NULLABLE	2022-09-01	Time Applicant spent in Declined in seconds