Loan Field Valid Values

Valid values for loan table fields, extracted from the WTPO production database (PS608) configuration tables and industry conventions.

Source: Azure SQL MI (PS608), extracted 2026-03-17.

Configuration-Defined Values

These values are defined in configuration tables and can vary by customer.

Loan Statuses (curr_status)

Source: pscat_loan_statuses

Status Code	Seq	Syntax (SQL criteria)	Fallout Type	Closed?	Rate Sensitive
unlocked	1	— (reserved)	s	No	Yes
initialization	2	— (reserved)	s	No	No
re-initialization	3	— (reserved)	s	No	No
Closed	4	disbursement_date <= dbo.sf_ps_asbusday(0) and curr_status not in ('withdrawn','denied')	s	Yes	Yes
Denied	5	curr_status in ('denied')	h	No	No
Withdrawn	6	curr_status in ('withdrawn')	h	No	Yes
Expired	7	Lock expiration < current business day	h	No	Yes
Rate Concession	8	Note rate decreased, discount points ≤ previous	s	No	Yes
Point Concession	9	Discount points decreased, note rate ≤ previous	s	No	Yes

Fallout types: s = soft (can be reprocessed), h = hard (requires manual intervention)

Loan Stages

Source: pscat_loan_stages

Stage	Seq	Rank	Notes
In Process	1	1	Initial stage
In Underwriting	2	2	Under review
Approved	3	3	Approved for closing
Docs Out	4	4	Documents sent

Instrument Types (instrument_type_name)

Source: pscat_instruments_types

Type
bond
cash program
note
security
whole loan

Active Instruments (instrument_name)

Source: pscat_instruments (595 active at WTPO). Organized by category:

Conventional Fixed (FNMA):

• 10, 15, 20, 25/30 year terms
• Balance tiers: ≤85K, 85-110K, 110-125K, ... 400K+
• High balance variants
• Sub-programs: HomeReady, MH Advantage, Refi Possible, RefiNow

Conventional Fixed (FHLMC):

• 10, 15, 20, 25/30 year terms
• Balance tiers matching FNMA
• High balance and super conforming variants
• Sub-programs: Home Possible, CHOICEHome, Refi Possible

Government (FHA):

• 10, 15, 20, 25, 30 year fixed
• Balance tiers
• FHA Streamline variants
• 5/1 ARM and high balance ARM

Government (VA):

• 10, 15, 20, 25, 30 year fixed
• Balance tiers
• VA IRRRL (streamline) variants
• 3/1 and 5/1 ARM

Government (USDA):

• 30 year fixed
• Balance tiers
• Rural Development (RD) variants

ARM Products:

• FNMA: 5/6, 7/6, 10/6 SOFR ARMs
• FHLMC: 5/6, 7/6, 10/6 SOFR ARMs
• Super Conforming ARM variants
• High balance ARM variants

Jumbo/Non-Agency:

• Jumbo 15yr and 30yr fixed
• Smart Edge, Smart Self, Smart Vest (30yr, 40yr, IO variants)
• Yosemite Jumbo AUS (5/6, 10/6 SOFR, 20-30yr fixed)

Closed End Seconds:

• 15, 20, 30 year standalone

Treasury/Hedging Instruments:

• US Treasury: 3mo, 2yr, 5yr, 10yr, 30yr
• Eurodollar futures: 12 contract months

Investor-Specific (PHH/Freedom):

• Conventional, FHA, VA, USDA variants
• 10-30 year terms
• High balance and jumbo variants

Industry-Convention Values

These fields use industry-standard codes. No configuration table — values are consistent across the mortgage industry.

Amortization Type (amort_type)

Value	Description
Fixed	Fixed rate, fully amortizing
ARM	Adjustable rate mortgage
Balloon	Balloon payment at term
Interest Only	Interest-only period
Graduated	Graduated payment

Loan Type (loan_type)

Value	Description
Conventional	Conforming or non-conforming, not government-insured
FHA	Federal Housing Administration insured
VA	Department of Veterans Affairs guaranteed
USDA	USDA Rural Development guaranteed
HUD 184	HUD Section 184 Indian Housing

Loan Purpose (purpose_code)

Value	Description
Purchase	Property acquisition
Refinance	Rate/term refinance
Cash-Out Refinance	Cash-out refinance
Construction	New construction
IRRRL	VA Interest Rate Reduction Refinance
Streamline	FHA Streamline refinance

Occupancy Code (occupancy_code)

Value	Description
Owner Occupied	Primary residence
Second Home	Second/vacation home
Investment	Investment property

Property Type (property_type)

Value	Description
SFR	Single-family residence
Condo	Condominium
PUD	Planned Unit Development
2-4 Unit	Multi-family (2-4 units)
Manufactured	Manufactured housing
Co-op	Cooperative
Townhouse	Townhouse

Cash-Out Indicator (cash_out_indicator)

Value	Description
true / Yes	Cash-out refinance
false / No	Not a cash-out

AUS Engine (aus_engine)

Value	Description
DU	Desktop Underwriter (Fannie Mae)
LP	Loan Prospector (Freddie Mac)
Manual	Manual underwriting
GUS	USDA GUS system

AUS Results (aus_results)

Value	Description
Approve/Eligible	DU approval
Accept	LP acceptance
Refer	Requires manual review
Caution	LP caution
Out/Ineligible	Not eligible

State (state)

Standard 2-letter US state and territory codes (AL, AK, AZ, ... WY, DC, GU, PR, VI).

Boolean/Flag Fields

Many fields use a simple flag pattern:

Pattern	Meaning
true / false	String boolean
Yes / No	String boolean
y / n	Single-char boolean
1 / 0	Numeric boolean

Fields using this pattern: buydown_flag, int_only, subordinate_financing_flag, first_time_borrower, flood_insurance_flag, loss_mit_flag, down_pymt_assist, loanaffordableindicator, conformingloanlimitindicator, jumboindicator, escrowindicator, mersorigmortgageeofrecordind, highbalanceindicator, interestonly, selfemployedindicator, enoteindicator, assumableindicator, appraisal_waiver_flag.

Note: Flag fields are inconsistent — some use true/false, others use y/n. PSSaaS should normalize these to a consistent pattern.

Empty Configuration Tables (at WTPO)

These tables have valid-value definitions but are empty at Watermark TPO, meaning the feature isn't configured:

Table	Purpose
pscat_sources	Loan source/channel definitions
pscat_products	Product code catalog