[Logo: Homes and Communities: U.S. Department of Housing and Urban Development]
[Vea la versión en español de esta página] [Contact Us] [Display the text version of this page] [Search/Index]
 

Housing
About Housing
Contact us
Keywords
 - Single Family
 - - Audience groups
 - - Buying a home
 - - Events & training
 - - FHA insured loans
 - - Common questions
 - - Housing counseling
 - - HUD homes/ REO
 - - Owning a home
 - - Reference guide
 - - Regulatory programs
Hospitals
Multifamily
OAHP
Reading room
Online forums
Work online

HUD news

Homes

Resources

Communities

Working with HUD

Tools
Webcasts
Mailing lists
RSS Feeds
Help

[The U.S. government's official web portal]  

Case Query

 Information by State
 Print version
 
The Case Query function lists case status information. The lender may request the status of a specific loan as it progress through the Federal Housing Administration(FHA) mortgage process. By querying a case, the lender will receive general case information regarding the property address, case type, the appraiser, Mortgage Insurance Premium (MIP), and insurance status. A lender may query a case by FHA case number, (property) address, (borrower) name, or (borrower)Social Security Number(SSN)/Tax Identification Number(TIN).

The Case Query function is run by posting the input file to:
Test https://hwvauwd491.hud.gov/b2b/chums/f17cqxml.cfm
Production https://entp.hud.gov/b2b/chums/f17cqxml.cfm



History of Changes


Multiple additions to individual case output. Implementation date January 29, 2008
Added element, FHAVAPrincipalReduction
Added attribute to FHAVAPrincipalReduction, _Required
Added attribute to FHAVAPrincipalReduction, _Value
Added element, FHAVAMortgageInsurancePremium
Added attribute to FHAVAMortgageInsurancePremium, UpfrontMIPFactor
Added attribute to FHAVAMortgageInsurancePremium, AnnualMIPFactor
Added attribute to FHAVAMortgageInsurancePremium, UpfrontMIPFactorException
Added attribute to FHAVAMortgageInsurancePremium, AnnualMIPFactorException
Lender Endorsement Indicators January 2 2006
Added attribute, EndorsementAuthority, to MORTGAGEINSURANCE
Added attribute, BinderStatus, to MORTGAGEINSURANCE


Example Input File

<?xml version='1.0' standalone='yes'?>
<MORTGAGEDATA MISMOVersionID='1.0.1'>
	<PROCESSSTATUS>
		<ProcessStatusCode>Query</ProcessStatusCode>
		<ProcessStatusRequestor>PRMS</ProcessStatusRequestor>
		<CurrentPage>1</CurrentPage>
	</PROCESSSTATUS>
	<FHAVA>
		<FHAVAFieldOfficeCode>Hartford,CT</FHAVAFieldOfficeCode>
	</FHAVA>
	<APPLICATION>
		<AgencyCaseIdentifier>0612002587</AgencyCaseIdentifier>
	</APPLICATION>
	<BORROWER>
		<LastName>s</LastName>
		<FirstName></FirstName>
		<SSN></SSN>
	</BORROWER>
	<PROPERTY>
		<PostalCode></PostalCode>
		<PARSEDSTREETNAME>
			<HouseNumber></HouseNumber>
			<StreetName></StreetName>
		</PARSEDSTREETNAME>
	</PROPERTY>
</MORTGAGEDATA>

End of Input Fields for Case Query
Data Item Valid Entries Description
<CurrentPage> Up to 4 Numeric characters Use to page through or jump to the desired output record page. Output pages are 20 records (at most) each. The total number of pages and records is displayed in the output section as TotalRecordsReturned
<FHAVA>
<FHAVAFieldOfficeCode>
Field Office (Required Entry If Query Case By Address, Name, or SSN/TIN; Optional Entry if Querying Case By FHA Case Number) Field Office where property is located.
<APPLICATION>
<AgencyCaseIdentifier>
Nine numeric characters followed by an "X" (will calculate the case number in a numeric format) or ten numeric characters; first two digits identify the state where property is located, third digit identifies the Field Office where case will be processed, following six digits indicate the serial number, and the final digit is a check digit (Required Entry if Querying Case By FHA Case Number) Number identifying/referencing the FHA case.
<PROPERTY>
<PARSEDSTREETNAME>
<HouseNumber>
Up to five alphanumeric characters (Required Entry if Querying Case By Address) House number of property.
<PROPERTY>
<PARSEDSTREETNAME>
<StreetName>
Up to 20 alphanumeric characters (Required Entry If Querying Case By Address) Street name of property.
<PROPERTY>
<PostalCode>
Five numeric characters (Required Entry If Querying Case By Address) ZIP Code of property.
<BORROWER>
<LastName>
Up to 20 alphabetic characters (Required Entry If Querying Case By Name) Last name of borrower.
<BORROWER>
<FirstName>
Up to 12 alphabetic characters (Required Entry If Querying Case By Name) First name of borrower.
<BORROWER>
<SSN>
Nine numeric characters (Required Entry If Querying Case By SSN/TIN) Social Security Number(SSN) of borrower, Tax Identification Number(TIN) of government agency or non-profit organization.


Information Returned for a Single Case:


Example Output File

<?xml version="1.0" standalone="yes"?>
<MORTGAGEDATA MISMOVersionID='1.0.1'>
	<PROCESSSTATUS>
		<ProcessStatusCode></ProcessStatusCode>
		<LastActionTaken></LastActionTaken>
		<LastActionTakenDate></LastActionTakenDate>
		<ProcessStatusFlag
			ProcessStatusFlagName="error_flag"
			ProcessStatusFlagValue="">
		</ProcessStatusFlag>
	</PROCESSSTATUS>
	<APPLICATION>
		<AgencyCaseIdentifier></AgencyCaseIdentifier>
		<BaseLoanAmount HECMindicator = ''></BaseLoanAmount>
		
		<UNDERWRITINGCASE CounselingConfirmationType=' '>
			<LoanScheduledClosingDate></LoanScheduledClosingDate>
			<FHAVA FHAVAADPCode = ''>
				<FHAVAMortgageInsurancePremium
					UpfrontMIPFactor=' '
					UpfrontMIPFactorException=' '
					AnnualMIPFactor=' '
					AnnualMIPFactorException=' '/>
				<FHAVAPrincipalReduction _Required='' _Value='' />
				<CaseTypeCD></CaseTypeCD>
				<CaseReceivedDate></CaseReceivedDate>
				<ClosingPackageReceivedDate></ClosingPackageReceivedDate>
				<FHAVAOriginatorIdentifier></FHAVAOriginatorIdentifier>
			</FHAVA>
		</UNDERWRITINGCASE>
	</APPLICATION>
	<BORROWER>
		<UnparsedName></UnparsedName>
	</BORROWER>

	<PROPERTY>
		<city></city>
		<state></state>
		<PostalCode></PostalCode>
		<CountyCode></CountyCode>
		<PARSEDSTREETNAME>
			<HouseNumber></HouseNumber>
			<StreetName></StreetName>
			<StreetSuffix></StreetSuffix>
		</PARSEDSTREETNAME>
	</PROPERTY>
	<SUBJECTPROPERTY>
		<SubjectPropertyAppraisedValueAmount></SubjectPropertyAppraisedValueAmount>
	</SUBJECTPROPERTY>
	<PARTY PARTYID = '' PartyType = 'Lender'>
		<PartyName></PartyName>
	</PARTY>
	<PARTY PARTYID = '' PartyType = 'Lender'>
		<PartyName></PartyName>
	</PARTY>
	<VALUATIONS>
		<AppraiserLicenseIdentifier></AppraiserLicenseIdentifier>
		<AppraisalEffectiveDate></AppraisalEffectiveDate>
	</VALUATIONS>
	<PARTY PARTYID = '' PartyType = 'Appraiser'>
		<PartyName></PartyName>
	</PARTY>
	<MORTGAGEINSURANCERESPONSE>
		<FHAVAEndorsmentDate></FHAVAEndorsmentDate>
		<MortgageInsuranceCertificateDate></MortgageInsuranceCertificateDate>
		<FHAVATotalScorecardCase></FHAVATotalScorecardCase>
		<FHAVAIndemnityDate></FHAVAIndemnityDate> 
	</MORTGAGEINSURANCERESPONSE>
	<MORTGAGEINSURANCE
	 EndorsementAuthority = 'HOC'
	 BinderStatus = 'ElectronicBinderReceived'>
	  <MortgageInsurancePremiumMaturationDate></MortgageInsurancePremiumMaturationDate>
		<MortgageInsuranceUnpaidPrincipalBalance></MortgageInsuranceUnpaidPrincipalBalance>
		<MortgageInsuranceRequired></MortgageInsuranceRequired>
		<MortgageInsurancePaid></MortgageInsurancePaid>
		<MortgageInsuranceReceived></MortgageInsuranceReceived>
		<MortgageInsurancePenalty>No</MortgageInsurancePenalty>
	</MORTGAGEINSURANCE>
	<PRODUCT>
		<LoanAmortizationTermMonths></LoanAmortizationTermMonths>
	</PRODUCT>
</MORTGAGEDATA>

Single Case
Data Item Description
<APPLICATION>
<AgencyCaseIdentifier>
FHA case number. Up to 10 numeric characters.
<UNDERWRITINGCASE CounselingConfirmationType=' '> One of: NoBorrowerCounseling, LenderTrainedCounseling, ThirdPartyCounseling, HUDApprovedCounseling
<FHAVAMortgageInsurancePremium UpfrontMIPFactor=' '> Calculated value; rate used to calculate upfront MIP
<FHAVAMortgageInsurancePremium AnnualMIPFactor=' '> Calculated value; rate used to calculate annual MIP
<FHAVAMortgageInsurancePremium UpfrontMIPFactorException=' '> Will contain explanation for lack of value for Upfront MIP
<FHAVAMortgageInsurancePremium AnnualMIPFactorException=' '> Will contain explanation for lack of value for Annual MIP
<FHAVAPrincipalReduction _Required=''> Indicates if a principal reduction is required
<FHAVAPrincipalReduction _Value=''> Indicates amount of principal reduction
<BORROWER>
<UnparsedName>
Borrower's name. Up to 22 alphanumeric characters.
<PROPERTY>
<Address1>
Property address line 1.
<PROPERTY>
<Address2>
Property address line 2.
<PROPERTY>
<City>
City in which property is located. Up to seventeen alphanumeric characters.
<PROPERTY>
<State>
State in which property is located. Two characters.
<PROPERTY>
<PostalCode>
Zip code of property. Nine numeric characters; last four-digits pre-filled with zeroes.
<PROPERTY>
<CountyCode>
County in which property is located. Three numeric characters.
<PROPERTY>
<PARSEDSTREETNAME>
<HouseNumber>
House number of property. Up to seven alphanumeric characters.
<PROPERTY>
<PARSEDSTREETNAME>
<DirectionPrefix>
Pre-direction to the street. Valid Direction - Two characters.
<PROPERTY>
<PARSEDSTREETNAME>
<StreetName>
Street name or number of property. Up to twenty alphanumeric characters.
<PROPERTY>
<PARSEDSTREETNAME>
<StreetSuffix>
Street type abbreviation. Up to four characters.
<PROPERTY>
<PARSEDSTREETNAME>
<DirectionSuffix>
Post-direction or section of street. Valid Direction - Two characters.
<PROPERTY>
<PARSEDSTREETNAME>
<ApartmentOrUnit>
Extension of the house or condominium number. Up to six alphnumberic characters.
<SUBJECTPROPERTY><SubjectPropertyAppraisedValueAmount> Appraised value of property
<SUBJECTPROPERTY>
<SubjectPropertyShortLegalDescriptionBlk>
Block number of a new property that has no street address. Up to three characters.
<SUBJECTPROPERTY>
<SubjectPropertyShortLegalDescriptionPlat>
Plat number of a new property that has no street address. Up to two characters.
<SUBJECTPROPERTY>
<SubjectPropertyShortLegalDescriptionLot>
Lot number of a new property that has no street address. Up to four numeric characters.
<PARTY PartyType='' PARTYID=''> Party types represented are Lender and Sponsor. The PARTYID represents various numbers as identifiers for these parties.
<PARTY><PartyName> Name of party. 30 alphanumeric characters.
<APPLICATION>
<UNDERWRITINGCASE>
<FHAVA>
<CaseTypeDescription>
The specific case/refinance/processing type.
<APPLICATION>
<UNDERWRITINGCASE>
<FHAVA>
<FHAVAOriginatorIdentifier>
Lender ID (10 digits)
<APPLICATION>
<UNDERWRITINGCASE>
<FHAVA>
<CaseTypeCode>
<APPLICATION>
<UNDERWRITINGCASE>
<FHAVA FHAVAADPCode='VALUE'>
ADP code of case. 3 numeric characters.
<APPLICATION>
<UNDERWRITINGCASE>
<FHAVA>
<CaseReceivedDate>
Date case number was issued (YYYYMMDD).
<VALUATIONS>
<AppraiserLicenseIdentifier>
Appraiser's license number. 22 alphanumeric characters.
<APPLICATION>
<UNDERWRITINGCASE>
<FHAVA>
<FHAVATotalScorecardCase>
Is case a Total Scorecard case Yes or No
<APPLICATION>
<UNDERWRITINGCASE>
<FHAVA>
<FHAVAIndemnityDate>
Date of Imdemnity (YYYYMMDD).
<VALUATIONS>
<AppraisalEffectiveDate>
Date appraisal was logged (YYYYMMDD).
<APPLICATION>
<UNDERWRITINGCASE>
<FHAVA>
<PriorLoanClosedBefore19990701>
For a refinance case, indicates if previous loan was closed prior to July 1, 1991 (Yes or No).
<APPLICATION>
<UNDERWRITINGCASE>
<FHAVA>
<ClosingPackageReceivedDate>
The date the closing package was received (YYYYMMDD).
<APPLICATION>
<UNDERWRITINGCASE>
<LoanScheduledClosingDate>
The date the loan was closed (YYYYMMDD).
<MORTGAGEINSURANCERESPONSE>
<FHAVAEndorsmentDate>
Date the loan was insured by the FHA (YYYYMMDD).
<MORTGAGEINSURANCERESPONSE>
<MortgageInsuranceCertificateDate>
Date loan data was printed (YYYYMMDD).
<MORTGAGEINSURANCE><MortgageInsuranceUnpaidPrincipalBalance> The unpaid principle amount when the value reaches 78%.
<MORTGAGEINSURANCE><MortgageInsurancePremiumMaturationDate> Final bill Date
<MORTGAGEINSURANCE MortgageInsuranceRequired='VALUE'> The total amount of MIP due. 8 numeric characters.
<MORTGAGEINSURANCE MortgageInsurancePaid='VALUE'> The amount of MIP which has been paid. 8 numeric characters.
<MORTGAGEINSURANCE>
<MortgageInsuranceReceived>
The date MIP was received (YYYYMMDD).
<MORTGAGEINSURANCERESPONSE>
<MORTGAGEINSURANCEFHAVANOR>
<MORTGAGEINSURANCEFHAVANORMESSAGE>
Any comments entered when the NOR was issued. 75 alphanumeric characters.
<MORTGAGEINSURANCERESPONSE>
<MORTGAGEINSURANCEFHAVANOR FHAVANorCode='VALUE'>
NOR Reason codes indicate why an insurance application was returned. 3 alphanumeric characters.
<PRODUCT>
<LoanAmortizationTermMonths>
Term of the loan. 3 numeric characters.
<APPLICATION>
<BaseLoanAmount HECMindicator = '[Y/N]'>
The amount of mortgage. 8 numeric characters. (FHA Direct MAX_CLAIM_AMT when HECMindicator is "Y", MORTGAGE_AMT otherwise)
<APPLICATION>
<UNDERWRITINGCASE>
<FHAVA>
<FHAVAStreamlinedReFinance
FHAVAStreamlinedReFinanceAuthorizationNumber='VALUE'>
Refinance authorization number from A43. 13 alphanumeric characters.
<ProcessStatusFlag ProcessStatusFlagName="error_flag" ProcessStatusFlagValue=""> Flag to determine if case number is in error ("Y"), a refinance case ("R"), or a purged case ("P").
<PROCESSSTATUS>
<LastActionTaken>
Last action performed on the case. 20 alphanumeric characters.
<PROCESSSTATUS>
<LastActionTakenDate>
Date the last action was taken (YYYYMMDD).
<MORTGAGEINSURANCE MortgageInsuranceLocationUninsurable='VALUE'> Indicates if the location of the property is insurable or not (Yes or No).
<MORTGAGEINSURANCE MortgageInsurancePropertyUninsurable='VALUE'> Indicates if the property is insurable or not (Yes or No).
<MORTGAGEINSURANCE EndorsementAuthority ='VALUE'> Indicates authority to endorse case; HOC or Lender.
<MORTGAGEINSURANCE BinderStatus ='VALUE'> Indicates status of the binder for the case: Not Requested, Awaiting Receipt, Electronic Binder Received, Paper Binder Received.
<MORTGAGEINSURANCE><MortgageInsuranceRequired> Amount of insurance required
<MORTGAGEINSURANCE><MortgageInsurancePaid> Amount of insurance paid
<MORTGAGEINSURANCE><MortgageInsurancePenalty> Yes/No
<APPLICATION>
<UNDERWRITINGCASE>
<PreProcessingReject>
Lists applicable codes indicating the case is a pre-processing reject. 35 alphanumeric characters.
<MORTGAGEINSURANCERESPONSE>
<MORTGAGEINSURANCEFHAVAFIRMCOMMITMENT>
<FHAVAFirmCommitmentCondCodes>
Firm Commitment condition codes. 76 alphanumeric characters.
<MORTGAGEINSURANCERESPONSE>
<MORTGAGEINSURANCEFHAVAFIRMCOMMITMENT>
<FHAVAFirmCommitmentCodes>
Firm Commitment Rejection codes indicating why a Firm Commitment was rejected. 76 alphanumeric characters.
<MORTGAGEINSURANCERESPONSE>
<MORTGAGEINSURANCEFHAVAFIRMCOMMITMENT>
<FHAVAFirmCommitmentComment>
Firm Commitment comments. 80 alphanumeric characters.
PRODUCT><LoanAmortizationTermMonths> Number of months of loan term
<PROCESSSTATUS>
<ProcessStatusCode>
Result of the request. See below for values and meanings.
<PROCESSSTATUS>
<ProcessStatusMessage sCode='1'>
Message detailing errors. Up to 80 alphanumeric characters. Up to 25 error messages may be returned (sCode)


Information Returned for a Borrower Name/Address/SSN-TIN Search:


Example Output File

<?xml version="1.0" standalone="yes"?>
<MULTICASEDATA MISMOVersionID='1.0.1'>
	<PROCESSSTATUS>
		<ProcessStatusCode>SuccessNoUpdateAllowed</ProcessStatusCode>
		<CurrentPage>1</CurrentPage>
		<TotalRecordsReturned
		BeginningRecord="1"
		EndingRecord="20">
		51
		</TotalRecordsReturned>
		<TotalPages>3</TotalPages>
	</PROCESSSTATUS>
	<CASEDATA CASEID = "1">
		<AgencyCaseIdentifier>0611984703</AgencyCaseIdentifier>
		<Borrower>
			<UnparsedName>ASHE II, THOMAS EARL</UnparsedName>
		</Borrower>
		<Address1>673   GREYSTONE RD</Address1>
		<LastActionTaken>INSURED</LastActionTaken>
	</CASEDATA> 
	<CASEDATA CASEID = "2">
		<AgencyCaseIdentifier>0611649426</AgencyCaseIdentifier>
		<Borrower>
			<UnparsedName>ASHE, PAULETTE O</UnparsedName>
		</Borrower>
		<Address1>22   MAIN ST U-4   D</Address1>
		<LastActionTaken>INSURED</LastActionTaken>
	</CASEDATA>
	<CASEDATA CASEID = "3">
		<AgencyCaseIdentifier>0612005155</AgencyCaseIdentifier>
		<Borrower>
			<UnparsedName>ASHE, PAULETTE O.</UnparsedName>
		</Borrower>
		<Address1>22   MAIN ST  DANBUR</Address1>
		<LastActionTaken>INSURED</LastActionTaken>
	</CASEDATA>
</MULTICASEDATA>

End of Output Fields for Case Query
Data Item Description
<CurrentPage> Reflects page of multiple page record that has been returned
<TotalPages> Reflects number of available pages in multiple page record return
<TotalRecordsReturned BeginningRecord="1" EndingRecord="21"> Provides total number of records, beginning record number and ending record number for current return.
<CASEDATA CASEID='VALUE'>
<AgencyCaseIdentifier>
FHA case number. Up to 10 numeric characters. Note: Up to 20 sets of case data may be returned. VALUE represents the sequential number of the case being returned from the total record count.
<CASEDATA CASEID='VALUE'>
<Borrower><UnparsedName>
Borrower's name. Up to 22 alphanumeric characters.
<CASEDATA CASEID='VALUE'>
<Address1>
Address of property. Up to 69 alphanumeric characters.
<CASEDATA CASEID='VALUE'>
<LastActionTakenDate>
Last action performed on the case. 20 alphanumeric characters.
<PROCESSSTATUS>
<ProcessStatusCode>
Result of the request. See below for values and meanings.
<PROCESSSTATUS>
<ProcessStatusMessage sCode='1'>
Message detailing errors. Up to 80 alphanumeric characters. Up to 25 error messages may be returned (sCode)


ProcessStatusCode Values:

End of ProcessStatusCode Values
SuccessNoUpdatesAllowed This indicates that the Case Query function successfully return case information. No updates are allowed because this function only queries the case data. It does not update the FHA database.
Unavailable System is down
Error This indicates that the Case Query function was not able to return case information. Either the case number did not exist or it couldn't find cases based on name, address, or SSN/TIN entered. Please see the ProcessStatusMessage for details


Comments or Questions? <SF Administration>

 

 
Content current as of 15 May 2008   Follow this link to go  Back to top   
----------
FOIA Privacy Web Policies and Important Links  Home [logo: Fair Housing and Equal Opportunity]
[Logo: HUD seal] U.S. Department of Housing and Urban Development
451 7th Street S.W., Washington, DC 20410
Telephone: (202) 708-1112   TTY: (202) 708-1455
Find the address of a HUD office near you