[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
ORAMH
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]  

Mass Case Query

- -
 Information by State
 Print version
 
Mass Case Query provides a means of retrieving status for large numbers of cases at once. Up to 500 specific cases or 1000 cases that match a search criteria can be returned at one time. A paging feature also permits multi-transaction retrieval of any number of records that match a search criteria.
  1. Send a list of unique case numbers. The lender will then receive case information for all requested cases.
  2. Send an originator ID and a case number assignment date range. The user will then receive case information for all cases for the selected originator where the case number was assigned within the date range.
  3. Send an originator ID and an endorsement date range. The user will then receive case information for all cases for the selected originator where the endorsement report date is within the date range.
  4. Send an originator ID and an NOR date range. The user will then receive case information for all cases for the selected originator where the case was NORed within the date range.
  5. Send a sponsor ID and a case number assignment date range. The user will then receive case information for all cases for the selected sponsor where the case number was assigned within the date range.
  6. Send a sponsor ID and an endorsement date range. The user will then receive case information for all cases for the selected sponsor where the endorsement report date is within the date range.
  7. Send a sponsor ID and an NOR date range. The user will then receive case information for all cases for the selected sponsor where the case was NORed within the date range.

To run Mass Case Query against test data post your data to:
https://hwvauwd491.hud.gov/b2b/chums/f17mhfcxml.cfm

To run Mass Case Query against live data post your data to:
https://entp.hud.gov/b2b/chums/f17mhfcxml.cfm


Example Input Files

A search for specific case numbers takes this form:

<?xml version='1.0' standalone='yes' ?>
<MULTICASEDATA MISMOVersionID = '1.0'>
	<PROCESSSTATUS>
		<ProcessStatusRequestor>ATSB2B_DEV</ProcessStatusRequestor>
		<InputRangeMagnitude>2</InputRangeMagnitude>
	</PROCESSSTATUS>
	<CASEDATA CASEDATAID = '1'>
		<Application>
			<AgencyCaseIdentifier>0611234567</AgencyCaseIdentifier>
		</Application>
	</CASEDATA>
	<CASEDATA CASEDATAID = '2'>
		<Application>
			<AgencyCaseIdentifier>0617654321</AgencyCaseIdentifier>
		</Application>
	</CASEDATA>
	<Key>
		<KeyName>MassCaseQuerySearchType</KeyName>
		<KeyValue>caseNumberList</KeyValue>
	</Key>
</MULTICASEDATA>

All other searches take the following form

Note: Both Originator and SponsorIDs are shown, but only the one specified by the particular search is required.

<?xml version='1.0' standalone='yes'?>
		<MULTICASEDATA MISMOVersionID= '1.0'>
	<PROCESSSTATUS>
		<ProcessStatusRequestor>ATSB2B_DEV</ProcessStatusRequestor>
		<ProcessStatusCursorRecordID>0621934756</ProcessStatusCursorRecordID>
	</PROCESSSTATUS>
	<CASEDATA>
		<FHAVA>
			<FHAVAOriginatorIdentifier>9988776655</FHAVAOriginatorIdentifier>
			<FHAVASponsorIdentifier>2987982734</FHAVASponsorIdentifier>
		</FHAVA>
	<Key>
		<KeyName>MassCaseQuerySearchType</KeyName>
		<KeyValue>OriginatorCaseAssignmentRange</KeyValue>
	</Key>
	<Key>
		<KeyName>InitialCaseAssignmentDate</KeyName>
		<KeyValue>20011230</KeyValue>
	</Key>
	<Key>
		<KeyName>TerminalCaseAssignmentDate</KeyName>
		<KeyValue>20020626</KeyValue>
	</Key>
	</CASEDATA>
</MULTICASEDATA>
End of Input Fields for Mass Case Query
Data Item Valid Entries Description
<PROCESSSTATUS>
<ProcessStatusCursorRecordID>
10 numeric characters (Optional entry) Beginning record to select, used to retrieve multiple sets of records when the search exceeds 1000 records.
<CASEDATA CASEDATAID = 'value'> alphanumeric (Optional entry) CASEDATAID values supplied on input will be returned and matched to the contained AgencyCaseIdentifier values on output. If these values are blank output records will be sequentially numbered.
<APPLICATION>
<AgencyCaseIdentifier>
10 numeric characters (Optional entry) Number identifying/ referencing the Federal Housing Administration (FHA) case number. A maximum of 500 of these elements may be present in a single query. AgencyCaseIdentifiers must be unique in each query.
<Key><KeyName> Fixed text (Required entry) One entry is required to specify the search type. (MassCaseQuerySearchType)

All searches except caseNumberList also require an initial and terminal date key pair form the following list: InitialCaseAssignmentDate, TerminalCaseAssignmentDate
InitialEndorsementDate, TerminalEndorsementDate
InitialNORDate, TerminalNORDate

<Key><KeyValue> Fixed text or Date (Required entry) Values for MassCaseQuerySearchType are
caseNumberList, OriginatorCaseAssignmentRange, OriginatorNORRange, OriginatorEndorsementRange, SponsorCaseAssignmentRange, SponsorNORRange, SponsorEndorsementRange

Values for date range keys are dates in the form of yyyymmdd

<PROCESSSTATUS>
<ProcessStatusRequestor>
Up to 34 alphanumeric characters (Required entry) Name of LOS sending request.


Information Returned:


Example Output File

<?xml version = '1.0' standalone = 'yes'?>
<MULTICASEDATA MISMOVersionID="1.0">
	<CASEDATA CASEDATAID="1">
		<Application>
			<AgencyCaseIdentifier>942447454</AgencyCaseIdentifier>
		</Application>
		<FHAVA>
			<FHAVAOriginatorIdentifier>139600024</FHAVAOriginatorIdentifier>
			<FHAVACaseNumberAssignedDate>19900815</FHAVACaseNumberAssignedDate>
			<FHAVAAppraisalLoggedDate>19900823</FHAVAAppraisalLoggedDate>
			<FHAVAMICReportedDate>19841228</FHAVAMICReportedDate>
			<MORTGAGEINSURANCE MortgageInsurancePaid="0.00">
				<MortgageInsurancePremiumDue>2903.16</MortgageInsurancePremiumDue>
				<MortgageInsuranceReceived>0</MortgageInsuranceReceived>
			</MORTGAGEINSURANCE>
		</FHAVA>
		<SubjectProperty>
			<Address1>1129 WHIPSERING WINDS CT</Address1>
			<City>APOPKA</City>
			<State>FL</State>
			<PostalCode>327030000</PostalCode>
		</SubjectProperty>
		<MORTGAGEINSURANCERESPONSE>
			<MortgageInsuranceFHAVAnor FHAVAnorDate="19910703">
			<MortgageInsuranceFHAVAnorMessage MortgageInsuranceFHAVAnorMessageID="1">NO UFMIP HAS BEEN CREDITED TO THIS CASE #. STATEMENT OF ACCOUNT IN</MortgageInsuranceFHAVAnorMessage>
			<MortgageInsuranceFHAVAnorMessage MortgageInsuranceFHAVAnorMessageID="2">THIS FILE BELONGS TO DIFFERENT CASE #.</MortgageInsuranceFHAVAnorMessage>
			</MortgageInsuranceFHAVAnor>
		</MORTGAGEINSURANCERESPONSE>
		<BORROWER BORROWERID="1">
			<UnparsedName>DOE, JANE R</UnparsedName> 
		</BORROWER>
		<PARTY PARTYID="K2MULR" PartyType="Appraiser" />
	</CASEDATA>
	<PROCESSSTATUS>
		<ProcessStatusCode>Success</ProcessStatusCode>
		<ProcessStatusMessage>Selected 1 case records. Returning 1</ProcessStatusMessage>
	</PROCESSSTATUS>
</MULTICASEDATA>

End of Output Fields for Mass Case Query
Data Item Description
<APPLICATION>
<AgencyCaseIdentifier>
Unique identifier of an FHA loan. Up to 10 numeric characters.
<APPLICATION><FHAVA>
<FHAVAOriginatorIdentifier>
Originator ID
<APPLICATION><FHAVA>
<FHAVACaseNumberAssignedDate>
date case number generated
<APPLICATION><fhava>
<FHAVAAppraisalLoggedDate>
Date appraisal logged
<APPLICATION><FHAVA>
<FHAVAMICReportedDate>
Date of MIC (endorsement)
<MORTGAGEINSURANCE MortgageInsurancePaid="0.00"> MIP paid
<APPLICATION><FHAVA><MORTGAGEINSURANCE>
<MortgageInsurancePremiumDue>
MIP due
<APPLICATION><FHAVA><MORTGAGEINSURANCE>
<MortgageInsurancePremiumReceived>
MIP Received
<SUBJECTPROPERTY>
<Address1>
Street Address
<SUBJECTPROPERTY>
<City>
Name of city
<SUBJECTPROPERTY>
<State>
2 letter state code
<SUBJECTPROPERTY>
<PostalCode>
ZIP code
<MORTGAGEINSURANCERESPONSE><MortgageInsuranceFHAVAnor>
<MortgageInsuranceFHAVAnor FHAVAnorDate="19910703">
Date of NOR
<MORTGAGEINSURANCERESPONSE><MortgageInsuranceFHAVAnor>
<MortgageInsuranceFHAVAnorMessage MortgageInsuranceFHAVAnorMessageID="1">
Text message regarding NOR (up to two)
<BORROWER BORROWERID='1'>
<UnparsedName>
Name of mortgagor(last,first,MI). Up to 22 characters.
<PARTY PARTYID="K2MULR" PartyType="Appraiser"> Identifies Appraiser by ID
<VALUATIONS><LocalAssessmentValue> Appraised value
<PROCESSSTATUS>
<ProcessStatusCode>
Result of the request. See below for values and meanings.
<PROCESSSTATUS>
<ProcessStatusCursorRecordID>
Record id of next sequential record matching current criteria, used to continue getting results 1000 records at a time.
<PROCESSSTATUS>
<ProcessStatusMessage>
Message detailing errors. Up to 80 alphanumeric characters.
<PROCESSSTATUS>
<ProcessStatusMessage sCode='1'>
sCode is used to uniquely identify each message.


ProcessStatusCode Values:

End of ProcessStatusCode Values
SuccessNoUpdatesAllowed This indicates that the Mass Case Query request has been successfully processed.
Error This indicates that an error has occurred in processing the Mass Case Query request. Please see the <ProcessStatusMessage> for details.
Unavailable System is down



Comments or Questions? <SF Administration>

 

 
  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