DSCR Application

DSCR Application

Report type: dscr_application

About this export

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

---

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